Bay Software Consultancy Ltd
(07) 578 8350
  • Home
  • Course Schedule
  • Course Outlines
    • Access >
      • Access Scheduled Dates
    • Basic Computing >
      • Basic Computing Scheduled Dates
    • Excel >
      • Excel Standard Courses
      • Excel Modular Training
      • Excel Scheduled Dates
    • Powerpoint, Publisher and Visio >
      • PowerPoint, Publisher and Visio Scheduled Dates
    • Project >
      • Project Scheduled Dates
    • Visual Basic for Applications
    • Word >
      • Word Scheduled Dates
  • Learning Paths
    • Computer Novice
    • Word User
    • Excel User
  • Book a Course
  • Tell us what you need...
  • About Us
  • Terms and Conditions
  • Contact Us

Microsoft Excel Modular Training

All of these half day courses are run on demand and are designed to provide a gradual learning path from beginner to intermediate level, complementing  our standard course offerings.

They can be attended separately or combined into full day courses.

The pre-requisite knowledge required for each course is specified in the course outlines.

Office Basics

Covers the basic skills needed to work with any Office application.  Using the File menu, the Ribbon and the Quick Access Toolbar.  Also covered is basic file management: creating, opening, viewing and saving files.
of10bsco.pdf
File Size: 138 kb
File Type: pdf
Download File

Creating Basic Workbooks

In half a day, learn how to create and print a basic workbook that records information, performs simple calculations and calculates totals.
xl10cbwcow.pdf
File Size: 138 kb
File Type: pdf
Download File

Formatting a Worksheet

The next step is getting your worksheet to look the way you want.  Learn about basic cell formatting, adding borders and shading automatically formatting cells based on their contents and copying existing formatting.
xl10fwco.pdf
File Size: 114 kb
File Type: pdf
Download File

Understanding Functions

In addition to writing your own formulas, you can also use the built-in Excel functions to perform calculations.  Explore the Autosum button, understand absolute cell referencing and learn to use the conditional functions to sum, count and average.
xl10ufco.pdf
File Size: 136 kb
File Type: pdf
Download File

Working with Large Worksheets

Learn the techniques necessary to view and work with large worksheets.  Use split screens, Freeze Panes, Zoom and multiple windows to view and manage large worksheets.
xl10wlwco.pdf
File Size: 138 kb
File Type: pdf
Download File

Location

We are no longer operating out of a fixed training location.
We can come to you, organise a training venue or provide online training options.

Quick Links

Microsoft Excel Courses
Microsoft Word Courses
Microsoft Project Courses
Microsoft Access Courses
Microsoft PowerPoint Courses
Microsoft Visio Courses
Microsoft Publisher Courses
Basic Computer Skills Courses

Ready to Book on a Course?

Contact Bay Software Consultancy Ltd today and we will help you to improve your efficiency in using Microsoft applications.
Book Now!