Excel Is Fun

Highline Excel 2013 Class Video 51

September 1, 2017 0

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: […]

Excel Is Fun

Highline Excel 2013 Class Video 50

August 25, 2017 0

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. […]

Excel Is Fun

Highline Excel 2013 Class Video 49

August 18, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 48

August 11, 2017 0

DESCRIPTION Topics in this video: 1. Conditional Formatting: Bar Chart with Data Labels 2. Formula to Define length of Bar WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 46

July 28, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 45

July 21, 2017 0

DESCRIPTION Topics in this video: 1. Add Data To Chart with Select Data Button 2. Add Secondary Axis 3. Change Chart Type For Series Values 4. 1 click Combining Chart Types in Excel 2013 5. […]

Excel Is Fun

Highline Excel 2013 Class Video 43

July 7, 2017 0

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