TUTORIALSMinutesWEEK_1Office_2010_Class_21_Excel_Formulas_

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

blog16

Get help from top-rated tutors in any subject.