Learn Microsoft Excel 2016 in 1 Hour Premium class

Bobby Gibbs, Making Technology Fun

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
71 Videos (1h 32m)
    • Welcome To The Learn Microsoft Excel 2016 in 1 Hour Course

      0:59
    • How To Technology Exclusive Facebook Community

      0:42
    • Overview

      0:23
    • Excel Step #1 - Everything You Need To Know About The Ribbon

      3:47
    • Excel Step #2 - This Is Why The Quick Access Toolbar Is Remarkable

      2:18
    • Action Step

      0:19
    • Overview

      0:23
    • Workbook Phase #1 - Creating A New Workbook

      1:09
    • Workbook Phase #2 - Saving A New Workbook

      1:43
    • Workbook Phase #3 - Navigating Within A Workbook

      1:08
    • Why Worksheets Are Superior - Adding, Removing & Renaming Worksheets

      0:34
    • Warning! Extreme Time Saving With Copying & Moving Worksheets Between Workbooks

      1:33
    • Bonus Step - Hide Or Unhide Worksheets?

      0:32
    • Action Step - Start Working With Workbooks & Worksheets

      0:19
    • Overview

      0:23
    • Elite Step #1 - Dates, Numbers And Text

      1:51
    • Elite Step #2 - Easily Edit Data

      1:14
    • Elite Step #3 - Working Wonders With Copy, Cut And Paste

      2:56
    • Elite Step #4 - Drag And Drop

      1:28
    • The Perfect Arrangement - Adding & Deleting Columns And Rows

      2:07
    • Find And Replace - Simple But Very Effective

      1:35
    • Timeless Secret - Adjusting Columns & Rows

      1:07
    • Case Study - "Now How Do I Sort Out This Data?"

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

      0:19
    • Overview

      0:23
    • Formatting Cells #1 - Making Your Presence Known With Borders

      1:09
    • Formatting Cells #2 - Merge Those Cells

      1:28
    • Wrapping Text - A Great Boon Allowing Multiple Lines In Cells

      0:35
    • 3 Key Basics - Font Size, Color & Text

      1:03
    • Fundamental Format #1 - Using the Date Format

      1:37
    • Fundamental Format #2 - Working With The Number Format

      0:59
    • Case Study: Table Creation Made Easy

      2:34
    • Action Step - Time For Some Formatting

      0:19
    • Overview

      0:23
    • Formula Basics #1 - Addition And Subtraction Formulas

      1:57
    • Formula Basics #2 - Multiplication And Division Formulas

      2:02
    • Important - Understanding The SUM Function

      2:13
    • Save More Than 33% Of Your Time By Copying Formulas

      1:15
    • Why You Must Know Absolute Cell Referencing

      2:11
    • Boost Results By Using Formulas Across Worksheets

      1:17
    • Excel Secret #1: VLOOKUPS

      3:08
    • Excel Secret #2: IF STATEMENTS

      2:09
    • Action Step - Test Out Those Functions And Formulas

      0:19
    • Overview

      0:22
    • Part #1 - Adding Authority With Print Titles

      1:19
    • Hidden Tip #1 - Save Paper By Using Print Area

      1:05
    • Part #2 - Knowing The Correct Orientation And Paper Size

      0:58
    • Hidden Tip #2 - Print More On A Page With Margins

      1:33
    • Part #3 - How Scaling Will Give You Full Control Of Your Printing

      1:39
    • Headers And Footers - Give Your Work An Identity

      3:04
    • Case Study - All You Need To Know About Printing

      3:43
    • Action Step - Let's Get Printing

      0:23
    • Overview

      0:23
    • Graphs And Charts #1 - Creating Graphs And Charts The Easy Way

      2:04
    • Graphs And Charts #2 - Creating Graphs And Charts The Easier Way

      1:40
    • Producing Brilliant Pie Charts

      1:31
    • Sparklines - Transform Your Worksheets With Mini Graphs

      0:56
    • Action Step - Create Graphs And Charts

      0:19
    • Overview

      0:23
    • APT #1 - Creating Outstanding Pivot Tables

      1:13
    • APT #2 - Modifying & Sorting Pivot Tables

      2:30
    • Action Step - Practice Using Pivot Tables

      0:19
    • Overview

      0:23
    • Bonus Tip #1 - Changing A Cell's Appearance Based On Its Value

      0:54
    • Bonus Tip #2 - The Simple Method Of Finding Duplicate Values

      0:38
    • Conditional Formatting Rule #1 - Top vs Bottom Rules

      1:26
    • Conditional Formatting Rule #2 - Average Rules

      0:50
    • Conditional Formatting Rule #3 - Removing Conditional Formatting Rules

      0:36
    • Bonus Step - Data Bars, Color Scales And Icon Sets

      0:52
    • Action Step - Begin Conditional Formatting

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

      0:58

About This Class

How great would it be if you could learn Microsoft Excel in just 1 hour? Well that is now possible. You will be transformed from a beginner to an expert in Excel in just 1 hour, following 4 easy and simple steps.

We Have trained 1000s of beginners Excel, where they have immediately been able to apply what they have learnt within this course.

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

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

Excel can be used for…

  • Scheduling
  • Pay roll systems
  • Weekly planners
  • Invoices
  • Bookkeeping
  • Budget keeping
  • Sorting and listing data
  • Employee and customer data
  • Almost anything that uses and requires data

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

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

In our Learn Microsoft Excel 2016 in 1 Hour class we will give you the blueprint for getting the most out of Excel. Even if you are completely new to Excel the simple step by step video tutorials, instructions and material will give you thorough guidance - everything you need in just 4 easy steps.

No more feeling stressed and overwhelmed, as our fully accredited Microsoft certified instructors will provide all the answers to how Excel operates; we will focus on…

  • Creating spreadsheets 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
  • Implementing the correct tools that will skyrocket your productivity by at least 33%

Plus you will receive an additional Bonus for enrolling…

Bonus: The 4 Step Excel 2016 Formula Guide - makes using functions and formulas easy and simple.

Enroll and Take Action

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

We look forward to seeing you in the class.

How To Technology

34

Students

--

Projects

0

Reviews (0)

Bobby Gibbs

Making Technology Fun