Excel VBA

Excel VBA 1.1

Step 1: Open a Workbook Step 2 Option A: Press  Alt  +  F11 This is the standard shortcut to open the VBE. Step 2 Option B: Developer Tab –> View Code First, the Developer Tab [Read More >>>]

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 Is Fun

Office 2016 01

DESCRIPTION Topics in this video: (00:01) Introduction (00:28) Programs/Apps (application software) (02:32) Task Bar (02:56) Operating Systems (03:11) Start Button (05:23) USB Flash Drive (05:58) Introduction to Windows Explorer (09:34) Deleting a File or Folder [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 26

DESCRIPTION In this video use Macro Recorder to record six Macros: (00:12) Basics for Recorded Macros (VBA) (05:55) Absolute Reference Macro: Format report that always has the same number of columns and rows. This Macro [Read More >>>]

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 1349

DESCRIPTION See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: (00:15) Introduction including Preview of Finished Solution [Read More >>>]

Dueling Excel

Dueling Excel 009

DESCRIPTION See Mr Excel and excelisfun take a table of data and create a column of values that can be used with the Statistical Data Analysis Excel Add-in. Mr Excel uses VBA Macro code. excelisfun [Read More >>>]

Dueling Excel

Dueling Excel 007

DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses a formula with INDEX, IF, [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 51

DESCRIPTION Topics in this video: 1. Macro Basics. 2. Format Variable Height Report with Absolute and Relative References. 3. Rearrange Records from Vertical Orientation to Proper Data Set with Relative References. Copy Code from Internet: [Read More >>>]