Excel: featured articles
- How to use Excel COUNTIFS and COUNTIF with multiple criteria
- Using IF function: formulas for numbers, text, dates, blank cells
- Creating a drop down list: static, dynamic, from another workbook
- Excel formulas for conditional formatting based on another cell value
- COUNTIF in Excel - count if not blank, greater than, duplicate or unique
- How to use Excel SUMIFS and SUMIF with multiple criteria
- Excel logical operators: equal to, not equal to, greater than, less than
- Nested IF formulas with multiple conditions, IFERROR, IFNA and more
Excel: VLOOKUP tutorial
- VLOOKUP in Excel – tutorial with formula examples
- INDEX & MATCH functions in Excel - a better alternative to VLOOKUP
- How to use VLOOKUP & SUM or SUMIF functions in Excel
- Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors
Outlook: featured articles
I love the program!
I love the program, and I can't imagine using Excel without it! Ultimate Suite saves me many hours of effort with the projects I manage within Excel. The program paid for itself the first day I used it. You created a really great set of tools for use within Microsoft Excel. Thank you!!!
One word... WOW!
I recently bought the package of add-ins for Excel. I've used it ONCE and it has paid for itself. It literally saved me HOURS of work. KUDOS!
If you often communicate with your friends and family, and especially if you conduct business via e-mail, your signature is one of the most essential points of communication. This tutorial will teach you how to create a professional attention-getting email signature in Outlook, add it to all outgoing emails automatically or insert into a message manually. Continue reading
This article introduces you to the Excel SWITCH function, describes its syntax and provides a couple of use cases to illustrate how you can simplify writing nested IFs in Excel. Continue reading
In this article you'll see how to compare two Excel files with the help of the Synchronizer add-in. Continue reading
On this page, you will find 15 easy tips to create an attractive professional email signature illustrated with beautiful examples. Also, we will have a closer look at 4 online HTML email signature generators that provide a collection of free email signature templates. Continue reading
If you want to get a list of unique values in a column, this tutorial offers a number of formulas and will teach you how to tweak them for different datasets. You will also learn how to quickly get a distinct list using Excel's Advanced Filter, and how to extract unique rows with Duplicate Remover. Continue reading
Work online is a commodity that is slowly turning into a necessity. If you want to take your tables to the cloud, consider the most popular spreadsheet solutions: Google Sheets and Excel online. In this blog post I will try to list the main differences in the features they provide Continue reading
If you want to quickly find, filter and highlight unique or distinct values in your Excel worksheets, this tutorial will show you fast and efficient ways. Continue reading
From this article you'll learn about the 5dchart Add-in. It's a flexible and easy-to-use Excel tool that makes creating 3D bubble charts and scatter plots fun and easy. Continue reading
In this tutorial, you will learn how to count unique values in Excel with formulas, and how to get an automatic count of distinct values in a pivot table. We will also discuss a number of formula examples for counting unique names, texts, numbers, cased-sensitive unique values, and more. Continue reading
This short tutorial explains the basics of the Excel COUNT and COUNTA functions and shows a few examples of using a count formula in Excel. You will also learn how to use the COUNTIF and COUNTIFS functions to count cells that meet one or more criteria. Continue reading
Ultimate Suite has become even better. We improved Consolidate Worksheets Wizard and Remove Characters, added the Clear Formatting, Split Text, Add Text add-ins and re-implemented Column Manager. Read this article to learn more. Continue reading
The tutorial explains how to remove duplicates in Excel 2010, Excel 2013, and Excel 2016. You will learn a few different techniques to find and delete duplicate values with or without first occurrences, remove duplicate rows, detect absolute duplicates and partial matches. Continue reading
In this tutorial, we are going to have a close look at how to show duplicates in Excel. You will learn how to shade duplicate cells, entire rows, or consecutive dupes using conditional formatting. Also, you will see how to highlight duplicates with different colors using a specialized tool. Continue reading
- ABOUT US