Excel 365 - Level I

This training focuses on the use of Microsoft Excel. It allows users to consolidate their knowledge and improve their use of the tool. Participants become more comfortable working with spreadsheets. It supports a more efficient use of Excel.

At the end of this training, the participant will be able to :

• Create and manage tables
• Format and manipulate data
• Know how to create and print charts from Excel data

Format table

• Formating cells and using styles (Refresh)

Calculate

• Entering and copying formulas
• Relatives / 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 function
  • 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
• Introduction to Pivot Tables

Verify data

• Use auditing tools
• Evaluate a formula

At the end of the training, participants will receive a certificate of attendance issued by the House of Training.