ITAG Ref: T250210
Cost Details
Gross Cost per person: €60
Net Cost per person after rebate: €45
Course Content
Concepts and Functionality
Working with Excel Workbooks
- The Excel Screen
- View Options
- Splitting Worksheet
- Hiding Worksheets, Columns and Rows
- Save Options
-
Functions in Excel
- Sumif, Countif, Conditional IF statement, worksheet subtotal, vlookup / hlookup
Printing
Advanced Formatting
- Paste special
- Conditional formatting
Sorting and filtering data
Subtotals
Pivot Tables
Data Validation
Advanced Chart Editing
Auditing and error management
Working with multiple sheets and workbooks
Scenario Manager
Macros