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

Project Description

Project Files - Download These

Use the link below to download the project files that will be used throughout the course:

http://www.mediafire.com/download/815fbnyorgowhhz/Work_FIles.zip

At the end of the course, you will have several completed worksheets that will show how well you have understood the course and help to make learning each lesson easier.

Student Projects