Technology Training for Today's Essential Office Skills

This webinar will demonstrate examples using the features in the Forecast group on the Data tab in Excel: • What If Analysis o Using Scenario Manager o Goal Seek o Data Table • Forecast Sheet Please plan to dedicate approximately 60 minutes to view this webinar. Read more

This webinar will provide a set-by-step overview of how you can eliminate repetitive tasks in Excel using macros: • Record a basic macro • How to test and run a macro • How to access macro in any spreadsheet • Edit a macro using Visual Basic for Applications (VBA) Please plan to dedicate approximately 60 minutes to view this webinar. Read more

In this webinar, you will learn how to: - Anatomy of a Workbook - terminology, how to move, shortcuts - How to not mess up a spreadsheet - find formulas and hidden content - for those who have inherited spreadsheets - Cell formatting and navigation - Excel is NOT Word  - Print like a Pro - Repeat top row on each page, scaling, set print area - No sweat formulas - Quick Analysis tool - Take it to a Table! - Total Rows, Filters and Sorting - Intro to functions - Defining absolute vs. relative references Please plan to dedicate approximately 60 minutes to view this webinar. Read more

Participants will learn how to customize the Quick Access toolbar and ribbon with built-in Word commands and simple macros. Macros demonstrated will include inserting page numbering, filename and path, using a letter template, and a shortcut to access a specific folder. Once the customization has been completed, participants will also learn how to share customization with other users. Please plan to dedicate approximately 60 minutes to view this webinar. Read more

Participants will learn how to create a custom dialog box in a letter template using Visual Basic for Applications (VBA). The dialog box will include a dropdown list of names that is imported from an Excel spreadsheet. Upon selection, the name will be added to the signature block and additional information pulled from the spreadsheet and inserted into the letter (e.g., email address, direct line and initials). Please plan to dedicate approximately 70 minutes to view this webinar. Read more

This webinar will explore the basics of creating and editing styles and discuss how to update the Normal template and saving as a new style set. Please plan to dedicate approximately 60 minutes to view this webinar. Read more