Microsoft Excel Bootcamp: Zero To Hero Training

4.9/5 (11 ratings)
See all reviews3,813 students enrolled

This course is designed for those interested to learn about Microsoft Excel.

Watch Free For 30 Days

start free access

-or-

buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This CourseBeginner

Welcome to this Microsoft Excel BootCamp. Together we’re going to learn how helpful Excel is in nearly every part of our professional lives.

This course is for beginners. You do not need any previous knowledge of Excel. We will stick closely to the powerful built in features of Excel and will not get bogged down in confusing code & complicated formulae.

This training course is project based. We start with a simple company branded invoice and explain how to calculate totals & tax.

Using a complex and messy spreadsheet we will clean it up using Excel’s automatic features. With our new tidy data you’ll learn how easy pivot tables can turn long and hard to understand information into simple tables & beautiful graphs.

Before you’re finished you’ll be making helpful drop down menus to help you fill out and sort your financial data.

You will learn how to turn uninspiring profit & loss statements into a good looking, easy to use documents.

Class projects

  • Create a quote & invoicing form.
  • Cleaning & formatting messy imported data.
  • Inventory spreadsheet.
  • Pivot tables
  • Regional Sales Report
  • Profit & loss spreadsheet.
  • GST & Tax calculations
  • Graphs for use in Word, PowerPoint, InDesign & Illustrator
  • Creating spreadsheets that work within Word documents.

Who should attend:

  • This course is designed for people who have little or no previous experience in Microsoft Excel. You will start right at the beginning and cover all the basics.
  • Only basic computing skills are necessary – if you can send emails and surf the internet then you’ve found the right training.
  • By the end of the course, you will be producing real world results with Excel.

What do you need?

  • No previous Microsoft Excel experience necessary.
  • You’ll need Excel 2016 installed on your laptop. The standard installation of Excel 2016 or the Microsoft Office 365 version is fine.

Our Promise to You

By the end of this course, you will have learned about Microsoft Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and develop your Microsoft Excel skills!

Course Curriculum

Course Sections

Introduction

Setting Up Printable Page Sizes

Adding Images And Logos

Adding Text And Aligning Cells

Date Formatting

Borders And Lines

Formulas To Calculate Sales Tax

Creating A Template

Printing And Exporting Pdf

Using Pre-Made Templates

Cleaning Up Messy Spreadsheets

Date And Currency Formatting

Remove Blank Rows And Columns

Removing Duplicates

Splitting Cell Contents

Sorting And Reordering

Repeating Formulas

Practice Exercise

Creating Graphs

Graphs For Word, Powerpoint, Indesign And Illustrator

How To Make A Pivot Table

Profit And Loss Spreadsheet

Cheat Sheet And Shortcuts

Reviews

4.9
11 student reviews
  1. Maria Russo says:

    Great
    Easy to follow and very detailed

  2. Candace Phillips says:

    Very Helpful!
    The course was very helpful and easy to follow. I've learned lots of useful information.

  3. Tameka says:

    Excellent!
    This course was very quick, but extremely informative. I love the pace, and wit of the instructor. The instructor teaches the course in a way that makes the student have many "ah ha" moments.