Querytech Academy Querytech Academy Academy
← BACK TO ALL COURSES COURSE_MSE-102

Microsoft Excel Intermediate

DURATION 11h 21m Medium
CERTIFICATION Querytech Academy

Course Overview

Learn essential data analysis tools such as PivotTables, advanced lookup functions, and professional reporting techniques.

Curriculum Structure

Comprehensive modules designed for real-world impact

1

Working with Large Datasets

Freeze panes, split windows, use Find & Replace efficiently, and manage large data

2

Advanced Lookup Functions

Master VLOOKUP, XLOOKUP, INDEX + MATCH, and dynamic lookups

3

Data Validation and Protection

Create dropdown lists, restrict input, and protect sheets/workbooks

4

Text and Date Functions

Use LEFT, RIGHT, MID, CONCAT, TEXT, DATE, EDATE, NETWORKDAYS, etc.

5

PivotTables and PivotCharts

Create, format, and analyze data with PivotTables and PivotCharts

6

Advanced Conditional Formatting & Visualization

Create advanced rules, use formulas in CF, and build better charts

7

Formula Auditing and Error Handling

Trace formulas, evaluate formulas, fix errors (#REF!, #N/A, #VALUE!, etc.)

Available Bootcamps

Choose a cohort and begin your journey to becoming job-ready

No active cohorts at the moment.
No upcoming cohorts scheduled yet.
No past cohorts available yet.