What you'll learn
- MS Excel
Requirements
- Nil
Description
Advanced MS Excel
The operational efficiency of any knowledge professional can improve significantly with an up gradation of his/her skills of MS Excel. With every additional function that you learn, life can become a lot easier.
Have structured the course as follows:
1) Warming Up
2) Data Analytics
3) Data Lookup
4) Pivot Table
5) Logical Functions
6) MIS Reporting
7) Data Cleaning
8) Scenario Building
9) Financial Functions
10) Charting
11) Formula Auditing
12) Keyboard Shortcuts
I hope this will significantly enhance your efficiency on the workfront
Don’t just read this book like a novel. Practice it and the learning curve will be the steepest
‘The proof of the pudding lies in the eating’. So let the videos make their sales pitch themselves
Who this course is for:
- Advanced Excel students
Course content
- Preview31:08
- 09:53Lecture 2_Data Analytics
- Preview24:26
- 23:35Lesson 4_Pivot Table
- 10:23Lesson 5_Logical Functions
- 08:46Lesson 6_MIS Reporting
- Preview25:23
- 06:30Lesson 8_Scenario Building
- 06:24Lesson 9_Financial Functions
- Preview14:55
- 03:18Lesson 11_Formula Auditing
- 03:18Lesson 12_Keyboard Shortcuts
Instructor
![Anurag Singal](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.8 Instructor Rating
- 192 Reviews
- 894 Students
- 5 Courses
Anurag secured All India Rank 22 in CA Final exams-Nov'07 . He completed PGPX - 1 year full-time MBA from IIM Ahmedabad 's in the year 2015. He has worked for 15+ years across corporate houses like Deloitte, ITC, Tata Steel and ABG. His core areas of expertise are M&A,Financial Modelling and Valuation. He was awarded CA Young Achiever-Manufacturing Sector at 6th ICAI Awards'13. He has been a TEDx speaker and has a popular YouTube channel ''Anurag Singal" YouTube to guide youngsters on Careers, Financial Planning and Latest Updates. He is Mentor at CAJobPortal . com is India's first recruitment website exclusively for finance professionals.