Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Best-practice essentials
Powerful formulas and clear reporting
Masterful manipulation and PivotTables
Automation and robustness

  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Foundation courses - Excel fundamentals

Solid grounding

     Duration: 1 day  
     Format: Hands-on, computer provided  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  
  YOUR POWER-PACKED AGENDA

Introduction to spreadsheets

  • Start Excel.

Open and close files

  • Use the Open dialog box to locate a file.

Navigate

  • Use the keyboard and mouse to move around.
  • Freeze Panes to keep the titles in view.
  • Navigate sheets and workbooks.

Create a workbook from scratch

  • Set the standard font.

Enter and edit data in cells

  • Enter column & row titles.
  • Use the F2 key to edit and correct.
  • Undo and Redo.

Copy and fill cells

  • Copy cells with the Fill Handle.
  • Use Copy & Paste to avoid re-typing.

Enter formulas

  • Create low-maintenance totals formulas.
  • Subtract, multiply, divide and anchor.

Format cells to create readable worksheets

  • Know where to put headings.
  • Distinguish inputs from calculations.
  • Apply number formats.
  • Understand what #### means.
  • Format text to improve readability.
  • Indent to clearly show the splits.
  • Use colour to clearly identify headings.
  • Use borders to enhance visual separation.
  • End with a narrow column and row.

Organise sheets

  • Give meaningful names to worksheets.
  • Colour code sheet tabs.
  • Adopt sheet type and name conventions.

Get it on paper

  • Prepare a printout with Page Setup.
  • Repeat the headings on each page.
  • Include page numbers, date and filename.
  • Adjust margins to fit more on the page.
  • Control where page breaks occur.

Prerequisites

Beginners who want to start with good habits, and those who are rusty or have shameful habits.


  LEARN IN A POSITIVE ENVIRONMENT
 
  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

Presenters

AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

  COURSE CANCELLATION POLICY
 
A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.