FR
EN
Details
Goals
Ability to create and manage tables. Format and manipulate data. Know how to create and print charts from Excel data.
Prerequisite
Knowledge of the Windows environment and the basics of Excel (see Excel 365 - Basics course).
Contents
Format table
Calculate
- Entering and copying formulas
- Relative/absolute references ($)
Functions
- Inserting a function manually, formula autocomplete
- Inserting a function using the wizard
- Main functions (reminder)
- Statistical functions (Countif, Sumif, Countifs, Sumifs, etc.)
- Text functions
- Date functions
Conditional formatting
- Applying predefined conditional formatting
- Customizing conditional formatting
Using range names
- Creating and using a range name
- • Modifying and deleting a range name, defining its scope (file, worksheet)
Data tables
- Creating a data table (Format as Table)
- Creating formulas using references to a data table
Presenting data as a chart
- Creating a chart
- Modifying/Formatting a chart
- Using chart styles
- Creating and using a chart template
- Sparklines
Analyzing data
- Sorting
- Filtering
- Remove duplicates
- Sheet View (custom views)
- Introduction to Pivot Tables
Verify data
- Use auditing tools
- Evaluate a formula
Sign up
Next session(s)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!