Formation Excel 2021, from Fundamentals to Advanced

-Module 1: Introduction to Excel Mastery

Understanding the Training Structure

Personalizing Learning through Knowledge Assessment

Practical and Digital Activities

Comprehensive Online Knowledge Evaluation with Recommended Learning Paths

-Module 2: Excel Fundamentals

Navigating Excel Environment

Basic Data Entry and Cell Manipulation

Undo and Redo Actions

Workbook Management

Hands-on Activities and Digital Exercises

-Module 3: Basic Calculations

Introduction to Formulas

Basic Mathematical Functions

Percentage Calculations

Formula Copying Techniques

Practical Exercises for Skill Reinforcement

-Module 4: Data Presentation

Applying Number Formats

Basic Formatting Techniques

Cell Alignment and Borders

Cell Color and Font Styling

Hands-on Practice Sessions

-Module 5: Printing and Page Layout

Page Setup Options

Print Preview and Printing

Page Breaks and Print Areas

Header and Footer Customization

Digital Activities for Practical Learning

-Module 6: Utilizing Excel Help

Spell Check and Find/Replace Functionality

Zoom and View Options

Row/Column Management

Cell Insertion and Deletion

Copy and Paste Techniques

Guided Digital Exercises

-Module 7: Sheet and Tab Management

Sheet Renaming and Tab Colorization

Insertion, Deletion, and Hiding Sheets

Freezing Panes and Splitting Windows

Print Title Rows/Columns

Digital Practice Sessions for Skill Enhancement

-Module 8: Advanced Data Manipulation

Multi-Line Cell Display

Absolute References in Formulas

Copying Values and Transposing Data

Date Formats and System Date Functions

Conditional Formatting Techniques

Guided Exercises for Skill Mastery

-Module 9: Charting Data Visualization

Creating and Modifying Charts

Selecting Chart Elements

Formatting Chart Elements

Creating Chart Types

Hands-on Digital Practice Sessions

-Module 10: Enhancing Charts and Objects

Customizing Data Labels

Managing Chart Axes and Series

Exploring Chart Types and Templates

Creating Specialized Charts

Adding and Formatting Objects
Digital Exercises for Skill Enhancement

-Module 11: Data Tables and List Management

Subtotal Calculations

Creating and Managing Data Tables

Sorting and Filtering Data

Advanced Filtering Techniques

Guided Practice Exercises

-Module 12: Pivot Tables and Analysis

Creating Pivot Tables

Modifying and Analyzing Pivot Table Data

Changing Pivot Table Source Data

Filtering and Formatting Pivot Tables

Creating Pivot Charts

Digital Practice Sessions for Advanced Proficiency

-Module 13: Increasing Efficiency

Data Conversion Techniques

Generating Data Series

Custom Views and Annotations

Error Checking and Formula Evaluation

Using the Watch Window

Practical Exercises for Improved Efficiency

-Module 14: Advanced Calculation Functions

Lookup Tables and Search Functions

Text Functions

Time and Date Calculations

Logical Functions

Nested Conditions

Financial Functions

Hands-on Practice Activities