Excel 2013 – Intermediate

Duration: 1 day

Course Aims and Objectives:

The Intermediate Excel 2013 training course demonstrates how to work more efficiently with workbooks and enhance the appearance of the data in the spreadsheets.

You will learn how to use more advanced formulae and functions. Use various tools to analyse data such as sorting, filtering, conditional formatting and auditing. You will also learn how to organize your data using tables and present data using charts.

Who should attend:

This course is designed for Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.

Assumed Knowledge

It is also recommended that proposed delegates have attended a Microsoft Excel 2013 Introduction course or have equivalent knowledge.

Course Outline Summary

Please note: The topics which are covered during this Intermediate Course may be included in either the Core Essentials Manual or the Advanced Essentials Manual. To identify the relevant manual please refer to the name in brackets after each topic.

 

Work with Basic Calculations and Functions

  • Using Mixed References in Calculations (Advanced Essentials)
  • Using Absolute Cell, Column and Row References (Advanced Essentials)
  • Work with Statistical Functions e.g. Average, Max, Min, Count and Counta (Core Essentials)
  • Work with Range Names (Advanced Essentials)

 

Use Multiple Worksheets and Workbooks

  • Link Multiple Worksheets (Advanced Essentials)
  • Calculate across Worksheets (Advanced Essentials)
  • Linking Workbooks (Advanced Essentials)

 

Calculating with Advanced Functions and Formulae

  • Work with Text, Date, Time and Financial Functions
  • Use Excel’s Quick Analysis Tools
  • Work with Logical Functions IF, AND, OR (Advanced Essentials)
  • Create Lookup Functions Vlookup and Hlookup (Advanced Essentials)
  • Use the Formula Auditing Commands (Advanced Essentials)

 

Working with Graphic Objects

  • Work with Shapes (Core Essentials)
  • Insert and Format SmartArt (Core Essentials)
  • Adding Text Boxes (Core Essentials)
  • Inserting Pictures and ClipArt (Core Essentials)
  • Use the Screenshot Command (Core Essentials)
  • Working with Symbols and Equations (Core Essentials)

 

Mastering Excel Tables

  • Work with Data Tables (Advanced Essentials)
  • Create Calculated Columns (Advanced Essentials)
  • Filter and Sort Data (Core Essentials)
  • Use Slicers to Filter Data (Core Essentials & Advanced Essentials)
  • Summarize Data with Pivot Tables (Advanced Essentials)

 

Apply Conditional Formatting

  • Customising Conditional Formatting
  • Sorting and Filtering by Conditional Formats

 

Working with Charts

  • Modify Charts (Core Essentials)
  • Add Trendlines to a Chart
  • Analyse Data using Sparklines (Core Essentials)