Microsoft Excel - From Beginner to Expert in 1 Hour Premium class

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

About This Class

Wouldn't it be great if you could learn Microsoft Excel in just 1 hour? Imagine going from beginner to expert in just 1 hour.

All this is possible in just 4 easy and simple steps.

Having taught 1000s of beginners Excel, they were instantly able to apply what they had learnt within this course.

Here we welcome you to the Learn Microsoft Excel 2013 in 1 hour course, where you'll learn how to use Excel in real life scenarios based on a variety of case studies.

Guarantee: By the end of this course you will be able to use Excel in real life scenarios within just 1 hour.

Excel can be used for…

  • Weekly planners
  • Invoices
  • Payroll systems
  • Budget keeping
  • Listing and sorting data
  • Bookkeeping
  • Customer and employee data
  • Scheduling
  • Almost anything that requires and uses data

And the best part is you can even use it at…

  • Home
  • Work
  • An educational establishment
  • Or just for fun - the possibilities are unlimited! 

Here we will focus on…

  • Creating worksheets which will turn you into an Excel Expert in less than 1 hour
  • Applying Excel to real life situations to enhance your results in your working environment
  • Using the right tools that will boost your productivity by at least 33%

Plus you'll receive 2 Bonuses for enrolling which are…

Bonus #1: The Excel 2013 Elite Formula Cheat Sheet - formulas available on demand

Bonus #2: The 4 Step Excel 2013 Functions Guide - makes using functions and formulas simple and easy

Enroll and Take Action

Join now and make the commitment of going through our course. It is sure to enhance your skills and level of knowledge with Excel.

We look forward to seeing you in the course.

See you then

How To Technology

35

Students

--

Projects

0

Reviews (0)

Bobby Gibbs

Making Technology Fun