5.00
(1 Rating)

MS Excel Mastery – Dashboards, Automation & Advanced Reporting

Categories: MS Excel Advanced
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This course description is designed to be high-impact, professional, and structured specifically for an LMS (Learning Management System) environment.

It focuses on turning “users” into “power users” by mastering the most critical tools in the Excel arsenal.

What Will You Learn?

  • Who Is This Course For?
  • The "Self-Taught" Professional: You know how to enter data and sum columns, but you struggle when asked to connect different datasets.
  • Aspiring Data Analysts: Those who need to transition from viewing data to extracting actionable insights.
  • Office Administrators & Managers: Anyone looking to automate repetitive reporting tasks and reduce manual errors.
  • Job Seekers: Individuals wanting to confidently list "VLOOKUPs and Pivot Tables" on their resume—the gold standard for office proficiency.

Course Content

Module 1

  • Chapter 1 – Excel Basics & Screen Interface Details
    05:03
  • Chapter 2 – Customized Tabs, Customized Groups & Buttons
    10:25
  • Chapter 3 – Edit Text, Find & Replace, Undo & Redo, Edit a Cell, Formulas & Functions
    13:39
  • Chapter 4 – Text Formatting & Text Alignment
    09:42
  • Chapter 5 – Numbers & Decimals, Dates & Formats, Currency Symbols
    08:00

Module 2
Working with Data - Relative Reference, Absolute Referencence Speak Cells, Stop Speaking Cells Text to Columns, Tab Delimited, Fixed with Advance Fill & Advantanges Flashfill & Features

Module 3
Lessons Covered Logical Functions, Equal to, Greater than, Less than, Less than or equal to, Greater than or equal to Excel Formulas, Addition, Subtraction, Multiplication, Division, BODMAS If Function, Nested If Function AND Function

Module 4
Text Function, Trim, Upper, Lower, Proper, Len Text Function Cont. Left, Right, Mid, Concatenate Count Function, Count, CountA, Countblank, Countif Statistical Functions, Cell Protection

Module 5
Key Takeaways Protect Worksheet, Protect Workbook Data Validation, All Features Data Validation, Error Alerts, Error Messages Conditonal Formatting I Conditonal Formatting II

Module 6
VlookUps, VlookUp Rules Vlook Up with Data Validation

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
PK
Parmeet Kaur
3 weeks ago
Crisp, Clear and to the point. loved it