Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

On Site Training

 
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Web design

 

If you like this site, let us create a web site for you.

Contact us for a quote.

 
 
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Corporate portraits

 
Portraits for promotional material, web sites or just to decorate your office walls. See Kate's recent commissions.
 
 
 
Home On-site Training   Prices Client Feedback Software Shop About Contact  
Expertly tailored Microsoft Office training courses: Brighton, Worthing, Portsmouth, Chichester, Sussex, Surrey and London
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Microsoft Excel Course for Beginners (1 day)

Microsoft Excel Beginners Course Overview

This 1 day Microsft Excel course is designed for those that have little or no experience with Microsoft Excel. The course covers training in the basics of formatting, navigation, data entry and calculations. Make sure you are comfortable with course content before you move on to the intermediate level course. The outline is only a suggestion and can be tailored to your business needs.

To accompany the instructor lead training, each delegate will receive manuals and practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed.

For pricing click here

To return to the application overview page click here

 Formulae Basics
  • Basic calculations
  • SUM, MIN, MAX, AVERAGE,COUNT, COUNTA
  • Copying formulae
  • Absolute referencing
  • Mixed referencing
  • Naming cells and ranges
  • Introduction to IF statements
  • Performing calculations with dates and times
 Charting
  • The chart wizard
  • Formatting chart elements
  • Changing the source data
  • Creating a secondary axis
  • Saving a custom chart
  • Setting a default chart
 Formatting
  • Changing column widths and row heights
  • Formatting cells for different data types
  • Using autoformat for tables
  • Format painter
  • Styles
  • Condtional formatting based on cell values
 Printing
  • Setting a print area
  • Getting data to fit the page
  • Headers and footers
  • Printing rows and/or column headers on every page
  • Printing gridlines
 Basic List Management
  • Sorting on multiple columns
  • Hiding columns
  • Changing column order
  • Freezing rows and columns
  • Introduction to filters

 

   

Home |   On-site Training  |  Prices   |   Client Feedback  |   About Us |   Contact Us

Copyright (c) 2008 Blue Pecan. All rights reserved.