Microsoft Excel Workshop – Calculation/Worksheet techniques/Pivot tables
Training Objectives
In this workshop, students will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user. We will show you all the powerful features and possibilities that allow you to quickly and effectively use calculation and spreadsheet functions as well as use and/or create advanced filters and Pivot tables.
Course Prerequisites
Basic Knowledge in Excel
Course Description
- Calculation and Spreadsheet functions
- Working with large worksheets, outlining and grouping
- Creating Complex formulas
- Creating and editing Name ranges
- Creating and editing Comments
- Viewing formulas and printing
- Relative and absolute reference
- Using Excel Function wizard
- Creating and editing conditional formatting
- Creating Excel Templates
- Creating, copy, move, edit and delete worksheets
- Protecting cells, worksheets and workbook
- Advanced filters, Subtotals and Pivot tables
- Consolidating multiple Worksheets and Workbooks
- Advanced filters
- Evaluate data with Pivot tables and Pivot charts
- Creating, editing and saving View and Report Manager
- Importing lists from other programs and using Import Manager
Upcoming Classes and Price
Duration
1 day
Price per Student
189,00 € plus VAT
(Price incl. 19% VAT.: 224,91 €)
On site training
For your customized - on site training we tailor the course to your needs by adapting the schedule, meeting place and applications to fit with your particular agenda. For fast problem solving you can also schedule individual time with one of our instructors (training on the job).
You could not find the class you need? Please contact us directly. We are happy to further assist you.
Keywords for this seminar
Excel, Microsoft, Office, Office 2007, pivot table, spreadsheet