Microsoft Excel 2016 Bootcamp - Zero to Hero Training
4.8 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,032 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 Bootcamp - Zero to Hero Training to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Become proficient in Microsoft Excel so you can create beautiful, professional spreadsheets, easily!
4.8 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,032 students enrolled
Last updated 6/2017
English
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course, you will be producing real world results with Excel.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
24 Lectures
01:54:05
+
Introduction
2 Lectures 03:27
+
How to make a Quote & Invoicing Form
8 Lectures 34:33



Date formatting
03:43

Borders & lines
05:12

Formulas to calculate sales tax
05:26

Creating a template
04:48

Printing & exporting PDFs
03:52
+
Using Templates
1 Lecture 01:42
Using pre-made templates
01:42
+
Cleaning up Messing data
8 Lectures 26:36
Cleaning up messy spreadsheets
04:02

Date & currency formatting
03:56

Remove blank rows & columns
02:25

Removing duplicates
04:27

Splitting cell contents
04:17

Sorting & Reordering
02:29

Repeating formulas
02:31

Practise exercise
02:29
+
Graphs in Excel
2 Lectures 14:55
Creating graphs
07:33

Graphs for Word, PowerPoint, InDesign & Illustrator
07:22
+
Pivot Tables
1 Lecture 11:00
How to make a Pivot Table
11:00
+
How to make a Profit & Loss Sheet
1 Lecture 17:23
Profit & loss spreadsheet
17:23
+
Cheat sheet & shortcuts
1 Lecture 04:29
Cheat Sheet & Shortcuts
04:29
About the Instructor
Daniel Walter Scott
4.6 Average rating
904 Reviews
12,517 Students
13 Courses
Microsoft trainer and Adobe Certified Instructor

Sharing is who I am, and teaching is where I am at my best, because I've been on both sides of that equation, and getting to deliver useful training is my meaningful way to be a part of the creative community.

I've spent a long time watching others learn, and teach, to refine how I work with you to be efficient, useful and, most importantly, memorable. I want you to carry what I've shown you into a bright future.

I have a wife (a lovely Irish girl) and kids. I have lived and worked in many places (as Kiwis tend to do) – but most of my 14+ years of creating and teaching has had one overriding theme: bringing others along for the ride as we all try to change the world with our stories, our labours of love and our art.

I'm a certified Adobe instructor (ACI) in Ireland. I'm also an Adobe Certified Expert (ACE) and have completed the Adobe Certified Associate training (ACA). And I don't just do Adobe. Remember, media is a very broad term – digital blew out the borders, so we are all constantly learning.

I've been teaching for 14+ years. I come from being a media designer and content creator – so I understand exactly where you're at now. I've been there. I love this stuff. Print, digital publishing, web and video. I can see how it all connects. And I can see how we can share those connections.

I built Bring Your Own Laptop in Ireland, New Zealand, Australia & online. I have a great team working with me to keep BYOL at the top of Adobe and digital media training. I understand business, I have one – so I know how important it is to get it right and make it work for you.

Now my focus is on Udemy. It's my mission to bring you the best training for digital media on Udemy.

Daniel Walter Scott