Microsoft Office
The Excel Solver Add-In: The Best Explanation in Just 5 Minutes
This Excel Solver Add-In tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. There are many Excel features that make life easier for us. One of them is the Excel Solver Add-In. This clever feature lets us find solutions to problems that have several constraints, which cannot be solved with a simple…
Dynamic Array Functions in Excel (XLOOKUP, FILTER, UNIQUE, XMATCH): Webinar Recording
We were once again joined by Excel expert, Deb Ashby, who took us through the Array Functions introduced in Microsoft Excel a few years ago. These functions replace and improve upon some existing functions (XLOOKUP instead of INDEX, MATCH). In this Dynamic Array session Debs covers the following Excel Functions: FILTER RANDARRAY SEQUENCE UNIQUE SORT…
The Excel FILTER Function
This Excel FILTER Function tutorial is suitable for users of Excel for Microsoft 365 Objective Use the Excel Filter Function to filter a range of data based on criteria you define to extract matching records. The Excel FILTER Function Explained The FILTER function is a new function available to Microsoft 365 users to filter data based on criteria…
How to Use OneNote: Recorded Webinar
In this OneNote tutorial, we teach you how to get started using OneNote 2019/365 Desktop edition. OneNote is an incredibly useful note-taking tool if used effectively, and it comes packed with features to help you increase your daily productivity. In this session we cover: What is OneNote and why is it useful? Creating Notebooks, Sections…
Ten Ways to Clean Data in Excel
This 10 Ways to Clean Data in Excel tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Use Excel’s functions and utilities to clean a raw dataset, removing errors and making it consistent ready for analysis. Cleaning Data Explained Data is the foundation of any analysis you do in Excel. If you receive a dataset…
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…
