Excel tutorials, functions and advanced formula examples, page 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
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
Convert PDF to Word using online PDF to DOC converters or manually
In this tutorial, you will learn a few quick ways to export PDF to Word. See how to convert the entire PDF file or its part manually or using free online converters, and how to turn a scanned .pdf document into an editable .doc file. Continue reading
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
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
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
Install and use Template Phrases on Outlook 2013 Reading Pane
We have just released a new update for Template Phrases. Install the latest version and enjoy using it on the reading pane in Outlook 2013; check out the improved macros and bug fixes. Continue reading
Making a cascading (dependent) Excel drop down list
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
Creating a drop down list in Excel: static, dynamic, from another workbook
The tutorial demonstrates 4 quick ways to create an Excel drop down list - based on a list of values, range of cells, named range and a dynamic dropdown. Continue reading
More tools added to Ultimate Suite for Excel
Our summer has been busy with developing 3 new tools for Ultimate Suite and with fixing some major and minor bugs. Now you can try the new add-ins for swapping, flipping, and transposing columns, rows, and cells in your table. Continue reading
Count & Sum by Color - the first Ablebits add-in for MAC is out
Do you have add-ins for MAC? This is one of the most popular support requests we get almost every day. It took our developers a while to look into the possibilities to create apps that would work in Excel 2011. Finally, about a week ago we received the long-awaited "Ready for Sale" from the MAC support team and Count & Sum by Color was published. Continue reading
How to insert new columns in Excel
This post looks at how to add up new columns in Excel 2010-2013. Read on to learn shortcuts to insert one or more columns, including nonadjacent ones. Grab and share a special VBA macros to automate adding every other column. Continue reading
