Main navigation

Menu

Working with Advanced Excel 2013

Master the advanced features of Microsoft Office Excel to be more productive at your workplace.
Mode Of Delivery

ONLINE You will need the Latest version PC or Laptop along with 2 Mbps internet connection.

3,200/-

4,400/-
( Excluding GST @ 18% )
Batch Starting From 08 Nov
SAT,SUN 01:30 PM TO 05:30 PM (IST)
Enroll Now

Still confused? Talk to our expert

3,200/-

4,400/-
( Excluding GST @ 18% )
Batch Starting From 08 Nov
SAT,SUN 01:30 PM TO 05:30 PM (IST)
Enroll Now

Still confused? Talk to our expert

Become an Excel power user
Real time practice on data sets
LIVE Online Classes
Support from NIIT Centre

Become an Excel power user

Real time practice on data sets

LIVE Online Classes

Support from NIIT Centre

Learn about Excel

The programme is designed to make learners conversant with using and implementing the advanced features of MS Excel and increase productivity and efficiency at workplace.

28 Hours
Weekday/Weekend Batches
Expert Faculty
Practical Oriented
Case Study based
NIIT Certificate

What will you Learn

Top Skills

Functions, Charts , Pivot Table , Graphics Object, Analyzing Data

Job Opportunities

Job roles in back office, accounts departments, administration

Who is this Programme for

Learners wanting to understand advanced features of Microsoft Office Excel to enhance productivity

Minimum Eligibility

Basic working knowledge of MS Excel

Programme Overview

Programme Overview

Microsoft Excel is extremely valuable for businesses, which use Excel features to record expenditures and income, plan budgets, and chart data. In fact, it is the very first requirement when applying for a job. This is the most comprehensive and reliable programme for learners who want to learn the advanced features of Excel, including latest technologies like XML and automation that will provide the learners with an edge over others.

  • Covers a combination of business concepts and hands-on learning on MS- Excel
  • Gain expertise in analysis and presentation of complex data using Excel
  • Understand business process automation and XML for structuring workbooks
  • Case study based practice exercises

Course Details

This programme enables the learner to use Microsoft Office Excel 2013 to analyse and calculate complex data using tools like pivot tables and organizing and presenting data using charts and graphics. It will enable learners to automate some common tasks, apply advanced analysis techniques to more complex data sets, and collaborate and share worksheets and Excel data with other applications.

  • Calculating data with advanced formulas
  • Organizing Worksheet and Table data
  • Presenting Data using Charts
  • Analyzing Data using pivot tables and pivot charts
  • Inserting graphic Objects
  • Customizing and Enhancing workbooks and the Excel environment
  • Streamlining workflow
  • Collaborating with others
  • Auditing worksheets
  • Analyzing data
  • Working with multiple workbooks
  • Importing and Exporting data
  • Using Excel with the web
  • Structuring workbooks with XML
  • Automating business operations
  • Manipulating the Excel environment

The NIIT Digital Advantage

LIVE ONLINE CLASSES

LIVE ONLINE CLASSES

Real-time classes conducted by NIIT Instructors at fixed batch timings.

CLASSROOM-LIKE EXPERIENCE

CLASSROOM-LIKE EXPERIENCE

Get answers to your queries from Instructors in real-time.

PEER AND FACULTY CONNECT

PEER AND FACULTY CONNECT

Be a part of the National Batch & connect to classmates all-over India.

LEARNING RESOURCES

LEARNING RESOURCES

Avail resources–like App, Guided Practice, Hands-on exercises, and more.

ROLE PLAYS AND CASE STUDIES

ROLE PLAYS AND CASE STUDIES

Online & skill-based tests along with role plays & case studies.

NEAREST NIIT CENTER SUPPORT

NEAREST NIIT CENTER SUPPORT

Get assistance from the Nearest NIIT Centre for any support or query.

Expert Faculty

Venkat Rao Yamana

In NIIT Limited as a Senior Training Lead Specialist with over 9 years of experience with exposure in Training, Content,  Development of Finance & Accounts, and a Master Trainer. Professionally qualified CIA, CS(Inter).

Skills in Tally.ERP9, ETTAD, Taxation along with GST, Business Tools, Corporate Financial Accounting, IBIRE, CSBFI, RBPP, and Finacle

Venkat Rao Yamana

Lead Specialist NIIT LTD

TESTIMONIALS

THE NIIT ADVANTAGE

 

India's Most Trusted Educational Brand
Industry Mapped Curriculum
Present Across 30 Countries
35 Million+ Learners Worldwide

FAQs

Have a question? Check from our list of frequently asked questions.

Undergraduates or graduates who have working knowledge of MS Excel basics and who want to know the advanced features of Excel.

The course curriculum design covers all the advanced features of MS Excel along with its implementation in different business scenarios. The course begins by acquainting the learner with the advanced formulas and then progresses to the analysis and presentation of complex data sets, including business process automation and XML. The combination of business concepts and hands-on learning, delivered by ind

Expert Faculty: Recognized practitioner experienced in related field interacting with students. Apart from guiding students on concepts and its implementation, he will pose challenges to learners to think through all the topics leading to better learning and increased retention.

Study Material: Students will be provided with study materials developed by NIIT. Also, students can refer to reference materials to obtain answers to queries generated during the learning process.

Hands-on Learning: Apart from classroom hours, learners will be provided with dedicated machine room hours to practice their learnings on MS Excel software.

Topics covered will be: Advanced Excel Formulas, Data Presentation using Charts, Data Analysis using Pivot Tables and Pivot Charts, Graphic Objects, Streamlining workflow, Multiple User Collaboration, Structuring workbooks with XML, Automating business operations, etc.

The certificate title that the learner will be receiving at the end of the course is “Working with Advanced Excel 2013”. Learners who will maintain the minimum academic credentials will get a graded certificate, failing which the learners will get only a participation certificate.

At the end of this programme, the learner will be able to:

  • Calculate data with advanced formulas
  • Present data using Charts
  • Analyze data using pivot tables and pivot charts
  • Insert graphic objects
  • Audit worksheets
  • Structure workbooks with XML
  • Automate business operations

There are as such no pre-requisites for enrolments except the eligibility criteria.

NIIT Digital is a Learner Experience Platform where a learner will have access to complete programme related information such as learner dashboard, learning schedule, self-paced learning content, Live sessions, assessments, faculty and learner engagement, batch group engagement, notifications, and other related delivery services as applicable to the course.

The platform facilitates ease of access through laptops and mobile devices for a rich experience. It can be accessed on the web through www.training.com.

At the end of this programme, the learner will be able to:

  • Calculate data with advanced formulas
  • Present data using Charts
  • Analyze data using pivot tables and pivot charts
  • Insert graphic objects
  • Audit worksheets
  • Structure workbooks with XML
  • Automate business operations

STILL HAVE A QUERY? Connect with us

Enroll Now
Top