Course Name |
Hours |
List Price |
Content |
Analyzing Data in Excel 2016 |
2.00 |
$99.00 |
|
Description: Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and thats a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. 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. And thats exactly what this course aims to help you do.
# of Days:
Setting:
|
Automating Workbook Functionality in Excel 2016 |
2.00 |
$99.00 |
|
Description: Microsoft Office Excel 2016 includes a range of features that enable you to automate a wide variety of workbook tasks. From ensuring that only the correct data is entered into your worksheets, to eliminating repetitive tasks, this course will help you master Excels automation features so that you can save valuable time and keep your data intact.
# of Days:
Setting:
|
Creating Sparklines and Mapping Data in Excel 2016 |
1.00 |
$59.00 |
|
Description: Microsoft Office Excel 2016s capabilities for graphically presenting data go well beyond the use of simple chart types. This course will show you how to use sparklines and how to map Excel data to make visual sense of your complex information for any of your business needs.
# of Days:
Setting:
|
Excel 2016 Charts |
4.00 |
$219.00 |
|
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data create a user-defined chart type.
# of Days:
Setting:
|
Excel 2016 Data Analysis with Power Pivot |
4.00 |
$219.00 |
|
Description: We are now living in the age of big data. 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. Fortunately, 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.
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 be able to do the following:
Get started with Power Pivot.
Visualize Power Pivot data.
Work with advanced functionality in Power Pivot.
# of Days:
Setting:
|
Excel 2016 Pivot Tables |
4.00 |
$219.00 |
|
Description: In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the most powerful tools in Excel.
# of Days:
Setting:
|
Forecasting Data in Excel 2016 |
2.00 |
$99.00 |
|
Description: If you have a large and complex Excel workbook, youll inevitably be juggling numerous variables and values to analyze or even anticipate different business scenarios. In this course, youll learn the skills you need to make the best use of the Excel features that support advanced planning, scheduling, forecasting, and other types of data analysis.
# of Days:
Setting:
|
Formatting an Excel 2016 Worksheet |
2.00 |
$99.00 |
|
Description: Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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 data manipulation.
# of Days:
Setting:
|
Getting Started with Excel 2016 |
2.00 |
$99.00 |
|
Description: Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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 data manipulation.
# of Days:
Setting:
|
Managing Excel 2016 Workbooks |
2.00 |
$99.00 |
|
Description: Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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 data manipulation.
# of Days:
Setting:
|
Modifying an Excel 2016 Worksheet |
1.00 |
$59.00 |
|
Description: Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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 data manipulation.
# of Days:
Setting:
|
Performing Calculations with Excel 2016 |
2.00 |
$99.00 |
|
Description: Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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 data manipulation.
# of Days:
Setting:
|
Printing Excel 2016 Workbooks |
2.00 |
$99.00 |
|
Description: Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. 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 data manipulation.
# of Days:
Setting:
|
Using Lookup Functions and Formula Auditing in Excel 2016 |
2.00 |
$99.00 |
|
Description: This course will help you develop the ability to create the advanced functions and formulas you need to perform complex calculations in Excel. In addition, it will give you the skills to audit your workbook content to find, troubleshoot, and correct errors or issues in your Excel data.
# of Days:
Setting:
|
Visualizing Data with Charts in Excel 2016 |
4.00 |
$199.00 |
|
Description: Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and thats a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. 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. And thats exactly what this course aims to help you do.
# of Days:
Setting:
|
Working with Functions in Excel 2016 |
4.00 |
$199.00 |
|
Description: Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and thats a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. 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. And thats exactly what this course aims to help you do.
# of Days:
Setting:
|
Working with Lists in Excel 2016 |
2.00 |
$99.00 |
|
Description: Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and thats a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. 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. And thats exactly what this course aims to help you do.
# of Days:
Setting:
|
Working with Multiple Worksheets and Workbooks in Excel 2016 |
2.00 |
$99.00 |
|
Description: Using multiple worksheets and workbooks to track, retrieve, consolidate, and report on data can all be done in Microsoft Excel 2016. Whether you are using formulas, 3-D formulas and functions, links to external data (meaning other worksheets or workbooks), or consolidating data from identical worksheets, this course will show you how Excels tools can help you do the job.
# of Days:
Setting:
|