Training Course Outline
Excel 2013 pivot tables
- Creating and using a pivot table
- Filtering and sorting data within a pivot table
- Automatically grouping data in a pivot table and renaming groups
- Manually grouping data in a pivot table and renaming groups
Excel 2013 input tables
- One-input data tables
- Two-input data tables
Excel 2013 charts
- Creating a combo line and column chart
- Changing the chart type for a particular data series
- Adding a data series to a chart
- Removing a data series from a chart
- Re-positioning chart title
- Re-positioning the chart legend
- Moving and formatting chart data labels
- Modifying chart axis scales
- Formatting an axis to display using commas
- Inserting images into chart columns
- Formatting the chart plot area using a picture
- Formatting the chart area using a picture
Excel 2013 and hyperlinks
- Inserting a hyperlink
- Editing a hyperlink
- Removing a hyperlink
Linking & embedding within Excel 2013
- What is embedding and linking?
- Linking data within a worksheet
- Linking cells between worksheets within a workbook
- Linking data between workbooks
- Linking data from Excel to a word document
- Linking an Excel chart to a word document
- Updating, locking and breaking links
Importing text files into Excel 2013
- What is a delimited text file?
- Importing a delimited text file
Sorting, filtering & totalling data within Excel 2013
- Sorting data by multiple columns at the same time
- Applying a pre-installed custom sort
- Creating a customized list and performing a custom sort
- Deleting an Excel customised list
- Using AutoFilter
- Using AutoFilter to perform multiple queries
- Top 10 AutoFilter
- Removing all AutoFilters from a worksheet
- Advanced filter criteria
- Sub-totalling
- Removing subtotals
- Expanding and collapsing outline detail levels
Tracking and reviewing changes in Excel 2013
- Enabling or disabling the ‘track changes’ feature
- Sharing, comparing and merging worksheets
Excel 2013 scenarios
- Scenario manager
- Scenario summary reports
Validating within Excel 2013
- Data validation – whole number
- Data validation – decimal number
- Data validation – list
- Data validation – date
- Data validation – time
- Data validation – text length
- Customising a validation input message and error alert
- Removing data validation
Auditing techniques in Excel 2013
- Tracing precedent cells
- Tracing dependent cells
- Identifying cells with missing dependents
- Showing all formulas in a worksheet, rather than the resulting values
- Inserting and viewing comments
- Editing comments
- Deleting comments
- Showing and hiding comments
Macros within Excel 2013
- Recording an Excel macro
Excel 2013 passwords & security issues
- Adding ‘open’ password protection to a workbook
- Adding ‘modify’ password protection to a workbook
- Removing an ‘open’ password from a workbook
- Removing a ‘modify’ password from a workbook
- Password protecting cells and worksheets
- Hiding formulas
- Un-hiding formulas
Available separately, as part of our Microsoft Office 2013 courseware bundle, or as part of the full IT Courseware library