Skip to content

Increase Excel expertise with online class

March 20, 2016

If you wish to learn Excel or improve current skills (and add a few intermediate ones), this class that I developed will definitely help.  It is in 12 modules in which you can learn skills in 15-45 minutes (depending on your familiarity).  Each lesson is self contained and includes written instructions and videos to demonstrate what is taught.

This class is offered  through Top Hat, one of the top producers of online course materials for higher education throughout America and Canada

Go to my webpage for additional information or go directly to this link at Top Hat for a free preview and to register.

Below is an outline of what this class consists of:

Lesson 1 –   Introduction – You’ve been hired to be the payroll manager and need to create the payroll for The Daily Planet.  This means calculating the gross pay, withholding taxes, and what they will be paid.

Lesson 2 –   Managing expenses – determine the car you can afford with its monthly payment and using goal seek.  You just got a job that pays $62,000 a year and can afford to spend 19% of your income on the vehicle.

Lesson 3       Formatting tips – using the format painter, cell styles, creating your own cell styles, and keyboard shortcuts

Lesson 4       Absolute and relative references – this lesson is definitely a bit geeky yet you will learn a lot in this by knowing whether to lock in a cell, a column, a row, or none at all.  Taught in the first lesson, this build upon this even more as you’ll do some complex formulas.

Lesson 5       Working with large worksheets – discover how to move around it quickly using the keyboard instead of the mouse.  Learn how to sort and output data.  Alphabetize the data or use filters to view necessary information.  Within minutes, you will do another payroll of over 400 records for many people, including print set up.

Lesson 6       Charts – Graphically present your data – taught in version 2013/365, there are some differences between this and earlier versions.  They are essentially the same with a few enhancements with the quick analysis tool in 2013.  In addition, discover the differences between the XLS (2003 and earlier versions of Excel) and XLSX (2007 to present).

Lesson 7       Vlookup and Naming Ranges – learn how to do a look up of data so that calculations or display of information can be presented.  There are two examples, one determining cost to ship based on size of item, the other will be a gradebook.  In addition, learn how to name a range of cells.  A range name such as Insurance_Value is much easier to work with than the absolute range of $B$12:$D:$19.

Lesson 8       Miscellaneous and useful tips – Put a password on a spreadsheet so unauthorized people do not get into it.  Protect your worksheet from data goofs.  Create a template that can be used for payroll, inventory, and more.  Discover how to copy a spreadsheet (or chart) and paste link into a Word or PowerPoint document so that it will change should the spreadsheet be altered.

Lesson 9       Working with text functions – know how to separate lengthy text string into columns, join data in several columns into visually attractive output.

Lesson 10     Printing the worksheet – Learn how to print out just one section; know how to find data within it.  Add comments (as documentation, reference) and discover how to include them in the printout).  Know how to display the formulas.

Lesson 11     Mail Merge – create letters, labels, envelopes and more in Word with this function – great for invitations for events, invoicing, and much more.

Lesson 12     Working with several worksheets – often you may need to either extract data from another file or wish to copy (or move) a worksheet from one file to another.  Organization is key in this example – make sure you always keep your files in the same folders.   

 

 

Advertisements

From → Excel, Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: