Microsoft Excel

Microsoft Excel - Level 2

Upcoming Microsoft Excel Level 2 courses:

Microsoft Excel - Level 2
1 day
Start date: 17 Sep 2024, 09:30am (Tuesday) In-class training
Microsoft Excel - Level 2
1 day
Start date: 07 Oct 2024, 09:30am (Monday) ONLINE training
Microsoft Excel - Level 2
1 day
Start date: 14 Nov 2024, 09:30am (Thursday) In-class training
Microsoft Excel - Level 2
1 day
Start date: 02 Dec 2024, 09:30am (Monday) ONLINE training
Microsoft Excel - Level 2
1 day
Start date: 20 Jan 2025, 09:30am (Monday) ONLINE training
Microsoft Excel - Level 2
1 day
Start date: 12 Feb 2025, 09:30am (Wednesday) In-class training

Microsoft Excel Level 2

Course Aim

To introduce additional features of Excel and to develop topics covered in the previous course. The course will encourage user confidence and will provide delegates with a comprehensive understanding of the commands and functions available in Excel at this level, enabling them to further manage spreadsheets, graphs and databases by the end of the course.

Who Should Attend?

Users with a good working knowledge of Excel who want to develop their knowledge further. Can set a simple spreadsheet up from the start and should already be able to perform basic calculations using formulae and functions.

Prerequisites

Attended the Level 1 Excel course or been using Excel for quite some time.


Course Content

Revision from L1

  • Properties of the screen
  • Setting Excel options
  • Customising the Quick Access Toolbar
  • Setting up a spreadsheet
  • Converting Excel spreadsheets to PDF

Multiple Worksheets

  • Switching between worksheets
  • Renaming worksheets
  • Inserting and deleting worksheets
  • Moving and copying worksheets
  • Grouping and ungrouping worksheets
  • Copying worksheets to other workbooks

Working with Formulae and Functions

  • Understanding the structure of calculations
  • Formula and function revision
  • Revising BODMAS
  • Keeping calculations updated
  • Performing calculations across worksheets
  • Relative and absolute cell referencing
  • IF function

Data Management - Sorting

  • Guidelines for creating a database
  • Setting up a database
  • Sorting records by text, numbers and dates
  • Sorting by more than one field

Data Management – Filtering

  • Turning the filter on and off
  • Filtering records using the Filter
  • Setting multiple filters
  • And and Or Criteria
  • Copying filtered data
  • Clearing all filters

Charting Worksheet Data

  • Plotting worksheet data
  • Plotting non-adjacent ranges
  • Creating a chart
  • Moving and resizing an embedded chart
  • Printing charts
  • Changing the chart type, layout and style
  • Formatting the elements of a chart
  • Adding, removing and formatting data labels
  • Changing the font and size of text labels
  • Showing a data table
  • Changing the axis scale
  • Formatting numbers on the axis
  • Displaying and hiding gridlines
  • Positioning the legend
  • Formatting the plot area
  • Printing charts

Boost your confidence while enhancing your knowledge – Let’s get started now!

We use cookies, which are placed on your computer or other device. By using this site, you agree to such cookies being used. To find out more please see our cookies policy.