THE RIBBON

The Developer Tab

The Developer Tab contains a variety of tools that allow you to customize Excel. Of particular importance is the fact that the Developer tab contains tools that allow you to create, access and edit macros. [Read More >>>]

Excel Topics

Recover Workbooks Using Versions

The Versions feature in Excel 2013 is a very useful tool as it can recover previous versions of a workbook if for example any of these situations occur. Your computer crashes. There’s a power cut. [Read More >>>]

Excel Topics

Quick Analysis Tool

The Quick Analysis Tool brings the most commonly used formatting, charting and summary tools into one convenient location. The tool allows you to quickly create an Excel table or Pivot Table, create a new chart, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1480

DESCRIPTION In this video learn how to do a two-way lookup to get the correct Price based on Quantity Discount & Product Name. Learn how to use the VLOOKUP and MATCH Functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1479

DESCRIPTION In this video learn the Basics of VLOOKUP to looks up a price based on a Bulk Quantity Discount. Also learn about the MATCH Function to automatically pick out the correct Column Number for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1478

DESCRIPTION In this video learn how to use Conditional Formatting to format the row in a data set and how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver [Read More >>>]

Excel Is Fun

Excel Magic Trick 1477

DESCRIPTION In this video learn how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver a TRUE when the Event Key is a Duplicate AND the Task Column equals [Read More >>>]