Video description
Learn and master Excel 2019 by learning advanced functions and formulas
About This Video
- 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
In Detail
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.
Who this book is for
This course is designed for those who have basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Publisher resources
Table of contents
- Chapter 1 : Introduction to Excel 2016 Advanced Course
- Chapter 2 : Functions
- Chapter 3 : Date and Time Functions
- Chapter 4 : Text Functions
- Chapter 5 : Logical Functions
- Chapter 6 : Lookup Functions
- Chapter 7 : Financial Functions
- Chapter 8 : Statistical Functions
- Chapter 9 : Connecting to External Data
- Chapter 10 : Tables
- Chapter 11 : Pivot Tables
- Chapter 12 : Data Analysis
- Chapter 13 : Graphs and Charts
- Chapter 14 : Excel Web App
- Chapter 15 : Course Conclusion
Product information
- Title: Microsoft Excel Advanced 2019
- Author(s):
- Release date: August 2019
- Publisher(s): Packt Publishing
- ISBN: 9781839219832
You might also like
video
Microsoft Excel - Pivot Tables In-Depth
In this Microsoft Excel – Pivot Tables training course, expert author Erin Olsen teaches you everything …
video
Microsoft Excel - Advanced Formulas And Functions
In this Microsoft Excel Advanced Formulas and Functions training course, expert author Guy Vaccaro takes you …
video
Big Data Analytics with Excel
In this Big Data Analytics with Excel training course, expert author Guy Vaccaro teaches you how …
video
Excel VBA and Macros with MrExcel (Video Training)
DVD includes: 7+ HOURS OF VIDEO INSTRUCTION 50 TIPS & TECHNIQUES SKILLS YOU CAN LEARN IN …