Main navigation
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/-
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%)
-
Become an Excel power user
-
28 Hours of Intensive learning with real time practice on data sets
-
LIVE Online sessions + App based learning
-
Additional Support from nearest NIIT Centre
Become an Excel power user
28 Hours of Intensive learning with real time practice on data sets
LIVE Online sessions + App based learning
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
Classroom Like Experience
Expert Faculty
Faculty and Peer Chat
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
Academics
Have basic knowledge of working in the Windows environment and Microsoft excel.
Additional Skills Required
Students interested in learning advance excel programming skills through this course.
Testimonials
See What Our Students Have to Say.
NIIT gave me the opportunity to establish myself by utilizing my skills to the fullest for my development as a professional. NIIT Played a major role in my shaping a successful life for me.
NIIT gave me the opportunity to establish myself by utilizing my skills to the fullest for my development as a professional. NIIT Played a major role...
Vishnu
Faculty at NIIT is expert in training. The faculty is highly experienced and knows what’s in demand. After 2 months, I got placed in Sapient. As a fresher NIIT provided me a platform to showcase my skills and get a job in a good company.
Faculty at NIIT is expert in training. The faculty is highly experienced and knows what’s in demand. After 2 months, I got placed in Sapient. As a...
Rahul Kaushik
Testimonials
See What Our Students Have to Say.
NIIT gave me the opportunity to establish myself by utilizing my skills to the fullest for my development as a professional. NIIT Played a major role in my shaping a successful life for me.
NIIT gave me the opportunity to establish myself by utilizing my skills to the fullest for my development as a professional. NIIT Played a major role...
Vishnu
Faculty at NIIT is expert in training. The faculty is highly experienced and knows what’s in demand. After 2 months, I got placed in Sapient. As a fresher NIIT provided me a platform to showcase my skills and get a job in a good company.
Faculty at NIIT is expert in training. The faculty is highly experienced and knows what’s in demand. After 2 months, I got placed in Sapient. As a...
Rahul Kaushik
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
related courses
Programme starts with basic banking and finance industry and step-by-step take you through all the modules you need to learn to become a skilled professional in the BFSI sector.
394 Hours | Course type: Classroom + Online
78000/-Enroll Now
The programme starts with the basics of digital marketing. Learn to create a social media strategy for all social platforms (Facebook, YouTube, Twitter, Google, Instagram, Pinterest, Google Plus). 50 hours of intensive learning, in-depth understanding of Social Media with live online classes.
50 hours | Course type:
6700/-
54 hours of online training and live sessions will help you with hands-on experience in the Java programming language. Learn to develop efficient and robust applications by using Java programming language.
54 hours | Course type:
7000/-
Learn one of the most popular tools for data analytics. Learn Python Programming basics and essentials, along with machine learning for conducting data analytics in Python. Hybrid Learning with Guided practice & Weekly Practice quiz questions on the app along with the Live Online sessions + App-Based Learning. Connect with Faculty on the App apart from the regular classes through online training.
42 hours | Course type:
7200/-
Need help? Connect with us.
