How to Navigate the Excel 2016 User Interface On Windows

How to Navigate the Excel 2016 for Windows UI Twitter

In this blog post, I’ll provide you with a brief introduction to the Excel 2016 User Interface. Once you’re done, you’ll be able to hit the ground running and navigate the Excel User Interface without wasting too much time. For Mac users, please click here to see a version of this blog post specifically for…

Continue Reading →

How to Create a Dynamic Named Range

How many times have you wanted to add things to a list in Excel without needing to change formulas or update cell references? Named Ranges are excellent for this because they allow you to define a specific name for your range of cells and then reference the name throughout your spreadsheet. If you want to add values to your named range, all you have to do is go into the Name Manager dialogue (Windows) or the Define Name dialogue (Mac) and update the reference to your range of cells once. However, what if you could add values to your named range, and the reference to your range of cells was updated automatically without going into the Name Manager dialogue (Windows) or the Define Name dialogue (Mac)? This is where Dynamic Named Ranges come in.

In this blog post, we are going to look at how to create and use Dynamic Named Ranges. There are several ways to create dynamic Named Ranges, but in this blog post, we look at a method that uses the OFFSET and COUNT, or COUNTA functions. Will also look at how to use Dynamic Named Ranges with drop-down menus.

Continue Reading →

How to Control User Input Using Data Validation Part 2

In this second part of a two-part series of blog posts on Excel Data Validation, we are going to look at how to control data input by users using the whole numbers, decimal, date, time, and text length Data Validation options. We’ll also look at how you can set minimum and maximum limits on the values input by users.

Continue Reading →

How to Control User Input Using Data Validation Part 1

How to control User Input Using Data Validatio Part 1 Feature Image

In this first blog post, in a two-part series of blog posts on Data Validation, we are going to look at how to control data input by a user using the Data Validation list feature. Data Validation limits the type of data that someone can enter into a cell. We’ll also look at how to display an Input Message when a user clicks into a cell, and how to display Error Alerts if a user tries to input incorrect values.

Continue Reading →

How to Use VLOOKUP and MATCH Functions to Perform a Two-Way Lookup

In this blog post, we will look at how to use the VLOOKUP and MATCH functions to perform a two-way lookup, sometimes referred to as a matrix lookup. This blog includes a quick refresher on the VLOOKUP and MATCH functions, but I’m going to assume that you are aware of both these functions.

Continue Reading →

Page 1 of 7