Microsoft Excel Masterclass – Beginner to Advanced Level
Microsoft Excel Masterclass – Beginner to Advanced Level, available at $44.99, has an average rating of 3.9, with 31 lectures, based on 125 reviews, and has 1078 subscribers.
You will learn about 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 This course is ideal for individuals who are Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs or This is the program for everybody who uses Excel daily or For those who love to save his/her precious time to buld quick Reports It is particularly useful for Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs or This is the program for everybody who uses Excel daily or For those who love to save his/her precious time to buld quick Reports.
Enroll now: Microsoft Excel Masterclass – Beginner to Advanced Level
Summary
Title: Microsoft Excel Masterclass – Beginner to Advanced Level
Price: $44.99
Average Rating: 3.9
Number of Lectures: 31
Number of Published Lectures: 29
Number of Curriculum Items: 31
Number of Published Curriculum Objects: 29
Original Price: $39.99
Quality Status: approved
Status: Live
What 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
Who Should Attend
- 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
Target Audiences
- 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
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
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: Key Excel Shortcuts
Lecture 3: Printing & Layouts
Lecture 4: Print Settings
Lecture 5: Find & Replace, Hide & Unhide, Groups
Chapter 2: Data Sorting, Subtotals, Filter and Advanced Filter
Lecture 1: Download Data Resources
Lecture 2: Complete Lecture
Chapter 3: Data Cleansing Technique
Lecture 1: Data Cleaning
Chapter 4: Conditional Formatting in Reports
Lecture 1: Complete Lecture
Chapter 5: Hyperlinking, Paste Special & Linking of Sheets
Lecture 1: Complete Lecture
Chapter 6: Data Validation & Name Ranges
Lecture 1: Complete Lecture
Chapter 7: Linking Worksheets and Consolidation
Lecture 1: Complete Lecture
Chapter 8: Basic Excel Formulas
Lecture 1: Basic Formulas
Chapter 9: Advanced & Complex Formulas
Lecture 1: Complex Formulas
Chapter 10: Creating Charts & Visual Reports
Lecture 1: Charts
Lecture 2: Sparklines (Mini Charts)
Chapter 11: Pivot Tables and Pivot Charts
Lecture 1: Power of Pivot Tables
Lecture 2: Interractive Reports & Slicers
Chapter 12: Right, Left & Mid Formulas & Flahs Fill replacement
Lecture 1: Magic Tricks
Chapter 13: What-if-Analysis
Lecture 1: Scenarios, Goal Seek & Data Tables
Chapter 14: Report Protections
Lecture 1: Protecting your Reports
Chapter 15: Advanced Vlookup, Xlookup, Index, Match
Lecture 1: Working with Lookups
Lecture 2: Lookup Excercises
Chapter 16: Macros & VBA in Excel
Lecture 1: Recording your first Macro
Lecture 2: Developer Tab & assigning Macros Buttons
Lecture 3: Creating your personal Macro Workbook
Chapter 17: Excel Revolutions (New Excel)
Lecture 1: New Excel (the Awesome tool)
Chapter 18: Additional Contents
Lecture 1: Additional Content: Removing blank cell/rows
Lecture 2: Additional Content: Reporting Values as Thousands, Millions etc.
Instructors
-
Asif Hafeez
Microsoft Certified Trainer | MCSA (BI Reporting)
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 5 votes
- 3 stars: 16 votes
- 4 stars: 35 votes
- 5 stars: 68 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple