Microsoft Excel - from scratch to pro level

Learn with practice - From beginner to advanced level - Trainer on social media and professional financial modeler


What you'll 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

Requirements
No previous knowledge of Excel is necessary to take this course.
You can start your Excel journey from zero.

Description
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
Who this course is for:
Beginner data analyst and financial modelers
Advanced Excel users who want to clear misonceptions
CFOs to do performance analysis of companies
Human resource personnel for doing performance analysis of employees and payroll processing
Freelancers who want to provide online services
Executive dashboard and information system creators
Accountants to prepare budgets and projections

More Info