Page 8 - Excel level 1

Visualizing Your Data
This module explains how to work with charts.
� Inserting Charts
� Understanding the Chart tool Bar
� Choose what data is displayed in your charts.
� Show and hide data labels.
� Show and hide the legend.
� Show and hide the chart title.
� Add a picture or shape to a chart.
� Change the way text displays in a chart.
� Change the fill color of a chart.

Working with Tables
This module explains how to work with tables. Lessons
� Format Data as a Table
� Move between Tables and Ranges
� Modify Tables
� Explain Dynamic Tables

Working with Named Ranges
This module explains how work with Named Ranges
� Using Named Ranges in Formulas
� Naming a Single Cell
� Naming a Range of Cells
� Naming Multiple Single Cells Quickly

Advanced Formatting
This module explains how work with formatting options in Excel.

Conditional Formatting
Conditional formatting in Excel enables you to highlight cells with a
certain colour depending on the cell's value. Using this feature can make
analysing data easier by applying visual styles to the data.

Working with Styles

henitectraining@aol.com