Please ensure Javascript is enabled for purposes of website accessibility
Microsoft Excel Training: From Zero To Hero
4.9( 34 REVIEWS )
4423 STUDENTS
1h 48m

Master Microsoft Excel Training for profit and loss spreadsheets. Ideal for beginners seeking comprehensive field training. Enroll now!

Read more.
Students
4423
Course Skill Level
Beginner
Time Estimate
1h 48m

Instructor

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

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 and complicated formula.

This training course is project based. We start with a simple company branded invoice and explain how to calculate totals and 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 and 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 and loss statements into a good looking, easy to use documents.

Class projects

  • Create a quote and invoicing form.
  • Cleaning and formatting messy imported data.
  • Inventory spreadsheet.
  • Pivot tables
  • Regional Sales Report
  • Profit and loss spreadsheet.
  • GST and Tax calculations
  • Graphs for use in Word, PowerPoint, InDesign and 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.

10 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

Section 1 - Overview
Introduction 00:00:00
Section 2 - How To Make A Quote And Invoicing Form
Setting Up Printable Page Sizes 00:00:00
Adding Images And Logos 00:00:00
Adding Text And Aligning Cells 00:00:00
Date Formatting 00:00:00
Borders And Lines 00:00:00
Formulas To Calculate Sales Tax 00:00:00
Creating A Template 00:00:00
Printing And Exporting Pdf 00:00:00
Section 3 - Using Templates
Using Pre-Made Templates 00:00:00
Section 4 - Cleaning Up Messy Data
Cleaning Up Messy Spreadsheets 00:00:00
Date And Currency Formatting 00:00:00
Remove Blank Rows And Columns 00:00:00
Removing Duplicates 00:00:00
Splitting Cell Contents 00:00:00
Sorting And Reordering 00:00:00
Repeating Formulas 00:00:00
Practice Exercise 00:00:00
Section 5 - Graphs In Excel
Creating Graphs 00:00:00
Graphs For Word, Powerpoint, Indesign And Illustrator 00:00:00
Section 6 - Pivot Tables
How To Make A Pivot Table 00:00:00
Section 7 - How To Make A Profit And Loss Sheet
Profit And Loss Spreadsheet 00:00:00
Cheat Sheet And Shortcuts 00:00:00

Course Review

4.9

4.9
34 Ratings
  1. SkillSuccess

    Great for beginners and those who know nothing about excel

    4.0

    The only thing that I would have wanted different is the speed in which everything was done. I felt a lot of times that he was going way to fast. I found myself constantly pausing and rewinding over and over. However, overall a wonderful course.

  2. SkillSuccess

    4.0

    I truly enjoyed this course. This course was very insightful and educational. The layout was designed very well. However, David went very fast! I had to go back over the things he was demonstrating alot. If he could slow down that would help.
    Thanks,
    JL

  3. SkillSuccess

    Easy to follow, great practice sheets and extremely informative…

  4. SkillSuccess

    5.0

    I’ve been wanting to learn Microsoft Excel for years, and this online course did not disappoint. I recommend taking this
    no stress training course if you are beginner like me. I feel more empowered now, and ready to help my husband’s business with all of his shop’s bookkeeping, as well as our personal accounting.

  5. SkillSuccess

    5.0

    Excellent course which was lead by a great instructor. I was able to follow along with ease however if I struggled I could review

4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?