Course details

Excel Level 2

Formatting Cells

Merging Cells

Font Size

Formatting Cells

Text Wrapping

Functions

- COUNT Function

- COUNTA Function

- MINIMUM Function

- MAXIMUM Function

IF Function

- COUNTIF Function

- SUMIF Function Part One

Naming Cells

Format Painter

Absolute Cell Reference

Linking

- Linking within a sheet

- Linking within a Workbook

- Linking to another Workbook

Hiding Rows and Columns

Un-hiding Rows and Columns

Advanced Charts

- Scatter Graph

- Adding a Text Box to a chart

- Combination Chart

- Amending Pie Charts

Using Filters

- Filtering for a specific value

- Removing a filter

- Filtering for a range of values

Sorting Data