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 >>>]

Excel Is Fun

Highline Excel 2013 Class Video 50

DESCRIPTION Topics in this video: 1. PMT function from Borrower point of view, End Payment. PMT with Begin Payment. 2. PMT function from Lender point of view. 3. PMT function with Balloon payment at end. [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 49

DESCRIPTION Topics in this video: 1. Formulas for Units, Sales, Variable Costs, Contribution Margin, Fixed Cost, Total Costs and Net Income. 2. X-Y Chart for Break Even Analysis. 3. Formulas and Chart label for Break [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 46

DESCRIPTION Topics in this video: 1. Formulas for Min and Max values 2. Formulas for Chart Labels 3. COUNTIFS formula to count between upper and lower numbers. BETWEEN Criteria. AND Criteria. 4. Histogram Chart with [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 43

DESCRIPTION Topics in this video: 1. Keyboard for chart on Active Sheet = Alt + F1 2. Keyboard for chart on New Sheet = F11 3. Set Default Chart in Excel 2013 WORKBOOKS