By using our website you agree to our use of cookies.

Microsoft Excel 2013 Intermediate

2 Day Course
Hands On
Code QAEX13ITM

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Calculating With Advanced Formulas (10 topics)

  • Use Excel's Quick Analysis Tools
  • Using Mixed References in Calculations
  • Work with Range Names
  • Calculating across Worksheets
  • Exploring Excel's Function Categories
  • Analysing Data Based on Criteria
  • Working with Text Functions
  • Calculating with Financial Functions
  • Using Logical Functions
  • Applying Lookup Functions

Auditing a Worksheet (5 topics)

  • Display formulas in worksheet cells
  • Show precedent and dependent cells
  • Finding and Resolving Errors
  • Using the Watch Window
  • Evaluating a Formula

Charts (6 topics)

  • Understanding Charts
  • Create a Chart
  • Modify and Format a Chart
  • Add and Remove Chart Data
  • Add a Trendline to a Chart
  • Analyse Data Using Sparklines

Mastering Excel Tables (6 topics)

  • Introducing Excel Tables
  • Creating Calculated Columns
  • Formatting a Table
  • Using Advanced Table Tools
  • Using Slicers
  • Converting Tables to Ranges

Working with Templates (3 topics)

  • Create a Hyperlink
  • Adding Comments
  • Work with Templates

Analysing Selected Data (4 topics)

  • Applying Basic Filters
  • Advanced Filters
  • Use Database Functions
  • Use Outlines to Organise Data

Organising Worksheet Data (3 topics)

  • Apply Basic Sorting to a Data Range
  • Advanced Sorting
  • Summarise Data with Subtotals

Apply Conditional Formatting (3 topics)

  • Conditional Formatting
  • Customising Conditional Formatting
  • Sorting and Filtering by Conditional Formats

An Introduction to Pivot Tables (2 topics)

  • Understanding Pivot Tables
  • Analyse Data with Recommended Pivot Tables

Appendix - Inserting Illustrations (4 topics)

  • SmartArt
  • Insert Images into a Spreadsheet
  • Insert Shapes into a Spreadsheet
  • Group and Layer Graphics

Prerequisites

At the end of this course you will be able to:

  • Calculate with advanced formulas
  • Audit formulas using the auditing tools
  • Work with Excel tables
  • Organise worksheet data so that data can be sorted and filtered
  • Create and modify Charts
  • Create Excel templates
  • Apply Conditional Formatting
  • Analyse data with Recommended Pivot Tables
User Microsoft Office Training Courses

Course PDF

Print

Sections