Excel Online Training
Are you looking for an easy cost effective way to improve your Excel skills? Join our one hour webinars from the comfort of your desk and gain skills that will help you work more efficiently in Excel. These interactive webinars will show you shortcuts and ways to make Excel work better for you. We offer two levels of online Excel training.Each level consists of two one hour session held one week apart. Each session is a combination of demonstration and doing. Ample time is available for questions. It works best if you have dual monitors or two computes (say a desktop and laptop) so that you can have the webinar on one screen and the course workbook for notes and practice on a second screen.
We teach using Excel 2007. There are currently three versions of Excel commonly in use. Excel 97-2003 is quite different in its layout and file structure. Excel 2007 & 2010 are quite similar. About 70% of the course is information that applies to all versions. About 26% of the course is specific to Excel 2007 & 2010. If you have any questions please contact us.
Level 1 teaches critical skills that make it easier to use Excel and get more out of your workbooks. Even advanced users will gain new insights.
Level 2 teaches more advanced skills for working with and manipulating data.
Level 1:
Session A:
Designed to orient you to key features and show keyboard shortcuts that save time.
• Workbook layout
• Quick Access Toolbar
• Save & Save As
• Cells & cell references
• Working with sheets
• Keyboard shortcuts
• Working with data
Designed to orient you to key features and show keyboard shortcuts that save time.
• Workbook layout
• Quick Access Toolbar
• Save & Save As
• Cells & cell references
• Working with sheets
• Keyboard shortcuts
• Working with data
Session B
Designed to introduce you to working with formulas, how to find and manipulate data and how to make your workbooks look better and be easier to use.
• Formulas
• Find & Replace
• Printing & Page Setup
• Format cells
• Merge cells
• Sort data
• Charts & basic formatting
• Protect
• Freeze panes
Designed to introduce you to working with formulas, how to find and manipulate data and how to make your workbooks look better and be easier to use.
• Formulas
• Find & Replace
• Printing & Page Setup
• Format cells
• Merge cells
• Sort data
• Charts & basic formatting
• Protect
• Freeze panes
Level 2:
Session A:
Designed to expand skills to include more advanced tools that assist in manipulating data and getting answers to questions.
• Charts & special formatting
• Excel functions
• IF statements
• Count functions
• Date & Time functions
• Removing duplicates
• Conditional Counts
• Conditional Sums
Designed to expand skills to include more advanced tools that assist in manipulating data and getting answers to questions.
• Charts & special formatting
• Excel functions
• IF statements
• Count functions
• Date & Time functions
• Removing duplicates
• Conditional Counts
• Conditional Sums
Session B:
Designed to further your skills to include financial and statistical functions and ways to find data more quickly.
• Financial functions
• Statistical functions
• Data to Text functions
• Range Names
• Lookup functions
Designed to further your skills to include financial and statistical functions and ways to find data more quickly.
• Financial functions
• Statistical functions
• Data to Text functions
• Range Names
• Lookup functions