The Learning Zone

30 Ultimate PowerPoint Tips and Tricks for 2020 : https://www.youtube.com/watch?v=0GW4vT7d3nc PowerPoint Tips and Tricks The ultimate compilation of PowerPoint tips and tricks to enhance your skills using Microsoft PowerPoint. I’ve combined long-established tips and tricks featured in previous videos with prominent new ones Microsoft added i

Excel Dynamic Array Formulas : https://www.youtube.com/watch?v=xwTUfU8PqCU Excel Tips and Tricks In January 2020 Microsoft released Dynamic Array Formulas for Excel. I'll show you the six new functions available to Office 365 Excel users. These functions are a dramatic change for Excel spreadsheets and that is why it took

Top 10 Excel Free Add-ins : https://www.youtube.com/watch?v=w9bog31avQc Top 10 Excel Free Add-ins Did you know Excel for Office 365 has several add-ins? I’ve searched through thousands of them to bring you the Top 10 free add-ins available from the Microsoft Store.

Advanced Excel Analysis Tip: Highlight Sort and Group the Top / Bottom Performers in a List in Excel : Excel Tips and Tricks Better analyze data in Excel by learning how to highlight and organize the data so that top and bottom values from a list are displayed next to each other for easier comparison. Credit TeachExcel

NOT() Function in Excel - Reversing True/False : Excel Tips and Tricks NOT() Function in Excel - Reversing True/False Credit TeachExcel

IF() Statement in Excel for Beginners : Excel Tips and Tricks How to use the IF() statement function for Excel - this is a tutorial for the beginner and I will take you through every step needed for creating useful IF statement functions that add logic and power to your spreadsheets. Credit TeachExcel

Auto-calculate Rooms needed for an Event in Google Sheets : Google Sheets Holding an event, and need to calculate what room size you need for registered attendees? In this video, we show you how to create a formula - using an IF statement in Javascript - to calculate the exact room size you need for your events. Watch to learn how you can utilize Google S

Excel 3D Formulas : https://www.youtube.com/embed/1p3X_DuUvYk Excel 3D Formulas Learn how to create a 3D formula in Excel, a formula that pulls data from the same cell in more than one spreadsheet. It can be a little tricky, but after watching this video you'll understand how to do it. This is a new and improved