Launching ApnaCourse 3.0 by May end. The first ever community driven & engagement based edtech platform

MS Excel 2016 Advanced Level


1211
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
Advanced Excel Final Exam
Basic Plan

  • 3 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
  • Advanced Excel Final Exam
USD 0
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. sandip patra
this is such as a nice course., sorry, i am a student
it is a good coure

Ravi kumar Baitha
Good, Apana course
Nice

AMIT MAHADEV AIER
Account Executive, Private
Nice

Mr. Arvind Kumar
Accountant, UPPCL
nice

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

Jadav Yuvrajsinh Bhupatsinh
student
good ..,

GAURANG RAVAL
LIVE CHOICE CONSULTANCY
VERY GOOD ....

Rohini udgiri
Sales Engineer
Very well structured Course.

Rohini udgiri
Sales Engineer
Very well structured Program .

Rohini udgiri
Sales Engineer
Excellent teaching covering all necessary details.

Matla Aravind
STUDENT
GOOD

Kajal Amit Tripathi
Pharmacist
Very informative

Anurag dubey
Good

Ms. Trupti Chache
very knowldgeable course cantain

Nilesh vishram vavle
Nice explanatation

Jagjeet Singh
Thanks for teach excel in depth.

Ms. sanjana jatav
very useful coarse

Ms. Dhanshree Laxmikant Nadkar Nadkar
Good

Ms. Dhanshree Laxmikant Nadkar Nadkar
Nice

Mr. Prashant kailashbhai Kotiya
Amazing training for excel 2016

MD. SAMIR HOSSAIN
great

Amit Kumar rajbhar
BEST COURSE

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 free access of 30 days. The 30 days access (basic plan) is only on the videos. To extend access by 180 days or to get course specials like question bank, course completion certificate, exam etc, you will have to enrol into the standard (paid) plan.

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 to ApnaCourse. For details of our faculty partners, 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 delivered the course.

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

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


×
×
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