Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel 2016 Bootcamp - Zero to Hero Training
Rating: 4.5 out of 5(318 ratings)
2,346 students

Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Become proficient in Microsoft Excel so you can create beautiful, professional spreadsheets, easily!
Created byDaniel Walter Scott
Last updated 1/2025
English

What you'll learn

  • By the end of the course, you will be producing real world results with Excel.

Course content

8 sections • 25 lectures • 1h 54m total length

  • Introduction1:43

    Learn essential, beginner-friendly Excel skills using built-in features to create invoices with totals and tax, clean messy spreadsheets, and build pivot tables, dashboards, and drop-down menus for financial data.

  • All the files1:44

Requirements

  • 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.

Description

Hi there, 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 Excels 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 & sort your financial data. . You will learn how to turn uninspiring profit & loss statements into a good looking, easy to use documents. 

Note: Mac users won't have the same experience of Excel as PC users as the software is slightly different and doesn't contain the exact same features. For example the Mac version of Excel doesn't currently support Flash fill so please make sure you're okay with missing out on some small things.

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 this course is for:

  • 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.

Report abuse