This courses will provide the learner with lots of practical Excel experience as well as useful tips and tricks.
- Hiding Rows and Columns
- Worksheet Panes
- Grouping and Ungrouping
- Sorting and filtering lists
- Forms in Excel
- Creating and managing data links
- Summary Reports - Sub Totaling Data
- Multiple Subtotals & Removing Subtotal
- Summary Report Outlining
- Analysing Data with PivotTables
- Creating & Modifying a PivotTable
- Changing PivotTable Summary
- Goal Seek
- The Scenario Manager
- IF Functions & Nested IFs
- Chart elements
- Formatting a chart axis
- Creating a combination chart
Did You Know? You will get free DCM Membership if you decide to book the Intermediate Excel Course. As a member company, you will have access to 100's of free courses for your team.