Microsoft Excel Advanced 2016
.MP4, AVC, 1920×1080, 30 fps | English, AAC, 2 Ch | 9 hours | 1.51 GB
Created by Simon Sez IT
Become a Microsoft Excel expert with this easy-to-follow course featuring 9-hours of professionally produced videos
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
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
Discover practical methods for financial and statistical functions
Become a Microsoft Excel expert and effectively use it for data analysis
(Buy premium account for maximum speed and resuming ability)