Excel Intermediate 1

Course Outline

This one-day course is for people who want expand their basic knowledge of Microsoft Excel to work with larger spreadsheets, create charts, manage tables of data and develop their knowledge of Excel’s functions.

  • Develop their skills to create and work with more complex formulae
  • Work with multiple worksheets, copying formats and formulas across worksheets
  • Represent data graphically using charts
  • Understand the concepts of creating and modifying Data Lists and Tables
  • Sort lists and filter information
  • Create Excel Functions; work with the Function Library and Function Wizard, understand Function syntax

Course Content

Overview and Recap of Interface

  • Freeze Panes
  • Split window
  • Page Layout View
  • Printing and Print Set up
  • Customise Quick Access Toolbar and Ribbon Tabs

Working with Comments

  • Insert, Edit, Show/hide, Print, Delete

Working with Multiple Worksheets

  • Copying Data Between Workbooks
  • View multiple sheets
  • Linking data between worksheets
  • Grouping worksheets
  • Hyperlinks to other files and worksheets
  • Using Paste Special and Live Preview
  • Copying Values & Formulas between Worksheets
  • Flash Fill

Managing Lists

  • Sorting Lists
  • Sorting Records By Multiple Fields
  • Using Auto-filter
  • Understanding filter criteria

More complex formulae

  • Calculations using dates; times; percentages; numeric values; currencies
  • Review of rules of BODMAS
  • Review of relative and absolute cell references

Functions

  • Generate statistics and calculations using SUM, AVERAGE, COUNT, MIN and MAX functions
  • Function Syntax, Wizard and Arguments
  • COUNTA, COUNTBLANK, COUNTIF and SUMIF
  • Simple IF functions to make decisions

Conditional Formatting

  • Conditional Formatting to highlight critical data
  • Applying filters to display cells with conditional formatting

Charts, Graphs and Sparklines

  • Creating, Moving, Resizing, Printing & Deleting Charts
  • Formatting Chart Objects & Data Series
  • Creating User-Defined Charts
  • Changing the Data Source; Editing Text/Axis Titles
  • Removing/Adding Axes Labels; Adding Data Labels & Tables
  • Creating Combination Charts
  • Using a Secondary Axis
  • Adding a Trendline
  • Sparklines

Excel Tables

  • Converting a range into a Table
  • Using Quick Analysis to create Tables
  • The Table Design ribbon
  • Adding rows to a table
  • Using the Total Row with Dynamic SUBTOTAL function
  • Analysing data with the Slicer
  • Structured References for Table formulas

Show the next months in

Location Dates Time Price exc. VAT   Status
Growtrain Ltd PO20 2BX 09 Jul 2020 09:00h – 16:00h £155.00 Registration Closes
Jul 09, 2020 10:00AM


Growtrain Ltd PO20 2BX

09 Jul 2020

09:00h – 16:00h

£155.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Growtrain Ltd PO20 2BX 10 Sep 2020 09:00h – 16:00h £155.00 Registration Closes
Sep 10, 2020 10:00AM


Growtrain Ltd PO20 2BX

10 Sep 2020

09:00h – 16:00h

£155.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Growtrain Ltd PO20 2BX 12 Nov 2020 09:00h – 16:00h £155.00 Registration Closes
Nov 12, 2020 9:00AM


Growtrain Ltd PO20 2BX

12 Nov 2020

09:00h – 16:00h

£155.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Contact Nina or Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This