Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel Masterclass – Beginner to Advanced Level

Learn Microsoft Excel from Novice to Expert & learn the art of creating quick Reports from a Microsoft Certified Trainer
4.6
4.6/5
(97 reviews)
895 students
Created by

8.8

CourseMarks Score®

7.6

Freshness

8.9

Feedback

9.2

Content

Platform: Udemy
Video: 3h 47m
Language: English
Next start: On Demand

Table of contents

Description

A good teacher can inspire hope, ignite the imagination, and instill a love of learning
~Bred Henery~
MS Excel is the first choice for any report. Data analysis is an exciting field to get into and the career prospects are amazing. You don’t need to be a math/computer science/coding whiz to land a job in data analysis.
Data Analysis in demand and we normally use Excel to create beautiful Charts and Graphs to show the results. MS Excel is the ultimate choice and widely used to prepare quick Reports and Dashboards and easy to understand that is the reason it has become the first choice of a Data Analysis.
In this Course I will teach you to create some beautiful Excel based Reports by simple techniques in quick time.

WHAT YOU WILL LEARN
•Simple methods to Excel Reports
•Using key Shortcuts
•Formulas and Functions
•Protect your Reports
•Subtotals, Sorting, Filter
•Advanced Filter, Linking of Data and quick Formatting
•Advanced Skills to create quick Reports
•Consolidation of Data, Combining and Merging Techniques
•Pivot Tables & Pivot Charts
•Vlookup, Xlookup, Advanced Features
•Macros and VBA
•Excel Tricks and Techniques
•Data Validation
•Quick way to create Reports and Charts

PREREQUISITES
•Basic Computer knowledge
•Basic level Excel skills
•MS office installed (better office 365 or office 2016 and above) on Windows based (but not Mac)

WHO THIS COURSE IS FOR?
•Finance Manager
•Students
•Sales Manager
•Training Manager
•Executives
•HR Managers
•Analyst
•Admin
•Data Analyst
•Teacher
•Researcher
•Excel Lover
•CFO

Happy Learning !

Thanks & Regards
Asif Hafeez

You will learn

✓ MS Excel skills from beginner to Advanced
✓ Confident using Excel for Business Reports
✓ Excel Formulas, Functions & keyboard shortcuts
✓ Pivot Table and Pivot Charts & Automate reports
✓ Creating Excel based dynamic Reports
✓ Excel Charts and Graphs and custom based Visualizations
✓ Comfort using Complex Formulas and apply formatting
✓ Be able to create summary reports quickly
✓ Macros and VBA to avoid donkey work

Requirements

• Basic Computer knowledge
• Basic level Excel skills
• MS office installed (better office 365 or office 2016 and above) on Windows based (bu not Mac)

This course is for

• Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs
• This is the program for everybody who uses Excel daily
• For those who love to save his/her precious time to buld quick Reports
Microsoft Certified Trainer | MCSA (BI Reporting)
ASIF HAFEEZ is FCMA and Microsoft Certified Trainer (MCT)
Microsoft Certified Solutions Associate (BI Reporting)
20 years industry experience in Oil & Gas, Petrochemicals, Manufacturing
Serving as a freelancer Trainer.
Has trained thousands of Excel users within his professional community.
Has conducted many workshops, Live trainings, in house programs in UAE, Qatar, Bahrain, KSA & Pakistan mainly on the followings.
– Advanced Excel
– Dashboards & Advanced Reports using Excel
– Dashboards using Power BI
– Financial Modeling Using Excel
– Advanced Financial Modeling with Power BI and Power Pivot

Few of certificates/designations includes
Microsoft Certified Trainer |(MCT)
Member of the International Association of Microsoft Certified Trainer | (IAMCT)
Microsoft Certified System Associate for BI Reporting | (MCSA)
Microsoft Certified Professional | (MCP)
Microsoft Certified Office Specialist for Excel | (MOS)
Financial Modelling and Valuation Analyst | FMVA®
Certified Financial Modeling Fundamental | Modano
Tableau Analyst and Tableau Data Scientist | Tableau
Advanced Communicator Bronze (ACB) | Toastmasters International
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 47m
Language: English
Next start: On Demand

Students are also interested in