Technology Training for Today's Essential Office Skills

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

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

This webinar will cover Microsoft Word’s features that are useful when working in multipage documents: how to divide your document into sections and create different headers and footers as well as style of page numbering within those sections. During the webinar participants will learn: how to insert headers and footer that contain text, automatic dates, page numbers, and the document filename with path how to create a different first page header or footer how to insert section breaks to vary the headers and footers and page numbering styles on different pages in a document how to insert more complex page numbers for chapters and appendixes eg. A-1 how to use the Styleref field to automatically insert a document or section title in the header or footer Please plan to dedicate approximately 45 minutes to view this webinar. Read more