In this video I explain how to use the INDEX MATCH formula as an alternative to VLOOKUP in Excel. Download the Excel file: https://www.excelcampus.com/functions…
You can follow along with the video and practice writing the formulas. The Excel file also includes my cheat sheet for writing the formulas.
I explain the two main benefits of INDEX MATCH over VLOOKUP. This includes:
1. The ability to return a value from a column to the left/above.
2. Separate columns for the lookup and return ranges.
3. We also look at the most common error that the formula returns and how to prevent it.
Windows LTSC? Too Heavy... Windows Enterprise? Hell no! We will BUILD the absolute LIGHTEST Windows 10 that will make Windows 7 users jealous. https://www.youtube.com/watch?v=P9sBeDge5YE
This video will show you how to clear 6 different types of cache in Windows 10 to free up disk space, troubleshoot issues on your computer and improve system performance. https://www.youtube.com/...
See all the new ways to work together on Microsoft Teams. Now you can join your team in the same virtual room with Together Mode, you can see up to 49 people at a time in Large Gallery View, and you ...
If you’re looking for free cloud storage offering the most space for your photos, videos, or any other type of data, we’ve got you covered. In this video, I’ll show you the 10 best free cloud storage...
You can change the look and feel of all your Office programs by changing the Office Theme or background. To change the background color and design of all your Office programs, go to File -- Optio...
Microsoft To Do integrates seamlessly with Outlook. You can manage your tasks from your Outlook inbox with the My Day pane or create tasks from flagged email. Learn how to use Microsoft To Do in Outl...
Having issues with Windows 10 Updates? If you've added hardware to your device, check for third-party driver updates and installation instructions on the hardware manufacturer’s website. Update an...
Microsoft Windows Autopilot helps companies deal with common IT challenges. Users receive a new-in-box device directly from the OEM or reseller partner—or a repurposed device from IT—and simply unbox...
Microsoft Windows Autopilot is flexible, so you can choose a deployment scenario that suits your business. For example, a user-driven Autopilot deployment is, well, driven by employees—wherever they ...
In this video, you can learn how to group rows and columns in Excel so that you can quickly hide and unhide rows or columns. You’ll also discover the Auto Outline feature that Excel has to anticipate...
Microsoft Teams helps you simplify your enterprise voice services with a reliable, high-quality integrated calling solution built on the Microsoft cloud. This demo shows how to use the Calling featur...
Learn how you can optimize Visual Studio for when you are using it to demo. Not only do you give your audience a better experience, but with a few tricks you can make it great for you as well. ht...
With Shifts in Microsoft Teams, you can view, manage, and share your team’s schedule for the day, week, or month. The Shifts app in Microsoft Teams keeps Firstline Workers connected and in sync. I...
Trello, the kanban project management tool adds another view, table view. Along with a host of updates across the last few month, Trello is gearing up to take on the likes of ClickUp, Notion, Airtabl...
If you’re a graphic artist creating scalable designs and you don’t want any of that nasty pixelation when resizing, Adobe Illustrator is the industry standard for creating vector graphics that never ...
This month, we cover the new Yammer experience for web and mobile, how to integrate the Yammer Communities app for Microsoft Teams, new policy packages to support first-line workers and managers, and...
Introducing the Microsoft Family Safety app, a simple way to protect what matters most. With features like content and screen time control, live location tracking, and more, Family Safety gives you t...
We aim to build tools and experiences for the modern workplace and for workers at all levels of the organization. We’ll continue to develop and bring to market purpose-built Firstline Worker capabili...
Using your Gmail address, you can sign up and create a Microsoft Teams free org. You will still need to create a Microsoft account. https://www.youtube.com/watch?v=tl0o5ehd2-g
There are two ways that you can be invited to join a Teams free org: via email or via direct link. Use Microsoft Teams on your desktop, on the web, or on your iOS or Android mobile device. https:...
In this video, I explain my preferred method for to create running totals in an Excel Table, and also learn how to make those totals conditional on specific criteria. This method uses struct...
Can the team track and manage the change across hundreds of stores, restocking, and new employees? Yes. They got this, with Microsoft Lists. https://www.youtube.com/watch?v=ug-PIO9YQf8
In previous videos we’ve separated out the good from the bad to show you the best free programs. Sadly, for a variety of reasons there is software you should avoid because it could cause more harm th...
Learning to work from home effectively can be hard in these tricky times. This webinar hosted by GoSkills originally will help you to navigate your new remote work lifestyle and give you actions on h...
If you want to change what appears behind you in a video conference, you can either blur your background or replace it entirely with any image you want. https://www.youtube.com/watch?v=vd7_Wtv-vX...
Microsoft Project 2020 is a project management solution from Microsoft 365 - a suite of tools to help you get work done. Today, we pass over to Collaboration Coach to explore Microsoft Project and ho...
As businesses adapt to the increased need to have people work remotely and connect with their customers virtually, this site will stay updated with the latest how-to information, tips, resources, and...
With Microsoft Teams, you can create new teams as you start new projects or add customers. In this tutorial, you’ll learn how to create a team that includes people both inside and outside of your com...
Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you...
To share files with your customers and work on documents together, use an “Anyone” link in Microsoft 365 Business Premium or Office 365. • From your SharePoint site, go to the folder you want to s...
This Microsoft Teams tutorial will show you how to join and participate in meetings with both internal and external users. • For internal users, start in Microsoft Teams. • Choose “Calendar” an...
Office 365 is getting some upgrades in June 2020 - expect Microsoft Powerpoint, Microsoft Teams, and Sharepoint to get significant improvements - this video overviews the latest Microsoft 365 tool ch...
With the “raise your hand” feature in Microsoft Teams, you can let everyone know you have something to say without interrupting the speaker. Select the “hand” icon, and the hand will show up...
This video explains how the SUBTOTAL function works. This function is used when you add a Total Row to your Excel Tables. It also is what is used when you click the AutoSum button. https://www.yo...
As you’re working from home, you can use Microsoft Teams background effects to limit distractions or infuse personality into your video meetings. This tutorial will show you how to make the most of T...
Microsoft Whiteboard has everything you need to run an effective planning meeting, including sticky notes, kanban templates, digital ink, and real-time collaboration. https://www.youtube.com/watc...
This video teaches you how to import tables from a PDF file into Excel with Power Query. Table data that spans multiple pages in the PDF can be appended together into one cohesive Excel Table. ht...
This video teaches you how to merge two tables or queries in Power Query to look up data and return matching results in Excel. The tables do not have to be formatted the same way. They just need to s...
Ever felt frustrated trying to debug asynchronous code? Check out this video to learn about the various tools and tricks that can help you debug your async code in Visual Studio 2019! https://www...
In this post, you can learn how to prevent Table formulas from filling down automatically. This is known as the Calculated Columns feature, which auto-fills the entire column when you input a formula...
In this video, I explain how to combine multiple Excel Tables or Worksheets with Power Query. You will learn how to fully automate this process to save you a ton of time with this common Excel ...
In this video tutorial, you’ll learn how to install Outlook and Office apps on Android devices. If your Android device is managed by Microsoft 365 Business, you may be prompted to set up additional s...
Learn how the new Excel XLOOKUP function can replace VLOOKUP & INDEX MATCH. Partial match, reverse order, and horizontal lookup formulas are now possible with this one function. XLOOKUP can pe...
In this video, I explain how to prevent errors in VLOOKUP formulas when inserting or deleting columns from the table array range. You can download the Excel file that I use in the vide...
In this video I explain everything you need to know to get started with VLOOKUP for Excel. Download the Excel file: https://www.excelcampus.com/filedownl... This tutorial is a follow-along lesson...
This GIMP tutorial for beginners will go over the basics including tips and tricks that can be used with the program. Near the end of this video, as an added bonus, I’ll show you how to create a thum...
With Microsoft Teams, you can create your own team, join an existing one, add people and channels, and customize your team settings. https://www.youtube.com/watch?v=OI-ABFcTELw
VLC is Bloated | Use These Video Players Instead I have used VLC for 10+ years and it is time to change to something better. https://www.youtube.com/watch?v=xixOafbvQEw
In Microsoft Teams, you have the control to decide what notifications you receive, where you receive them, and how often you get them. https://www.youtube.com/watch?v=4ifVbwFbRwk
Custom Project Templates in Visual Studio 2019 allow us to create starting points for our projects that are customized exactly how we want them to be. In this video, we will configure a Caliburn.Micr...
Pair programming is a really powerful way to greatly improve your development skills and make an application better. The idea is that two people working together are more focused, come up with better...
Visual Studio 2019 can make you faster and more consistent as a developer with tools like Intellicode, EditorConfig, Code Cleanup, XAML Hot Reload, and a lot more. In this video, we are going to go t...
How we live and work has changed. Our priority is to help you respond to today’s challenges by enabling employees to work remotely. Join us for a new episode of Modern Workplace as we explore how to ...
With a Microsoft Teams live event, you can join it with a live event link, and participate in Q&A if it’s available. https://www.youtube.com/watch?v=316Bb8cgHMw
If your Microsoft Teams live event has a Q&A option, participants can send questions to live event moderators. You can choose to publish the questions and answer publicly or send an answer privat...
With Microsoft Teams, you can set up a live event, manage the content you want to share, and send a link to invite your team members. https://www.youtube.com/watch?v=Jmi5mk0Rfgo
There is brand new Git tooling coming to Visual Studio and in this episode we invited Taysser Gerhfal and Pratik Nadagouda to tell us all about it. https://www.youtube.com/watch?v=ROC0rVXNGb8
The new Microsoft Edge is here! Built on an open-source foundation called “Chromium", it will help you browse the web reliably, securely, and productively while protecting and respecting your privacy...
Access all of your email accounts in one place with Microsoft 365. This video tutorial walks you through the simple steps to import data from existing email accounts and redirect to those accounts in...
Learn how to configure your work email in Outlook with this simple tutorial. Once your Microsoft 365 apps are installed, go to the start menu and search for Outlook. Then, click on the app to get sta...
Install and access Microsoft Office 365 apps with this simple-to-follow tutorial. To start, go to Office.com and select “install Office” followed by “Office 365 apps.” To install Microsoft Teams, sel...
Microsoft Edge makes managing and organizing your favorite websites simple. See how you can save your favorites and organize them into folders for fast and easy access. https://www.youtube.com/wa...
This video walks you through the updated process to request assistance from Microsoft FastTrack for organizations setting up remote work and learning, in response to the COVID-19 outbreak. https:...
Most companies understand how to measure business outcomes. But how do you quantify—and then influence—the day-to-day actions that drive those outcomes? See how workplace intelligence will separate y...
Our customers inspire us as they leverage our technology to stay connected and continue to have an impact in these challenging times. The Metropolitan Police Service keeps protecting. University o...
Stay connected with others no matter where you are. With real-time co-authoring, auto-save, notifications, and @mentions, you can more efficiently share and work with others in your favorite Office a...
Mads kicks off the Remote Office Hours talking to Scott about working from home with Visual Studio, dealing with the complexities of the pandemic when doing so, and how you can make it a bit easier o...
For several years, I’ve either been using my home office to work remotely or as my primary place of business. So, with more of you working from home, I reached out to friends that also work from home...
Microsoft Teams Mic Setup and Basic Usage This goes over the first things to set up after you have Microsoft Teams installed. I go over video, mic, and speaker set up with an overview of Microsoft Te...
Free Remote Control Software | Veyon Let's go over Veyon which is a remote control software for doing a virtual classroom, so you can cast demos, control pcs, reboot, shutdown, and more all from a si...
Introducing the all new Microsoft Edge, a web browser that gives you the privacy, productivity and value you want while you browse. Available on Windows, Android, macOS and iOS, Microsoft Edge deliv...
This FileMaker Beginner tutorial is going to show you how to create a script that can add leading zero to your numeric values using the Right( ) calculation function. https://www.youtube.com/watc...
Create connections and engagement between leaders and employees at every level in your organization with Live Events in Microsoft 365. Use video and interactive discussion across Yammer, Microsoft Te...
Want to get the most out of Teams? Here are some of our favourite tips and tricks when using Microsoft Teams! https://www.youtube.com/watch?v=_Cw9uXfgTLQ https://www.youtube.com/watch?v=oARN...
Find out why top security companies are joining the Microsoft Intelligent Security Association (MISA) to defend against increasingly sophisticated, fast-moving threats. https://www.youtube.com/wa...
In this episode, Robert is joined by Sourabh Shirhatti, who shows how to build a gRPC service with Visual Studio. Sourabh starts with an introduction to gRPC, a language agnostic, high-performance Re...
Collaboration bars for Microsoft Teams allows you to turn your focus rooms or smaller conference areas into high-quality, collaborative meeting spaces! These affordable, simple to install and easy to...
There are many reasons why schools may need to leverage remote communication tools to function. Whatever they may be, Microsoft Teams for Education makes connecting virtually seamless for members of ...
Microsoft Teams for Education makes connecting virtually seamless for members of any school, college or university. Included for free with Microsoft Teams educators can create online classroom spaces...
Microsoft Teams for Education makes connecting virtually seamless for members of any school, college or university. Included for free with Microsoft Teams educators can create online classroom spaces...
As a banking leader in Latin America and one of the largest banks in the world, Itaú Unibanco handles thousands of transactions every second. Operating on an aging data infrastructure, the bank found...
Microsoft Whiteboard enables you and your co-workers to collaborate and share visual ideas in real-time while working remotely. https://www.youtube.com/watch?v=RH26Ncrvwsw
Adobe makes so many software that it can be quite overwhelming for even a professional to understand what each one is used for. Many people who are new to this have confusing questions regarding ...
These are 10 useful Firefox extensions that enhance your web browser. A couple months back we did a video about useful extensions for the Chrome browser. Now it’s time to give some love to Firefox. I...
These are the Top 10 Chrome Extensions to use 2020. Over the past few years, we’ve done several videos showing you the best extensions from the Chrome Web Store. With nearly a hundred having been sho...
For companies seeking to migrate to the Microsoft Cloud Services, Microsoft created a series of videos that speak high level to common risk and control considerations. This specific video will walk y...
These are the absolute best video editing software. These will be in 5 categories from best for beginners to best overall finishing things out. In the final category, we’ll have 2 winners. Best overa...
This video will show you how to force the Google Chrome browser dark mode for every website on Windows, Android, Mac, or Linux. https://www.youtube.com/watch?v=-RK0iSTqLa4
If you’re looking for the best FREE screen recorder, you have many choices. Whether it’s creating a presentation for your business or recording your latest gaming session for YouTube or Twitch, there...
These are the Top 5 video editors that you can use online in your favorite web browser. In the past we’ve shown you the best video editing programs that you can install on your computer. Many of you ...
In this episode, Robert is joined by Burke Holland, who introduces us to Visual Studio Online, which provides a cloud-based development environment you can access from anywhere. Burke shows how easy ...
It’s never been more important to make sure your devices are secure and your personal, private data stays private. Now with the McAfee Mobile Security app, we can help make your mobile experience eve...
The new Office mobile app—designed to be your go-to app for getting work done on a mobile device—is now available for anyone to download on Android and iOS. https://www.youtube.com/watch?v=untLDc...
This month, we're focusing on tools for Firstline Workers and Managers, new productivity experiences across Microsoft 365, and more. https://www.youtube.com/watch?v=4KTToEqdUBk
It’s inspiring to see how industry leaders like IKEA are driving higher levels of employee engagement and enhancing the customer experience by putting tools like Microsoft Teams into the hands of the...
Windows PC There are different ways to remove apps and programs, so if you can't find the one you're looking for, you can try another location. Note that some apps and programs are built in...
Reimagined to include anyone who manages projects as a part of their job, Microsoft Project, also known as Project for the web, is a simple yet powerful tool for individuals and teams to manage work ...
Resume Assistant in Microsoft Word shows you examples of how professionals in the field you're interested in describe their work experience and skills. https://www.youtube.com/watch?v=-Oc5BaEnxN8...
Not sure what command you need to perform a specific task? The "Search" function will help you find it. Learn more at the Office 365 Training Center: https://office.com/training https://www.youtu...
We're thrilled to announce that Vevo Digital has begun a partnership with NordVPN as an official registered re-seller of NordVPN activation keys. Here are some of the awesome key features of Nor...
"We’re excited to announce starting today you can try the Windows Subsystem for Linux 2 by installing Windows build 18917 in the Insider Fast ring!" Full details can be found on the Microsoft dev ...
Here's a handy Windows 10 edition comparison chart, it shows the four main different Windows 10 editions, Home, Pro, Enterprise & Education. You can use this to decide which edition of Windows 10...
We've put together a list of links to free Microsoft Office online training courses for various apps in the Microsoft Office suite. The training includes things such as quick start guides, learning t...
Microsoft has announced that the next major Windows 10 update is coming in October, and it will be called Redstone 5. New features include a new cloud clipboard that syncs across devices, a dark theme...
