Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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 Videos (1h 38m)
    • Microsoft Excel Promo

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

      0:56
    • How To Technology Exclusive Facebook Community

      0:42
    • Overview

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

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

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

      0:23
    • Overview

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

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

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

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

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

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

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

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

      0:22
    • Overview

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

      1:48
    • Cells Step #1 - Editing Data

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

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

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

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

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

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

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

      0:20
    • Overview

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

      1:33
    • Powerful Cells #2 -Merging Cells

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

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

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

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

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

      1:06
    • Case Study: Table Please

      2:40
    • Action Step - Time To Format

      0:24
    • Overview

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

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

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

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

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

      1:55
    • Adding Authority - Headers & Footers

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

      4:16
    • Action Step - Print Those Worksheets

      0:22
    • Overview

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

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

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

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

      1:28
    • Important - Absolute Cell Referencing

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

      1:33
    • Bonus Step #1: VLOOKUPS

      3:44
    • Bonus Step #2: IF STATEMENTS

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

      0:20
    • Overview

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

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

      1:19
    • Bonus Step - Using Filters

      0:19
    • Acing Pie Charts

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

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

      0:23
    • Overview

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

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

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

      0:21
    • Overview

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

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

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

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

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

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

      0:58
    • Action Step - Start Conditional Formatting Now

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

      0:42