Course Description

Excel 2016 Bootcamp



Excel 2016 Bootcamp is a course run by 1 Training, Dublin. It is a 'Online Learning' course . For more information about Excel 2016 Bootcamp at 1 Training, please review the details below.

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

The Excel 2016 Bootcamp course at 1 Training is listed in Courses.ie's national courses finder.
Training Provider1 Training
Course LocationDublin
Course TypeOnline Learning
Course Fee18
Entry 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)
Carear Path• Administration • Reception • Accounting • Bookkeeping • Business ownership • PA professionals
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on Courses.ie by clicking here.

Course Provider

1 Training



63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training




Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the Courses.ie community.
 

Map