Get Better at Your Job with Excel
2-Day Workshop
Based on a participant list, an automatic seating plan consisting of form elements will be created.
Numbering is often used in Excel, and these automatic numberings work even when rows are deleted.
A waffle chart can be used to present a value convincingly, whether it is a whole number or a percentage.
Workshop Content
Efficient Work with Excel:
- Personalize the interface
- Use cell names for faster function creation
- Expert tips for using the Name Manager
- Create dynamic range names
Pro Tips for All Areas:
- Optimize number display
- Navigate complex workbooks with hyperlinks
- Automatic and sequential numbering
- Use watermarks as copyright notice
Excel Highlights:
- Conditional formatting adds color
- Complex filtering with wildcards
- Automatically display filter results on other sheets
- Mirror two tables
- Create a dynamic seating plan
- Create waffle charts to present a value
Analysis with Pivot Tables:
- Define data for analysis
- Create pivot tables and adjust layouts
- Calculate percentages without writing a formula
- Create calculations in pivot tables
Optimizing Workflows with Macros:
- Step-by-step guide to your first macro
- Create macros for formatting
- Methods to start a macro
Who Should Attend This Workshop?
This workshop is aimed at data scientists, business analysts, and anyone who works with large datasets, processes them efficiently and in a structured manner, and wants to improve their work with Excel.