Business Analytics

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

How to Divide in Excel: It’s Easier Than You Think

5 min read Jan 2014

How to Alphabetize in Excel: A Guide to Organized and Efficient Lists

5 min read Jan 2014

The Excel LOOKUP Function: Power to Search your Spreadsheets

8 min read Jan 2014

Excel Advanced Filter: Complex Criteria Made Easy

5 min read Dec 2013

Excel Drop Down List 2010: Stop, Drop and Scroll

4 min read Dec 2013

Excel 2010 Pivot Tables: Introduction to Tables, Fields, and Filters

4 min read Dec 2013

Excel Goal Seek – What it Does, and How to Use It

5 min read Dec 2013

The Excel “Not Equal” Operator: How to Auto-Filter Data

5 min read Dec 2013

Best Excel Add-Ins: What you Don’t Know About Excel That Will Improve Your Productivity

4 min read Dec 2013

Excel Subtotal Function: What It Is and How It can Save You Time

9 min read Nov 2013

Find Duplicates in Excel: Remove the doubles from your Database

10 min read Nov 2013

Excel Tutorial: An In-Depth Guide to Working with your Data, Building Formulas, and Using Functions

22 min read Nov 2013

Excel Indirect Functions: How They Work and What They Are There For

5 min read Oct 2013

ANOVA in Excel: A Walkthrough of Excel’s Variance Analysis Tool

4 min read Oct 2013

T Test Excel: Make your Analysis as Simple as It Can Be

4 min read Oct 2013

How To Use Microsoft Access For Your Small Business

3 min read Jun 2013