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

Printing

  • Setting Print Areas Repeating Print Heading Headers/Footers

 

Charting

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

 

Sparklines

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