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

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.