by John MacDougall | Mar 24, 2017 | Formulas
In a previous post I showed How To Turn A Table Into A Column Using Formulas, and in this post we’re going to explore how to do the inverse action and turn a column into a table. Get The Completed Workbook You could do this in a number of different ways...
by John MacDougall | Mar 18, 2017 | Tips
Get The Workbook While entering or editing data in Excel it is possible to add line breaks in the cell using Alt + Enter. This can be a convenient way to display data in Excel, but is often not great for any type of data analysis. For example, it might be more...
by John MacDougall | Mar 12, 2017 | Templates
Download Example Files While learning new functions or exploring new features like pivot tables or charts, it’s always good to have some data handy to use. Here is some random sales data for 2016 to help in your learning. What’s in the data? Sales...
by John MacDougall | Mar 9, 2017 | Templates
Download Example Files Next time your company has a social or fundraising bingo event breakout this Excel Bingo template on the projector to call out the bingo game. This bingo template features a Next button, which randomly selects the next number from the remaining...
by John MacDougall | Mar 8, 2017 | Formulas
Get The Completed Workbook If you work in finance and most other fields, it probably happens a lot that you need to know what calendar quarter a date falls under. Unfortunately there is no Excel function available to return this information based on a given date....