Course Name |
Hours |
List Price |
Content |
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:
|
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:
|