Posts Tagged 'Excel'

Aug
27

Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors

The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel 2013, 2010, 2007 and 2003, troubleshoot and fix common errors and overcome VLOOKUP's limitations. Continue reading

Aug
21

How to remove rows based on a cell value: shortcuts, VBA macros, delete every other row

This article lists several ways to delete rows in Excel 2010-2013 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

4 ways to do a 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 functions in Excel - a 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 rules

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 and group columns in Excel

This tutorial shows how to hide columns in Excel 2010-2013. You will see the standard Excel Hide columns functionality in action as well as learn to group and ungroup columns with Outline. Continue reading

Aug
5

How to use VLOOKUP & 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 2010-2013. 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 formula examples: two-way lookup, nested vlookup with multiple criteria

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 2010 - 2013. Continue reading

Older posts »