Microsoft Excel - Multiple Sheets and Charts – An Introduction
Course Duration: 90 Minutes
Target Audience:
This session is intended for Excel users who wish to use multiple sheets in Excel create graphical charts.
Course Objectives:
This session will explain the multiple sheet functionality in Excel and how to create column and pie charts.
Course Outline:
Introduction and Overview
CONTENT
Managing Worksheets
-
Naming Sheets
-
Changing the Sheet Tab Colour
-
Moving Sheets within a workbook
-
Copying Sheets within a workbook
-
Copying Sheets to another workbook
Creating and Managing Charts
-
Creating a Column Chart
-
Creating a Pie Chart
-
Changing the Chart Colour Scheme
-
Add a Chart Title
-
Modify the Legend and Axis
-
Changing the Data Source