Microsoft Excel

Microsoft Excel - Level 1

Upcoming Microsoft Excel Level 1 courses:

Microsoft Excel - Level 1
1 day
Start date: 09 Sep 2024, 09:30am (Monday) ONLINE training
Microsoft Excel - Level 1
1 day
Start date: 11 Oct 2024, 09:30am (Friday) In-class training
Microsoft Excel - Level 1
1 day
Start date: 04 Nov 2024, 09:30am (Monday) ONLINE training
Microsoft Excel - Level 1
1 day
Start date: 12 Dec 2024, 09:30am (Thursday) In-class training
Microsoft Excel - Level 1
1 day
Start date: 16 Jan 2025, 09:30am (Thursday) In-class training
Microsoft Excel - Level 1
1 day
Start date: 10 Feb 2025, 09:30am (Monday) ONLINE training

Microsoft Excel Level 1

Course Aim

This introduction to Excel will provide delegates with a comprehensive understanding of the commands and functions available in Excel at a beginner's level, enabling delegates to create and manage spreadsheets by the end of the course. A good understanding of the basics of calculations will be gained.

Who Should Attend?

Users with no existing knowledge of Excel and new or recent users of Excel who want to gain a good understanding of Excel. Those who want to build a solid and comprehensive knowledge of Excel from the basics upwards.

Prerequisites

Ability to use the keyboard and mouse. An understanding of Windows.


Course Content

Introduction to Excel and the Excel Screen

  • Starting and exiting from Excel
  • The opening screen
  • Minimising, maximising and restoring
  • Using the Ribbon to execute commands
  • Customising the Quick Access Toolbar
  • Excel views for displaying spreadsheets

Creating and Working with Excel Workbooks

  • Creating new and blank workbooks
  • Creating workbooks using templates
  • Saving, closing and opening workbooks
  • Changing the name of workbooks
  • Switching between open workbooks

Working with Worksheets and Data

  • Moving around a worksheet
  • Selecting techniques
  • Entering and editing worksheet data
  • Identifying how worksheet data behaves
  • Looking at dates and numbers, and controlling formats
  • Entering information using the autofill
  • Deleting and copying using the autofill
  • Creating and using customised lists

Managing Worksheet Data

  • Moving and copying worksheet data
  • Inserting and deleting rows and columns

Worksheet Views

  • Freezing worksheet titles
  • Zooming in and out on worksheet data

Performing Calculations

  • Understanding and structuring basic calculations
  • Entering and editing formulae and functions
  • SUM, AVERAGE, MAX, MIN and COUNT functions
  • Understanding BODMAS
  • Copying calculations to other cells

Formatting Cells

  • Changing the font and font size
  • Applying bold, italics and underline
  • Amending the vertical and horizontal alignment
  • Changing the orientation of text
  • Centring text over more than one cell
  • Merging cells and wrapping text
  • Applying number formats
  • Formatting using borders and shading
  • Changing the row height and column width
  • Copying existing cell formats

Formatting the Page Layout of a Worksheet

  • Setting page orientation and margins
  • Changing the scaling and size of a worksheet
  • Centring horizontally and vertically
  • Creating headers and footers
  • Printing titles on multiple pages
  • Inserting, moving and deleting page breaks

Previewing and Printing Worksheet Data

  • Previewing worksheet data before printing
  • Setting and removing print areas
  • Printing worksheet data
  • Converting to PDF

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.