Microsoft Excel Advanced 2019: Learn and master Excel 2019 by learning advanced functions and formulas

Simon Sez IT

$92.99

5 (1 Ratings)

Video Aug 2019 8hrs 5mins 1st Edition

Simon Sez IT

$92.99

5 (1 Ratings)

Video Aug 2019 8hrs 5mins 1st Edition

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Download Code

Key benefits

Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information
Learn and master advanced charting and graphing in Excel

Description

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

Who is this book for?

This course is designed for those who have basic knowledge of Excel 2019/365 and those upgrading from previous software versions

What you will learn

What s new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
How to create awesome visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek, and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts