It happens all the time, you’re making your Excel template and you decide it might be better to switch the information in your rows to your columns or your columns into rows. Naturally,…
Intermediate Excel Lessons
How to Transpose Columns into Rows and Vice-Versa in Excel
Unlocking Specific Cells in a Spreadsheet
Unlocking specific cells in a spreadsheet is a very useful tool if you’re sharing files for a project or class assignment. You can save portions of your document by protecting the page and…
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…
Concatenate Function in Excel
Combining several cells and any values contained within them into one cell is easy to accomplish with the Concatenate Function. This is a trick that is quick to implement. This Excel function is…