PDF
Advanced techniques for data formatting, analysis, pivot tables and automation with Excel 365.
In this two-day training course, participants will learn advanced techniques for entering, formatting and evaluating Excel data. The focus is on professional data analysis, the use of logic and reference functions, and the efficient use of pivot tables.
In addition, participants will be introduced to macros for automating recurring tasks and significantly speeding up workflows.
Ideal for anyone who wants to bring their Excel skills up to a professional level and evaluate complex data with confidence.
Your advantages at a glance
- Advanced data analysis and function application
- Creating, customising and graphically evaluating pivot tables
- Protecting data in a targeted manner and securing workbooks
- Introduction to macros for automation
- Participation in person or online possible
Seminar Contents
Working with Tables
- Edit and format tables
- Apply conditional formatting
- Create drop-down lists
- Define and use named ranges
Data Analysis with Functions
- SUMIF, SUMIFS
- COUNTIF, COUNTIFS
- IFERROR
Logical Functions
- Create simple IF() formulas
- Combine functions (AND(), OR(), etc.)
- IFS(), LAMBDA()
Array and Dynamic Array Functions (New in Excel 365)
- VLOOKUP(), XLOOKUP()
- CHOOSECOLS(), FILTER(), UNIQUE(), SORT()
Date and Time Calculations
- Basic date calculations
- Formatting date and time values
Data Analysis with Pivot Tables
- Create PivotTables from Excel data
- Modify rows and columns
- Use table layouts and PivotTable options
- Create PivotCharts
Data Protection
- Protect workbooks
- Protect worksheets
- Protect cells and ranges
Macros and Automation (Introduction)
- Record and save macros
- Automate routine tasks
Prerequisites
- Participation in an Excel fundamentals course or equivalent solid knowledge
- Basic experience working with Excel spreadsheets
Target Audience
- Users with good basic Excel skills who want to deepen and expand their knowledge
- Professionals who want to efficiently analyze, visualize, and automate data
- Employees in controlling, administration, project management, or commercial/business roles
