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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

3 of 3 students recommend this class