MS Excel 2016 Advanced Level


422
Learners
This Online Training Course on MS Excel 2016 Advanced level covers the complex features of Excel 2016 including Formulas, Functions, Database connections, Charts, Pivot tables and more. The course is ideal for participants who are know the basics of excel
Course Faculty
WIN Corporate Training
Leading Excel Corporate Trainer with 14+ yrs training experience. more>>
Basic Course Offerings
23 Lecture Topics
7+ Hours of Video Lectures
Course Specials
Interactive Discussion Forum
Course Completion Certificate
Basic Plan

  • 30 days Free access to Basic Course Offerings covering HD Video Lectures delivered by Industry Experts.
  • Videos may contain ads
INR 0
Enrol Now
EFY Times
Standard Plan

  • 180 days access to basic course offerings covering HD video lectures
  • Course specific discussion forum for anytime doubt resolution
  • Ad-free Videos
  • Course Completion Certificate
USD 40/USD 33.33
Enrol Now
Enterprise Plan

  • Ideal for multiple participants.
  • Single payment option for instant multi user on-boarding.
  • Attractive discounts on bulk purchases.
  • Option to include white labelled LMS with custom dashboard report.
  • Multi course selection available.
Course Overview
This Online Training Course on MS Excel 2016 Advanced level covers the complex features of Excel 2016 including Formulas, Functions, Database connections, Charts, Pivot tables and more. The course is ideal for participants who are know the basics of excel.

This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years.

Course Curriculum
1 Working with Formulas Part 1 21:57
2 Working with Formulas Part 2 18:22
3 Learning Function Categories Part 1 Preview 15:55
4 Learning Function Categories Part 2 28:35
5 Learning Function Categories Part 3 19:18
6 Learning Function Categories Part 4 28:04
7 Database Management in Excel 2016 Part 1 14:23
8 Database Management in Excel 2016 Part 2 20:54
9 Working with charts 16:50
10 Other features 15:31
11 Working with Pivot tables Part 1 15:38
12 Working with Pivot tables Part 2 16:56
13 Enhancing pivot tables 09:12
14 Cell and Workbook protections 20:07
15 Working with more formatting features 04:48
16 Data validation 20:19
17 Consolidating worksheets 07:30
18 Performing spreadsheet What-if analysis tools 12:09
19 New features in MS-Excel 2016 17:17
20 Summary 01:45
21 General Features Excel 2016 29:05
22 Functions Excel 2016 28:16
23 Charts Excel 2016 28:33
Advanced Excel Final Exam  

Eligibility Criteria
Participants to this course are required to have a basic understanding of Excel 2016 and its features.

Ratings & Reviews
Mr. Gyan Dutta Bharti
Area Sales Manager, Dabur India Limited
Thanks to Vijayalakshmi madam, for providing such a proficient vividly elaborated course.

Mr. Gyan Dutta Bharti
Area Sales Manager, Dabur India Limited
Hi Friends, as of now, i have completed 70% of this course , this course is amazing because even a novice can start learning and will reach at a proficient level. Thanks to Apnacourse.com for such nice stuff.

Ms. Radha P
Manager - Accounts, Samurai Exports
Excellent

Ms. Radha P
Manager - Accounts, Samurai Exports
Excellent

GAURANG RAVAL
LIVE CHOICE CONSULTANCY
VERY GOOD ....

Sri lalitha
Wow fantastic

Ramesh K
Soooooo Good and Smart

Ms. Jigna Chawda
Excellent course

Ms. Suprabha A
Good. Found topics on functions fairly well covered.

Frequently Asked Questions

There are no limitations in accessing the course. You can assess the course through the web (ApnaCourse.com) on any device

Most courses are self paced courses with a typical duration of 6 months (180 days) access period. This means, you get 180 access to the course from the moment you enrol into it. You can extend you access by 180 more days at any point during the subscription or post expiration of subscription. Some courses also support a Live Online Classroom courses that Virtual batches on specific dates.

Yes. If your access to a course expires, you can extend that through an online payment and continue from where you left of.

We engage only experienced and certified faculties for each course. Each faculty has decades of relevant teaching / training experience that they bring onto ApnaCourse. For details on their experience, please visit the Faculty section in the website.

We offer a course completion certificate on most courses. This certificate is jointly given by our partner trainer or training instiute who provided the course.

For any course specific doubts, there is an Online forum on ApnaCourse called Social Circle for every Course. Post your questions there and an expert would be able to respond on it. For general payment or enrolment related information, please email at support@apnacourse.com or connect our helpdesk.

Pl visit our detailed FAQ section at https://www.apnacourse.com/about/faq. If you still have doubts, feel free to contact our helpdesk.


×
×
Course Expert
WIN Corporate Training
WIN Corporate Training is run by renowned corporate trainer Mrs. Vijayalakshmi. Her delivery style and conversations are completely unique, practical and activity based which implants long lasting impact on participants. The trainer has 14+ years of experience in Technical Training. She has trained participants in Net, Java, Database and Advanced Excel with VBA Technologies. Clientele includes EY, Goldman Sachs, Axa, ABB, Deloitte, L&T Infotech, Oracle and many other top MNC's.
×
All batches are currently full