Excel Module 1 – Essentials

Book this course

Course description

Microsoft Excel is one of the most widely used business programs for any organisation, regardless of industry or sector. Excel training is therefore a great way to enhance your overall commercial skillset.

We show you all the essential features and tools you need to be aware of in order to get started on Excel – such as creating spreadsheets, adding different types of formula, formatting, and printing.

Is it right for me?

If you’re a new Excel user, or you simply want to refresh your existing knowledge, this introductory Excel training course will provide you with the skills you need to begin effectively using this software.

What will I get out of it?

By the end of the course you will be able to:

  • Create, save and print worksheets, e.g. timesheets, sales figures, invoices, etc.
  • Create different types of formula
  • Use basic Excel functions
  • Edit and manipulate information
  • Format worksheets for professional presentation
Our day was very enjoyable. The thought of going back into a classroom to be taught seemed a bit school like and so was a bit apprehensive, but once there, our trainer was very welcoming and made learning a pleasant experience. He knows his stuff and was able to answer all questions and offer help even though the course we were on did not include some of our queries, he took the time to share the answers. I will be adding my name to the next course as was a good experience. I will use the skills learnt daily and am looking forward to the next level.
Asset Records Assistant, Scotia Gas Networks

What does it cover?

  • Adding text, numbers, dates and times
  • Using automatic features
  • Renaming worksheets
  • Saving a workbook
  • Compatibility with earlier versions of Excel
  • Quick Analysis Tags and Flash Fill (2013 and 2016)
  • Basic formulas
  • Ordering calculations
  • Editing formulas
  • Using absolute references in formulas
  • The function wizard
  • Autocalculate
  • Navigating and editing worksheets
  • Moving and copying
  • Deleting data
  • Inserting and deleting columns and rows
  • Zoom
  • Freeze panes
  • Changing text attributes
  • Changing number formats
  • Using list autofill
  • Adjusting column widths and row heights
  • Adding simple borders
  • Using the Mini Toolbar
  • Applying cell styles
  • Using print preview
  • Amending page setup options
  • Printing a worksheet
  • Using Page Layout View and Page Break Preview

Book this course

Course leader

Susan Howard

Head of Technical, Digital and Project Management

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

Visio – Professional Flowcharting and So Much More

Visio is an extremely powerful and versatile design tool. It can be used for a variety of different functions in...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article