• No products in the basket.

Excel 2016 Bootcamp

4.6( 5 REVIEWS )


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

What are the requirements?

  • You must be 16 or over
  • You should have a basic understanding of English, Maths and ICT
  • You will need a computer or tablet with internet connection (or access to one)

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.

What careers can I get with this qualification?

With this course, you are able to fulfil various roles, such as:

  • Administration
  • Reception
  • Accounting
  • Bookkeeping
  • Business ownership
  • PA professionals

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

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
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
WhatsApp chat
Offer Extended – Up to 95% OFF !!
Use code SAVE95 | SAVE90 or SAVE80 at checkout