Macros can help you save enormous amounts of time, but they are uncharted territory for many Excel users. Learn how to create your own simple macros to automate repetitive tasks in Excel 2016. Find out how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be easily recorded. Discover how to expand macros with Do loops and If statements, and test macros step-by-step.

The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.

Duration: 3h 33m       Level: Beginner

Create clean, professional, and engaging business reports, from proposals to whitepapers, with Microsoft Word 2016.

Duration: 1h 16m       Level: Beginner
Enrollment: Online     Learning Method: Self-paced

Learn how to enter and organize data, create formulas and functions, build charts and PivotTables and use other powerful Excel 216 features.

Duration: 8h 53m       Level: Beginner
Enrollment: Online     Learning Method: Self-paced

Get a quick introduction to purposeful slide design. Discover how to modify and personalize your own design approach to maximize presentation impact.

Duration: 1h 33m       Level: All
Enrollment: Online     Learning Method: Self-paced

If you are new to PowerPoint and want to learn how to create, edit and share presentations and slideshows with PowerPoint 2016, this is the course for you. It will provide you with the basic foundation to more advance learning in using PowerPoint.

Duration: 3h 1m        Level: Beginner
Enrollment: Online    Learning Method: Self-paced