Quickly Find Files by Adding Key Words
Instead of using the search bar in Teams to find files, add key words to find them fast. This video shows you how using columns and choice widgets.
Category: Microsoft
Using the Design Ideas feature
The Design Ideas feature in Microsoft PowerPoint 365 uses artificial intelligence to generate slide designs based upon your content. In this video we show you…
Migration of Network Folders to OneDrive
All NECS users need to know about the file migration from the H: drive to OneDrive
Online Archiving in Outlook 365
Exchange online archiving is a solution that allows you to store and manage older emails outside of your primary mailbox, freeing up quota space and i…
Introduction to PivotTables (FULL COURSE)
containing: What is a PivotTable and why do we use them?; Creating a basic PivotTable; Building a PivotTable with multiple areas; Using multiple numer…
Advanced Formulae & Functions (FULL COURSE)
containing: Exploring the Formulas ribbon; Comparing the Logical functions of IF and IFS; Using the Statistical functions of COUNTIF and COUNTIFS; Us…
How to Cleanse Raw Data (FULL COURSE)
containing: Data cleansing functions; Text substitution functions; Using Flash Fill; Extracting the correct text; De-duplication techniques; Using Tex…
Introduction to XLOOKUP (FULL COURSE)
containing: Using XLOOKUP instead of VLOOKUP or HLOOKUP; Creating a two-way lookup with XLOOKUP; Overcoming limitations of VLOOKUP; Returning multiple…