Two Unique Ways to Use Excel
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,…
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…
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…
Recorded 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…
Removing Duplicates in Excel
Removing duplicate information can be both helpful and intimidating when working with many line items in Excel. Follow these steps to make the process easy : Ensure your data has…
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…
New Excel 2019 Function: MROUND
Every new version of Microsoft 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…
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…
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…
Grouping Rows in Excel
Hiding certain rows or columns in Excel can make viewing complex, detailed information easier to read. Grouping Rows in Excel allows you to quickly collapse and expand similar data to…