Excel tutorials, functions and advanced formula examples, page 17
Excel array formulas, functions and constants - examples and guidelines
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
How to count cells with text and characters in Excel
This tutorial shows how to count cells with text and characters in Excel 2010-2013. You will find several helpful Excel formulas for counting characters in one or several cells, character limits for cells and get a link to see how to get the number of cells that contain specific text. Continue reading
6 most efficient uses of the INDEX function in Excel
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
Try out super speedy Merge Tables Wizard BETA and share your feedback
What a beginning of the year it was! Not sure about you but I feel like the year is already flying by. Last week we officially finished the BETA version of new Merge Tables Wizard (whew!). So I'll take some time to kick my feet up while waiting for your feedback. Continue reading
Using OFFSET function in Excel - formula examples
The tutorial explains the arcane twists of the OFFSET function and covers the most efficient ways to use OFFSET in Excel. Continue reading
How to use INDIRECT function in Excel - formula examples
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
Excel templates - where to download and how to make custom templates in Excel
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
How to calculate compound interest in Excel - formula for daily, monthly, yearly compounding
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
How to calculate percentage in Excel - formula examples
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
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
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
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
Excel IF statement with multiple AND/OR conditions, nested IF formulas, and more
The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading
Using IF function in Excel: formulas for numbers, text, dates, blank cells
In this tutorial, we are going to learn the syntax and common usages of Excel IF function as well as discuss a few formula examples for text, dates and numbers that will hopefully prove helpful both to beginners and experienced Excel users. Continue reading
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
How to use Excel SUMIFS and SUMIF with multiple criteria - formula examples
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 2016, 2013, 2010, and lower. Continue reading
How to use SUMIF in Excel - formula examples to conditionally sum cells
This tutorial explains the Excel SUMIF function in plain English and provides a numbers of SUMIF formula examples of Excel conditional sum for numbers, text, dates and wildcards. Continue reading
5 ways to sum a column in Excel 2016 - 2010
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
How to convert Word to PDF - online and desktop solutions
Learn how to convert Word to PDF using the capabilities of Microsoft Word's Save As feature, and how to choose DOC to PDF online converter or free desktop software best suited for your document type. Continue reading
Convert text-formatted digits to number using Excel VALUE function and other options
In this article, I'll show you how to convert text digits to number using several options in Excel 2010-2013. You'll see how to make Excel treat digits as numbers with the help of the VALUE function, error checking, Paste Special and applying the number format. Those who want to automate the task will find a helpful VBA macro and a special add-in. Continue reading
