EX13L2 – Microsoft Office Excel 2013 Level 2

Enquire/Book this course

  • This field is for validation purposes and should be left unchanged.
Print this page
  • Code: EX13L2
  • Duration: Days 1
  • Price per delegate: £295.00 +VAT

Trained over 60000 delegates

Course delivered by industry expert instructors

Highly competitive pricing

 

Course Description

Creation of formula and organise data into tables, as well as looking at charts and templates.

Target Student: 

This course is designed for individuals who already have foundational knowledge and skills in Excel 2013 and are ready to advance their data analysis skills and abilities through the application of advanced Excel 2013 functionality such as tables, charts and formatting.

Prerequisites: 

  • Create basic spreadsheets
  • Select and edit data
  • Perform basic formatting
  • Open, close and save files
  • Create basic formulas - AutoSum
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Use the AutoFill feature

Performance-Based Objectives

  • Calculate across worksheets and named ranges
  • Work with Excel tables
  • Organise worksheet data so that data can be sorted and filtered
  • Create and modify Charts
  • Apply Conditional Formatting
  • Change Excel Options

Course Content

Lesson 1: Calculating With Advanced Formulas

  • Use Excel's Quick Analysis Tools
  • Work with Range Names
  • Calculating across Worksheets
  • Analysing Data Based on Criteria
  • Using Logical Functions (IF, AND, OR)
  • Applying Lookup Function

Lesson 2: Charts

  • 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

Lesson 3: Mastering Excel Tables

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

Lesson 4: Organising Worksheet Data

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

Lesson 5: Apply Conditional Formatting

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

Lesson 6: Analysing Selected Data

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

Lesson 7: Appendix - Excel Options