Excel - Productivity

This training focuses on improving productivity in Excel by working efficiently with large tables, data validation, conditional formatting, Flash Fill, sheet management, links and keyboard shortcuts. It helps participants streamline their workflow and speed up everyday tasks.

  By the end of this training, participants will be able to:

• work efficiently with large tables

• use validation, conditional formatting and Flash Fill

• manage sheets and create links

• Manipulate large tables
• • Definition
  • Rules for building a list
  • Freeze panes, repeat headers …
  • Format as table
  • • Table name
    • Add a totals row
  • Moving & selecting in an efficient way
  • Data validation
  • Find/replace data
• Conditional Formatting
• • Apply a conditional formatting to cells
  • Create a rule
  • Manage the formatting rules: edit, delete
• The flash fill
• • Automatically extract or combine data
  • Start flash fill automatically/manually
• Managing sheets
• • Add, rename, delete a sheet
  • Move & copy a sheet
  • Set a color to the sheet tab
• Create and manage links
• Keyboard shortcuts

• Basic Excel skills