This Microsoft® Excel 2016 Bootcamp 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 or complicated formulae. Project Files Included!
Length: 1 hr 54 min
This title is available in theTotal Training All-Access library.
This Microsoft Excel 2016 Bootcamp 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 Excels automatic features. With our new tidy data, you’ll learn how easily Pivot Tables can turn long and hard-to-understand information into simple tables and beautiful graphs. Before we’re finished, you’ll be making clever drop down menus to help you fill out and sort your financial data. You will even learn how to turn uninspiring Profit and Loss statements into a good looking, easy-to-use documents!
Now is your time to go from Excel Zero, to Excel Hero, and for you to become the Microsoft Excel professional in your office.
CHAPTER 01: OVERVIEW 03:28 1. Introduction 2. All the files
CHAPTER 02: HOW TO MAKE A QUOTE & INVOICING FORM 34:37 1. Setting up printable page sizes 2. Adding images & logos 3. Adding text & aligning cells 4. Date formatting 5. Borders & lines 6. Formulas to calculate sales tax 7. Creating a template 8. Printing & exporting Adobe® PDFs
CHAPTER 03: USING TEMPLATES 01:43 1. Using pre-made templates
CHAPTER 04: CLEANING UP MESSY DATA 26:40 1. Cleaning up messy spreadsheets 2. Date & currency formatting 3. Remove blank rows & columns 4. Removing duplicates 5. Splitting cell contents 6. Sorting & Reordering 7. Repeating formulas 8. Practice exercise
CHAPTER 05: GRAPHS IN EXCEL 14:56 1. Creating graphs 2. Graphs for Word, PowerPoint®, Adobe InDesign® & Illustrator
CHAPTER 06: PIVOT TABLES 11:00 1. How to make a Pivot Table
CHAPTER 07: HOW TO MAKE A PROFIT & LOSS SHEET 17:24 1. Profit & loss spreadsheet
Daniel Scott is a Microsoft Trainer and Adobe® Certified Instructor. He’s been teaching for more than 14 years – covering topics such as print, digital publishing, web, and video. He loves to see how it all connects, and how we can share those connections. He prides himself on delivering the best service to his clients and making sure all his students learn to their fullest potential. He is currently the lead trainer at Bring Your Own Laptop Training Center in New Zealand.