Aug
27
Excel VLOOKUP not working - solving #N/A, #NAME, #VALUE errors
The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel, troubleshoot and fix common errors and overcome VLOOKUP's limitations. Continue reading
Tutorials, videos, useful tips for Excel, Outlook and Google Sheets, page 17
Aug
21
How to remove rows in Excel based on a cell value
This article lists several ways to delete rows in Excel 2016, 2013, and 2010 based on a cell value. In this post you'll find hotkeys as well as Excel VBA. Delete rows automatically or use the standard Sort and Find options in combination with helpful shortcuts. Continue reading
Aug
19
5 ways to do case-sensitive VLOOKUP in Excel
The tutorial explains how to make Excel VLOOKUP case-sensitive, demonstrates a few other formulas that can look up case in Excel and points out strengths and limitations of each function. Continue reading
Aug
13
INDEX & MATCH in Excel - better alternative to VLOOKUP
This tutorial demonstrates the key strengths of Excel's INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples that will help you easily cope with many complex tasks when VLOOKUP fails. Continue reading
Aug
7
Relative and absolute cell references in Excel conditional formatting
Invest a few minutes and learn how to correctly use relative and absolute cell references in Excel conditional formatting rules. This knowledge will certainly save you far more time in the long run. Continue reading
Aug
6
How to hide columns in Excel using shortcut, VBA or grouping
The possibility to hide columns in Excel is really helpful as there may be lots of reasons for keeping certain details from showing. Continue reading
Aug
5
How to use VLOOKUP with SUM or SUMIF functions in Excel
In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Continue reading
Jul
30
How to unhide and show hidden columns in Excel
From this article, you'll learn how to unhide columns in Excel 2016 - 2007. It will teach you to show all hidden columns or just the ones you select. Grab a special macro to unhide all columns in Excel automatically each time you open a worksheet and find out how to protect the hidden columns from being displayed. Continue reading
Jul
29
Advanced VLOOKUP in Excel: multiple, double, nested
In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOKUP functions in one formula, dynamically pull data from different sheets, and more. Continue reading
Jul
25
How to create waterfall chart in Excel (bridge chart)
This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2016, 2013. Continue reading
Jul
21
How to insert page numbers in Excel
This article explains page numbering in Excel 2019, 2016, 2013 and lower. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete number watermarks added incorrectly. Continue reading
Jul
17
Excel VLOOKUP tutorial for beginners with formula examples
This VLOOKUP tutorial explains the syntax and provides a number of examples that illustrate the most common usages of the VLOOKUP function in Excel. Continue reading
Jul
15
How to insert and remove page breaks in Excel
The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2016 - 2010, where to find the Page Break Preview, hide and show the marking lines. Continue reading
Jul
10
How to use Excel COUNTIFS and COUNTIF with multiple criteria
The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading
Jul
9
How to rotate charts in Excel - rotate bar, column, pie and line charts
This post describes how to rotate a chart in Excel 2016-2010. You'll learn different ways to spin bar, column, pie and line charts including their 3-D variations. Besides, you'll see how to reverse the plotting order of values, categories, series and legend. Those who often print graphs and charts will read how to adjust the sheet orientation for printing. Continue reading
Jul
2
COUNTIF function in Excel - count if not blank, greater than, duplicate or unique
The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading
Jun
24
How to freeze panes in Excel to lock rows and columns
In this short tutorial, you will learn how to quickly lock header row and first column in Excel. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. These tips work equally well in all modern versions of Excel 2013, 2010 and 2007. Continue reading
Jun
19
3 ways to count empty cells in Excel
If your task is to get Excel count blank cells in your worksheet, read this article to find 3 ways to accomplish it. Learn how to search and select empty cells with the Go to Special option, use Find and Replace to count blanks or enter a formula in Excel 2010-2013. Continue reading
Jun
18
How to count non-empty cells in Excel
This articles looks at the ways to count non-blank cells in Excel 2010-2013. Below you'll find 3 methods for counting non-blanks: see the number on the Excel Status bar, employ the Find and Replace dialog or use a special formula. Continue reading
Jun
17
How to conditionally format dates and time in Excel with formulas and inbuilt rules
See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading
Jun
14
Easily print comments in Excel
How to print comments in Excel 2016-2010 in several clicks. Get cell notes to paper as displayed on your table or print them at the end of the page. Continue reading
Jun
13
Fastest ways to insert multiple rows in Excel
Inserting multiple rows in Excel may be one of the numerous tasks you come across daily. In today’s article, I hope to inspire shortcut-oriented users by showing some really quick ways to add new rows in Excel. You’ll also see how to solve this task using standard menus and Ribbon buttons and how to add empty rows between multiple data lines. Continue reading
Jun
12
How to import contacts to Outlook from Excel in 3 steps
In this article, I’ll show you how to import contacts from Excel to Outlook 2010-2013. You’ll find three easy steps for getting your contacts exported. Convert your data to .csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields. Continue reading
Jun
10
Excel conditional formatting formulas based on another cell
This tutorial explains how to use Excel formulas to format cells and entire rows based on the values you specify or based on another cell's value, and provides a handful of formula examples. Continue reading
Jun
5
Excel Icon Sets conditional formatting: inbuilt and custom
Assuming you already know the basics of Excel conditional formatting, let's move on and see what options you have with regard to icon sets and how you can leverage them in your projects. Continue reading
May
30
How to use AutoFill in Excel - all fill handle options
This post looks at the AutoFill Excel feature. You will learn how to fill down series of numbers, dates and other data, create and use custom lists in Excel 2010, 2013 and lower. This article also lets you make sure you know everything about the fill handle, cause you may be surprised how powerful this tiny option is. Continue reading
May
29
Excel Conditional Formatting tutorial with examples
Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and spot variances of cell values with a quick glance. Continue reading
May
26
How to recover unsaved Excel file or restore its previous version
Do you want to protect your workbooks from unexpected computer crashes or power failures? This article explains how to recover unsaved files and restore previous versions of your workbook in Excel 2016 - 2010. You'll also learn different ways of file backup to your PC and to the cloud storage. Continue reading
May
23
How to make a Gantt chart in Excel
See how you can quickly make a simple Gantt chart in Excel, where you can download advanced Excel Gantt chart templates or utilize the online Project Management Gantt Chart generator. Continue reading
May
16
How to mail merge and print labels from Excel
This tutorial explains how to mail merge and print labels in all versions of Excel 2010 to Excel 365. You will learn how to properly prepare your Excel file to make mailing labels, set up the main label document in Word and save it for later usage. Continue reading
