Excel Intermediate – Tutor Led
August 6
Duration: 1 Day
We can deliver training onsite at your workplace or via virtual classrooms if preferred.
For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package.
What you will learn:
| Managing Multiple Spreadsheets | Using Charts |
| · Using Multiple Worksheets | · Chart Objects |
| · Creating Multiple Views | · Creating a Chart |
| · Managing Multiple Worksheets and Workbooks | · Change the Location of a Chart
· Changing Chart Type, Style and Sub Type |
| · Linking Data Between Worksheets | · Changes to Chart Source Data |
| · Viewing Multiple Applications | · Chart Quick Menus
· Creating a Chart Template |
| Protection | Data Validation |
| · Workbook protection | · Adding Data Validation |
| · Worksheet protection | · Data Validation Messages |
| · Restrict Data Entry
· Data Validation Calculations |
|
| Conditional Formatting | |
| · Adding Conditional Formatting
· Remove Conditional Formatting · Colour Scales · Highlight Blank Scales · Icon Sets · Data Bars · Conditional Formatting Formulas |
Filter and Sort
· Sorting a List · Filtering a List · AutoFilters · Customer Auto Filters · Using Subtotals in a List
|
| Creating and Using Functions
· Using Built in Functions · Using Nested Functions · AUTOSUM · COUNT Functions · IF Functions · Using Date and Time Functions · Combine and Separating Text · Tracing and Correcting Worksheet Errors |
LookUps
· VLookUp · HLookUp · XLookUp
Pivot Tables · Creating a Pivot Table · Conditional Formatting within Pivot Tables · Pivot Table Slicers · Creating a Pivot Chart |
Duration: 1 Day
We can deliver training onsite at your workplace or via virtual classrooms if preferred.
