Microsoft Excel 2016 PC Bootcamp
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
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
Start date
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
12 Month Unlimited On-Demand Online Access to the Course.
Course programme
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