Title: Video Tutorial Podcast – Pivot Tables are not that Hard!
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 […]
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!
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.
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”.