Learn Microsoft Excel Course Basic & Intermediate

Excel Training Basic & Intermediate Objectives

Our Excel Training Basic & Intermediate course focuses on foundational to intermediate Excel skills. Participants will start with basic spreadsheet navigation, data entry, and formatting techniques. Moving into intermediate levels, attendees will delve into essential functions like SUM, VLOOKUP, and IF statements, along with mastering conditional formatting and chart creation for data visualization. Practical exercises reinforce learning in data manipulation, sorting, and filtering to effectively manage large datasets. By the end of the training, participants will be proficient in creating dynamic reports, utilizing Excel's tools for analysis, and boosting workplace productivity through efficient spreadsheet management.

Basic Excel Course Duration: 1 Day

Lesson 1: Getting Started with Excel 2021

• Topic A: Navigate the Excel User Interface
• Topic B: Use Excel Commands
• Topic C: Create and Save a Basic Workbook
• Topic D: Enter Cell Data

Lesson 2: Performing Calculations

• Topic A: Create Worksheet Formulas
• Topic B: Insert Functions
• Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

• Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
• Topic B: Search for and Replace Data
• Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

• Topic A: Apply Text Formats
• Topic B: Apply Number Formats
• Topic C: Align Cell Contents
• Topic E: Apply Basic Conditional Formatting
• Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

• Topic A: Preview and Print a Workbook
• Topic B: Set Up the Page Layout
• Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

• Topic A: Manage Worksheets
• Topic B: Manage Workbook and Worksheet Views

Intermediate Excel Course Duration: 1 day

Lesson 1: Working with Functions

• Topic A: Work with Ranges
• Topic B: Use Specialized Functions
• Topic C: Work with Logical Functions
• Topic D: Work with Date and Time Functions
• Topic E: Work with Text Functions

Lesson 3: Analyzing Data

• Topic A: Create and Modify Tables
• Topic B: Apply Intermediate Conditional Formatting
• Topic C: Apply Advanced Conditional Formatting

Lesson 5: Using PivotTables and PivotCharts

• Topic A: Create a PivotTable
• Topic B: Analyze PivotTable Data
• Topic C: Present Data with PivotCharts
• Topic D: Filter Data by Using Timelines and Slicers

Lesson 2: Working with Lists

• Topic A: Sort Data
• Topic B: Filter Data
• Topic C: Query Data with Database Functions
• Topic D: Outline and Subtotal Data

Lesson 4: Visualizing Data with Charts

• Topic A: Create Charts
• Topic B: Modify and Format Charts
• Topic C: Use Advanced Chart Features