Excel: Increasing your efficiency (advanced users)

Classical courses

Version: Microsoft 365
Duration: 1 day (09:00-17:00)
Price training (excl. VAT) starting at: €1490
Number of people: 1-12p

Description

Do you know how to use Excel fluently, but do you feel like you could still improve your skills? Do you still need to master certain functions? Are you looking for tips on how to work more efficiently? If you’ve answered yes to these questions, you’ve come to the right place. Our ‘Excel: How do I increase my efficiency and productivity?’ course is packed with tips and tricks to help you finish your work in the tool even faster.

Objectives

After this training, you’ll know:

  • How to work with formulas, tables, PivotTable, chartc etc fluently
  • An array of useful keyboard shortcuts
  • How to work quickly and efficiently in Excel

Target Group

Everyone who works with Excel regularly and wants to learn how to use it more efficiently.

Prerequisites

Basic Excel knowledge is required.

Content

Part 1 General

  • Keyboard shortcuts
  • Navigating smoothly in a workbook

Part 2 Tables

  • Advantages of a table
  • Flash Fill

Part 3 Functions and Formulas

  • Cell names
  • Absolute and relative cell addressing
  • Logical functions (if, ifs, switch)
  • Lookup functions (vlookup, xlookup, match, index)

Part 4 Data validation

  • Limiting the contents of a cell
  • Customising Error messages
  • Looking up incorrect values in the workbook

Part 5 Conditional Formatting

  • Colouring cells based on the value in the cell
  • Data bars, shades, icons
  • Finding duplicate values
  • Combined conditional formatting
  • Using formulas in conditional formatting

Part 6 PivotTables

  • Showing calculations as percentages of the total
  • Grouping in PivotTables
  • Filtering PivotTables via slicers
  • Connecting slicers to multiple PivotTables
  • Creating a PivotTable from multiple Tables

Part 7 Charts

  • Creating, modifying, and formatting charts
  • Templates

Book this training

Let's start a conversation!

Team Xylos is ready to meet you