MS Excel – Basics in English

Increase your Efficiency

• Working with the Ribbon
• Efficiency Tipps for your daily work
• Customizing the Status Bar
• Freeze Panel and Split the Table

Working with Functions and more

• Important basic Functions like SUM and AVERAGE
• Relative and absolute Cell References
• Partial Summation
• IF-THEN-ELSE Function

The Swiss Army Knife: Strg + T

• Format and adjust your tables
• Working with slicers and the summary row

Creating insights with Pivot-Tables

• Build up a Pivot-Table from your data source
• Working with the fieldlist
• Slicers and Timelines
• Not the usual chart: Pivot-Charts
• KPIs like percentages without formulas

Extend your Excel-Toolset

• Conditional Formatting
• Sorting and Filtering
• Create and edit Diagrams
• Sparklines
• Setup Printing
• Tipps&Tricks