The Advanced Excel, Power Pivot & VBA Bundle
- Offered byUDEMY
The Advanced Excel, Power Pivot & VBA Bundle at UDEMY Overview
Duration | 31 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
The Advanced Excel, Power Pivot & VBA Bundle at UDEMY Highlights
- Earn a certificate upon completion
- 30-Day Money-Back Guarantee
- Get Full lifetime access
The Advanced Excel, Power Pivot & VBA Bundle at UDEMY Course details
- Those wanting to automate Excel task or procedures
- Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
- Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge
- Learn to unlock advanced Excel tools Power Query and Power Pivot
- Averages, percentiles, and LINEST functions
- Calculating depreciation and interest and other Financial & Statistical? Functions
- PivotTables and Pivot Charts, Sparklines and data bars
- Importing data from other data sources
- Advanced data analysis techniques including Power Query
- How to automate tasks and operations that you perform frequently
- General syntax rules, what keywords are, and how to add comments
- In this 4-course bundle, you get over 20 hours of expert-led video training on Advanced Excel, Power Pivot, Power Query and VBA
- You’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information before looking at Visual Basic for Applications for Excel
The Advanced Excel, Power Pivot & VBA Bundle at UDEMY Curriculum
Advanced Excel 2019 Course
What's new/different in Excel 2016
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
VBA for Beginners
Introduction to VBA as a language (syntax and keywords)
How to automate repetitive tasks
Macros, subroutines and logical constructs
Introduction to VBA functions including returning values from functions
Writing an array formula
Key Objects and error handling in VBA
PivotTable and Chart Objects
Intermediate VBA
Deeper dive into the VBA Language
Core VBA module interactions
Advanced parameter definitions
Excel events including pre-defined and event parameters
Custom Objects including creating and defining a Class
Creating and designing a Userform
Modifying the Excel interface and UI
External references and Office Interlop
The ADODB and Scripting Libraries
Power Pivot, Power Query & DAX
How to get started with Power Query
How to connect Excel to multiple workbooks
How to get data from the web and other sources
How to merge and append queries using Power Query
How the Power Pivot window works
How to set up and manage relationships in a data model
How to create a PivotTable to display your data from the Power Pivot data model
How to add calculated columns using DAX
How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
All about creating Pivot Charts and PivotTables and using your data model
How to use slicers to adjust the data you display
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?