Discover the Excel spreadsheet software and master all its features. From the basics to advanced commands, this training will help you progress through all aspects of the software (data entry and formatting, simple and advanced formulas, charts, long table management, pivot tables, advanced tools, and more).
Objective: By the end of the course, participants will be able to use both the fundamental and advanced features of Excel 2021.
Prerequisites: No prior knowledge of Excel is required. Minimal experience with the software may help participants progress more quickly.
Target audience: Any user wishing to discover or review the basics of Excel and explore advanced features.
Here’s the continuation translated into English from the uploaded file:
1. EXCEL 2021 – LEVEL 1: ESSENTIAL KNOWLEDGE
This module offers interactive training composed of 45 training videos, 45 practice exercises, and 5 additional information points.
• Introduction to spreadsheets
• Opening a workbook
• Overview of the environment
• Navigating within a workbook
• Data entry assistance
• Entering data
• Selection, copying, and moving data
• Selecting and clearing cells
• Undoing and redoing actions
• Column width/row height
• File saving basics
• Saving a workbook
• Modifying cell content
• Creating a new workbook
• Entering formulas
• Sum and other simple calculations
• Percentage calculations
• Copying formulas to adjacent cells
• Simple number formats
• Applying a theme
• Highlighting text
• Font and font size
• Cell content alignment
• Cell colors
• Cell borders
• Page setup
• Print preview and printing
• Page breaks
• Print area
• Headers and footers
• Header and footer customization
• Using Excel Help
• Spell checking
• Find and replace
• Zoom display
• Inserting/deleting rows, columns, and cells
• Moving cells
• Copying to non-adjacent cells
• Quick formatting copy
• Merging cells
• Text orientation
• Cell styles
• Data sorting
• Worksheet naming and tab color
• Inserting, deleting, and adding sheet backgrounds
• Moving, copying, and hiding worksheets
• Freeze panes and split windows
• Repeating row/column titles in printing
• Hiding worksheet elements
• Grouping data with outlines
(And it continues with Level 2, Level 3, Microsoft Office use cases, Excel use cases, and a digital workbook.)