Course Description

"Your Excel skills could land your next job."

- Fortune Magazine

A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't.

Are you ready to land your next job and increase your pay by 13%?

This course is designed to teach you the basics and beyond of Excel 2016. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.

You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:

  1. Create a basic Kitchen Remodel Costs worksheet.
  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.
  3. Create professional looking pie charts, bar charts, column charts and more.
  4. Create a table and a range and sort your data.
  5. Create pivot charts and tables to do lightening fast analysis of your data.
  6. Learn to use new features of Excel 2016 including 1-click forecasting and 3D maps.
  7. Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you'll learn in this course:

  1. VLOOKUP
  2. COUNT & COUNTA
  3. COUNTIF & COUNTIFS
  4. AVERAGE & AVERAGEA
  5. SUM, SUMIF & SUMIFS
  6. IF
  7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

  1. Spreadsheets
  2. Tables
  3. Ranges
  4. Pie, Column, Bar and Line charts
  5. Pivot tables
  6. Pivot charts
  7. Tons of tips and tricks to make using Excel 2016 easier every day.

So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the TAKE THIS COURSE button or check out one of the free preview lectures to see if it's the perfect fit for you.

Author, Instructor, Digital Entrepreneur

Steve McDonald

I believe that learning can be easy if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals. Whether I am teaching How I Retired Early Publishing Kindle eBooks or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets. For over 10 years I have studied strategies to create passive income and how to use passive income to vastly improve the quality of your life. I have tested many different strategies from investing in rental real estate to building niche websites about my hobbies, like with my pottery-on-the-wheel website to publishing Kindle eBooks. I have studied what works and what doesn't work and I have narrowed my research down to the strategies that work the best for creating financial freedom and an improved quality of life. Each of my courses is designed to share with you these secrets. I hold nothing back. And I won't bore you with all of the strategies that don't work. I'll get right into the exact steps that I have taken to be successful so that you have the opportunity to replicate it. Of course, it's no secret that my favorite way to generate truly passive income is through publishing Kindle eBooks. I have published over 100 eBooks and published five of those in print. Many of my books have been bestsellers including my own pottery book The Despicable Five. Once I figured out the Kindle publishing system, some formatting secrets that for some reason are not easy to find, and learned how to use some simple SEO skills that I learned while testing out website building, publishing eBooks became remarkably simple. Even hiring writers, which would seem scary at first, is really easy and even fun, when you follow my system. I even have it set up so you can publish one or two books and then roll the profits from them into hiring writers so you aren't taking any money out of your pocket. It starts out as a little income snowball and as you add the profits back into the snowball it grows and grows until you are seeing a surprising and exciting amount of passive income. I retired in 2014 thanks to my eBook publishing success. Now, when I'm not skiing or kayaking or hiking with my 7 year old son I'm using my spare time to find the best ways to create passive income. As I find great ways to make money from home I'm more than happy to share what I learn with you. I am here to guide you on your way to success. You can contact me at any step of the way for assistance or even if you're unsure whether my course is the perfect fit for you. I'm always happy to help. Would you like to start earning passive income? It all starts with knowledge, and my courses make that part easy for you. Sign up for a course today and learn how to create passive income for yourself.

Course curriculum

  • 1

    Introduction

    • Promo Video

    • Introduction

  • 2

    Tours

    • Tour of Excel

    • Templates Tour

  • 3

    Excel Basics

    • Saving Your Excel Document

    • Entering Data and Navigating Cells

    • Creating Simple Formulas

    • Working With Worksheets and Workbooks

    • Creating and Formatting a Heading

    • Formatting Subheadings and Columns and Alphabetizing Lists

    • Entering and Formatting Numbers

    • Final formatting Grids

  • 4

    Formulas and Functions

    • Intro to Formulas and Functions

    • What is a Formula

    • Create Formulas to Calculate Total Costs

    • What is a Function

    • Anatomy of a Formula

    • Quickly Select Cells When Entering a Formula

    • Absolute vs Relative Cell reference

    • AVERAGE and AVERAGEA

    • COUNT COUNTA and COUNTBLANK Fixed

    • IF Function

    • SUMIF and SUMIFS Functions Fixed

    • COUNIF and COUNTIFS Functions

    • VLOOKUP Function

    • LEFT RIGHT MID Functions

    • Concatenate

    • LEN

    • FIND and SEARCH

    • Min and Max

    • AND and OR

    • ROUND

    • Conditional Formatting

  • 5

    Charts and Graphs

    • Charts and Graphs

    • Charts Formatting

    • Bar Chart Creation

    • Pie Chart

    • Line Chart

  • 6

    Pivot Tables

    • Pivot Tables Prepare Your Data

    • Pivot Tables Creating a Pivot Table the 4 parts

    • Pivot Tables Quick Calculations with Lots of Examples

    • Pivot Charts

  • 7

    Special Features

    • New Features for 2016

    • New Charts for 2016

    • Tell Me What You Want to Do Feature

    • 1 Click Forecasting

    • Excel 2016 3D Maps Demo

  • 8

    Wrapping Up

    • Conclusion