It may seem like a simple concept, but having the ability to quickly look up the number of times a certain word appears in your document is a big plus in many different…
Advanced Excel Lessons
Find Number of Words in a String Template
Copy Data to Single Column Template
Macros are powerful tools within Excel and can be used to make your life much easier. Who doesn’t love when the template knows what you need and calculates totals automatically for you. You…
Convert to Proper Case
Making your document look professional and wonderful is all part of the job. Maybe you know the sting if getting through hundreds of pieces of data before you realize you didn’t properly format…
How to Use the ROUND Function in Excel
The ROUND Function is the best way to get your data looking just the way you want it. This simple formula takes any decimal figures and simply rounds that number, or number set,…
Goal Seek Function in Excel
The Goal Seek Function is the bread and butter of any industry using Excel to keep track of their yearly sales. For example, if you own a Redbox dispensing machine and you want…
How to Make a Gauge Chart in Excel
Creating a Gauge Chart in Excel is a nice way to step up your project tracking game and have an effective way to analyze important information at a glance. A Gauge Chart or…