Blog Articles: Excel and Google Sheets

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 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'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...

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'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...

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...

Excel offers several options to find the average of a range of numbers. You could use a formula to do this, but you can also use the AVERAGE function. This is a list of the various tutorials related to using the AVERAGE function. You can use these to learn the...

Although Excel allows you to copy and paste data, this doesn't make sense with a large dataset or certain formats. Instead, you can import or export data much more quickly.  Here, you will learn some of the operations related to importing and exporting data in Excel as well as troubleshooting...

It can be frustrating when your Excel spreadsheet doesn't act the way you expect. This can often happen when you are working with formulas, where you might get a series of errors. One of the most common errors in Excel related to formulas is the #REF! error. Here is why...

There are many ways to work with filenames in Excel. You might need to make changes to the worksheet name or format, or want to name or rename other files using Excel. This piece will give you some guidelines and shortcuts for common tasks that involve Excel filenames.  Changing Excel...