Description
INTERMEDIATE MICROSOFT EXCEL TRAINING CURRICULUM
FILTERING DATA
- How to Filter data that contains a specific word(s).
- How to copy a Filter range to another sheet.
- How to Filter multiple columns.
- How to do a Filter search.
- How to Filter with And, Or Conditions.
- How to Filter dates and numbers.
- How to Filter by Colour.
- How to do Advanced Filter.
CHARTS
- How create charts.
- How to use the chart layout style.
- How to use the chart options.
- How keep charts up to date.
- How to create a combo chart.
CONDITIONAL FORMATTING
- How to highlight cell rules
- Top/Bottom rules
- Conditional formatting presets – data bars, colour scales, icon sets
- How use formulas for conditional formatting.
- How to use duplicate and unique values.
FREEZING ROWS AND COLUMNS
- How to freeze rows.
- How to freeze columns.
- How to freeze top row.
- How to freeze first column.
- How to unfreeze panes.
GROUPS AND SUBTOTALS
- How to group columns and rows.
- How to use the Subtotal command to summarise data with the count and sum function.
- How to remove the subtotal.
- How to remove all groups.
LINKS
- How to create a link to an existing file or webpage.
- How to place a link in the same worksheet or another worksheet.
- How to create a link to a new document.
- How to create a link to an email address.
- How to remove links.
OTHER VIEW OPTIONS
- How to create a new excel window.
- How to split an excel sheet.
- How to hide your excel window.
- How to arrange your excel window in different ways.
ANALYSING DATA WITH PIVOT TABLES & PIVOT CHARTS
- How to create a Pivot table.
- How to analyse Pivot table.
- How to use Timelines and Slicers.
- How to create a Pivot Chart.
SMARTART GRAPHICS
- How to insert SmartArt graphics.
- How to add text, shapes.
- Customise SmartArt graphics.
- SmartArt Graphics layout.
SORTING DATA
- How to sort by values.
- How to sort by range.
- How to sort by custom list.
- How to sort by cell colour.
- How to sort by cell icons.
- How to do multilevel sorting.
SPARKLINES
- How to create different sparklines.
- How to modify sparklines.
TABLES
- How to format data as a table.
- How to use predefined table styles.
- How to modify tables adding rows and columns.
- Other table style options.
- How to remove a table and clear formats.