Microsoft Excel 2016 Bootcamp - Zero to Hero Training (Udemy.com)
Become proficient in Microsoft Excel so you can create beautiful, professional spreadsheets, easily!
Created by: Daniel Walter Scott
Last updated January 2025
What you will learn
- By the end of the course, you will be producing real world results with Excel.
Course 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.
Instructor Details
- 4.6 Rating
323 Reviews
Daniel Walter Scott
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.
More courses by Daniel Walter Scott
User Experience Design Essentials - Adobe XD UI UX Design (2025)
4.7 (46,830 Reviews)
Provider: Udemy
Time: 9.7h
$189.99
Adobe Photoshop CC – Essentials Training Course (2025)
4.8 (36,753 Reviews)
Provider: Udemy
Time: 11.6h
$189.99
Adobe InDesign CC - Essentials Training Course (2026)
4.7 (19,611 Reviews)
Provider: Udemy
Time: 11.9h
$149.99
UX Design & User Experience Design Course - Theory Only (2025)
4.3 (11,988 Reviews)
Provider: Udemy
Time: 2.5h
$109.99
Adobe Premiere Pro CC – Essentials Training Course (2025)
4.7 (11,647 Reviews)
Provider: Udemy
Time: 15.8h
$129.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Do Básico ao Avançado - O Curso Completo de Microsoft Excel (2022)
4.8 (115,224 Reviews)
Provider: Udemy
Time: 11.7h
$74.99
Master NEW Excel Functions in Office 365 & Office 2021+ (2026)
4.8 (5,254 Reviews)
Provider: Udemy
Time: 7.1h
$109.99
Reviews
By Tanisha Gathright on 8/27/2026
This video is a good match for me because I already know the basics but wanted a refresher course on some of the items that I do not typically use on a daily basis. The video moves at a nice pace for a refresher. Not too slow, but not too fast so that I am missing part of the materials. I like not having to continuously stop or slow down the video.
By Karen Brown on 9/19/2024
because you talk too fast and thro in extra info that you arent using I keep having to rewind
By James Hall on 5/2/2023
I was looking to expand my knowledge and Excel was always one of those systems that seemed a bit scary to approach. Having just completed Dan's "Figma UI UX Essentials" course, I knew what I was getting into and Dan's teaching style once again has helped me overcome any hesitation going into Microsfot Excel. Highly recommend!
By Kevin Meier on 1/5/2021
Just finished the Course ! Great Course, thank you very much for these awesome course about excel, i use it a lot but learn a few new tricks and could easily refresh and update my knowledge and add new skills. Is another course about excel you have on udemy? Again thank you very much, now I go on with the Word course :-)
By Ivana Diederichová on 1/3/2021
If you would like to learn Excel, but you fall asleep every time you open it, then this is an excelent course for you. :) Dan's playful teaching style, can make you see Excel in a new light. It gave me good grasp of Excel essentials while having fun. Thnx Dan.
By Brittney B Gates on 9/24/2020
Dan's courses are always great because it's hands-on and not a boring lecture. I like that he actually gives you projects and practice assignments. Whoever decided that giving lectures was the best way to teach must have been an attention freak. This was very helpful for me. I will continue to take these courses and recommend them to the people around me.
By Nicola Householder on 7/13/2020
Loved the course, Dan! Another awesome, well-explained Bootcamp with great exercises along the way. I am a designer who has never really used Excel and wanted to learn the basics. I learned so much thanks to you. Especially loved the part about charts/graphs which will be helpful in working with non-designers to make data visualization prettier.
By Jeremy Granger on 12/10/2019
I've used spreadsheets for years, but I was self-taught and used google and youtube to fill in the gaps. Once again, Dan doesn't disappoint. He managed to showcase some pretty cool features that I was never aware of. Looking forward to the next course from him already!
By Émilien M. on 12/6/2019
La formule de Daniel Walter est parfaite : cours bref mais efficace, sans oublier la petite touche humoristique ! Je recommande à 200% pour celles et ceux qui découvrent Excel et veulent des résultats simplement et rapidement (par exemple, un devis propre).
By Francisca Roele on 11/20/2019
Loved the course, Dan is on point with the instruction. Very pleasant instructor to listen to, like the joke inserts. There is plenty of information in the course to get you started. He moves fast, but you can slow down the video speed if you have trouble following along. My only remark is that Dan often does things without saying what he's doing. For example he would select a bunch of rows/columns to apply a feature but not saying how many. Or he would change the format of a section or change the width and not saying what he did. I like to follow along and if the spoken instruction doesn't match the on screen instruction it forces me to pause or rewind the video - observe what he's doing and follow suit. It's a nit picking, but that's why I gave 4 1/2 out of 5.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












