-
Book Overview & Buying
-
Table Of Contents
Microsoft Excel Advanced 2019
By :
Microsoft Excel Advanced 2019
By:
Overview of this book
Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Advanced-2019
Table of Contents (15 chapters)
Introduction to Excel 2016 Advanced Course
Functions
Date and Time Functions
Text Functions
Logical Functions
Lookup Functions
Financial Functions
Statistical Functions
Connecting to External Data
Pivot Tables
Data Analysis
Graphs and Charts
Excel Web App
Course Conclusion
This video is locked
