Microsoft Power BI

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

Discussion and Question Time