Print PDF
Print Course Overview

Bookmark and Share

Microsoft: Excel

Microsoft Excel Training Course Microsoft Excel is a spreadsheet program that you can use to create, edit, format and save professional files. Its uses range from creating simple lists of data organised in tables through to more complex spreadsheets utilising formulas, functions and macros.  View Microsoft Excel Subject Details

Stage 1: Understanding Spreadsheets ITS11

Scheduled Training Courses

 13/06/2012  16/07/2012  13/08/2012  13/09/2012  12/10/2012  13/11/2012  13/12/2012

This Training course can also be run on request as a One to One or a Classroom Booking.

Overview

This stage assumes no prior knowledge of Excel. The course would be ideal for beginners or for people who are self taught and just wish to brush up on their existing skills.

The course begins with an overview of the program, navigation of the screen and an introduction to the terminology. This then leads into setting up spreadsheets and starting to use basic calculations (Adding, Subtracting, Dividing and Multiplying) and then an introduction to Formulas i.e. Sum, Average, Count, Minimum, and Maximum. By the end of this course students will be in a position to produce formatted information for printing, use basic formulas, and create simple graphs.

  • Screen Layout (Terminology/ Toolbars/ Shortcut / Cursors/ Navigation)
  • Formatting (Open/ Close/ Saving/ Text/ Columns & Rows/ Borders)
  • Editing (Planning, Autofil / Copy / Cut / Paste / Paste Special)
  • Printing (Selection/ Entire Workbook/ Worksheet/ Page Setup)
  • Basic Graphs (Bar / Area / Pie)
  • Basic Formulas ( - + * / Basic Percentages / Averages / Dates)
A sample excel spreadsheet showing a sales team
Sales Data Produced in Excel
  
  An Excel chart of sales figures
A Graph of the Sales Data Produced using Excel

 

Related Training Courses

Stage 1: Understanding Spreadsheets ITS11
Stage 2: Spreadsheets Made Easy ITS12
Stage 3: Complex Formulas ITS13
Stage 4: Master Class ITS14

Find Training Courses

Search The Pringle PCS Training Brochure View All Training Courses

Book This Training

CALL 0114 281 3350

Or email us

sales@pcs-limited.com

Single Booking £140.00

£84.00 40 % Discounted Price
Normal Price £140.00
* Discounts Apply When Booking More Than One Person On The Same Scheduled Course ex vat  
One delegate in a mixed group at Skywalker House

One To One

Price £345.00 ex vat  
One delegate one trainer either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House

Company Classroom

Price £395.00 ex vat  
A dedicated trainer for your company either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House