Main navigation
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
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
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
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.
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
