eLearning Bundle - Excel 2016 Online Course

Microsoft Excel TrainingeLearning Bundle - Excel 2016

by Certstaffix® Training

Length: 5 Course(s)      Price: $350/person (USD)      Access Length: 6 Months      Category: Microsoft Excel


This eLearning Bundle includes these five Excel 2016 courses: Microsoft Office Excel 2016: Part 1 (Beginner), Microsoft Office Excel 2016: Part 2 (Intermediate), Microsoft Office Excel 2016: Part 3 (Advanced), Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) and Microsoft Office Excel 2016: Part 5 (Data Analysis with Power Pivot).

Office Versions That Can Attend: Microsoft Office 2019, 365 and 2016 (Microsoft Windows PC)
Courses Taught With: Office version 2016 (Microsoft Windows PC) Software and Courseware
Not Appropriate For: Macintosh versions of Microsoft Office
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Microsoft Excel Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • Desktop Software Courses: We provide lab environment with the software you are learning, no need to have the software on your computer
  • 6 month subscription length

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It

Related Training:

Microsoft Excel Training

Features:

• Audio Narration
• Inline Quizzes
• Job Aids and Reference Materials
• Exercise Files
• Simulations
• Video
• Accessible / 508 Compliant
• Post-Assessment

Microsoft Office Excel 2016: Part 1 (Beginner) - 2:09 hours

Microsoft Excel 2016 can help you organize, calculate, analyze, revise, update, and present your data
in ways that will help you or other decision makers in your organization steer you in the right direction.
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build
upon to eventually become an expert in Excel 2016.

Target Student
This course is intended for students who wish to gain the foundational understanding of Microsoft
Office Excel 2016 that is necessary to create and work with electronic spreadsheets.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel
2016 Exam and the Excel 2016 Expert Exam.

Course Objectives
Upon successful completion of this course, you will be able to create and develop Excel worksheets and
workbooks in order to work with and analyze the data that is critical to the success of your
organization.

You will:
• Get started with Microsoft Office Excel 2016.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Prerequisites
To ensure success, you need to be familiar with using personal computers and should have experience
using a keyboard and mouse. You should also be comfortable working in the Windows environment.

Microsoft Office Excel 2016: Part 2 (Intermediate) - 2:26 hours

In this course you'll learn create advanced workbooks and worksheets that can help deepen your
understanding of organizational intelligence. The ability to analyze massive amounts of data, extract
actionable information from it, and present that information to decision makers is at the foundation of
a successful organization that is able to compete at a high level.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence
from your raw data. In other words, when you have questions about your data, you need to know how
to get Excel to provide the answers for you.

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel
2016 Exam and the Excel 2016 Expert Exam.

Target Student
This course is designed for those, who already have foundational knowledge and skills in Excel 2016
and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze
and present data.

Course Objectives
Upon successful completion of this course, you will be able to leverage the power of data analysis and
presentation in order to make informed, intelligent organizational decisions.

You will:
• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use PivotTables and PivotCharts.

Course Prerequisites
This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016: Part
1 course.

Microsoft Office Excel 2016: Part 3 (Advanced) - 1:37 hours

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional
logic to construct and apply elaborate formulas and functions will put the full power of Excel right at
your fingertips. The more you learn about how to get Excel to do the hard work for you, the more
you'll be able to focus on getting the answers you need from the vast amounts of data your
organization generates.

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel
2016 Exam and the Excel 2016 Expert Exam.

Target Student
You will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in
collaborative partnerships involving workbook data, construct complex Excel functions, and use those
functions to perform rigorous analysis of extensive, complex datasets.

Course Objectives
Upon successful completion of this course, you will be able to perform advanced data analysis,
collaborate on workbooks with other users, and automate workbook functionality.

You will:
• Work with multiple worksheets and workbooks.
• Use Lookup functions and formula auditing
• Share and protect workbooks.
• Automate workbook functionality.
• Create sparklines and map data.
• Forecast data.

Course Prerequisites
This course is intended for students who are experienced Excel 2016 users and have a desire or need to
advance their skills in working with some of the more advanced Excel features.

Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) - 1:11 hours

The need to analyze data and gain actionable insight is greater than ever. You already have
experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable
of doing much more. Being able to harness the power of advanced PivotTable features and create
PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for
you to analyze, but also organize the data in a way that can be meaningfully presented to others. This
leads to data-driven business decisions that have a better chance for success for everyone involved!

Target Student
Students taking this course are experienced Excel users who are seeking to advance their data analysis
capabilities by using PivotTables.

Course Objectives
Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable
functionality to analyze your raw data.

You will:
• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze data by using PivotTables.
• Work with PivotCharts.

Course Prerequisites
To ensure your success in this course, you should have experience working with Excel 2016 and
PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic
PivotTables.

Microsoft Office Excel 2016: Part 5 (Data Analysis with Power Pivot) - 0:53 hours

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Target Student
People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Course Objectives
Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.

You will:
• Get started with Power Pivot.
• Visualize Power Pivot data.
• Work with advanced functionality in Power Pivot.

Course Prerequisites
To ensure your success in this course, you should have experience working with Excel 2016 and
PivotTables.
Course Description: Print It | Download PDF | Email It