Tutorials

Take a closer look at Google Docs and discover how to build and share documents with rich formatting, images, and tables. In this course, Jess Stratton shows how to get around the web-based interface, create new documents, and add features such as footnotes, headers and footers, and page numbering.

Get the most out of Google Docs, the popular word processing app, including its advanced formatting options and collaboration features.

Google Sheets is a feature-rich, cloud-based spreadsheet application that allows you to format and analyze all kinds of data. In this course, author Sally Norred shows you how to get the most from Google Sheets.

Get the most out of Google Sheets. Author Jess Stratton provides helpful tips and tricks to boost your productivity, from leveraging Google's wide array of templates and sharing spreadsheets to creating interactive charts and applying conditional formatting.

Learn how to create high-impact presentations with Google Slides. Follow along with staff instructor Jess Stratton as she shows how to plan and build a presentation.

Learn how to create, edit, format, and share documents with ease using the Microsoft 365 subscription version of Word. This course covers how to edit and format text to create a stylish document with instant purpose. Find out how to leverage templates and built-in tools, create numbered and bulleted lists, work with columns and tables, add images to your documents, collaborate on documents with your team, and share documents via OneDrive and email.

Microsoft Word contains a multitude of helpful features that can streamline your document creation workflow. In this course, Nick Brazzi shines a spotlight on some of the software's lesser-known features, sharing useful tips that can help you improve your productivity and efficiency in Word. Follow along with Nick as he shows you a variety of power-user formatting tricks, including how to select text more effectively, maintain text format when you're copying and pasting, and add a drop cap effect. Learn how to create customized spell-check dictionaries, work with nonprinting characters, leverage the Resume Assistant, and much more.

Learn how to use Word styles to help save time creating consistent and well-designed documents. Instructor Gini von Courter shows how to create, apply, and modify a variety of style types, from paragraph styles to list styles. More advanced topics include generating a dynamic table of contents from styles, using style sets, restricting formatting and document use with styles, using keyboard shortcuts, and much more.

Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data.

In this course, staff instructor Jess Stratton demystifies these powerful features, sharing bite-sized tips designed to help you work faster and more efficiently in Excel. Jess begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She goes over identifying values, then digs into a variety of useful Excel functions. Jess highlights how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.

Topics include how to emphasize data with fonts, borders, colors, and the pitfalls to avoid. Learn how to control alignment, write custom number formats, accentuate dynamic data with conditional formatting, and use styles to transform the look and feel of spreadsheets with one click.

Excel PivotTables–which allow you to quickly calculate and analyze large amounts of data–are one of the most powerful features of Microsoft’s ubiquitous spreadsheet tool. But many users have only a basic understanding of how PivotTables work. In this course, instructor Jess Stratton offers a plethora of bite-sized tips designed to deepen your understanding of how PivotTables work and how to use them more effectively.

Explore the basic components of a dashboard in Excel: tables, PivotTables, PivotCharts, slicers, and timelines. Learn how to plan a dashboard, create a summary table, build a time series chart, and then finalize your dashboard so it's ready to share with stakeholders. Jordan gives you quick, easy-to-use tips and techniques so you can start visualizing your data immediately.

If you’re a frequent user of Excel, chances are you have Excel tasks that you need to repeat often. Fortunately, you can automate these tasks by creating macros. Many people assume macros are complicated and reserved only for Excel power users. Not so! In this short course, Excel MVP Oz du Soleil first explains the best times to use a macro, and then how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. Learn how to set up macros in Excel now, saving time later.

Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions.

In this training course, Jess Stratton shows how to get started with PowerPoint templates and themes or build a new presentation from scratch. She explains how to change the slide layout; add and edit text, images, charts, video, and animation; format slides for consistency; and add speaker notes and comments to ensure a smooth delivery. She explores strategies for creating inclusive and accessible presentations for users with disabilities.

In this short course, presentation guru Jole Simmons shares some helpful tricks to take your PowerPoint game to a new level. First, Jole teaches how to take both the presenter and the audience into account in your design approach. Next, learn to identify the main points of the story you’re trying to tell in PowerPoint. Find out how to go the extra mile in making design calls. Explore some ways to convey your information without forcing everybody to read what's on the slide. Learn how to break information into threes, for better learning retention. Jole also discusses how to make sure your presentation is inclusive and geared towards a variety of people. Then, discover ways to add life to your slides with a well-placed surprise. Jole explains continuity, flow, and how to bring it all together.