Microsoft Excel Advanced Level 1

Using Names

A single cell or a range of cells can be named to simplify references in formulas and functions.

You’ll learn how to create Names, use Names in formulas and functions and Manage Names.

Using Tables

The fancy formatting options for tables are just the beginning, what makes tables excellent to work with, it the way they interact with Formulas, Functions, PivotTables, Data Validation and a host of other features.

Advanced Functions

Understanding Excel’s Functions is an import aspect of using Excel to it’s full potential. The advanced functions covered in this course aims to help you understand function structure and requirements which can be applied to any function.

Advanced Conditional Formatting

Conditional formats are a valuable method for error checking of data entries and highlighting discrepancies between numbers.

For example, when a cell entry exceeds a specified value or is outside a particular range, the user can be alerted by seeing the value displayed in a different colour.

Data Managment

Learn about Advanced techniques for Sorting, Filtering and Summarising Data with the SUBTOTAL function.

PivotTables and PivotCharts

A PivotTable is an interactive table that quickly summarises, or cross-tabulates, large amounts of data from lists or tables. Field headers can be dragged to various regions within the PivotTable structure with complete flexibility to create a report.

Once a PivotTable is populated with data it can be rearranged, charted, formatted, filtered, calculated, summarised and broken up into individual pages.

Macros (VBA for Excel)

When the same actions or tasks are repeatedly performed in documents, it might be time to create a macro. A macro is a recording of each command and action performed to complete a task. Then, whenever a task needs to be carried out in a document, the macro could be run instead.