Microsoft Excel – Basics in English
This hands-on oriented course will familiarize you with the basic handling of Microsoft Excel. You will learn to make calculations using simple formulas and functions and visualize business data with charts. We will cover efficient table design, the sparkline features and printing. This course also contains an introduction of some often-used techniques, like sorting data and conditional formatting. And of course, we will take a closer look on the newly introduced features of the latest Excel version.
This course will be delivered in English language!
Kursinhalte
Increase your Efficiency- Working with the Ribbon
- Efficiency Tipps for your daily work
- Customizing the Status Bar
- Freeze Panel and Split the Table
- Important basic Functions like SUM and AVERAGE
- Relative and absolute Cell References
- Partial Summation
- IF-THEN-ELSE Function
- Format and adjust your tables
- Working with slicers and the summary row
- 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
- Conditional Formatting
- Sorting and Filtering
- Create and edit Diagrams
- Sparklines
- Setup Printing
- Tipps&Tricks
Version
Damit Sie bestens vorbereitet sind, trainieren wir mit der neuesten Version der Anwendung. Unterschiede zu älteren Versionen werden bei Bedarf erläutert bzw. behandelt.Zielgruppe
Business workers, who want to learn the basic approach to Microsoft Excel.Voraussetzungen
General working with Microsoft WindowsAbschluß
Nach Seminarabschluss erhalten Sie ein tecTrain-Teilnahmezertifikat.
Buchen Sie Ihren Termin
Alle Preise zzgl. MwSt.
Angebot einholen
Ihr individuelles Kursangebot
Kostenvoranschlag
Unverbindlich herunterladen
Training Services
Services zu Ihrem Seminar
