Microsoft Office
Using GETPIVOTDATA in Excel
This GETPIVOTDATA tutorial is suitable for users of Excel 2013/2016/2019 and Excel for Microsoft 365. Objective Use the GETPIVOTDATA function in Excel to reference values in cells contained within a PivotTable. In this guide, you’ll learn: What is GETPIVOTDATA? Video Tutorial – GETPIVOTDATA Excel How to Use GETPIVOTDATA in Excel? How to Toggle GET PIVOT Off/On? How to…
12 Creative PowerPoint Templates for Presentations – Free to Download
By far, Microsoft PowerPoint is one of the most used tools at the time of creating presentations for business or educational purposes. With billions of installs around the world, PowerPoint is used not only by consultants and business professionals but also by educators around the globe. If you are creating a lot of presentations and…
Using Tables in Word
This Tables in Word tutorial is suitable for users of Word 2013/2016/2019 and Microsoft 365. Objective Insert a table into a Microsoft Word document and utilize the options on the Table Tools contextual ribbon to format and modify the layout of the table. Video Tables Explained Tables play a significant role when it comes to laying out a document. They present…
Create and Update an Index in Word
This Index in Word tutorial is suitable for users of Word 2010/2013/2016/2019 and Microsoft 365. Objective Mark entries in a long document for inclusion in the index. Create an index in Word from scratch and understand how to edit and update it. Indexing Explained An index lists the terms and topics discussed in a document listed in alphabetical order. It is usually…
How to use the OFFSET function in Excel
This tutorial on how to use the OFFSET function in Excel is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Use the OFFSET function to return a cell or range of cells that is a specified number of rows and columns from a cell or range of cells. The OFFSET Function Explained The OFFSET function is part of the…
Footnotes in Word and Endnotes in Word
This tutorial on Footnotes in Word and Endnotes in Word is suitable for users of Word 2010/2013/2016/2019 and Microsoft 365. Objective Include footnotes and endnotes in your document to provide additional information about something mentioned in the document. Video Tutorial Footnotes and Endnotes Explained Footnotes and Endnotes can be used in a Word document to explain, provide references to or comment…
Working with Page Breaks in Microsoft Word
This Page Breaks for Microsoft Word tutorial is suitable for users of Word 2010/2013/2016/2019 and Microsoft 365. Objective Insert Page Breaks in Microsoft Word and Sections Breaks into Microsoft Word to control the layout and formatting. Page Breaks in Microsoft Word Explained If you have ever struggled to get a long Word document to look exactly as you would like, it…
How to Use Microsoft PowerPoint Animations and Transitions for Creative Presentations
PowerPoint Animations are special visual effects added to a text or an object in Microsoft PowerPoint. You have to click the object and select the animations tab. They bring your text or object to life. A transition is a visual effect that occurs when you move from one slide to the next in PowerPoint. A…
Getting Started with Power Pivot: Advanced Excel
Power Pivot is a tool in Excel that enables us to create data models and perform more complex operations than the standard Pivot Tables allow. You may have seen references to the data model in Excel before when creating PivotTables – this is Power Pivot. It is also known as the data model. This article…
Advanced Word Tutorial: Tips and Tricks in MS Word – Recorded Webinar
In this 1-hour class, we look at some of the Advanced features of Microsoft Word. Microsoft Word is more powerful than you may think. In this Advanced Microsoft Word Tutorial, we take a look at some of the features that Word has that makes created awesome and professional-looking documents simple. Once again, this advanced Word…
How to Create a Contents Page in Word
This Contents Page in Word tutorial is suitable for users of Word 2010, 2013, 2016, 2019, and Word for Microsoft 365. Objective Create a Table of Contents for a Word document and update it to add new entries. Table of Contents Explained A Table of Contents page makes it easier for your readers to navigate and work with long documents. It gives documents a professional look and…
What-If Analysis in Excel – Recorded Excel Live Class
In this 1-hour class, we look at the awesome power of What-If Analysis in Excel. What If Analysis in Excel allows you to test out different scenarios without complex formulas. In this tutorial we cover Goal Seek, Scenario Manager, Data Tables, and Solver. Once again, this class was hosted by the excellent Deborah Ashby. In…
