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 Capability

Need a bespoke solution?

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

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine