Excel Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles and videos.

Stacked Column Chart - BAD CHART

Charts & Dashboards, Finance, Formulas, Modeling

Stacked Column Bar Chart Alternatives – Find the Missing Trends

May 23, 2013

Comparative Distribution XY Scatter Chart

Charts & Dashboards

Comparative Distribution Chart – Histogram or Box Plot Alternative

May 20, 2013

Tiered Rate Structure Table - SUMPRODUCT Formula

Finance, Formulas, Modeling

Excel Formula to Calculate Commissions with Tiered Rate Structure

May 15, 2013

Absolute Reference in Structured Reference Formula

Tables & Data, Tips, Tips & Shortcuts

Absolute Structured References in Excel Table Formulas

May 8, 2013

Number Stored as Text Error

Keyboard Shortcuts, Tips, Tips & Shortcuts

Convert Text to Numbers – Excel Keyboard Shortcuts

May 6, 2013

Add Zoom Button to Excel Charts

Charts & Dashboards, Macros & VBA, Tools

Zoom on Excel Charts

April 7, 2013

Macros & VBA, Tools

Find All VBA Form for Excel

March 26, 2013

Excel 2007 Table Colors Converted Earlier Version

Tools

Excel’s Color Palette Compatibility Issue & Solution

January 28, 2010

Tools

Format Multiple Excel Worksheets in Multiple Workbooks

December 9, 2009