RISPARMIA 19%
CareerVision Training
Learning247

Microsoft Excel 2016 PC Bootcamp

Learning247
Online
Prezzo Emagister

57 € 47 
*Prezzo Orientativo
Importo originale in GBP:
£ 48  £ 39

Informazioni importanti

Tipologia Corso
Metodologia Online
Inizio Scegli data
  • Corso
  • Online
  • Inizio:
    Scegli data
Descrizione

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.

Informazioni importanti

Prezzo per gli utenti Emagister:

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Online
Inizio Scegli data
Luogo
Online

Cosa impari in questo corso?

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

Programma

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.