Posts Categorized: Tips

Excel 104: Pivot Tables on Mac and PC [Video]

Excel 104: Pivot Tables on Mac and PC [Video]

My first impression of a Pivot Table: They are scary, confusing monsters that always make your data look funky. Once I got over the intimidation of them: They are the magical, unicorn warriors of the Excel world. The main thing that Pivot Tables do is … pivot … your data. Just like you would while trying to… Read more »

Focus on the Outstanding: Write Less and Write Better

Little Hero

There is so much content being cranked out it is really impossible to read it all. I notice that much of the content appears to be calculated topics that I think are chosen strictly with the goal to bring in traffic. From what I see most of those articles have the same basic information I have… Read more »

101 Wednesday Recap: Basic Formulas in Excel

101 Wednesday Recap: Basic Formulas in Excel

Formulas in Excel are basically the keyboard shortcuts of any program. They make operating through large data dumps 10x faster. Do you spend time copying and pasting over and over to combine or look up data? Then this tutorial will be the start of lots of time saved. You’ll be pony status at the end… Read more »

Excel 103: How to Do Annotating in Excel

Excel 103: How to Do Annotating in Excel

Reports should be concise, clear, and pretty. One big way to help your reports be more clear is to label them clearly. Some simple tricks like adding a comment box next to a chart can really help draw in the untrained-data-eye. This is especially important when you have CEOs who hate looking at spreadsheets and… Read more »