Microsoft Excel 2013 Level 2

Recap of Basic Formulas and Functions
Using Large Excel Worksheets
o Increasing & decreasing the magnification
o Splitting the window,
o Freezing & unfreezing panes

Working with Multiple Worksheets
o Navigating between and selecting worksheets
o Renaming worksheets
o Selecting multiple worksheets
o Colouring worksheet tabs
o Copying & moving worksheets
o Copying and moving data between worksheets
o Using grouped worksheets
o Creating formulas across sheets
o Creating aggregate functions across sheets
o Referencing cells across sheets
o Hyperlinking between sheets

Using Paste Special & Flash Fill
o Working with Paste Special
o Copying values & formulas between worksheets
o Performing mathematical operations
o Creating data sequences using ‘Flash Fill’

Using Range Names
o Jumping to a named range
o Assigning names to ranges
o Using range names in formulas
o Editing and deleting named ranges
o Creating range names from headings
o Applying range names to existing formulas
o Creating named ranges across sheets

Appendix - Using Graphics in a Workbook (if time)
o Drawing and formatting ‘Shapes’
o Inserting SmartArt

Using Multiple Workbooks
o Opening, activating & tiling workbooks
o Copying data between workbooks
o Linking cells between workbooks
o Managing and troubleshooting workbook links

Creating Charts
o Creating, moving, resizing, printing & deleting charts
o Using built-in chart styles and ‘Quick Layouts’
o Formatting chart objects & data series
o Adding & removing chart elements (eg. titles, data labels, legend)
o Changing the data source
o Changing chart type and location
o Filtering chart categories and data series
o Creating chart templates
o Using ‘Recommended Charts’
o Advanced charting

• Creating a combination chart
• Using a secondary axis
• Adding a trendline
• ‘Sparklines’ (mini charts in a single cell)

o Using the ‘Quick Analysis button” to create a chart or add a SparkLine

Working with Excel Data Tables
o Creating & modifying a data table
o Working with the data form
o Creating an Excel table
o Using the ‘Quick Analysis button” to create an Excel table

Analysing Data Tables
o Sorting tables
o Sorting a table by multiple fields
o Filtering data in a table
o Creating a custom filter
o The SUBTOTAL function
o Using the ‘Quick Analysis button” to add totals to a table
o Use the Slicer to filter an Excel table

The next course in this series is:

• Excel 2013 Level 3