|
|
This video demonstrates how to: Create create queries: selecting fields; using criteria.
|
|
|
This video demonstrates how to: Create a database; create a table; enter data, create a form; create a report; save a database for back-up.
|
|
|
This video demonstrates how to: Insert Table; Table Design Ribbon; Total Row; Total Row: Sum, Min, Max; Copy/Paste variables; Currency & Accounting in Number Section; Filter; Remove table
|
|
|
This video demonstrates how to: Create an IF function; Use Conditional Formatting
|
|
|
Using Excel 2019, this video demonstrates how to: Use Function Library; Use PMT Function; Copy worksheet; Format titles; Rename worksheets; Color worksheet tabs
|
|
|
Using Excel 2019, this video demonstrates how to: Create clustered column chart; change chart style; change chart color; create percentage formula; and anchor cell.
|
|
|
This video demonstrates how to: Mail merge labels in Microsoft Word 2019
|
|
|
This video demonstrates how to: Rename Word file when icon; Margins; Select All; Change Font; Edit Font: Change Type & Color; Format Painter
|
|
|
This video demonstrates how to: Open Microsoft Word; Find Ruler; Save File As; Save File; Word Styles; Insert Picture; Resize Picture; Move Picture; Wrap Text; Insert Table; Edit Table
|
|
|
This video covers: Opening Word; Finding Ribbons; Saving Word document; Show/Hide; Word styles; insert images; image styles; Wrap text; Insert table; table styles; editing table
|
|
|
Explore how to organize source data in PivotTables in Excel.
|
|
|
Learn more about PivotTables in Excel with this video.
|
|
|
Explore how to split up data from a single cell into multiple cells in Excel.
|
|
|
This video walks you through working with data and formulas across multiple worksheets in Excel.
|
|
|
In this video, learn how to copy named ranges in Excel.
|
|
|
Explore how to concatenate data in Excel in this video.
|
|
|
Watercoolers are comprised of a keynote presentation and a series of lightning talks. Below are the presenters and their topics in order of appearance.
[Keynote] Lee
Staton -…
|
|
|
Video will demonstrate: Inserting slide footer with name, date, and slide number; Add slide transition to all slides
|
|
|
Video Demonstrates: Opening PowerPoint; Saving presentation; Insert table; Insert chart; Insert SmartArt; Themes.
|
|
|
Video Demonstrates: Opening PowerPoint; Creating new presentation; Saving presentation; Slide layouts; Lists; Themes
|
|
|
Video will demonstrate: Make a Form; Change Theme; Make a Report; Make Publishing Date query
|
|
|
Video demonstrates: Download instructions; Design database from queries; Open Access; Name Project; Create table; Make a Form; Change Theme; Make a Report; Make First Item Owned query
|
|
|
In this video you will learning: IF Function; Conditional Formatting; Table Creation & Table Uses; Total Row; Label Arrows > View and Filter Data; Copying from Table; Sorting Data; Filtering…
|
|
|
Video covers: 1. PMT function; 2. Creating several PMT functions for comparison
|
|
|
Video covers: 1. Renaming file; 2. Chart creation;
|
