New Excel 2019 Function: MROUND

Every new version of Excel comes with new or updated functions. The 2019 version of Excel is no exception. One of the new functions is MROUND. MROUND is a little different than other rounding functions, as you reference a cell with a number and tell it to give you the closest multiple requested by you. … Continue reading New Excel 2019 Function: MROUND

Sorting by Multiple Columns in Excel

When working with large chunks of data, we sometimes need to sort the data to figure out where we need to focus our attention. This could mean that we need to quickly sort our data by more than one column, allowing us to make decisions on which path to take, without having to create new … Continue reading Sorting by Multiple Columns in Excel

Filter Data with Header Drop-down Filters in Excel

All too often, when we are sent data from other, it is not presented in the view we would like. Changing the way our data looks, and being able to do it quickly, can save us some time, when we use the right tools. In some cases, using a table has some advantages, while using … Continue reading Filter Data with Header Drop-down Filters in Excel

Creating Excel Templates

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old information. By using a template, your workbook is ready and waiting for you to enter data; everything else will happen automatically, when you automate your … Continue reading Creating Excel Templates

Recorded Macros vs. Coded Macros

In the world of Microsoft, macros are the way many users automate various steps of their daily processes. There are two basic types of macros, recorded and coded. Recorded macros are what most users are familiar with. as they are simple to create and simple to use.  Coded macros are less common, as require knowledge … Continue reading Recorded Macros vs. Coded Macros

Automate Excel Without Macros

Many students come to us wanting to learn how to create macros in Excel to automate their spreadsheets.  However, they often don’t realize that formulas can be used to create most of the automation they want. Although we can use macros to automate steps, there are limits to macros (especially the simplistic ones that are … Continue reading Automate Excel Without Macros

Why Excel? Two unique scenarios

When you think of Microsoft Excel what comes to mind? Accounting spreadsheets? Using formulas to calculate numbers? Generally, we think of Excel only as a system to manage our numbers, but you might be surprised by some other things that you can do with this program. We are going to look at two uses for … Continue reading Why Excel? Two unique scenarios

Missing a Mouse? Use ALT – Excel

  If you’ve ever had a mouse go bad in the middle of a project, you probably called IT to bring you a new mouse.  Or if this happened at home, you drove to the store to get a replacement. Regardless of where it happens, it is Murphy’s Law that it will happen at the … Continue reading Missing a Mouse? Use ALT – Excel

Keep Decimals Out of the Equation with Data Validations in Excel

Using Data Validations in Excel can be very helpful, as validations make sure the data is entered correctly, and ensures all the intended functionality works according to plan. One possible validation scenario is the need for all numbers to be displayed as whole numbers. Follow these steps to ensure no decimals are included during data … Continue reading Keep Decimals Out of the Equation with Data Validations in Excel

Adding Data Labels to Charts/Graphs in Excel

After adding a chart or graph to your Excel workbook, some items may need labeling, in order for management to see details about the data. This is different than a Legend, as that can be added differently to the chart or graph. There are three ways to add or change Data Labels in Excel, and … Continue reading Adding Data Labels to Charts/Graphs in Excel