Excel Package (Beg-Int-Adv) Class

PERFORM CALCULATIONS WITH FORMULAS & AUTOSUM:

FORMATTING:

EDIT A SPREADSHEET:

CHARTS & GRAPHS:

ADVANCED FORMULAS:

3-D FORMULAS:

LINK WORKBOOKS & CONSOLIDATE DATA:

VALIDATION:

PIVOT TABLE BASICS:

GROUP / OUTLINE / SORT / FILTER / SUBTOTAL DATA:

FORMULA AUDITING:

TEMPLATES:

CONDITIONAL FORMATTING:

PASSWORD PROTECT ALL OR PART OF WORKBOOK:

FUNCTIONS:

MACROS:

WHAT-IF TOOLS:

WORKBOOKS CONTROLS (Buttons, Checkboxes):