Excel Is Fun

Excel Magic Trick 1401

DESCRIPTION See how to use the Excel 4.0 Macro Function GET.CELL & a Defined Name to create a Conditional Formatting Logical Formula to Format Row when the Date is Bold. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1355

DESCRIPTION See how to extract records from a vertical column that contains Parent Names in Bold and Children Names in “Not Bold” and display parent and children records horizontally. Learn about the GET.CELL Excel 4 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1346

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. [Read More >>>]

WORKBOOKS & WORKSHEETS

Worksheet Basics

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 [Read More >>>]

Dueling Excel

Dueling Excel 61

Formula To Report Cell Reference 5 Examples DESCRIPTION See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand [Read More >>>]