Excel tutorials, functions and advanced formula examples, page 7

How to VLOOKUP across multiple sheets in Excel with examples

When looking up some information in Excel, it's a rare case when all the data is on the same sheet. More often, you will have to search across multiple sheets or even different workbooks. The good news is that Microsoft Excel provides more than one way to do this. Continue reading

Excel formula to count cells with certain text: exact and partial match

When analyzing large chunks of information in Excel, you may often want to know how many cells contain specific text. This tutorial explains how to do it in a simple way. Continue reading

INDEX MATCH in Google Sheets – flexible Vlookup for your spreadsheets

When you need to find data in your sheet that corresponds to a certain key record, it is usually Google Sheets VLOOKUP you turn to. But there you go: VLOOKUP slaps you with limitations almost immediately. That's why you'd better increase the resources for the task by learning INDEX MATCH. Continue reading

How to count cells with text in Excel: any, specific, filtered cells

Initially, Excel spreadsheets were designed to work with numbers. But these days we often use them to store and manipulate text too. Want to know how many cells with text there are in your worksheet? Microsoft Excel has several functions for this. Continue reading

Google Sheets QUERY function: a spreadsheet cure-all you have yet to discover

If you've been following this blog for a while, you may remember QUERY. I mentioned it as a possible solution for a couple of cases. But those are far from enough to uncover its full potential. Today, it's high time we get to know this spreadsheets superhero properly. And guess what – one equally noteworthy tool will also be there :) Continue reading

How to export and import contacts between Outlook and Google Gmail

Switching between Microsoft Outlook and Google Gmail is a very common trend these days. Some people are migrating from a desktop-oriented Outlook app to a cloud-based Gmail while others are using different email clients for their personal and business communication. Luckily, both Outlook and Gmail make it possible to transfer all your contacts in one go. Continue reading

Google Sheets FILTER function: formulas and tools to filter data in spreadsheets

If the only way you know of creating a filter in Google Sheets is the standard tool, I have a surprise for you. :) Come explore the FILTER function with me. There are plenty of ready-made formulas you can borrow, along with a new powerful tool that complements the filtering toolset immensely. Continue reading

How to import contacts into Outlook from CSV and PST file

There may be different reasons why you may want to transfer contacts into your Outlook address book. For example, you inherited a list of contacts in an external database, or you are migrating from another mail server, or perhaps you are setting up a new account. Continue reading

How to export contacts from Outlook

Whether you are migrating to another email service or making a regular backup of your data, it is crucial to transfer all contact details without any fail. This tutorial will teach you a few easy ways to export Outlook contacts into a .csv or .pst file, so that you could later import them anywhere you need. Continue reading

Excel INDEX MATCH MATCH and other formulas for two-way lookup

When searching for something in your Excel spreadsheets, most of the time you'd look up vertically in columns or horizontally in rows. But sometimes you need to look across both rows and columns. This is called a two-dimensional lookup, and this tutorial shows how to do it in 4 different ways. Continue reading

Excel INDEX MATCH with multiple criteria - formula examples

Although Microsoft Excel has special functions for vertical and horizontal lookup, expert users normally replace them with INDEX MATCH, which is superior to VLOOKUP and HLOOKUP in many ways. Among other things, it can look up two or more criteria in columns and rows. Continue reading

XLOOKUP function in Excel for vertical and horizontal lookup

The tutorial introduces XLOOKUP - the new function for vertical and horizontal lookup in Excel. Left lookup, last match, Vlookup with multiple criteria and a lot more things that used to require a rocket science degree to accomplish have now become as easy as ABC. Continue reading

How to share Outlook calendar with Google

Sharing something between two different applications is often far more complicated than it needs to be, especially when it comes to Microsoft Outlook and Google Gmail, the two most prevalent mail and calendar apps used today. This tutorial will teach you 3 easy ways to share Outlook calendar with Google without using any extensions, plug-ins or third-party tools. Continue reading

How to add and view shared calendar in Outlook

In the previous article, we discussed different ways to share Outlook calendar with other people. Looking from another angle - if someone shared a calendar with you, how do you open it in Outlook on your desktop? Continue reading

How to use MINIFS function in Microsoft Excel

When it comes to finding the minimum based on conditions, there are several possible solutions. You’ll see different approaches to locate the lowest value and choose the one that suits best for you. Continue reading

Excel MIN function - usage and formula examples

If you have a large range of data to find the lowest value in, the scrolling and looking for it manually is not an option. Please check different ways of locating a minimum number in Excel and choose the best one for your task. Continue reading

How to share Outlook calendar

Want to let your colleagues, friends and family members know what's on your schedule so they can see your free times? The easiest way is to share your Outlook calendar with them. Depending on whether you use a locally installed desktop app or Outlook Online, an Exchange Server account within your organization or a private POP3 / IMAP account at home, different options will be available to you. Continue reading

How to share and publish calendar in Outlook on the web and Outlook.com

If you have an Office 365 subscription or are subscribed to another Exchange-based mail service, you can use Outlook on the web to share your calendar with coworkers, friends and family members. Continue reading

Video: how to merge 2 Google sheets

This video tutorial explains how to keep your Google Sheets tables up-to-date with the Merge Sheets add-on. The tool will scan two tables for matches and do a quick vlookup. It will update old records, add missing info, and pull new rows and columns to your main table. Continue reading

MAX IF in Excel to get highest value with conditions

Almost every Excel user is familiar with the good old MAX function that is designed to return the largest value in a dataset. In some situations, however, you may need to drill down into your data further to find the max value based on certain criteria. Continue reading