Templates Courses Blog Why Sheets? Hire Us
Buy Now
Use conditional formatting, the Remove Duplicates Tool and the UNIQUE function to effectively and easily remove duplicates in Google Sheets in this Simple Sheets Blogpost
How to Remove Duplicates in Google Sheets Without Using Apps Script conditional formatting countif excel functions google sheets gsheets remove duplicates unique May 18, 2022
Learn how to deal with a reference isn't valid error whenever you're working with formulas or pivot tables in this Simple Sheets blogpost
A Reference Isn't Valid Excel Error | How to Fix this Excel Error? excel formulas excel tips excle errors pivot tables May 16, 2022
Learn how to add zeros in Excel to store your SSN, phone numbers, and other numbers that have leading zeros
How to Add Leading Zeros in Microsoft Excel Apr 26, 2022
Learn how to use Google Finance functions to get timely and accurate exchange rate data and create a currency converter worksheet
How to Change Currency in Google Sheets changing currency google finance google sheets gsheets Apr 12, 2022
Learn how to remove borders and dashes using built in tools and the substitute function in this blogpost
How to Remove Dashes in Excel exceltips exceltools removedashes substitute function Apr 12, 2022
Make sure that your spreadsheets are always optimized for speed and efficiency by removing formulas in Excel. Learn how in this blogpost.
How To Remove Formula in Excel (While Keeping the Data) copy paste exceltips formulas keyboard shortcuts Apr 07, 2022
Know how to highlight cell values in your Excel tables with or with the use of Number formatting and the Conditional Formatting tool
How to Make Negative Numbers Show Up in #Red in Excel conditional formatting exceltips number formatting tables Mar 28, 2022
Understand why the #SPILL! error occurs in Excel and know a few tips to avoid and fix them in this blog!
HOW TO CORRECT THE #SPILL ERROR IN EXCEL array functions excel formulas excel tips spill error spill functions Mar 06, 2022
Learn a few methods on how to identify, highlight, and remove duplicate values from your Microsoft Excel Spreadsheets. Some of the methods in this article also work with Google Sheets.
How to Remove Duplicates in Excel countif data duplicates exceltips remove duplicates tables Feb 27, 2022
Doing Subtraction in Excel
Doing Subtraction in Excel Feb 05, 2022
Conditional Formatting is a great basic tool to highlight data in your Excel Spreadsheets. Learn more about them in this article.
Using Conditional Formatting in Excel conditional formatting excel exceltips exceltools Jan 24, 2022
Learn how to lock cells in excel to protect your data and formulas from being overwritten
Locking Cells in Excel cell format exceltips lock cells Jan 12, 2022
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

CATEGORIES

All Categories #name? error #value! error add-ons array functions audit formulas automation bar chart benefit of excel templates calculation in excel calendar design calendar formatting calendar templates cell cell format cells changing currency circular references column chart combine worksheets compare columns compatibility comprehensive guide conditional formatting converion rate copy paste count formula countif currency currency settings customization data data analysis data analyst data cleaning data consolidation data formatting data import/export data in excel data management data organization data validation data visualization datamanipulation date format deleting formats deleting tables dependent lists developer tools drop-down lists duplicates error handling error resolution errors exact match excel excel add-ins excel calendar excel charts excel customization excel error messages excel errors excel extensions excel formulas excel function excel functions excel histograms excel index function excel influencers excel integrations excel is fun excel live training excel match function excel merging sheets excel tips excel tips and tricks excel tricks excel troubleshooting excel tutorial excel tutorials excel365 exceltips exceltools excle errors file conversion financial financial models find function footer formatting formula errors formula guide formulas freeze rows functions google finance google sheets google sheets charts graph graphs gsheets header if if function ifs and vlookup index match iserror iserror excel function keyboard shortcuts lock cells lookup macros match and index merge metrics microsoft excel microsoft forms microsoft office templates multiple columns multiple criteria navigation nested function now function number formatting pdf pdf to excel pdf to spreadsheet performance measurement pie chart pivot tables planning print settings printable spreadsheet templates printing options productivity productivity tools remove duplicates removedashes reporting reverse lookup schedule scorecard search function show changes signing an excel document spill error spill functions spreadsheet spreadsheet formulas spreadsheet management spreadsheet program spreadsheet templates spreadsheetfunctions spreadsheets statistical analysis step-by-step guide substitute function sum t-test tables text box tick boxes time management time-saving tools tips and tricks tutorial tutorials unique unprotect sheet user forms vba vlookup vlookup another sheet windows 11 windows 11 excel workbook worksheet worksheet merging xlookup xlookup multiple criteria xlookup vs index match xlookup vs vlookup youtube