Excel 2016 Bootcamp

Excel 2016 Bootcamp

Overview:

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.

What skills will I gain?

• Learn to make clever drop down menus to help you fill out and sort your financial data
• Turn uninspiring Profit and Loss statements into a good looking, easy-to-use documents
• Learn to clean up your spreadsheets using Excels automatic features
• Learn to turn long and hard-to-understand information into simple tables and beautiful graphs

Meet the Instructor:

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.

Course outline:

• Module 01: Overview
• Module 02: How To Make A Quote & Invoicing Form
• Module 03: Using Templates
• Module 04: Cleaning Up Messy Data
• Module 05: Graphs In Excel
• Module 06: Pivot Tables
• Module 07: How To Make A Profit & Loss Sheet
• Module 08: Cheat Sheet & Shortcuts

How will I be assessed? 

• You will have one assignment. Pass mark is 65%.
• You will only need to pay £19 for assessment.
• You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

What Certification am I going to receive?

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.

Course Curriculum Total Units : 24
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
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
6: PIVOT TABLES
7: HOW TO MAKE A PROFIT & LOSS SHEET
8: CHEAT SHEET & SHORTCUTS