Business Analytics

Learn more about using business data, reports, dashboards, and metrics to understand performance and guide decisions.

Learning VBA – Makes You Smarter

4 min read Jun 2014

Interpretation of Data: The Basics

4 min read May 2014

SQL Decode – Evaluating Expressions and Conditions on a Case-By-Case Basis

6 min read May 2014

SQL Sum: Adding Up All Your Values

5 min read May 2014

KPI Dashboard Creation in Excel: How to Wow Your Boss

6 min read May 2014

Create a Pie Chart: It’s Easy As – You Guessed It – Pie

6 min read May 2014

SQL SELECT UNIQUE : Searching for Distinct Values

5 min read May 2014

Six Sigma Tools – Quality Tools to Improve Business

5 min read Apr 2014

Confidence Interval Function in Excel

4 min read Apr 2014

Linear Regression Example in Excel For Everyday Life

4 min read Mar 2014

Google Spreadsheet Functions: Top 5 You Should Know How to Use

5 min read Mar 2014

Excel VBA Autofilter: How to Use Filters to Highlight Your Data

5 min read Mar 2014

Excel Diff: Easy Ways to Find (and Highlight) Data Set Differences

5 min read Feb 2014

Excel OR: How to Use Logical Functions in Excel

5 min read Feb 2014

New Line in Excel Cell: Doing It Right

5 min read Feb 2014

“Too Many Different Cell Formats” in Microsoft Excel: Causes and Fixes

5 min read Feb 2014