Skip to content

Microsoft 365: Excel Desktop Level 1

Find a Course
  • Or choose a specific course

Microsoft 365: Excel Desktop Level 1

Course Cost £175 +VAT
Duration 1 DAY
Online
  • Course focuses on creating, editing basic Excel worksheets.
  • Aims to teach Excel components, formulas, and functions.
  • Targeted at those needing basic Excel knowledge.
  • Prerequisites include familiarity with Windows environment.
  • Objectives cover Excel environment exploration and formatting.

Overview

The Online Microsoft 365 Excel Training Course aims to enable participants to understand the basic components of Excel and learn how to create and use formulas. Targeted at individuals needing basic Excel knowledge, the course covers exploring the Excel environment, creating worksheets, using formulas and functions, formatting worksheets, managing workbooks, and setting up printing options. Prerequisites include familiarity with using a computer in a Windows environment. The course is one day long and costs £175 + Vat.

Who should attend

Anyone requiring basic knowledge of Excel.

Course Content

Course

In this virtual, Instructor-Led course you will create and edit basic Microsoft Excel worksheets and workbooks.  You will learn all the basics you need to start entering your data and building organised workbooks.

Course Aim

Enable delegates to examine the basic components of Excel and learn how to create and use formulas.

Target Student: Anyone requiring basic knowledge of Excel.

Prerequisites:Delegates should be familiar using a computer/laptop within a Windows environment.

Objectives:

  • explore the Excel Environment
  • create a basic worksheet
  • modify a workbook/worksheet
  • use basic formulas and functions
  • format an Excel worksheet
  • manage worksheets and workbooks
  • set up printing options

Getting Started with Excel

  • Excel and the Excel Environment
  • New Single Document Interface
  • Start up, Back Stage view and Themes
  • The Ribbon
  • Customise the User Interface
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks
  • Use Search for Help and Smart Lookup

Modifying a Workbook

  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options and AutoComplete
  • Selecting Items within Excel
  • Insert and Delete Options
  • Column Width and Row Height
  • Spell Check
  • Undo and Redo
  • Hide and Unhide Options

Formatting an Excel Worksheet

  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries

Using Formulas and Functions

  • Create Relative Formulas
  • Mixed Cell References
  • AutoCalculate
  • Create Absolute Formulas
  • Using Functions
  • Use SUM and AutoSum
  • Commonly Used Functions
  • The Insert Function
  • Copy Formulas and Functions

Managing Worksheets and Workbooks

  • Use Excels Quick Analysis Tools
  • Format Worksheet Tabs
  • Manage Worksheets
  • Deleting and Inserting Worksheers
  • Grouping and Ungrouping Worksheets
  • Fill Across Worksheets
  • View Worksheets and Workbooks

Printing Options

  • Set the Page Layout Options
  • Set Page Breaks
  • Print Worksheets and Workbooks
  • Page Setup
  • Print Layout View

Duration:1 Day

Cost: £175 + Vat

Online Microsoft Excel Training Course

Virtual Microsoft Excel Training Course

Microsoft Excel Online Training Course

Microsoft Excel Virtual Training Course

Who Should Attend

Anyone requiring basic knowledge of Excel.

Location

This course supports online training.
Course Cost £175 +VAT
Online
Duration 1 DAY

Experts in Construction and Infrastructure Training

1000+

Training courses available

250000+

Course hours completed

50+

Expert trainers

CITB, APS, IEMA

Accreditation training centres

12

Accreditations

Testimonials

We’ve helped thousands of professionals grow their skills and confidence. Hear directly from the people who’ve taken our training courses.

The course was exceptional, well run in terms of delivery of information, IT online course but seamless. Very interesting examples of temporary works failures applicable to the businesses we worked in. Break out activities / group examples worked very well and were again well managed by the trainer. Fantastic course, I will recommend to others! Best course I have attended in years!

CITB Temporary Works Co-Ordinator

Black & Veatch

The trainers knowledge was excellent and I liked his examples and how he could relate them to every day relatable examples that we could all understand. Coming from different industries and sectors his examples were a common ground. It was handled very well virtually and the engagement worked with his questioning and answering

Contract Management

The Pension Regulator

The training was very interactive and the tutor was excellent in engaging every course attendee and ensuring that the course content was tailored to each attendees Organisation and Company requirements

CITB Temporary Works Awareness

Kone – H &S Advisor

Contact an Expert Trainer