Blog Articles: Excel and Google Sheets

All resources related to Blog for Excel and Google Sheets.

Blog

Learn How to Work With Images in Excel
When you think of Excel, you might only picture a spreadsheet full of data. But, the program has the ability to represent information in a variety of ways. One thing you can do is add images to Excel to make the data more meaningful.  This guide explains the various ways...
The ##### Excel Error – How to Locate and Fix the ##### Error in Excel
It can be disturbing when you are working in Excel and come across an error that you either don't know how to define or resolve. There are several common types of errors, and one of them is a row of number, pound or hashtags that looks like this: #####. We'll...
Excel Pivot Table Examples – Pivot Table Tutorial, Create Pivot Table, Pivot Table Columns
Pivot tables are powerful tools in Excel that allow you to quickly summarize a set of data into a more meaningful table or report. In short, this is a summary of your larger set of data, and a pivot table does nothing to change the underlying figures.  Whether you want...
Excel COUNTIF Function Examples – COUNTIF Greater Than, COUNTIF Multiple Criteria
Excel's COUNTIF function is used to count cells in a selected range that meet a single criterion. It can be used to count cells with numbers, texts, and dates that match your specifications. The function supports a variety of operators as well as partial matches and wildcards.  Whether you want...
The #VALUE Excel Error – How to Find and Fix #VALUE Errors in Excel
The #VALUE error in Excel is an incredibly general error that usually signals something isn't right with a formula or function. Whether you are working with a simple calculation or complex formulas, there's a good chance that you'll run into this error at some point.  This guide will not only...
Brad Edgar Shares the Power of Problem-Solving with Excel
Brad Edgar started helping colleagues with Excel and quickly realized he had an aptitude for the product. That led him to start bradedgar.com, offering Excel products — including dashboards for $5 — resources and tutorials. He also has a popular YouTube channel with dozens of learn-it-yourself videos. He spoke with...
Excel VLOOKUP Function Examples – VLOOKUP Tutorial, VLOOKUP Between Sheets
Excel's VLOOKUP function provides you with a simple way to lookup and pull data from a range or table. There are many things you can do with VLOOKUP, including combining it with other functions. This is a list of the various VLOOKUP tutorials that you can reference on Excelchat to...
The Ultimate Guide to Working With URLs in Excel
When working with Excel spreadsheets and data, you might want to reference outside resources. You do this by simply naming another file or location, but it makes much more sense to create a "link" within your spreadsheet.  This guide explains the various ways that you can insert and manipulate URLs...
Excel IF Function Examples – IF THEN, IF with Multiple Criteria, IF ELSE
Excel's IF function allows you to perform a logical test on your data and return one value if the result is TRUE and another if it is FALSE. There are a variety of ways to use the IF function, some more complex than others. This is a list of the...
The #NAME Excel Error – How to Find and Fix #NAME Errors in Excel
Excel functions such as AVERAGE, COUNTIF, and SUM are a useful way of shortcutting calculations, but that doesn't mean that you won't run into troubles. In fact, there are many types of errors that can pop up in Excel, and a common one is the #NAME? error. Here is why...
1 2 3 4