Jan
13
How to show percentages in Excel
In this short tutorial, you will find many helpful details about Excel percent format and learn how to make Excel display percentages in the way you want. Continue reading
"Excel" category, page 15
Dec
17
Using logical functions in Excel: AND, OR, XOR and NOT
Last week we tapped into the insight of Excel logical operators that are used to compare data in different cells. Today, you will see how to extend the use of logical operators and construct more elaborate logical tests to perform more complex calculations and more powerful data analysis. Excel logical functions such as AND, OR, XOR and NOT will help you in doing this. Continue reading
Dec
10
Excel logical operators: equal to, not equal to, greater than, less than
Many tasks you perform in Excel involve comparing data in different cells. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. Continue reading
Dec
3
Excel IF statement with multiple conditions
For powerful data analysis, you may often need to build an Excel IF statement with multiple conditions or use IF together with other functions. This tutorial will show you the most effective ways to do this. Continue reading
Nov
26
How to use IF function in Excel: examples for text, numbers, dates, blanks
IF is one of the most popular and useful functions in Excel. Generally, you use an IF statement to test a condition and to return one value if the condition is met, and another value if the condition is not met. Continue reading
Nov
19
How to use Pivot Tables in Excel - tutorial for beginners
In this Excel pivot table tutorial you will learn what a PivotTable is, find a number of pivot table examples that will help you to get started quickly and see how to create and use pivot tables in Excel 2016, 2013, 2010 and 2007. Continue reading
Nov
12
How to use Excel SUMIFS and SUMIF with multiple criteria
This tutorial explains the difference between the SUMIF and SUMIFS functions in terms of their syntax and usage, and provides a number of formula examples to sum values with multiple AND / OR criteria in Excel. Continue reading
Nov
4
How to use SUMIF function in Excel with formula examples
If you are faced with a task that requires conditional sum in Excel, the SUMIF function is what you need. It is a really great function that can help you make sense of an incomprehensible set of diverse data. Instead of adding up all numbers in a range, it lets you sum only those values that meet your criteria. Continue reading
Oct
31
5 ways to sum a column in Excel
This tutorial shows how to sum a column in Excel 2010-2013. Try out 5 different ways to total columns: find the sum of the selected cells on the Status bar, use AutoSum in Excel to sum all or only filtered cells, employ the SUM function or convert your range to Table for easy calculations. Continue reading
Oct
22
Converting PDF files (text and image) to Excel
The article explains how to export different PDF files to Excel manually or using free online converters, and how to choose the conversion method best suited for a given file type. Continue reading
Oct
10
How to convert numbers to text using Excel TEXT function and other options
This tutorial shows how to convert number to text in Excel 2016 - 2010. See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. Learn how to change number format to text with the Format Cells… and Text to Columns options. Continue reading
Oct
9
How to convert Excel files to PDF
This short tutorial describes 4 possible ways to convert Excel files to PDF – by using Excel's Save As feature, Adobe software, online Excel to PDF converters and desktop tools. Continue reading
Sep
30
Making a dependent (cascading) drop down list in Excel
The tutorial demonstrates how to create cascading drop down lists in Excel that display choices depending on the value selected in a previous dropdown. Continue reading
Sep
24
Create drop down list in Excel: static, dynamic, editable, searchable
Excel is good at organizing and analyzing complex data. One of its most useful features is the ability to create dropdown lists, which allow selecting an item from a pre-defined list. Continue reading
Sep
1
How to add columns in Excel: single, multiple, every other
In this article, we will explore various methods to insert columns in Excel, ranging from simple right-click options to VBA macro for adding every other column automatically. Whether you need to add more data to your report, rearrange existing columns … Continue reading
Aug
27
Excel VLOOKUP errors: #N/A, #VALUE, #NAME
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
Aug
21
How to remove rows in Excel based on a cell value
This article lists several ways to delete rows in Excel 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