MS Excel 2016 Advanced Level


378
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>>
Course Offerings
23 Lecture Topics
6+ Hours of Video Lectures
Interactive Discussion Forum
Course Completion Certificate
Not sure if its the right course ?
Or
Get in touch with our Career Consultants
This course has a
Online Training

  • 180 Days access to HD Video Lecture delivered by industry experts
  • Interactive Discussion Forum for solving queries.
  • Course Completion Certificate
New
This course is available only under Privilege Membership.
Privilege Membership: A pay-once access-all;subscription membership on ApnaCourse.com
Get access to 125+ courses at USD 133.31/ USD 66.64.
.
Enrol Now
Corporate Training

  • Hybrid (Online + Onsite) Learning Approach.
  • White Labeled Learning Management System (LMS).
  • Standard/customizable dashboards for individuals and teams.
  • Affordable Pricing.
  • Dedicated Account Manager.
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 12:35
22 Functions Excel 2016 15:19
23 Charts Excel 2016 15:31
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
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.
×
×
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