Excel Basic Course

 

​

Duration

1 day

​

Do you need to get up to speed with the basics of Excel? This course is designed for people who are new to spreadsheets or who have little experience with Microsoft Excel.  Develop your skills and confidence by learning from experienced Excel instructors who will help you learn the essentials.

​

​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