COURSE INFORMATION

The aim of the course is to allow you to explore further formula options and display your data in charts for quick visual analysis. You will also learn how to work and manage lists of data.

  • Creating Charts
  • Intermediate formulas
  • Manage Data
  • Work with Tables

Creating Charts

  • Create Charts
  • Explore chart types
  • Change the chart layout
  • Move and Resize charts
  • Add chart elements
  • Modify chart data
  • Add trendlines
  • Create Chart templates
  • Create Sparklines

Print and Distribute

  • Set Print Area and Page breaks
  • Headers and Footers
  • Margins and Orientation

Intermediate Formulas

  • Review of Absolute & Relative cell references
  • Create and use Range Names
  • Work with the Insert Function tool
  • Try a variety of Functions from popular categories (DATE, LOGICAL, LOOKUP)

Manage Data

  • Quick Analysis
  • Outline and Subtotals
  • Data Validation
    Flash Fill
  • Import and Export data

Tables

  • Create a Table
  • Sort Data
  • Filter Data
  • Add Rows and Columns
  • Slicers
  • Remove duplicates
  • Overview of Creating Pivot Tables

Intermediate Formatting

  • Conditional Formatting
  • Apply Styles
  • Create and Modify Styles
  • Apply a Theme

Collaboration

  • Cell comments
  • Version History
  • Protect Worksheets
  • Protect Workbook structure
  • File Protection
  • 1 day trainer led or virtual
  • £195
  • Attendance of the Introduction to Excel course or a sound knowledge of copy/paste options, basic formulas, Absolute vs Relative cell referencing, and use of Autofill is recommended.
  • Advanced Excel
  • Summarising with Lists
  • Formulas and Functions
  • Analysing and presenting data
  • Charts and Dashboards