Working with Advanced Excel 2013

Overview

  • Total Duration 28 Hours
  • Course Fees Actual Fees may vary, depending upon your centre selection. 4,400

    ( Excluding GST @ 18% )

  • Course Type Classroom

Become an excel power user

Industry Veteran Faculty

13600+ Learners

Hands-on application of tools

  • Learn Advanced features of Excel to become an excel power user
  • Analyze and calculate complex data using tools like pivot tables
  • Automate some common tasks and collaborate and share worksheets and excel data
  • Extensive Learning hours with 28 hours of classroom training along with real time practice on data sets for better learning and increased retention

Share

Get in touch with us

I understand the Privacy Policy .

This course 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 students 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.

 

Learning Objectives

1. Calculating data with advanced formulas

2. Organizing Worksheet and Table data

3. Presenting Data using Charts

4. Analyzing Data using pivot tables and pivot charts

5. Inserting graphic Objects

6. Customizing and Enhancing workbooks and the Excel environment

7. Streamlining workflow

8. Collaborating with others

9. Auditing worksheets

10. Analyzing data

11. Working with multiple workbooks

12. Importing and Exporting data

13. Using Excel with the web

14. Structuring workbooks with XML

15. Automating business operations

16. Manipulating the Excel environment

Working with Advanced Excel 2013

Have basic knowledge of working in the Windows environment and Microsoft excel

FAQs

Who should join this course?

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

Why is this course Unique?

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 industry experienced faculty makes this course unique.

What learning resources are available?

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.

What topics are covered as a part of the curriculum?

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.

What are the pre-requisites for the enrolment?

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

What certificate will I be receiving after this course and what is the certificate criteria?

You will receive a certificate from NIIT Limited Criteria: They are two types of certificates
i. Graded certificate: successful completion of the assessments of the programme
ii. Participation certificate: on successfully attending the programme

What will be my takeaway from this course?

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

Appointment with counsellor