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

  • Duration: 1 day

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
  • Which functionalities can boost your Excel workflow
  • 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
  • Navigate a workbook easily

Part 2 Working with cell names

  • What is a cell name?
  • Define a cell name
  • Use the Name Manager

Part 3 Functions and formulas

  • Absolute and relative cell address
  • SumIf(s), CountIf(s), Vlookup, IfError
  • Age calculation

Part 4 Tables

  • Advantages of a table
  • Convert a list into a table
  • Analyse a table with Quick Analysis
  • Using Flash Fill

Part 5 Data validation

  • Limit the content of a cell
  • Edit error messages
  • Look up incorrect values in a workbook

Part 6 Conditional formatting

  • Colour cells based on their value
  • Data bars, colour hues, icons
  • Find duplicate values
  • Combined conditional formatting
  • Use formulas in conditional formatting

Part 7 PivotTables

  • Create PivotTables based on multiple tables
  • Show calculations as percentages compared to the total value
  • Group data in PivotTables
  • Use slicers in PivotTables

Part 8 Charts

  • Create, edit and format charts
  • Chart templates

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

This training as in-company training?

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request