Excel – VLookups and HLookups
One of the most requested training topics we receive is in how to create a V or H Lookup formula. There are multiple uses for them. You can use one […]
Excel – VLookups and HLookups Read Post »
One of the most requested training topics we receive is in how to create a V or H Lookup formula. There are multiple uses for them. You can use one […]
Excel – VLookups and HLookups Read Post »
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,
Two Unique Ways to Use Excel Read Post »
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
Automate Excel Without Macros Read Post »
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
Keep Decimals Out of the Equation with Data Validations in Excel Read Post »
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
Recorded vs Coded Macros Read Post »
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
Removing Duplicates in Excel Read Post »
All too often, when we are sent data from someone, it is not presented in the view we would like. Changing the way our data looks, and being able to
Filter Data with Header Drop-Down Filters in Excel Read Post »
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
New Excel 2019 Function: MROUND Read Post »
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
Sorting by Multiple Columns in Excel Read Post »
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
Creating Excel Templates Read Post »