Description
**This course includes practice exercises and LIFETIME access**
Get beyond the basics and supercharge your current Excel skills.
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.
Advanced Excel 2019 Course
What You’ll Learn
- 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
What You’ll Learn
- 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
What You’ll Learn
- 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
What You’ll Learn
- 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
Advanced PivotTables in Excel
What You’ll Learn
- How to do a PivotTable (a quick refresher)
- How to combine data from multiple worksheets for a PivotTable
- Grouping, ungrouping, and dealing with errors
- How to format a PivotTable, including adjusting styles
- How to use the Value Field Settings
- Advanced Sorting and Filtering in PivotTables
- How to use Slicers, Timelines on multiple tables
- How to create a Calculated Field
- All about GETPIVOTDATA
- How to create a Pivot Chart and add sparklines and slicers
- How to use 3D Maps from a PivotTable
- How to update your data in a PivotTable and Pivot Chart
- All about Conditional Formatting in a PivotTable
- How to create amazing looking dashboards
***Exercise and demo files included***
This bundle includes:
- 5 distinct courses in one!
- 28+-hours of video tutorials
- Over 200 individual video lectures
- Exercise files to practice what you learned
- Demo files used by the trainer
- Certificate of completion
This course is designed for students that already have a good understanding of Microsoft Excel and are looking to take their capabilities to the next level.
If you’re already using Excel to a high standard and are looking to start using more complex functions and automate repetitive tasks, then this 3-course bundle is for you. These courses are packed with practical examples of how you’d apply these new skills in a business context.
Here’s what our students are saying…
“So far, this class is great; it is exactly the speed I need. I like that I can pause the video and try something or go back and watch it again if I missed something. So much better than the 8-hour classes where the instructor breezes through everything in a whirlwind!”
– Christy Sobczak
“Very easy to follow and looking forward to learning more from the instructor. Very riveting. Looking forward to learning more. Thanks. I recommend this instructor. He is very knowledgeable. There’s a lot of material and I’m learning a lot. I hope I can remember it all.”
– Bob Santero
“It’s been an amazing experience! Worth to try it… There are so many things I didn’t know about, and it’s a good opportunity EXCELLENT WORK !!! HIGHLY RECOMMEND IT!!!”
– Andriana
Who this course is for:
- 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.
Requirements
- Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
- Intermediate knowledge of Microsoft Excel.
- Beginner knowledge of Excel for VBA.
- You’ll need a copy of Microsoft Excel that is compatible with the Power Pivot tool.
Last Updated 12/2022
Total Size: 15.8 GB
Download Links
Torrent Download
The Advanced Excel, Power Pivot & VBA Bundle.torrent (250 KB) | Mirror
