Karen Horn

This 3-hour session will introduce you to the capabilities of the MS Excel program. Learn the basics of what you can do with the powerful electronic spreadsheet program including: Purpose of spreadsheetsMoving around the screenUsing the ‘Ribbon’Entering dataCreating basic formulasSelecting cellsWorking with workbooksViewing & printing Date: September 15, 2022 Time: 9:00 a.m. – Noon Cost:…

FORMULAS & FUNCTIONS In this 3-hour session, learn how to set up formulas and functions to get the Excel program to do the math for you. Topics include: Creating and editing formulasMathematical operatorsCommon functionsConditional functionsAbsolute & relative cell referencesProtecting your workbook Date: September 29, 2022Time: 9:00 a.m. – NoonCost: $150.00Instructor: Heather Lyon ABOUT EXCEL TRAINING…

Make your Excel workbooks look professional and readable by learning how to properly format all the aspects of your spreadsheet. In this 3-hour session, you will learn how to work with: Formatting dates & numbersCell alignmentFonts & sizesBordersColours and patternsFormat painterThemes & StylesConditional formatting Date: October 13, 2022Time: 9:00 a.m. – NoonCost: $150.00Instructor: Heather Lyon…

In the Excel program, you can convert your data from a spreadsheet into a table and/or chart. Learn how you can turn dry financial and statistical information into a vibrant visual display that will have a powerful impact on your audience! Charts vs. TablesCreating a chartChanging chart typesChanging chart layout and locationUsing sparklinesCreating a tableCreating…