Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Solid grounding
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 next step 1

Best-practice essentials

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

Navigate quickly

  • Move around quickly with shortcuts. (Ctrl+Down arrow, Ctrl+Home, Ctrl+End, Home, End Enter).
  • Use windows to see two different sheets on screen together.
  • Change Excel options so that you work more efficiently.

Know your way around formulas

  • Use SUBTOTAL to create reliable subtotals.
  • Create formulas more easily with the Function Wizard.
  • Enter formulas rapidly with absolute cell-addressing.
  • Calculate stats with AVERAGE, MIN, MAX, COUNT, COUNTA.

Format quickly and consistently

  • Format faster and consistently with named styles.
  • Copy styles from one workbook to another.
  • Include styles in the default workbook.

Discover the benefits of range names

  • Get around quickly with names.
  • Select ranges quickly to copy or print.
  • Build clear formulas quickly.
  • Locate names easily by naming with a convention.

Good spreadsheet design tips

    Create a Params sheet
  • See the benefits of one sheet for storing settings.
  • Structure sheets for clarity
  • Name and colour sheet tabs to show the flow of data.
  • Set the order of sheets for ease of understanding.
  • Document for ease of use and maintenance
  • Include step-by-step procedures on the Guide sheet.
  • Create a flow-of-data diagram to enable comprehension.
  • See other uses for drawing tools.

Prerequisites

All Excel users except beginners. You should be comfortable with the course agenda items of the Solid grounding (Excel fundamentals) course. This is a course that advanced Excel users should also attend, as it covers spreadsheet design conventions, good practice and use of styles for formatting. Even advanced users probably won't know 80% of this.


  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.