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
