|
TUTORIALS
|
Minutes
|
|
WEEK 1
|
|
|
Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?
|
31
|
|
Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations
|
9
|
|
Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF
|
22
|
|
Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
|
17
|
|
Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed
|
35
|
|
Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions
|
21
|
|
Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports
|
15
|
|
Office 2010 Class #28: Excel Number Formatting: Formatting As Façade
|
23
|
|
Office 2010 Class #29: Excel ROUND Function How And When To Use It.
|
12
|
|
Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days
|
4
|
|
Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations
|
9
|
|
|
|
|
TUTORIALS
|
TIME
|
|
WEEK 2
|
|
|
Office 2010 Class #32: Excel Percentage Number Format (6 Examples)
|
7
|
|
Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting
|
34
|
|
Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features
|
5
|
|
Office 2010 Class #35: Excel Sort and Filter (Data Analysis)
|
18
|
|
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
|
24
|
|
Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
|
6
|
|
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)
|
12
|
|
Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)
|
15
|
|
Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data
|
3
|
|
|
|
|
|
|
|
|
|
pgastaldi
tutorials1.docx
0
