Excel tutorials, functions and advanced formula examples, page 9
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
Excel MAXIFS function - get largest value based on multiple criteria
Traditionally, when you needed to find the highest value with conditions in Excel, you had to build your own MAX IF formula. While not a big deal for experienced users, that might present certain difficulties for novices. Luckily, Microsoft has recently introduced a new function that lets us do conditional max an easy way! Continue reading
MAX function in Excel: formula examples to find and highlight highest value
MAX is one of the most straightforward and easy-to-use Excel functions. However, it does have a couple of tricks knowing which will give you a big advantage. Continue reading
How to create a table in Excel
At the surface, an Excel table just sounds like a way to organize data. In truth, this generic name covers a ton of useful features. Tables containing hundreds or even thousands of rows and columns can be instantly recalculated and totaled, sorted and filtered, updated with new information and reformatted, summarized with pivot tables and exported. Continue reading
How to insert Google Sheets checkmarks and cross marks
Lists help us put things in order. Stuff to buy, tasks to solve, places to visit, movies to watch, books to read, people to invite, video games to play - everything around us is practically filled with those lists. And if you use Google Sheets, chances are that it would be best to track your endeavours there. Let's see what instruments spreadsheets offer for the task. Continue reading
Sparklines in Excel: how to create, use and change
Looking for a way to visualize a large volume of data in a little space? Sparklines are a quick and elegant solution. These mini-charts are specially designed to show data trends inside a single cell. Continue reading
Useful Google Sheets functions that don't exist in Excel
This blog post brings the majority of those Google Sheets functions that Excel doesn't have to your attention. They are conveniently classified by Google based on their primary task. So just pick the group from the table of contents and you'll find their descriptions with the simplest examples. Continue reading
Schedule email sending and delay delivery in Outlook
Does it often happen to you that you send an email and a moment later you wish you hadn't? Perhaps you clicked Reply All instead of Reply, or accidentally sent sensitive information to a wrong person, or just realized that your angry response was a bad idea and you need to cool down. Continue reading
Handy tools to manage text in Google Sheets
Despite lots of perks offered by Google Sheets, it also has its drawbacks. A clear example of that is the shortage of simple tools to manage text. Are we bound to add or replace text in Google Sheets manually or with complex formulas? Not anymore. :) We've filled this gap with simple one-click tools. Allow me to introduce them to you in this blog post. Continue reading
How to recall email message in Outlook and Gmail
A hasty click of the mouse can happen to the best of us. So, the Send button is hit, your email is on its way to the recipient, and you are cringing at the thought of what it may cost you. Before you start weighing the consequences and composing an apology notice, why not try to retrieve the erroneous message? Continue reading
How to merge several Google sheets into one without copy-pasting
Every once in a while each Google Sheets user faces the inevitable: combining several sheets into one. Copy-pasting is tedious and time-consuming, so there has to be another way. And you're right - there are several ways, in fact. So get your tables ready and follow the steps from this article. Continue reading
Excel print area: how to set, change and clear
When you hit the Print button in Excel, the entire spreadsheet is printed by default. But what if you don't really need to print out all the content of a huge worksheet? Then set the print area that includes only your selection. Continue reading
How to print Excel spreadsheet: tips and guidelines for perfect printouts
Living in a digital world, we still need a printed copy every now and then. At first sight, printing Excel spreadsheets is super easy. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. Continue reading
How to change Google Sheets date format and convert dates to numbers and text
In this guide, you'll find out how Google stores dates and how you can format them for your better convenience. Some date formats are offered to you by spreadsheets while others should be created from scratch. There are even a couple of handy functions for the task. I also describe a couple of ways to convert your dates to numbers and text if necessary. Continue reading
How to calculate IRR in Excel with formulas, template and Goal Seek
When you know the internal rate of return of a project, you may think you have all you need to evaluate it - the bigger the IRR the better. In practice, it's not that simple. Continue reading
