Microsoft Excel Advanced 2016

Become a Microsoft Excel expert with this easy-to-follow course featuring 9-hours of professionally produced videos

Learn

How to import and export data to and from Excel
How to create various charts and graphs
Effectively create and use functions and formulas
Import and export data
Create and effectively use Pivot Tables
How to use Excel for data analysis

About

Through 57 lectures and over 9-hours of content, this course will take you through using functions in everyday work environments. Professional financial functions are covered including payments, future value, and depreciation. Students will learn statistical functions such as averages, percentiles, and regression.

In order to improve efficiency, students will also cover connecting to external data—such as other workbooks or web data—and tables including style, selection, and sizing. Pivot tables and data analysis are key concepts for work environments.

To aid reporting, students will learn about surface charts, stock charts, radar charts, bubble charts, and graphs.

After completing this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms (such as tables, graphs, and pivot tables) in order to show important analyses such as depreciation, percentiles, and regression for use with planning. Students who finish this course will have advanced knowledge of the versatility of Excel that is immediately applicable to work requirements.

All the codes and supporting files for this course are available at: github.com/PacktPublishing/Microsoft-Excel-Advanced-2016

Features

Discover practical methods for financial and statistical functions
Become a Microsoft Excel expert and effectively use it for data analysis