Intermediate Excel

Turn unorganised data into useful information and quickly make spreadsheets your friends. The course starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.

Notes:
• All lessons are bite-sized and self-contained, so you can select only what you need.
• Features matching content with Interactive Online Learning and Skills Assessments.

Creating and Working with Charts

• Choosing and selecting the source data
• Choosing the right chart
• Inserting a chart
• Editing, adding and removing chart data
• Changing chart data
• Changing chart layout and style
• Working with chart labels
• Changing the chart gridlines
• Changing the scale
• Emphasizing data
• Using chart templates
• Changing chart type
• Using sparklines

Managing Workbooks

• Using workbook views
• Selecting and switching between worksheets
• Inserting and deleting worksheets
• Renaming, moving and copying worksheets
• Splitting and freezing a window
• Creating headers and footers
• Hiding rows, columns, worksheets and windows
• Setting the print area
• Adjusting page margins and orientation
• Adding print tiles, gridlines and row and column headings
• Adjusting paper size and print scale
• Printing a selection, multiple worksheets and workbooks
• Working with multiple workbook windows
• Creating a template
• Protecting a workbook
• Protecting worksheets and worksheet elements
• Sharing a workbook

More Functions and Formulas

• Formulas with multiple operators
• Inserting and editing a function
• AutoCalculate and manual calculation
• Defining names
• Using and managing defined names
• Displaying and tracking formulas
• Understadnding formula errors
• Using logical functions (IF)
• Using financial functions (PMT)
• Using database functions (DSUM)
• Using lookup functions (VLOOKUP)
• User defined and compatibility functions
• Financial functions
• Date & time functions
• Math & trig functions
• Statistical functions
• Lookup & reference functions
• Database functions
• Text functions
• Logical functions
• Information functions
• Engineering and cube functions

Working with Data Ranges

• Sorting by one column
• Sorting by colours or icons
• Sorting by multiple columns
• Sorting by a custom list
• Filtering data
• Creating a custom autofilter
• Using an advanced filter

Working with Tables

• Creating a table
• Adding and removing data
• Working with the total row
• Sorting a table
• Filtering a table
• Removing duplicate rows of data
• Formatting the table
• Using data validation
• Summarising a table with a pivottable
• Converting to a range