Meeting Between Colleagues

Excel Introduction

Duration: 1 day

Attendees: 1 - 10

Format: Virtual

This course is designed for learners and teams who wish to gain the skills to create, edit, format and print Microsoft Excel worksheets.

This course is suitable for users of Microsoft Excel 2013, 2016 or 365 subscription editions.

Excel Environment

  • Exploring Excel 2016 Ribbons Working with the Excel layout Introducing the Excel Sheet and tools


Working with Ranges

  • Working with ranges Selecting ranges with the keyboard and mouse Entering values into a range Copying/cutting and pasting data Using the AutoFill feature Filling cells


Using Formulas

  • Entering formulas Using the SUM function Using MAX, MIN, AVERAGE and COUNT functions Creating an absolute cell reference Copying and Moving Data Working with Quick Analysis


Sorting and Filtering

  • Sorting data alphabetically and numerically Creating a Custom Sort Filtering Data Applying a Custom Filter


Formatting Cells/Numbers

  • Applying Currency, Date, % and Number Formatting Applying Cell colours Adjust Row/Column height and width Add, Delete and Adjust Rows/Columns


  • Setting Print Areas Repeating Print Heading Headers/Footers



  • Creating a default Column Chart Changing the Chart type Customising chart colours and fonts



  • What is a Sparkline? Creating Sparklines Changing Sparkline type Customising the Sparkline