Technology Training for Today's Essential Office Skills

In this webinar, we will discuss: • Using Excel’s consolidate feature • Creating 3D references • Using external references (if you have multiple workbooks) Please plan to dedicate approximately 60 minutes to view this webinar. Read more

How to create, format, and use PivotTables to analyze data. In this webinar, we will go over:  - 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

In this webinar, we will go over: Customizing PivotTable Layouts Grouping and Ungrouping Data in PivotTables Calculating Fields and Items in PivotTables Using Slicers and Timelines in PivotTables Creating PivotCharts from PivotTables Please plan to dedicate approximately 60 minutes to view this webinar. Read more

Instead of entering data in Excel cell by cell, row by row, learn how to use a data entry form. This makes it easier and faster to focus on individual records without scrolling horizontally. In this webinar you will learn how to create a basic data entry form in Excel using the built‑in Form feature. You will also learn how to add a button to a worksheet to open the form. 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