Description

Already comfortable with Excel, but feel like you could work just that bit faster? Are there a few functions you haven't quite mastered yet? Could you use some tips to work more efficiently? Then you're in the right place. In our course "Excel: How can I boost my efficiency?" you'll get plenty of tips and tricks to get your work done even faster in the tool.

Objectives

After this Excel training:

• You'll work fluently with formulas, tables, PivotTables, charts and more

• You'll know all kinds of handy shortcuts

• You'll be able to do your work in Excel quickly and efficiently

Target audience

Anyone who regularly works with Excel and wants to learn to work more efficiently with it.

Prerequisites

You have a good basic knowledge of Excel.

Contents

General

• Shortcuts

• Navigating a workbook smoothly

Tables

• Benefits of a table

• Flash Fill

Functions and formulas

• Cell names

• Absolute and relative cell referencing

• Logical functions (IF, IFS, SWITCH)

• Lookup functions (VLOOKUP, XLOOKUP, MATCH, INDEX)

Data validation

• Restricting a cell's content

• Custom error messages

• Finding invalid values in the workbook

Conditional formatting

• Colouring cells based on the cell's value

• Data bars, colour scales, icons

• Finding duplicate values

• Combined conditional formatting

• Using formulas in conditional formatting

PivotTables

• Showing calculations as percentages of the total

• Grouping in PivotTables

• Filtering PivotTables via slicers

• Connecting slicers to multiple PivotTables

• Formatting pivot tables based on multiple tables

Charts

• Creating, changing and formatting charts

• Templates