Beginners Excel Training

Rating 5 out of 5 based on 3 reviews

beginners microsoft excel training1 Day – £225 + vat

This Excel training beginners course will provide you with a working understanding of the basic features of Microsoft Excel.

Beginners Excel Training Course Content

Managing files

Excel Training Introduction

  • The Excel Screen
  • Saving, Opening, Closing a Workbook
  • Moving around the Worksheet
  • Scroll Bars
  • Worksheet, Columns, Rows and Cells
  • Using Toolbars and Menus

Entering Data in Excel

  • Editing Data in cells
  • Selecting Cells
  • Clearing Cells
  • Entering Data using In-Cell and Formula Bar

Working with Rows and Columns in Excel

  • Delete and Insert
  • Change Column Width
  • Change Row Height

How to Move and Copy Data

Formatting Cells in Excel

  • Applying Date Formats
  • Applying Currency Formats
  • Applying Text Formats
  • Formatting using
  • Formatting using Dialog
  • Merge and Centre
  • Borders and Shading
  • Toolbar
  • Format Painter

Using Worksheets

  • Rename your Worksheets
  • Inserting New Worksheets
  • Moving and Coping Worksheets
  • Deleting Worksheets

Using AutoFill

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

Formulas and Functions

  • What are Functions
  • How to Enter a Formula
  • Using simple Functions (Average, Min, Max)
  • Working with Formula
  • How to Use Autosum

Printing in Excel

  • Page Set Up
  • Page Breaks
  • Print Preview
  • Printing

Charts in Excel

  • Using the Chart Wizard to create charts
  • Formatting a Chart

Beginners Excel Training Course Prerequisites

Delegates are not expected to have any prior knowledge of Excel at all. But attendees should have reasonable general PC skills.

3 Reviews

5 / 5 stars
says:

The pace was of the Excel Training very good and there was lots of opportunity to practice and consolidate learning.

5 / 5 stars
says:

Clear and concise teaching, refreshed my knowledge of Excel, friendly atmosphere, taught in a relaxed manner, but still taught everything that was expected.

5 / 5 stars
says:

Lots of new things to learn. I think I have increased my usage of Excel from 10% of its capacity to nearly 50%!

Leave a Review

Rating