Posts Tagged 'Excel'

May
3

Video: How to change case in Excel

In this video you’ll learn several ways you can change case of your records in Excel spreadsheets. We’ll look at a special tool that allows you to capitalize the first character in each cell or update the selected values to uppercase, lowercase, or proper case; we’ll learn the standard Excel functions we can use, and see how we can employ Flash Fill in Excel. Continue reading

May
2

Excel 2016 SWITCH function - the compact form of nested IF

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

Apr
28

Synkronizer - your new easy way to compare Excel files

In this article you'll see how to compare two Excel files with the help of the Synchronizer add-in. Continue reading

Apr
21

How to get a list of unique and distinct values in Excel

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

Apr
21

Video: How to remove extra spaces in Excel

Learn how to trim leading and trailing spaces, delete all blanks between numbers, and remove extra spaces between cell values in Excel using standard functions or a special add-in. Continue reading

Apr
14

Excel online or Google Sheets: choosing online solution for your tables

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

Apr
13

Distinct and unique values in Excel: how to find, filter, select and highlight

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

Apr
12

Automatically create 3D bubble charts in Excel with the 5dchart Add-in

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

Apr
7

How to count distinct and unique values in Excel

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

Mar
30

How to count cells in Excel: COUNT and COUNTA functions with formula examples

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

Older posts →