Excel Master

Videos on ExcelMaster

Charting

Other

Charting Tips

Pivot Table Tips

Other Tips

Consolidating Ranges with Pivot Tables

Concatenation and Formatting a few tips …

To Merge or not to Merge … aye, that is the question!

Use SOLVER to Solve Brain Teasers

Best Practice … well, no!

How do ARRAY Formulas Work?

The IFERROR(…) Function Again!

Why do ARRAY Formulas Work?

Using the Fill Tool in Excel

Rough to Smooth

From Rough Download to Smart Data

Linear Programming Chart

Setting up a Histogram

Bradford Score

Excel Book Now Published

From the Book: Summary Contents

From the Book: Who is This Book For?

From the Book: Video … the Excel Ribbon

From the Book: Video … the ToolPak Add-In

Excel Book Arrived

Comparing Ranges

Depreciation Schedules: BMW, Volvo and Porsche

PPT Presentations

Pivot Tables