Beginners Excel Training

Overview

Microsoft Excel, the workhorse of the office, has a wide range of functions. From tracking simple to-do lists, to tracking the process of projects and managing large and complex financial reports and company accounts it's a very malleable tool.

Excel is an extremely powerful spreadsheet application designed to save you time - and most users do not realize the full range of functionality available to them.

Excel training course for beginners helps you discover the application's capabilities while working through exercises to create simple worksheets.

We also provide private and in-company Microsoft Excel courses.

Course Objectives

This introductory Excel training course will provide you with:

• A working understanding of the basic features of MS Excel
• Confidence to use Excel on a daily basis
• Knowledge of functions and formulae to save time and reduce workload

Onsite Training

This course can be run in-company anywhere & we can tailor the content to focus on your requirements.

Who is this course for?

Anyone struggling to work with Excel daily or who wants to start using it but has no previous experience.

Related Courses

• Advanced Excel Training
• Advanced Access Training
• VBA For Excel Training

Outline Details

Beginners Excel Training Course Content

Introduction to Excel

• The Excel Screen
• Using the Ribbon
• The quick Access Toolbar
• Saving, Opening, Closing a Workbook
• Moving around the Worksheet

Entering Data

• Entering, editing and deleting data
• Undo and Redo
• Filling Cells
• Cut, Copy and Paste
• Using the Windows Clipboard

Working with Rows and Columns

• Inserting and Deleting Columns and Rows
• Change Column Width & Row Height
• Hide and Un-Hide Columns

Formatting Cells

• Highlighting Methods
• Formatting Text & Numbers
• Alignment of Cells
• Merging Cells
• Wrapping Text
• Borders and Shading

Working with Worksheets

• Renaming Worksheets
• Inserting Worksheets
• Move and Copy Worksheets
• Delete Worksheets

AutoFill

• How to use the AutoFill Handle
• Using AutoFill to Copy Sequence
• Using AutoFill to Replicate
• Customer AutoFill Lists

Viewing Data

• Zooming a Workbook
• Freezing Panes
• Splitting a Window

Using Formulae and Functions

• How to Enter a Formula
• What are Functions
• Using Sum/Average/Max/Min
• Copying Formulas
• Relative and Absolute References

Printing

• Setting up the Page for Printing
• Using Different Views
• Adding Headers and Footers
• Using Print Titles
• Setting and Clearing Print Areas

Simple Charts

• Creating Simple Charts
• Changing Chart Type
• Formatting a Chart