Skip to the main content
< Back

Computer Course Description

Microsoft Excel 2016

  • 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. You will learn to:

    * Perform calculations

    * Modify a worksheet

    * Format a worksheet

    * Print workbooks

    * Manage workbooks

  • This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Beginner course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. In this course, you will:

    * Work with functions

    * Work with lists

    * Analyze data

    * Visualize data with charts

    * Use PivotTables and Pivot Charts

    Prerequisite: Excel 2016 Beginner or equivalent knowledge.

  • The more you learn about how to get Excel to do the hard work for you, the more you will be able to focus on getting the answers you need from the vast amounts of data your organization generates. You will:

    * Work with multiple worksheets and workbooks

    * Use Lookup functions and formula auditing

    * Share and protect workbooks

    * Automate workbook functionality

    * Create Sparkline’s and map data

    * Forecast data

    Prerequisite: Excel 2016 Beginner and Intermediate or equivalent knowledge

  • 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:

    * Get started with Power Pivot

    * Visualize Power Pivot data

    * Work with advanced functionality in Power Pivot

 

Print page