Excel

From TSG Library of Knowledge

Contents 1 The Basics 2 Basic Formulas 3 Advanced Formulas 4 VBA / Macros 4.1 Range Object 4.2 Loops 5 Class Modules

The Basics

Basic Formulas

IF Statement

Relative and Absolute Referencing

Average

Sum

IsError

Advanced Formulas

vlookup

VBA / Macros

Range Object

Static Range

.End Ranges

Loops

Loops are used to sequentially loop through a sequence such as a range, a counter, or something else.

For Loop

Do While Loop

Class Modules