Microsoft excel 2016 pc bootcamp online training course
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
Course Description
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
- MS Excel
- Microsoft excel training
- Project
- PC training
- PC
- Spreadsheet
- Microsoft Excel
- Windows
- Excel
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.
Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
Microsoft excel 2016 pc bootcamp online training course