Subscribe to Myriad of Ideas via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,096 other subscribers

Most Shared Posts

    Video Tutorial Podcast – Pivot Tables are not that Hard!

    Title: Video Tutorial Podcast – Pivot Tables are not that Hard!

    Date: 5/10/2013



    I used Excel 2013 and some of my Google Analytics to show how you can quickly summarize data into a presentable format. Take a look, I’ll show you how to “fish” with Pivot Tables! Have a good one! And please […]

    Ever wonder how to filter data?


    Today’s video tutorial is how to filter on data within Excel. I’ll show some do’s and don’ts, as well as how you can leverage a filter to your advantage. It’s simple, so sit back and relax.

    Have a good day!





    Example 3 – The VLOOKUP

    A quick 14 minute Tutorial on how to use VLOOKUPs and how to get around the “bumps” in the road.

    You can watch this Full Screen and at the HD setting (to make it more clear), just change your settings on the Video player.



    Hard Returns – Don’t Do it

    If you ever enter data into a database or spreadsheet do not do a hard-return (aka carriage return). If you are entering data and hit “alt-Enter” you are creating hard-returns. Instead use the formatting function of “wrap text” to make your spreadsheet “pretty”.