Advanced Excel
| Session 1: | Introduction | 0:25:57 |
|---|---|---|
| 1.01 | Introduction | 0:00:55 |
| 1.02 | Interface | 0:03:30 |
| 1.03 | Tabs and Ribbons | 0:02:30 |
| 1.04 | Document Windows | 0:11:50 |
| 1.05 | Navigation Tips | 0:04:59 |
| 1.06 | Office Button and Save | 0:02:13 |
| Session 2: | Entering, Editing and Formatting Data | 0:40:31 |
| 2.01 | Introduction | 0:01:31 |
| 2.02 | Entering Data | 0:02:58 |
| 2.03 | Fonts, Fills, and Alignment | 0:06:59 |
| 2.04 | Cut, Copy, and Paste | 0:06:01 |
| 2.05 | Paste Special | 0:05:18 |
| 2.06 | Undo and Redo | 0:02:45 |
| 2.07 | Moving, Finding, and Replacing a Value | 0:07:50 |
| 2.08 | Cell Styles | 0:04:17 |
| 2.09 | Comments | 0:02:52 |
| Session 3: | Formatting Numbers | 0:17:04 |
| 3.01 | Introduction | 0:01:00 |
| 3.02 | Currency Format | 0:03:11 |
| 3.03 | Format Painter | 0:03:15 |
| 3.04 | Formatting Dates | 0:03:30 |
| 3.05 | Custom and Special Formats | 0:06:08 |
| Session 4: | Managing Worksheets | 0:16:42 |
| 4.01 | Introduction | 0:01:25 |
| 4.02 | Naming and Moving Worksheets | 0:03:26 |
| 4.03 | Copying Worksheets | 0:02:37 |
| 4.04 | Adding, Deleting and Hiding Worksheets | 0:02:43 |
| 4.05 | Grouping Worksheets | 0:02:40 |
| 4.06 | Moving, Copying, Deleting and Hiding Grouped Worksheets | 0:03:51 |
| Session 5: | Modifying Rows and Columns | 0:18:09 |
| 5.01 | Introduction | 0:01:13 |
| 5.02 | Inserting and Deleting Columns and Rows | 0:04:17 |
| 5.03 | Inserting & Deleting Cells | 0:03:01 |
| 5.04 | Inserting Multiple Columns & Rows | 0:02:03 |
| 5.05 | Modifying Cell Width and Height | 0:05:44 |
| 5.06 | Hiding and Unhiding Rows and Columns | 0:01:51 |
| Session 6: | Understanding Formulas | 0:32:49 |
| 6.01 | Introduction | 0:01:31 |
| 6.02 | Using Operations | 0:03:11 |
| 6.03 | Creating Formulas | 0:04:27 |
| 6.04 | AutoSum | 0:03:40 |
| 6.05 | Common Formulas | 0:04:48 |
| 6.06 | Searching for Formulas | 0:03:52 |
| 6.07 | Copying Formulas | 0:03:01 |
| 6.08 | Using Relative and Absolute References | 0:08:19 |
| Session 7: | Changing Views | 0:28:40 |
| 7.01 | Introduction | 0:01:47 |
| 7.02 | Workbook Views | 0:05:13 |
| 7.03 | Show/Hide | 0:02:00 |
| 7.04 | Zoom Features | 0:02:34 |
| 7.05 | Freeze Panes | 0:03:21 |
| 7.06 | Split Windows | 0:01:49 |
| 7.07 | Viewing Multiple Windows | 0:05:05 |
| 7.08 | Minimize The Ribbon | 0:01:01 |
| 7.09 | Worksheet Backgrounds | 0:01:44 |
| 7.10 | Watermarks | 0:04:06 |
| Session 8: | AutoFill and Custom Lists | 0:14:20 |
| 8.01 | Introduction | 0:01:30 |
| 8.02 | AutoFill a Series | 0:03:28 |
| 8.03 | AutoFill Non-Adjacent Cells | 0:02:09 |
| 8.04 | AutoFill on Multiple Sheets | 0:01:39 |
| 8.05 | Creating Custom Lists | 0:04:05 |
| 8.06 | Series Formatting | 0:01:29 |
| Session 9: | Conditional Formatting | 0:12:29 |
| 9.01 | Introduction | 0:01:02 |
| 9.02 | Highlight Cells Rules | 0:02:41 |
| 9.03 | Top/Bottom Rules | 0:02:34 |
| 9.04 | Data Bars | 0:01:19 |
| 9.05 | Color Scales | 0:01:39 |
| 9.06 | Custom Formatting Rule | 0:03:14 |
| Session 10: | Tables | 0:14:24 |
| 10.01 | Introduction | 0:01:03 |
| 10.02 | Insert a Table and Style Options | 0:03:29 |
| 10.03 | Add Rows and Columns | 0:02:39 |
| 10.04 | Perform a Function in a Table | 0:04:18 |
| 10.05 | Summarise With Pivot Table | 0:02:58 |
| Session 11: | Data Tools | 0:27:25 |
| 11.01 | Introduction | 0:01:38 |
| 11.02 | Data Validation | 0:06:27 |
| 11.03 | Drop-Down Lists | 0:04:04 |
| 11.04 | Removing Duplicates | 0:02:35 |
| 11.05 | Text To Columns | 0:04:19 |
| 11.06 | Goal Seek | 0:03:43 |
| 11.07 | Scenario Manager | 0:04:38 |
| Session 12: | Referencing Formulas | 0:16:04 |
| 12.01 | Introduction | 0:01:53 |
| 12.02 | Multiple Sheet References | 0:01:37 |
| 12.03 | Consolidating Data - With or Without Links | 0:06:37 |
| 12.04 | Trace the Precedents and Dependents | 0:03:10 |
| 12.05 | Using the Watch Window | 0:02:47 |
| Session 13: | Ranges and Dates | 0:14:55 |
| 13.01 | Introduction | 0:01:11 |
| 13.02 | Cell Names | 0:04:21 |
| 13.03 | Named Ranges | 0:01:44 |
| 13.04 | Formulas with Cell Names | 0:02:17 |
| 13.05 | Date Formulas | 0:05:22 |
| Session 14: | Lookups | 0:22:32 |
| 14.01 | Introduction | 0:01:27 |
| 14.02 | VLOOKUP | 0:06:20 |
| 14.03 | VLOOKUP Exact Match | 0:09:17 |
| 14.04 | HLOOKUP | 0:03:52 |
| 14.05 | HLOOKUP Exact Match | 0:01:36 |
| Session 15: | Conditional Logic | 0:40:37 |
| 15.01 | Introduction | 0:01:14 |
| 15.02 | IF Statement | 0:07:43 |
| 15.03 | Nested IF | 0:04:21 |
| 15.04 | AND | 0:02:10 |
| 15.05 | OR | 0:01:57 |
| 15.06 | NOT | 0:01:41 |
| 15.07 | IFERROR | 0:03:13 |
| 15.08 | SUMIF | 0:02:21 |
| 15.09 | AVERAGEIF | 0:01:06 |
| 15.10 | COUNTIF & COUNTIFS | 0:09:46 |
| 15.11 | SUMIFS | 0:02:44 |
| 15.12 | AVERAGEIFS | 0:02:21 |
| Session 16: | Text Formulas | 0:09:35 |
| 16.01 | Introduction | 0:01:30 |
| 16.02 | Case Formulas | 0:01:41 |
| 16.03 | Fix Number Fields | 0:02:47 |
| 16.04 | Trim Spaces | 0:01:23 |
| 16.05 | Substitute Text | 0:02:14 |
| Session 17: | Introduction to Charts | 0:21:00 |
| 17.01 | Introduction | 0:00:50 |
| 17.02 | Chart Types | 0:02:01 |
| 17.03 | Instant Chart | 0:01:33 |
| 17.04 | Update Chart | 0:02:56 |
| 17.05 | Column Chart | 0:03:47 |
| 17.06 | Picture Fill | 0:02:21 |
| 17.07 | Adjust Chart Size | 0:02:44 |
| 17.08 | Line Chart | 0:02:43 |
| 17.09 | Scatter Chart | 0:02:05 |
| Session 18: | Formatting Charts | 0:23:53 |
| 18.01 | Introduction | 0:01:05 |
| 18.02 | Chart Styles | 0:02:26 |
| 18.03 | Chart Layouts | 0:03:39 |
| 18.04 | Add Labels | 0:03:28 |
| 18.05 | Axis Options | 0:03:40 |
| 18.06 | Chart Title | 0:03:40 |
| 18.07 | Legends | 0:02:15 |
| 18.08 | Data Labels | 0:03:40 |
| Session 19: | Adding Graphics to Spreadsheets | 0:26:57 |
| 19.01 | Introduction | 0:01:07 |
| 19.02 | Insert Pictures | 0:02:36 |
| 19.03 | Modifying Pictures | 0:03:44 |
| 19.04 | Insert Shapes | 0:04:01 |
| 19.05 | Insert SmartArt | 0:05:11 |
| 19.06 | Apply Themes | 0:03:42 |
| 19.07 | Arrange | 0:06:36 |
| Session 20: | Outline, Sort, Filter, and Subtotal | 0:26:33 |
| 20.01 | Introduction | 0:00:57 |
| 20.02 | Group and Ungroup | 0:03:05 |
| 20.03 | Sort Data | 0:01:52 |
| 20.04 | Sort Multiple Levels | 0:02:37 |
| 20.05 | Filter Data | 0:03:18 |
| 20.06 | Advanced Filter | 0:05:41 |
| 20.07 | Conditional Sorting and Filtering | 0:01:47 |
| 20.08 | Sorting with Custom Lists | 0:02:54 |
| 20.09 | Subtotal | 0:04:22 |
| Session 21: | PivotTables | 0:19:30 |
| 21.01 | Introduction | 0:01:14 |
| 21.02 | Creating PivotTables | 0:02:48 |
| 21.03 | Choosing Fields | 0:04:07 |
| 21.04 | PivotTable Layout | 0:03:29 |
| 21.05 | Filtering PivotTables | 0:02:04 |
| 21.06 | Modifying PivotTable Data | 0:02:10 |
| 21.07 | PivotCharts | 0:03:38 |
| Session 22: | Protecting Data | 0:11:28 |
| 22.01 | Introduction | 0:00:40 |
| 22.02 | Workbook Passwords | 0:03:40 |
| 22.03 | Protecting Workbooks | 0:03:08 |
| 22.04 | Unlocking Cells | 0:04:00 |
| Session 23: | Collaboration | 0:22:14 |
| 23.01 | Introduction | 0:01:07 |
| 23.02 | Document Properties | 0:04:26 |
| 23.03 | Inserting Hyperlinks | 0:04:23 |
| 23.04 | Sharing a Workbook | 0:02:45 |
| 23.05 | Track Changes | 0:03:55 |
| 23.06 | Accept/Reject Changes | 0:02:30 |
| 23.07 | Mark as Final | 0:03:08 |
| Session 24: | Printing | 0:34:07 |
| 24.01 | Introduction | 0:01:04 |
| 24.02 | Page Orientation | 0:01:54 |
| 24.03 | Page Breaks | 0:03:02 |
| 24.04 | Print Area | 0:02:37 |
| 24.05 | Margins | 0:06:11 |
| 24.06 | Print Titles | 0:03:08 |
| 24.07 | Headers and Footers | 0:07:16 |
| 24.08 | Scaling | 0:04:07 |
| 24.09 | Sheet Options | 0:04:48 |
| Session 25: | Saving a Workbook | 0:24:16 |
| 25.01 | Introduction | 0:01:41 |
| 25.02 | Save As Previous Version | 0:03:40 |
| 25.03 | AutoRecover Save Options | 0:04:08 |
| 25.04 | Templates | 0:04:28 |
| 25.05 | Save As PDF | 0:01:50 |
| 25.06 | Save As Web Page | 0:03:15 |
| 25.07 | Macro-Enabled Workbook | 0:05:14 |
| Session 26: | Macros | 0:18:28 |
| 26.01 | Introduction and Macro Security | 0:03:40 |
| 26.02 | Recording a Macro | 0:04:37 |
| 26.03 | Assign a Macro to a Button or Shape | 0:03:33 |
| 26.04 | Run a Macro upon Opening a Workbook | 0:02:57 |
| 26.05 | How to Inspect and Modify a Macro | 0:03:41 |
Send Enquery