Excel Basic Course

 

​

Duration

One day

​

​Course Description

This course covers the basic day-to-day tasks required to work with an Excel spreadsheet to produce basic reports. You will learn how to use a variety of Excel tools including working with data, doing calculations, printing, and representing data with charts.

 

Course pre-requisites

Be familiar with Windows and using the mouse.

 

​

Course Content

Getting Started with Excel

• Overview & Excel screen

• Selecting cells

• Entering data into the worksheet

 

Modifying a Worksheet

• Editing the contents of a cell

• Use AutoFill

• Calculate data using simple functions

• Moving and copying data

• Drag and drop editing

• Inserting columns, rows and cells

• Change column width and row height

• Hide rows and columns

• Find & replace

 

Enhance a Worksheet

• Use the Font group

• Work with the cell alignment options

• Apply different formats to numbers

• Date formats

• Copy formatting using Format Painter

 

Preparing for Printing

• Print Preview

• Page Layout view

• Page Setup options

• Controlling Page Breaks

• Page Break Preview

• Printing a worksheet

 

Charting

• Create a 3-D column chart

• Choosing the source data

• Category and value axis

• Use chart tools

• Moving and sizing embedded charts

• Charting non-consecutive data

• Changing the axis plot order

• Layout tools

• Printing a chart themes & graphics

​

​

Follow on Course:  Excel Intermediate - Read more