Microsoft Excel Class – Introduction

Microsoft Excel Class – Introduction

$439.99 - One Day Class

Add More Students:
$60 per each Additional Student

6hr Class with 1hr Break

10 people minimum charge applies for on-site training. Remote sessions are available for 1-on-1 training.

Not Just Teachers
Classes are held by a professional with real-life day to day advanced Excel experience. We try to concentrate our focus on training students to be ready for working environment.
OnSite Training
At your office, home, conference room.. you name it. Training at your location, at your convenience.
Not Enough?
Sessions can & will be catered to your particular needs.

Request a Session

Name(req.)

Phone(req.)

Email address(req.)

Address for the Session(req.)

Date(req.)

Time(req.)

# of Participants

N/A

Additional Requirements/Comments

This field should be left blank

Questions?

(312) 818-5503

Excel Training Session

How it Works?

Request

Request a tutoring session.

Get Confirmation

Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.

Done!

That's it! Enjoy your session at your location!

Microsoft Excel Introduction Course Includes

Starting Microsoft Excel
The Excel screen
Using the ribbon
Using keytip badges
Minimising the ribbon
Using shortcut menus
Launching dialog boxes
Customising the quick access toolbar
The office button
Using the office button
The status bar
Customising the status bar
Exiting safely from Microsoft Excel

Creating a new workbook

Understanding workbooks
Using the blank workbook template
Typing text into a worksheet
The ‘Save As’ dialog box
Saving a new workbook
Typing numbers into a worksheet
Typing simple formulas in a worksheet
Easy formulas
Typing dates in a worksheet
Easy formatting
Checking spelling in a worksheet
Making and saving changes
Printing a worksheet
Safely closing a workbook

Working with workbooks

Opening an existing workbook
Moving about a worksheet
Moving about a workbook
Going to a specific location
The ‘Open” dialog box

Editing in a workbook

Understanding data editing
Overwriting cells contents
Editing longer cell entries
Editing formulas
Editing functions
Clearing a cell
Deleting in a worksheet
Undoing and redoing operations

Formulas and functions

Understanding formulas
Creating formulas that add
Creating formulas that subtract
Formulas that multiply and divide
Understanding functions
Using the SUM function to add
Summing non-contiguous ranges
Calculating an average
Finding a maximum value
Finding a minimum value
More complex formulas

Formula referencing

Absolute versus relative referencing
Relative formulas
Problems with relative formulas
Creating absolute references
Creating mixed references

Selecting ranges

Understanding ranges
Selecting ranges
Selecting non-contiguous ranges
Using special selection techniques
Selecting larger ranges
Selecting rows
Selecting columns
Viewing range calculation
Creating an input range

Copying Excel data

Understanding copying in Microsoft Excel
Using fill for quick copying
Copying from cell to another
Copying from one cell to a range
Copying from one range to another
Copying relative formulas
Copying to a non-contiguous range
Copying to another worksheet
Copying to another workbook

Font formatting

Understanding font formatting
Working with live preview
Changing fonts
Changing font size
Growing and shrinking fonts
Making cells bold
Italicising text
Underlining text
Changing font colours
Changing background colours
Using the format painter
Applying strikethrough
Subscripting text
Superscripting text

Cell alignment

Understanding cell alignment
Aligning right
Aligning to the centre
Aligning left
Aligning top
Aligning bottom
Aligning to the middle
Rotating text
Indenting cells
Wrapping and merging text
Merging and centering
Merging cells
Unmerging cells

Row and column formatting

Approximating column widths
Setting precise column widths
Setting the default column width
Approximating row height
Setting precise row heights
Hiding rows and columns
Unhiding rows and columns

Printing:

Understanding printing
Previewing before you print
Performing a quick print
Selecting a printer
Printing a range
Printing an entire workbook
Specifying the number of copies
The ‘Print’ dialog box

* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.

* The client must provide suitable and safe work environment for the tutor to be able to provide the training.