5.00
(1 Rating)

Microsoft Excel Intermediate

Categories: Data Analysis
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This intermediate Excel course is perfect for those who already know the basics and are ready to level up their skills for real-world data handling and analysis. Whether you’re managing projects, analyzing business trends, or organizing personal data, this course will help you unlock the full potential of Microsoft Excel.

With hands-on exercises and relatable examples, you’ll master essential tools like cell referencing, data filtering, advanced formulas (including VLOOKUP, XLOOKUP, and nested functions), as well as visualization techniques like charts and Pivot Tables. You’ll also learn how to clean, sort, and present data with clarity and confidence.

Show More

What Will You Learn?

  • 📁 Excel Essentials
  • Understand how to control cell references (relative, absolute, and 3D)
  • Navigate complex workbooks with Freeze Panes and custom view options
  • Use Find and Replace to quickly clean and manage data
  • 📁 Data Handling & Analysis
  • Create and manage Excel Tables for structured data
  • Sort, filter, and apply conditional formatting for clearer insights
  • Use advanced filtering and data tools like Remove Duplicates and Data Validation
  • 📁 Functions & Formulas
  • Build dynamic formulas using logical, math, text, and COUNT functions
  • Apply nested formulas for more complex problem-solving
  • Master lookup functions including VLOOKUP, XLOOKUP, and HLOOKUP
  • 📁 Visualization & Reporting
  • Create clear, impactful charts to tell a data story
  • Design Pivot Tables to summarize and explore large datasets
  • Present your data in a clean, organized, and professional format

Course Content

Essentials

  • Relative & Absolute Cell References
    12:28
  • 3D cell reference
    05:49
  • Find and Replace
    09:15
  • Freeze Panes and View Options
    07:19
  • Essentials

Data Handling & Analysis

Functions & Formulas

Data Lookup (Matching Data)

Visualization & Reporting

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
SF
Steven Famure
1 week ago
Straight to the point no faffing around unlike other courses out there, I Like it.

The best platform to learn data courses

Email Us: bootcamp@datavasity.com

Want to receive push notifications for all major on-site activities?

✕