When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel - from scratch to pro level
Learn with practice - From beginner to advanced level - Trainer on social media and professional financial modeler
This Course Includes
udemy
5 (7 reviews )
8 total hours 
english
Online - Self Paced
course
Udemy
About Microsoft Excel - from scratch to pro level
Excel from scratch to advanced Level!
This course is designed in step by step manner to help you build upon the previous learning and ultimately reach the expertise level intended. The course is not only targeted at learning the tools or functions but is also expected to improve your efficiency in day to day work.
Target audience of the course
This course is best suited for individuals who need to prepare reports on business performance or performance evaluation of employees.
This type of learning is also best suited for entrepreneurs dealing with performance of their startups.
Also, it is useful for those who deal with Big data or large set of data on daily basis.
The persons include accountants, data analysts, financial modelers, valuation analysts, CFOs.
How this course is different from others
The course is designed to provide complete hands on experience. The videos are supported by more than 20 sample files for practice purposes.
I have taught the tools in practical scenario with real life examples.
The focus has been on providing clarity on the concept behind working of a tool so that you can easily apply it to any specific scenario. So you will know the WHY behind the tools.
In addition to the tools, continuous guidance is provided on improving working efficiency to make you a true PRO.
The videos are high quality to enable you to view data and working with ease.
The videos have clear sound so that you follow the instructor easily.
Simple and plain English is used to explain topics.
The topics are well planned and build upon each other. So following the sequence of the lectures will definitely take you home.
What you will find in this course?
It includes topics related to working environment of excel
Basic to advanced formulas and functions
Conceptual clarity on functions
Guidance on arranging data in report form
Deal with large data sets using Pivot Tables
Create interactive reports using slicers and timelines
Know the charts from scratch and also customize them easily
Complex combination of functions for complex problems
What You Will Learn?
- Learn to work like a professional in Excel.
- Follow the instructor with Hands on exercise to get a grip of concepts.
- Master the Xlookup, Vlookup, Index, Match, Nested IFs for applying in complex financial models.
- Modify Charts and create your own templates.
- Get access to Trainer, Chartered Accountant with 20+ years of professional experience and media presence.
- Create Interactive Pivot Table reports with ease.
- Learn the ETL functions and work on any data set.
- Convert static data to interactive with Slicers.
- Know the story of Dates in Excel and tell your story.
- Create your search forms with combination of formulas and functions.