Microsoft Tools Certificate
Use the videos in this section to ramp up your working knowledge of PowerPoint, Excel and more. Beginners and intermediates: You’ll be surprised how much can be done to improve your decks. Features Microsoft master trainer Bill Monroe.
-
PowerPoint 03 – Adding Video, Audio and More
Improve your deck with video, audio, data and animations with instruction from Microsoft trainer Bill Monroe. This is the third in our series on learning PowerPoint.
-
PowerPoint 02: How to Use Shapes and Transitions to See the Story
See the Story: Microsoft trainer Bill Monroe teaches you how to use shapes, transitions, morph and more in this walkthrough of PowerPoint. Excellent details for improving your decks.
-
PowerPoint 01 – Storytelling with PowerPoint
Learn how to create a slide deck from a template and add basic content, speaker notes and launch your slideshow. Learn PowerPoint uses and tour the interface.
-
Microsoft Excel 05 – What if
The more data you have, the more questions you will have about it, and the more answers it can provide. Excel has a variety of conditional formulas that let you evaluate subsets of your data to find the stories to tell: If…Then formulas; Conditional Functions; XLOOKUP; Array Functions.
-
Microsoft Excel 04 — Pivot tables
Pivot table are the simple solution for some, and a rare kind of magic to others. In this session, we’ll demystify pivot tables and show you how you can use them to simplify your analysis and give you more options than ever in how you extract your story.
-
Microsoft Excel 03 — Top of the charts
Numbers gives us the facts, but images tell us the story. In this session, we’ll show you how to create charts from your data, leverage Excel’s suggestions, modify them to […]
-
Microsoft Excel 02 – Fill it out
In this session, we’ll explore how Excel helps you add data in a flash. We’ll explore new data types that pull information from the internet and help you spot the important stuff at a glance: Conditional Formatting; Auto Fill; Flash Fill; Geography and Stock Data Types; Leveraging Tables for Expanding Data Sets
-
Excel 01 – Welcome to Excel
In this session we’ll start at A1 and introduce you to the basics of Excel, how it’s structured, and how to get around in it. We’ll show you how you can start using formulas to take Excel beyond just a list of stuff.
-
Transcription and translation in Microsoft Word
In this session, we’ll teach you how to create transcripts of your interviews in Word on the web. We’ll explore Word’s dictation features and highlight its ability to translate between different languages.