Advanced techniques for data entry, formatting, analysis, and automation with Excel

In this two-day workshop, participants learn advanced techniques for entering, formatting, and analyzing Excel data. The course shows how to effectively protect data, work with logical and lookup functions, and perform complex analyses using pivot tables.
In addition, participants are introduced to macros to automate recurring tasks and make workflows more efficient.

Your benefits at a glance

• Advanced functions for data analysis, logic, and lookups
• Create, customize, and analyze pivot tables
• Protect data and worksheets effectively
• Record and use macros for automation
• Available as in-person or online training

Course Content

Editing and formatting tables

• Apply conditional formatting
• Create drop-down lists
• Define and use named ranges

Protecting data

• Protect workbooks
• Protect worksheets
• Protect cells and ranges

Data analysis with functions

• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• IFERROR

Logical and array functions

• Create simple IF formulas
• Combine functions (AND, OR, NOT, etc.)
• Use VLOOKUP

Data analysis with pivot tables

• Create pivot tables from Excel data
• Customize rows and columns
• Use table layout and options
• Create PivotChart reports

Recording macros

• Basics: What are macros?
• Record and save simple macros
• Assign macros to buttons

Prerequisites

• Participation in an Excel basics 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 them
• People who analyze, visualize, and automate data
• Professionals in controlling, administration, project management, or commercial/business fields