Skip to main content

Excel: How do I increase my efficiency? (advanced users)

Version: Office 365
Duration: 1 day
Price incompany training: € 1100 VAT excl. / Terms for incompany training.

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
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?