Customized MS Excel Tutoring

There are three levels of tutoring sessions that can be used as a baseline for determining the type of features you would like to become more proficient and productive at. Microsoft Excel (MS Excel) can be a very helpful tool for creating professional looking charts, tracking information, and managing finances. Tutoring is available for MS Excel version 2007 through 2016 and Office 365.

Each session is customized to your abilities and interests, but here is an overview of the types of features reviewed for each level.

_____________________________________________________________________

Basic

Get familiar with MS Excel by learning:

• The basics: highlighting, copying and pasting from external sources as well as internal

• How to create basic formulas so they automatically calculate information for you

• How to keep track of all User IDs, passwords, and email addresses in a password protected Excel file

• Learn basic formatting with headers, fonts, colors, wrapping text, merged cells, etc.

_____________________________________________________________________

Mid-Level

Learn more than just the basics. Gain an understanding of:

• The basics: highlighting, copying and pasting from internal and external sources

• How to create advanced formulas that automatically calculate for you

• How to keep User IDs, passwords, and email addresses in password protected Excel files

• More in-depth formatting features: headers, fonts, colors, wrapping text, merged cells, etc.

• How to create additional worksheets by copying from others or from scratch

• How to use the Excel ribbon

• How to make a very useful Excel spreadsheet aimed at tracking my finances (See the BLOG titled 'MS Excel and Banking')

_____________________________________________________________________

Advanced

Perfect your skills like a pro. Adding to your abilities, learn:

• Excel Security basics: require key codes, reading versus writing mode, and saving as PDF

• How to create much more advanced formulas for MS Excel

• How to link Excel worksheets and spreadsheets

• Basic formatting with headers, fonts, colors, wrapping text, merged cells, etc.

• How to change viewing size, saving a size, modifying grid lines, freezing panes, etc.

• Basic graphing

_____________________________________________________________________