Master Microsoft Excel 2016 Bundle [for PC]

Microsoft Excel is the most popular spreadsheet software in the world, and is regularly used in many professional environments. This introductory course will teach you the absolute basics of working with Excel, helping you discover its many valuable uses. This software is extremely useful to anybody, for both professional and personal purposes, and this is the perfect course to get you started.

• Access over 4 hours of online video tutorials 24/7
• Launch Excel & understand key terminology
• Navigate your way around a spreadsheet
• Open, Save & Close workbooks
• Select cells, rows & columns
• Build simple formulas, sort & organize data
• Import data from other applications
• Perform “what-if” analysis

Microsoft Excel is the most popular spreadsheet software in the world, and is regularly used in many professional environments. This introductory course will teach you the absolute basics of working with Excel on your Mac, helping you discover its many valuable uses. This software is extremely useful to anybody, for both professional and personal purposes, and this is the perfect course to get you started.

• Access over 4 hours of online video tutorials 24/7
• Launch Excel & understand key terminology
• Navigate your way around a spreadsheet
• Open, Save & Close workbooks
• Select cells, rows & columns
• Build simple formulas, sort & organize data
• Import data from other applications
• Perform “what-if” analysis

Building upon your Excel foundations, this course will teach you how to use the essential tools in Excel for Mac, and to truly get the most out of this powerful software. You’ll work with charts, graphs, filters and lists, import different file formats, and track changes in a spreadsheet. By course’s end, you’ll have the skills to perform complex tasks quickly with Excel.

• Access over 4 hours of online video tutorials 24/7
• Save & export Excel into different formats
• Protect workbooks & worksheets
• Import & export XML & CSV files
• Work w/ Vlookup & Hlookup functions
• Filter & subtotal lists
• Work w/ named cells & ranges
• Use validation in a spreadsheet

Building upon your Excel foundations, this course will teach you how to use the essential tools in Excel, and to truly get the most out of this powerful software. You’ll work with charts, graphs, filters and lists, import different file formats, and track changes in a spreadsheet. By course’s end, you’ll have the skills to perform complex tasks quickly with Excel.

• Access over 4 hours of online video tutorials 24/7
• Save & export Excel into different formats
• Protect workbooks & worksheets
• Import & export XML & CSV files
• Work w/ Vlookup & Hlookup functions
• Filter & subtotal lists
• Work w/ named cells & ranges
• Use validation in a spreadsheet

Many people have a basic understanding of Excel, but few are real masters of this software. By the end of this course, however, you’ll be one of the few. Covering all the advanced tools in Excel, this course arms you with the tools to report and manipulate huge amounts of data quickly and easily, and to automate repetitive tasks. This course will separate you from the Excel pack.

• Access 3 hours of content 24/7
• Understand advanced formatting for text & cells
• Update changes across a workbook
• Work w/ Pivot Tables & charts
• Learn how to record & run a macro
• Discover how to link worksheets & workbooks
• Trace & track errors in a spreadsheet
• Add custom controls to a worksheet

Pivot Tables provide a powerful way to summarize and report on large amounts of data. They’re an excellent tool for anybody tasked with working with considerable data. This course will teach you how Pivot Tables work and the structure that must be followed to create useful reports and charts.

• Access 90 minutes of online video tutorials 24/7
• Check source data to ensure it’s correctly organized for Pivot Table results
• Figure out which data to put in row, column, or page areas
• Update or refresh the data in a Pivot Table when required
• Drill into data using the Pivot Slicer tool
• Use Pivot Action settings

Excel Macros save you time and headaches by automating common, repetitive tasks. Although they sound complicated, macros in Excel require no formal programming skills, and are relatively easy to implement once you know how. By the end of this course, you’ll not just know how to use macros in Excel’s Developer Tab, but you’ll be automating complex tasks in your sleep. Literally! You can do that!

• Access 1.5 hours of online video tutorials 24/7
• Work within the Excel developer environment
• Run & record existing macros
• Create a custom tab within the ribbon
• Move macros between different workbooks
• Debug a macro using step/walk tools
• Understand security settings for macros
• Differentiate between absolute & relative macros

Charts are one of Excel’s most useful tools, allowing a user to summarize and report on data graphically, thereby providing a more coherent image to a series of data points. Over this course, you’ll learn in detail how Charts works, and the different types of charts you can create and edit. Before you know it, you’ll be able to efficiently express data in functional graphs.

• Access 100 minutes of online tutorials 24/7
• Learn how to create & edit in Charts
• Understand data insertion & customization in Charts
• Use the secondary axis & trendlines
• Discover advanced editing options in Charts to enhance reports

One of Excel’s most common uses–and certainly one of its most powerful–is to accomplish large calculations. To do this, you must use the Formula and Functions tools. This course will give you detailed instruction on how to use these tools to simplify large tasks and better manage large amounts of data.

• Access 3 hours of online video tutorials 24/7
• Learn how basic operators & functions work
• Understand the different types of functions available & their uses
• Discover advanced Lookups, Text & Date Functions & useful hints & tips
• Answer all of your questions on how to create Formulas & Functions & how to use them