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

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

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.

Download Brochure

Working with Data in Advanced Excel

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

Working with Workbook and Worksheets

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

Automation in Excel

Structuring workbooks with XML
Automating business operations
Manipulating the Excel environment

The NIIT Digital Advantage

LIVE ONLINE CLASSES

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

CLASSROOM-LIKE EXPERIENCE

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

PEER AND FACULTY CONNECT

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

LEARNING RESOURCES

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

ROLE PLAYS AND CASE STUDIES

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

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.

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 ind

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 certificates will I be receiving for this course?

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.

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

What are the pre-requisites for the enrollment?

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

What is the delivery platform NIIT Digital?

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.

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

STILL HAVE A QUERY? Connect with us