Excel’s UNIQUE function lets you extract a list of distinct values from a list or range. Read on for time saving techniques!Continue readingHow To Use the Unique Function in Excel
Category: Microsoft Excel
Articles, shortcuts, tips and tricks designed to help Microsoft Excel users get more out of the business world’s leading spreadsheet application.
AutoSum lets users quickly add numbers from one or more ranges in a spreadsheet. Read on if you want to use AutoSum like a boss!Continue readingHow to Use AutoSum in Excel to Quickly Add Rows or Columns
Need to compare text in two cells to determine whether the strings are the same or different? We got you covered… read on!Continue readingCompare Two Strings in Excel: 3 Ways to Find Matching Text
In this article, we’ll look at how comments work – then we’ll show you how to hide comments in Excel to eliminate visual clutter.Continue readingHow To Hide Comments in Excel and Ditch of Those Triangles!
Excel displays a green triangle in any cells containing errors. This article explains two ways to ignore all errors in Excel when needed.Continue readingIgnore All Errors in Excel – and Hide the Green Triangles!
Need to increase or decrease the number of decimal points in your spreadsheet? Read on for 3 ways to change decimal places in Excel.Continue readingHow To Change Decimal Places in Excel (3 Ways)