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.
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...
