Microsoft Excel 2016 PC Bootcamp

Course

Online

Save 18%
£ 39 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

CareerVision Training

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.

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!

This training course is for Microsoft Office Excel 2016 for Windows.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Project
  • PC
  • Excel
  • Windows
  • Microsoft Excel
  • Spreadsheet
  • PC training
  • Microsoft excel training
  • MS Excel
  • Microsoft
  • Excel 2016
  • Microsoft Excel 2016

Teachers and trainers (1)

Online Course Online Course

Online Course Online Course

12 Month Unlimited On-Demand Online Access to the Course.

Course programme

Course Outline

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

CHAPTER 08: CHEAT SHEET & SHORTCUTS 04:30
1. Cheat Sheet & Shortcuts


PACKAGE INCLUDES:
  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 1 hrs 54 min
  • Platform: Windows
  • Level: Beginner to Advanced
  • Project Files: Included


Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.

Microsoft Excel 2016 PC Bootcamp

£ 39 VAT inc.