Microsoft Excel - From Beginner to Expert in 1 Hour

Bobby Gibbs, Making Technology Fun

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
75 Lessons (1h 38m)
    • 1. Microsoft Excel Promo

      1:14
    • 2. Welcome To The Learn Excel 2013 in 1 Hour Course

      0:56
    • 3. How To Technology Exclusive Facebook Community

      0:42
    • 4. Overview

      0:30
    • 5. Excel Tip #1 - The Power of The Ribbon

      1:38
    • 6. Excel Tip #2 - Secrets of The Quick Access Toolbar

      1:50
    • 7. Action Step - Start Excelling With The Ribbon & Quick Access Toolbar

      0:23
    • 8. Overview

      0:27
    • 9. Workbook Guide #1 - Creating a New Workbook

      1:04
    • 10. Workbook Guide #2 - Saving a New Workbook

      1:48
    • 11. Workbook Guide #3 - Navigating within a Workbook

      1:00
    • 12. The Real Meaning of WWW #1 - Add & Remove Worksheets

      0:27
    • 13. It's All in The Name - Renaming a Worksheet Tab

      0:25
    • 14. Copy & Move Worksheets Between Workbooks to Boost Productivity

      1:48
    • 15. The Real Meaning of WWW #2 - To Hide or Not To Hide?

      0:51
    • 16. Action Step - Work With Those Worksheets & Workbooks

      0:22
    • 17. Overview

      0:31
    • 18. It's All About The Numbers, Dates and Text

      1:48
    • 19. Cells Step #1 - Editing Data

      1:11
    • 20. Cells Step #2 - The Incredible Benefits of Copy, Cut & Paste

      3:00
    • 21. Cells Step #3 - Drag & Drop

      1:39
    • 22. Secret #1 - Adding & Deleting Columns & Rows

      1:51
    • 23. Those Wonderful Worksheets - Ease of Use with Find & Replace

      1:40
    • 24. Secret #2 - Adjusting Column Widths & Row Heights

      1:02
    • 25. Case Study - "If Only I Could Sort Out This Data"

      3:17
    • 26. Action Step - Enter & Edit That Data

      0:20
    • 27. Overview

      0:28
    • 28. Powerful Cells #1 - Adding Impact with Borders

      1:33
    • 29. Powerful Cells #2 -Merging Cells

      1:16
    • 30. The Benefits of Multiple Lines - Wrapping Text in Cells

      0:40
    • 31. Hidden Secret #1- Changing Merged Cells into Standard Cells

      0:54
    • 32. First Impressions Count - Changing Font Size, Type & Color

      1:24
    • 33. Hidden Secret #2 - Applying The Delightful Date Format

      1:52
    • 34. Hidden Secret #3 - Why You Need Number Formats

      1:06
    • 35. Case Study: Table Please

      2:40
    • 36. Action Step - Time To Format

      0:24
    • 37. Overview

      0:26
    • 38. Part #1 - Transform Your Worksheets with Print Titles

      1:36
    • 39. Bonus Tip #1 - Save Money with Print Area

      0:57
    • 40. Part #2 - Finding The Right Paper Size & Orientation

      1:26
    • 41. Bonus Tip #2 - How Margins Will Maximise Your Printing

      1:46
    • 42. Part #3 - Scaling: A Must for Perfect Printing

      1:55
    • 43. Adding Authority - Headers & Footers

      4:04
    • 44. Case Study - Now How Do I Print My Work?

      4:16
    • 45. Action Step - Print Those Worksheets

      0:22
    • 46. Overview

      0:27
    • 47. Basic Formulas #1 - Addition & Subtraction Formulas

      2:06
    • 48. Basic Formulas #2 - Multiplication & Division Formulas

      2:36
    • 49. The SUM Function - The Core of Excel

      2:21
    • 50. Save At Least 33% of Your Time with Copying Formulas

      1:28
    • 51. Important - Absolute Cell Referencing

      2:09
    • 52. Skyrocket Your Results - Using Formulas Across Worksheets

      1:33
    • 53. Bonus Step #1: VLOOKUPS

      3:44
    • 54. Bonus Step #2: IF STATEMENTS

      2:15
    • 55. Action Step - Start Experimenting with Functions & Formulas

      0:20
    • 56. Overview

      0:28
    • 57. Graphs & Charts Part #1 - Creating Graphs & Charts The Quick Way

      2:05
    • 58. Graphs & Charts Part #2 - Creating Graphs & Charts The Quicker Way

      1:19
    • 59. Bonus Step - Using Filters

      0:19
    • 60. Acing Pie Charts

      1:19
    • 61. Sparklines - How Mini Graphs Will Revolutionise Your Worksheets

      1:00
    • 62. Action Step - Create Those Graphs & Charts

      0:23
    • 63. Overview

      0:24
    • 64. PPT #1 - Creating Superior Pivot Tables

      1:13
    • 65. PPT #2 - Sorting & Using Pivot Tables

      1:19
    • 66. Action Step - Put Those Pivot Tables Into Practice

      0:21
    • 67. Overview

      0:24
    • 68. Phase #1 - Changing Cell Appearances Based on Their Value

      1:14
    • 69. Phase #2 - The Ease of Finding Duplicate Values

      0:52
    • 70. Rule #1 - Top vs Bottom Rules

      1:40
    • 71. Rule #2- How Being Average Rules

      1:05
    • 72. Rule #3 - Removing Conditional Formatting Rules

      0:44
    • 73. Bonus Step - Color Scales, Data Bars & Icon Sets

      0:58
    • 74. Action Step - Start Conditional Formatting Now

      0:22
    • 75. Final Action Step - Putting It All Together

      0:42