This excellent Excel 2016 Bootcamp course will get you up to speed with Excel 2016, and is intended for beginners, so if you have no experience using Excel 2016 then this course is for you. The course will teach you learn how easily Pivot Tables can turn long and hard-to-understand information into simple tables and beautiful graphs. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.
Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.
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.
Those who successfully pass this course will be awarded a Excel 2016 Bootcamp certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.
With this course, you are able to fulfil various roles, such as:
1: OVERVIEW | |||
1. Introduction | |||
2. All the files | |||
2: HOW TO MAKE A QUOTE & INVOICING FORM | |||
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 | |||
3: USING TEMPLATES | |||
1. Using pre-made templates | |||
4: CLEANING UP MESSY DATA | |||
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 | |||
5: GRAPHS IN EXCEL | |||
1. Creating graphs | |||
2. Graphs for Word, PowerPoint®, Adobe InDesign® & Illustrator | |||
6: PIVOT TABLES | |||
1. How to make a Pivot Table | |||
7: HOW TO MAKE A PROFIT & LOSS SHEET | |||
1. Profit & loss spreadsheet | |||
8: CHEAT SHEET & SHORTCUTS | |||
1. Cheat Sheet & Shortcuts |
Good Course
This was a really good course and good content which helped me to learn a lot.
Great
I definitely recommend 1Training to anyone who is interested in online education to support their current career. It’s a great course
Enjoyed Studying This Course
Really enjoyed studying this course and it helped me so much in my workplace.
Great Course
A great course which will be surely useful to anyone in the business field.
Loved It!
Loved the learning experience since it was highly useful in my workplace as well as in many other matters