The first part of our tutorial focuses of formatting dates in Excel and explains how to set the default date and time formats, how to change date format in Excel, how to create custom date formatting, and convert your dates to another locale. Continue reading
The tutorial focuses on Excel array formula examples and demonstrates how to use Excel functions that support calculations in arrays to count cells that meet several conditions, sum values in every Nth row, count any given character in a range, and more. Continue reading
In this tutorial, you will learn what an Excel array formula is, how to enter it correctly in your worksheets, and how to use array constants and array functions in Excel. Continue reading
Initially, Excel was designed to work with numbers. Fortunately, the developers of this helpful application didn't forget about text. Below, you'll find a number of formulas for counting characters in Excel. Just look through the examples and see which one best suits your needs. Continue reading
In this tutorial, you will find a number of Excel INDEX formula examples that demonstrate the most efficient uses of INDEX in Excel. Continue reading
The tutorial explains the arcane twists of the OFFSET function and covers the most efficient ways to use OFFSET in Excel. Continue reading
This Excel INDIRECT tutorial explains the function's syntax, basic uses and provides a number of formula examples that demonstrate how to use INDIRECT in Excel. Continue reading
Learn how to make your own Excel templates and where to find the best collections of free templates for your Excel such as calendars, budgets, invoices, inventory, charts, and more. Continue reading
The tutorial explains the compound interest formula for Excel and provides examples of how to calculate the future value of the investment at annual, monthly or daily compounding interest rate. You will also find the detailed steps to create your own Excel compound interest calculator. Continue reading
In this tutorial, you will lean a quick way to calculate percentages in Excel, find the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more. Continue reading
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
