Excel Know-how for Business Users
2-Day Workshop
Learn how to create a list of people with tasks in a single cell for a task list involving multiple people – all without programming!
Discover how to implement automatic project planning with a Gantt chart. Simply enter the start date and number of days, and let Excel handle the rest. The current date will be automatically highlighted.
Our seminar will show you practically how to use these features to work more efficiently and plan complex projects in an organized way.
Workshop Content
Optimizing Work Processes in Excel
- Personalizing Excel
- Perfecting data entry
- Combining row contents without using a function
- Unpivoting tables
- Switching rows and columns
Solution-Oriented Use of Essential Excel Functions
- Performing calculations with numbers and text values
- Summing only visible columns
- Modeling values with logical functions
- Refining data with specialized functions
- Determining and visualizing the current state
Excel Case Studies:
- Numbering only after input in the column
- Automatically creating a seating plan
- Calculating quarters
- Comparing two tables
- Project planning with a Gantt chart
- Combining multiple tables into one list
- Converting a task list into a people list
- Visualizing proportions with a treemap chart
- Presenting Excel data in PowerPoint
Business Intelligence (Power BI):
- Data mining with PowerQuery
- Regular execution of analytical tasks
- Creating Pivot Tables across multiple tables
Who Should Attend This Workshop?
This workshop is ideal for business analysts, data scientists, and anyone who wants to process, analyze, and present large datasets efficiently and attractively using Excel.