Business Intelligence Practicum (Excel)

Business Intelligence Practicum (Excel)

Categories: Intro To Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

What Will You Learn?

  • Excel Skills for Business Intelligence and data visualization.
  • Pivot Table
  • XLOOKUP

Course Content

Week 1: Structuring and Organizing Data with Excel Tables
Junior Data Administrator will master the fundamentals of structuring and organizing raw datasets into Excel tables. They will create drop-down lists, apply table formatting, and use table-specific formulas. These skills form the foundation for organizing data for future analysis and automation.

  • Watch & Learn: Structuring and Organizing Data with Excel Tables (Video)
    10:17
  • Quick Quiz: Test Your Understanding of Excel Tables (Quiz)
  • WEEK 1 – Deep Dive: Data Organization with Excel Tables (Lesson)

Week 2: Sorting, Filtering, and Basic Formulas

Week 3: Basic Formulas Data Cleaning and Conditional Formatting

Week 4: Basic Formulas Data Cleaning and Conditional Formatting
Continue with Week 3.

Week 5: Pivot Tables & Slicers

Student Ratings & Reviews

No Review Yet
No Review Yet