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

Microsoft Excel Beginner

DURATION 8h 40m Medium
CERTIFICATION Querytech Academy

Course Overview

Master the fundamentals of Excel including formatting, basic formulas, sorting, filtering, and conditional formatting.

Curriculum Structure

Comprehensive modules designed for real-world impact

1

Getting Started with Excel

Understand Excel interface, ribbons, navigation, workbooks vs worksheets, and saving formats

2

Basic Formulas and Functions

Use SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, and simple IF statements

3

Conditional Formatting

Apply highlighting rules, data bars, color scales, and icon sets

4

Data Entry and Cell Formatting

Master data entry techniques, number formats, alignment, fonts, borders, and cell styles

5

Data Types and Basic Formatting

Differentiate between Text, Numbers, Dates, and Formulas; apply effective formatting

6

Printing and Page Setup

Set print areas, headers/footers, page breaks, and scaling

7

Sorting and Filtering Data

Sort data by multiple columns, use AutoFilter, and custom filters

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.