• excel-2016

    Microsoft Office Excel 2016 Part 1

    $0.00 

    This courseware 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. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel Expert Exam.

    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.

    Objectives:

    • Get started with Microsoft Office Excel 2016.
    • Perform calculations.
    • Modify a worksheet.
    • Format a worksheet.
    • Print workbooks.
    • Manage workbooks.
  • excel-2016

    Microsoft Office Excel 2016 Part 2

    $0.00 

    This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Part 1 course and will help start you down the road to creating 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. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel Expert Exam.

    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.

    Objectives:

    • Work with functions.
    • Work with lists.
    • Analyze data.
    • Visualize data with charts.
    • Use PivotTables and PivotCharts.
  • excel-2016

    Microsoft Office Excel 2016 Part 3

    $0.00 

    This courseware builds off of the foundational and intermediate knowledge presented in the Microsoft Office Excel 2016 Part 1 and Part 2 to help you get the most of your Excel experience. 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 Expert Exam.

    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.

    Objectives:

    • 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.
  • PivotTables

    Microsoft Office Excel 2016/2019 Data Analysis with PivotTables

    $0.00 

    Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that 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.

    This courseware presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

    Objectives:

    • Prepare data for PivotTable reporting and create PivotTables from various data sources.
    • Analyze data by using PivotTables.
    • Work with PivotCharts.
  • Excel Dashboards

    Microsoft Office Excel 2016/2019 Dashboards

    $0.00 

    To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. And that’s exactly what this Excel Dashboards courseware aims to help you do.

    This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Part 1, 2 and 3 courses and will help start you down the road to creating advanced workbooks and worksheets that you can use to create Excel dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.

    This course presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

    Objectives:

    • Create range names and advanced formulas.
    • Automate workbook functionality.
    • Apply conditional logic.
    • Visualize data by creating basic charts.
    • Create trendline and sparkline charts.
    • Use PivotTables, PivotCharts, and slicers to create a dashboard.