Excel Essentials: Level 1 Basics - Master Excel Step-By-Step

Master the basics of Excel and boost your income!
Course Created by Alan Jarvis
Hi, my name is Alan, and I have almost thirty years of experience in teaching various subjects and have held senior management positions at several blue chip and Times Top 100 companies.

My love for Excel began soon after the program was released. Back then, we really only used it for typing tables in our production planning department. If you can believe it, I was taught to then calculate with a calculator and TYPE the answers into Excel...you'd be surprised how many people I meet who still do this!

If you are a complete beginner, just want to polish up your skills, or want to create sophisticated super efficient solutions for your business or personal life, my series of courses will help you achieve that. All you need is a little time, and a willingness to learn...I'm looking forward to working with you.

Alan

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

If you are looking to master Excel, or just brush up on the basics, you've come to the right place!

Excel is the most widely used business software in the world, and for good reason. It is so adaptable, it can be used for almost anything! Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities. Several of my students have gone on to get better paying jobs, or even start their own businesses!

Mastering Excel is easy, but you would be surprised how many people just don't understand the basics...this course is aimed at those people. We cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it!

Who is this course aimed at?

Complete beginners, and those who want to build a solid foundation upon which to build their skills.

How is it structured?

Together we concentrate on building a single complete project from scratch, using all the basic functions and give you a thorough understanding. I know your time is valuable, so most lectures are between 3-5 minutes, allowing you to dip in and out when it's convenient for you. This also maximizes your learning, and makes it easy if you need to go back to refresh your memory...no need to click through a 40 minute lecture to find what you're looking for! There are  screencasts, presentations, pdfs, downloadable files...all designed to optimize your learning.

What do I get with this course?

  • Lifetime access to over 4 hours of content. 
  • Almost 50 bite-size lectures, each covering a specific topic in detail. Some of which I have never seen taught before!
  • Downloadable source file, and pdfs that you can take with you and quickly refer back to if you are away from home.
  • If you're bot completely satisfied, a full 30-day money back guarantee

Why take this course?


I have been using Excel for over 20 years, but there is a difference between being good at something and being able to teach it. In that time I have taught hundreds of people how to master its power. Because I have taught so many people, I know not to assume you already understand something, and I have probably already heard every question you are likely to have.This course took over 4 months to produce, and has been tested extensively with scores of people. If something didn't work, or wasn't clear, it was revised until it did.

Of course, we never stop learning, and I will continue to develop this course and your skills with your feedback.

Enjoy!

Alan

Course Objectives

  • At he end of this course you will be able to create fully functioning spread sheets from scratch, and more importantly, understand how they work!

Who Is This For?

  • This course is aimed at complete beginners, or those who want to get a thorough knowledge of the basics.

Course Outline

Chapter 1: Mastering The Basics

  • Lesson 1
    Opening Excel
    03:47
  • Lesson 2
    The Anatomy Of A Workbook
    15:20
  • Lesson 3
    The Anatomy Of A Workbook R…
    06:12
  • Lesson 4
    First Things First - Save Y…
    02:02
  • Lesson 5
    Entering Data - Text
    01:42
  • Lesson 6
    Editing Data - Text
    01:43
  • Lesson 7
    Ooops . I Made A Mistake - …
    01:21
  • Lesson 8
    Formatting Text - Fonts
    09:04
  • Lesson 9
    A Quick Word On Formatting
    01:21
  • Lesson 10
    Formatting Text - Alignment
    03:08
  • Lesson 11
    Saving Time With AutoFillin…
    04:42
  • Lesson 12
    POWER USER - Adding Your Ow…
    04:24
  • Lesson 13
    Saving Time with Format Pai…
    02:49
  • Lesson 14
    Changing The Column Width
    03:34
  • Lesson 15
    Merge And Centre
    03:02
  • Lesson 16
    Entering Data - A Couple Of…
    03:58

Chapter 2: Doing The (Simple) Math

  • Lesson 17
    Sums - The Old Fashioned Way!
    03:12
  • Lesson 18
    Sums - Using Autosum
    05:33
  • Lesson 19
    Copying Formulas
    03:18
  • Lesson 20
    SUMming Horizontally
    03:17
  • Lesson 21
    Basic Formulas - Subtraction
    02:29
  • Lesson 22
    Basic Formulas - Multiplica…
    01:33
  • Lesson 23
    Basic Formulas - Division
    01:22
  • Lesson 24
    Average Function
    02:42
  • Lesson 25
    The Order Of Mathematical O…
    06:39
  • Lesson 26
    POWER USER - Evaluate Formu…
    04:51

Chapter 3: Rearranging Things

  • Lesson 27
    Inserting Columns And Rows
    06:22
  • Lesson 28
    Moving Existing Columns And…
    02:28
  • Lesson 29
    Cut, Copy, Insert And Delete
    06:08
  • Lesson 30
    Hiding Columns And Rows
    02:42

Chapter 4: Formulas: Learning The Clever Stuff!

  • Lesson 31
    ROUNDing Functons
    05:56
  • Lesson 32
    Formatting Numbers
    02:13
  • Lesson 33
    A Primer In Building Comple…
    03:11
  • Lesson 34
    Buliding a Compex Formula
    04:20

Chapter 5: A Few More Essentials

  • Lesson 35
    Sorting
    04:17
  • Lesson 36
    Wrapping Text And Soft Enter
    04:00
  • Lesson 37
    Adding A New Worksheet
    01:08
  • Lesson 38
    Creating A Simple Chart
    04:21
  • Lesson 39
    Adding Borders
    02:37
  • Lesson 40
    Customizing the Quick Acces…
    02:12
  • Lesson 41
    Simple Printing
    03:35
  • Lesson 42
    Freezing For An Easier View
    04:07
  • Lesson 43
    Getting Help
    01:40
  • Lesson 44
    Filters
    06:22
  • Lesson 45
    Highlighting Cells
    02:04
  • Lesson 46
    Closing
    01:31

Chapter 6: Bonus Section: Whizzing Around Excel!

  • Lesson 47
    Bonus 1 Whizzing Around Exc…
    06:46
  • Lesson 48
    Bonus 2 Keyboard Shortcuts
    11:19

Chapter 7: Bonus Section: Absolute and Relative Cell References

  • Lesson 49
    1 A1 Style - Relative Relative
    02:16
  • Lesson 50
    2 A1 Style - Absolute Absolute
    02:45
  • Lesson 51
    3 A1 Style - Absolute Relative
    02:17
  • Lesson 52
    4 A1 Style - Relative Absolute
    02:02

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)