Top 5 Data Skills You Need to Learn in 2019
Think about it. We have 26 letters in the alphabet and 10 basic numerical digits. Yet, somehow it all combines to generate more than 2.5 quintillion bytes of da...
Tag: Excel
How to Analyze Data for Your Business
5 Tools Entrepreneurs Need to Analyze Data There are a few great options for free and some that are paid. I'll cover these 4 tools for now: Excel Tableau...
What Data Technology Should I Learn?
From my recent live broadcast, in this video I cover the following topics: Background on Data Industry Key Technologies in Data Data Personas Who Should Learn W...
Never See Errors Again in Excel
We've already looked at how to use VLookup to return a corresponding value from another sheet here (VLookup Basics). Now we're going to expand upon that and add...
Keyboard Settings for Excel via VMFusion
Ever have problems using your standard keyboard shortcuts in Excel when running it on a Mac in VMFusion? Me too… So, after some digging and testing I foun...
Excel Tip – Hacking Excel Web Queries
If you are unfamiliar with web queries its OK, their easy, and I’m gonna explain how they work and how to manipulate them beyond their intended use to increase ...
Democratizing Business Intelligence using Gemini
If you've not heard of Gemini yet you're in for a treat. I found these videos on youtube yesterday of the Gemini demo from the BI conference last year that you ...
Building a Project Timeline in MS Excel
Below is a recent screencast I recorded showing how to build a project timeline (gannt chart style) using MS Excel. It's simple and easy and works great for por...
Excel Tip – Defaulting to Non-Compatibility Mode
I was recently fighting with Excel because I was sick of it wanting to run in Compatibility Mode by default. Everything I found out there said that you simply n...
Excel Tip: Identifying the max length of values in a column
Sometimes files are received such as client feeds that contain values in columns that exceed the maximum number of characters allowed in the destination databas...