Excel Introduction

Duration: 1 Day 

This 1 day instructor led training course provides delegates with a solid grounding in Microsoft Excel. Delegates will be introduced to spreadsheet concepts and gain an appreciation of the main features of Excel and what it has to offer.

How can I attend my course?

Who will Benefit:

Users requiring a firm foundation in the basic usage and overall appreciation of spreadsheets will benefit greatly from this course.

Target Audience:

This course is designed to give new users of Microsoft Excel an understanding of its basic features.


Objectives.

You will learn how to:

  • Understand spreadsheet concepts
  • Enter and modify data and structure
  • Create worksheets from scratch
  • Create basic formulas
  • Calculate with common functions
  • Format spreadsheets
  • Create Charts
  • Choose required printing options


Prerequisites.

We recommend that attendees of this course have the following prerequisites:

Before taking this course, you should be familiar with using a computer, keyboard, mouse and a basic knowledge of using Windows.


Course Outline.

Getting started

  • Spreadsheet terminology
  • The Excel environment
  • Getting help
  • Navigating a worksheet

Entering and editing data

  • Moving and copying data
  • Inserting and deleting ranges, rows, and columns
  • Modifying column widths and row heights
  • Autofit columns and rows

Formulas

  • Create basic calculations
  • Order of calculation
  • Absolute referencing
  • Moving and copying formulas

Functions

  • Overview of functions
  • Using AutoSum
  • Using other common functions
  • Display formulae on a worksheet

Formatting

  • Text formatting
  • Row and column formatting
  • Number formatting
  • Conditional formatting
  • Additional formatting options

Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Managing large workbooks

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets

Charts

  • Chart basics
  • Formatting charts

My Course Notes

You will receive a full set of course notes and all supporting materials for your course. Hard Copy Delivered to your premises or Downloaded to a chosen device.
 

     OR  

To book this course please call +44 (0) 1444 410296 or email at Info@kplknowledge.co.uk

© Copyright 2020 KPL KnowledgeSolutionsWeb Design By Toolkit Websites