1
Slaying Excel Dragons Book #1: How Excel Is Set Up, Customize Ribbon and Toolbar
7:55
2013-01-28
2
Slaying Excel Dragons Book #2: Excel 2010 Keyboard Shortcuts Are Fast!
21:53
2013-01-29
3
Slaying Excel Dragons Book #3: Data Into Information: SUMIFS, PivotTable, Verifying Formulas & Data
20:27
2013-01-30
4
Slaying Excel Dragons Book #4: Table Format Structure For Raw Data & Data Analysis
5:54
2013-01-31
5
Slaying Excel Dragons Book #5: Excel Table Feature (Excel as Database)
18:28
2013-02-01
6
Slaying Excel Dragons Book #6: Number Formatting As Façade: Decimal, Date, Time, Percentage
32:56
2013-02-02
7
Slaying Excel Dragons Book #7: Excel Data Alignment: Pitfalls & Advantageous Tricks
15:01
2013-02-02
8
Slaying Excel Dragons Book #8: Excel Stylistic Formatting
21:06
2013-02-04
9
Slaying Excel Dragons Book #9: Excel Page Setup For Reports Large or Small
20:42
2013-02-05
10
Slaying Excel Dragons Book #10: Excel Cell Styles and Table Styles
8:29
2013-02-06
11
Slaying Excel Dragons Book #11: Comprehensive Excel Formula Creation Guide (Formula Types, Elements)
38:54
2013-02-06
12
Slaying Excel Dragons Book #12: How Excel Formulas Are Evaluated Order of Operations Excel Formulas
17:11
2013-02-09
13
Slaying Excel Dragons Book #13: Putting Cell References In Formulas (3 Methods)
7:29
2013-02-09
14
Slaying Excel Dragons Book #14 Percentage Increase Or Decrease Formulas
6:31
2013-02-09
15
Slaying Excel Dragons Book #15: Cell References in Formulas: Relative, Absolute, Mixed
40:12
2013-02-11
16
Slaying Excel Dragons Book # 16: Relative, Absolute, Mixed Cell Ranges & Adding With Two Criteria
12:42
2013-02-12
17
Slaying Excel Dragons Book #17: Mixed Cell References & Orientation of Formula Inputs
9:01
2013-02-13
18
Slaying Excel Dragons Book #18: What If and Scenario Analysis in Excel
6:55
2013-02-14
19
Slaying Excel Dragons Book #19: Worksheet, Workbook 3-D Cell References, Arrange All Feature
21:45
2013-02-15
20
Slaying Excel Dragons Book #20: Efficient Use Of Cell Ranges in Formulas. Insert Row, Range Updates.
4:12
2013-02-15
21
Slaying Excel Dragons Book #21: Benefits of Insert Function Dialog Box. FV Function Example
10:22
2013-02-15
22
Slaying Excel Dragons Book #22: Averaging without Zeros AVERAGEIF function or Replace Feature
7:29
2013-02-20
23
Slaying Excel Dragons Book #23: PMT Function For Loan Payment
5:55
2013-02-20
24
Slaying Excel Dragons Book #24: Defined Names, Create Names From Selection & Name Manager
9:09
2013-02-20
25
Slaying Excel Dragons Book #25: AND and OR Criteria For Adding, Counting, and Averaging Formulas
24:46
2013-02-20
26
Slaying Excel Dragons Book #26: SUMPRODUCT Function (12 Examples)
43:08
2013-02-24
27
Slaying Excel Dragons Book #27 IF function (12 Examples), AND OR functions, Nesting IFs
33:55
2013-02-24
28
Slaying Excel Dragons Book #28: VLOOKUP Function & Data Validation Dropdown List (11 Examples)
36:13
2013-02-26
29
Slaying Excel Dragons Book #29: MATCH Function To Compare Two Lists, Tables or Databases
7:40
2013-02-27
30
Slaying Excel Dragons Book #30: INDEX & MATCH Function For Unusual Lookup Situations (10 Examples)
36:32
2013-02-28
31
Slaying Excel Dragons Book #31: ROUND Function -- When & How To Use ROUND
8:15
2013-03-03
32
Slaying Excel Dragons Book #32: 3 Types Of Averages AVERAGE, MEDIAN, MODE, COUNTIF Functions
9:04
2013-03-03
33
Slaying Excel Dragons Book #33: RANK Functions & Excel 2010 Compatibility Functions RANK.AVE RANK.EQ
5:27
2013-03-04
34
Slaying Excel Dragons Book #34: Goal Seek What If Analysis
2:24
2013-03-05
35
Slaying Excel Dragons Book #35: Basic Array Formulas & Functions
29:24
2013-03-06
36
Slaying Excel Dragons Book #36: Custom Number Format & the TEXT function
29:17
2013-03-06
37
Slaying Excel Dragons Book #37: Sort Sorting in Excel, Data Analysis (Sorting 20 Examples)
23:31
2013-03-09
38
Slaying Excel Dragons Book #38: Data Analysis Subtotal Feature (9 Examples)
17:46
2013-03-11
39
Slaying Excel Dragons Book #39: Data Analysis Pivot Tables & Pivot Charts, PivotTables & PivotCharts
19:34
2013-03-12
40
Slaying Excel Dragons Book #40: Grouping Dates in PivotTables: Years, Months or Weeks, and more
11:46
2013-03-14
41
Slaying Excel Dragons Book #41: Blanks (Empty Cells) or Text in Number Fields PivotTable Trouble
5:08
2013-03-18
42
Slaying Excel Dragons Book #42: PivotTable Slicers, Report Filter & Show Report Filter Pages
11:44
2013-03-19
43
Slaying Excel Dragons Book #43: 5 Special PivotTables -- Changing Functions and Calculations
15:55
2013-03-21
44
Slaying Excel Dragons Book #44; Data Analysis Filter Feature: Extract Data Based on Criteria
17:55
2013-03-24
45
Slaying Excel Dragons Book #45: PivotTables Treat Integer & Decimal Numbers Differently inGrouping
7:48
2013-03-26
46
Slaying Excel Dragons Book # 46: Advanced Filter For Extracting Records From Data Set (12 Examples)
33:26
2013-03-27
47
Slaying Excel Dragons Book # 47: Text To Columns Last Name First Name & Address
10:41
2013-03-29
48
Slaying Excel Dragons Book # 48: Importing Data Into Excel From Excel, Text File, Access, Web Query
12:24
2013-03-29
49
Slaying Excel Dragons Book #49: Complete Lessons On Excel Charts (26 Examples)
46:09
2013-03-29
50
Slaying Excel Dragons Book #50: Conditional Formatting (12 Examples)
28:30
2013-04-02
51
Slaying Excel Dragons Book #51: Find and Replace & Go To Special
5:52
2013-04-05
52
Slaying Excel Dragons Book #52: Recorded Macros
28:06
2013-04-08
53
Slaying Excel Dragons Book #53: Defined Name Formula Dynamic Ranges For Charts and Array Formulas
45:19
2013-04-10