Technology Training for Today's Essential Office Skills

This webinar will demonstrate the following types of data validation to ensure clean data entry in a spreadsheet: • Allow uppercase entries only • Prevent invalid dates • Create drop-down lists • Dependent drop-down lists • Prevent duplicate values • Allow only numeric or text entries • Validate an entry based on another cell • Allow entry of weekdays only • Restrict text length • Entries contain specific text • Create meaningful error messages Please plan to dedicate approximately 60 minutes to view this webinar. Read more

During this webinar participants will learn: • how to create a PivotTable from existing data • how to use a filter to narrow down the data in a PivotTable to view only the information required • how to add a slicer to make filtering even easier • how to create a PivotChart from a PivotTable Please plan to dedicate approximately 60 minutes to view this webinar. Read more

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

This webinar will include: • Cell protection so only areas to be filled in will be available • Creating interactive drop-down lists that populate text in other areas of the form • Hide data table tabs used to create drop-down lists • Setup conditional text to appear using an IF formula • Create a submit button to send completed form as an email attachment Please plan to dedicate approximately 60 minutes to view this webinar. Read more