Ms Excel - 5 Levels Mastery Course 19+ hours
200+ Excel Shortcuts, Formulae ,Charts , Custom Visualizations , Data Analysis, Power Pivot ,Power Query & Much more !!
Excel,Excel Formulas and Functions,Excel Dashboard,Office Productivity,Microsoft Office
Lectures -32
Resources -7
Duration -19 hours
30-days Money-Back Guarantee
Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.
Course Description
You can learn and practice Microsoft Excel Latest Version For Free !!
No need to spend a penny for buying any software ...
Not believing me ?
Join Now to find out more..
You have already taken a small but crucial and important step to Master Ms-Excel.
- This Course Has 5 Levels Of Excel Proficiency.
- If You Want To Transform Your Excel Skills From Beginner To Advanced And Even Beyond, Then This Course Is Just Right For You
- Excel Users Who Have Basic Skills And Want To Develop Their Skills Further
- Students Looking Out For Extraordinary Interactive Hands-On Approach For Advanced Excel Skills Training
- Professionals Looking To Pursue Career In Business Intelligence, Data Science, Financial Modelling & Advisory, Investment Banking
In addition to the above, I shall solve your every query and also add any additional material if you request it !!..
Goals
What will you learn in this course:
Here is a Gist what all you will benefit from in this course:
Mastering Excel Worksheet Operations and Templates
Customizing User Interface Experience for Ms-Excel
Mastering Ms-Excel Formulae for Mathematical, Textual, Conditional Analysis, Financial Analysis. Statistical Analysis purposes
Mastering Basic to Advanced Ms-Excel Charting Techniques with Custom Visualizations
Mastering Data Analysis using Tools like Pivot Tables , What-If Analysis, Goal Seeking, Solver , Analysis ToolPak and Much More
Mastering Power Pivot ,Power Query and working directly with Internal Data Model
Prerequisites
What are the prerequisites for this course?
- None at all...
- It is designed for absolute beginners as well

Curriculum
Check out the detailed breakdown of what’s inside the course
Level 1 :Warming Up With Excel Basics
10 Lectures
-
Getting Started With Excel Latest Version For Free !! 03:52 03:52
-
Course Resources
-
Excel Basic Introduction 34:38 34:38
-
Basic Data Entry And Editing 32:30 32:30
-
Excel Worksheet Operation Basics 25:58 25:58
-
Excel Ranges And Tables 01:06:40 01:06:40
-
Worksheet Formatting 01:01:12 01:01:12
-
Excel Workbook And Templates 25:25 25:25
-
Printing 19:10 19:10
-
User Interface Customization 12:00 12:00
Level 2 : Mastering Excel Formulae & Functions
10 Lectures

Level 3 : Master Excel Charts and Visualization Techniques
3 Lectures

Level 4 : Master Data Analysis And Management
7 Lectures

Level 5 : Mastering Power Pivot And Power Query
2 Lectures

Instructor Details

kamarthi karthik
I am a banker by profession who has worked in F500 bank in one of the early stages of career. I had an intensive flair and overzealous passion for teaching ever since I was an undergrad. Here at UDEMY I have found a beautiful way to realize my dream of becoming a mentor and a teacher by sharing my knowledge.
Thanks a lot UDEMY
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now