Microsoft Excel 2013 and 2016 Training Bundle

$999.00

Categories: ,

Description

This Microsoft Excel 2016 training bundle includes 6 certification courses on Microsoft Excel. Students get the full curriculum for Microsoft Excel Basic, Intermediate & Advanced for both the 2013 and 2016 versions of the software.

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training.

This Microsoft Excel training bundle will help arm you with the knowledge to use it more effectively whether you are using Excel 2013 or Excel 2016. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.

Outline

Excel 2013 Introduction

  • 1.1 Intro To Excel Overview Of Screen
  • 1.2 Ribbon Elements
  • 1.3 Entering Data And Editing Font Attributes
  • 1.4 Number Formats
  • 1.5 Formatting Cells
  • 1.6 Printing
  • 1.7 Formulas Part 1
  • 1.8 Formulas Part 2
  • 1.9 Rearranging Data
  • 1.10 More Formulas
  • 1.11 More Formulas Part 2 Review And Sort
  • 1.12 More Formulas Part 3 Concatenate
  • 1.13 Chart Part 1
  • 1.14 Chart Part 2
  • 1.15 Chart Part 3
  • 1.16 Summary

Excel 2013 Intermediate

  • 2.1 Introduction
  • 2.2 Review
  • 2.3 Formulas Across Worksheets – Part 1
  • 2.4 Formulas Across Worksheets – Part 2
  • 2.5 Conditional Formatting
  • 2.6 Data Validation
  • 2.7 Named Ranges
  • 2.8 CSV Files
  • 2.9 Text To Column
  • 2.10 Grouping Data
  • 2.11 More Charts Beyond Building Blocks
  • 2.12 Working With Windows Part 1
  • 2.13 Working With Windows Part 2
  • 2.14 Headers Footers And Protecting Data

Excel 2013 Advanced

  • 3.1 Pivot Tables Part 1
  • 3.2 Pivot Tables Part 2
  • 3.3 Sparklines
  • 3.4 Trancing Formulas
  • 3.5 What If Scenario
  • 3.6 External Data Sources
  • 3.7 Customizing Menus And Options
  • 3.8 Customizing Menus And Options Part 2
  • 3.9 Macros

Excel 2016 Beginner

  • 1.1 Tabs And Ribbons Part 1
  • 1.2 Tabs And Ribbons Part 2
  • 1.3 Cells Part 1
  • 1.4 Cells Part 2
  • 1.5 Cells Part 3
  • 1.6 Cells Part 4
  • 1.7 Calculations Part 1
  • 1.8 Calculations Part 2
  • 1.9 Calculations Part 3
  • 1.10 Printing Part 1
  • 1.11 Printing Part 2

Excel 2016 Intermediate

  • 1.1 Menus And Keyboard Shortcuts Part 1
  • 1.2 Menus And Keyboard Shortcuts Part 2
  • 1.3 Menus And Keyboard Shortcuts Part 3
  • 1.4 Tabs Part 1
  • 1.5 Tabs Part 2
  • 1.6 Formulas And Calculations Part 1
  • 1.7 Formulas And Calculations Part 2
  • 1.8 Formulas And Calculations Part 3
  • 1.9 Formulas And Calculations Part 4
  • 1.10 Importing Data Part 1
  • 1.11 Importing Data Part 2
  • 1.12 Invoices

Excel 2016 Advanced

  • 1.1 Advanced Invoice Part 1
  • 1.2 Advanced Invoice Part 2
  • 1.3 Advanced Invoice Part 3
  • 1.4 Advanced Invoice Part 4
  • 1.5 Number Crunching
  • 1.6 Creating A Pivot Table From Scratch
  • 1.7 Smaller Excel Components Part 1
  • 1.8 Smaller Excel Components Part 2
  • 1.9 Smaller Excel Components Part 3