Acquire

Main navigation

Menu

Working with Advanced Excel 2013

Extend your knowledge on Microsoft Office Excel, become more skilled and efficient in your workplace as you learn to use and implement its features.

New Batches available from15 June Hardware and Software Requirements

3,200/- 4400/-

( Excluding GST @ 18% )

Enroll Now

Working with Advanced Excel 2013

Extend your knowledge on Microsoft Office Excel, become more skilled and efficient in your workplace as you learn to use and implement its features.

New Batches available from15 June Hardware and Software Requirements

3,200/- 4400/- (Excluding GST @ 18%)
  • module

    Become an Excel power user

  • module

    28 Hours of Intensive learning with real time practice on data sets

  • module

    LIVE Online sessions + App based learning

  • module

    Additional Support from nearest NIIT Centre

module

Become an Excel power user

module

28 Hours of Intensive learning with real time practice on data sets

module

LIVE Online sessions + App based learning

module

Additional Support from nearest NIIT Centre

Programme Overview

Key Highlights

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

LIVE Classroom Like Experience + app based learning Classroom Like Experience
Expert Faculty Expert Faculty
Faculty and Peer Chat     Faculty and Peer Chat
Multiple Learning resources - Recorded Sessions, App Learning, Quizzes and more. Multiple Learning Resources

Course Details

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

Calculating data with advanced formulas and Importing and Exporting data.
Organizing Worksheet and Table data and Auditing worksheets.
Presenting Data using Charts and Streamlining workflow.
Analyzing Data using pivot tables and pivot charts.
Inserting graphic Objects and Customizing, Enhancing workbooks and the Excel environment.
Structuring workbooks with XML and Manipulating the Excel environment.

eligibility

Qualification Academics

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

Knoweldge Additional Skills Required

Students interested in learning advance excel programming skills through this course.

Testimonials

See What Our Students Have to Say.


Testimonials

See What Our Students Have to Say.


Get certified in Advance Excel.

On successful completion of the programme you will be awarded with a prestigious Advance Excel certification from NIIT.

Connect with a global network of accomplished NIIT Alumni. 

Course Module

Modules

Working with Advanced Excel 2013

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

Why NIIT?

For over 38+ years, NIIT has taken pride in creating career opportunities for students from different walks of life.

INDUSTRY MAPPED CURRICULUM

PRESENT ACROSS 30 COUNTRIES

35 MILLION+ LEARNERS WORLDWIDE

INDIA'S MOST TRUSTED EDUCATIONAL BRAND

Need help? Connect with us.

Top