Introduction

Microsoft Excel Essentials Training

Microsoft Excel is commonly used by businesses UK-wide, but few know how to make the most of its many features.

In this introductory session, we explain some of the most useful features that Excel has to offer. We look at formulas and workbooks, and how you can present data in various forms.

Learn how to make the most of Excel.

IT Support - IT Training
IT Training

Who is this course for?

Aimed at regular users, this session is all about working more efficiently by understanding Excel’s many time-saving features and some of the tasks you can usefully automate.

It will also help you add polish to reports and generate more insights from your data. To find out more, please contact us.

Work more efficiently.

IT Support - Support Staff at Desks

Excel Essentials Course Content

Creating and Managing Workbooks and Worksheets
  • Overview of the user interface
  • Creation of worksheets and workbooks
  • Navigation within worksheets and workbooks
  • Formatting of worksheets and workbooks
  • The configuration of page setup and headers/footers
  • Customisation options and views for worksheets and workbooks
  • The configuration of worksheets and workbooks for distribution to others
Managing Data Cells and Ranges
  • Insert data in cells and ranges
  • 
Formatting cells and ranges
  • Summarise data with conditional formatting
  • Summarise and organise data
Creation of Tables
  • Creation and management of tables
  • 
Management of table styles and options
  • 
Filtering and sorting tables
Creation of Charts and Objects
  • Creating charts
  • Formatting charts
  • Inserting and formatting objects
Performing Operations with Formulas and Functions
  • Summarise data by using functions
  • Using conditional operation functions: IF and COUNTIF functions
  • 
Using conditional operation functions: SUMIF and AVERAGEIF
  • 
Formatting and modifying text by using functions
  • Combining text using functions and flash fill
Contact Us

For more information contact us...

    If you need responsive and reliable IT solutions that are tailored to your business, then contact the experts at AMP. Our skilled engineers provide outstanding IT support and technical expertise you can depend on.

    HP Business Partner