Excel 2016 eLearning Bundle Course

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 rom 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 incollaborative 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.