Ms Excel - 5 Levels Mastery Course 19+ hours
200+ Excel Shortcuts, Formulae ,Charts , Custom Visualizations , Data Analysis, Power Pivot ,Power Query & Much more !!
Updated on Apr, 2024
Language - English
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 10000+ 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
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
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