17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
The Advanced Excel, Power Pivot & VBA Bundle
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
**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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.pad/0
63 B
TutsNode.net.txt
63 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/1. Introduction to Excel 2019 Advanced Course/2. WATCH ME Essential Information for a Successful Training Experience.srt
2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/1. Introduction to Excel 2019 Advanced Course/3. Excel 2019 Advanced Course Exercise Files.html
947 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/1. Introduction to Excel 2019 Advanced Course/4. Excel 2019 Advanced Course Demo Files.html
945 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/1. Introduction to Excel 2019 Advanced Course/5. Downloadable Course Transcripts.html
718 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/1. Introduction to Excel 2019 Advanced Course/5.1 Microsoft Excel 2019 Advanced Course by Simon Sez IT .pdf
911.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/10. Tables/1. Introduction to Tables.srt
14.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/10. Tables/5. Exercise 6.srt
1.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/10. Tables/6. Section 10 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/11. Pivot Tables/2. Working with Pivot Tables.srt
15.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/11. Pivot Tables/3. Filters and Slicers.srt
15.5 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/12. Data Analysis/2. Scenario Manager.srt
13 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/12. Data Analysis/4. Solver.srt
13.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/16. Essential VBA Training for Excel - Automate Repetitive Tasks Introduction/3.1 VBA-Exercise-and-Solution-Files.zip
352.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/17. The Environment/2. The VBA Editor.srt
12.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/18. VBA as a Language/3. Variables and Method Calling Rules.srt
13 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/18. VBA as a Language/4. How to Define and Manage Variables.srt
13.5 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/19. Introducing Macros/6. Looping Collections and the For Each Loop.srt
6.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/2. Functions/1. Functions - Part 1.srt
16.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/2. Functions/4. Section 2 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/20. Introducing Functions/5. The Worksheet Function Object.srt
12.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/21. Common Keys to VBA/1. The Application Object.srt
14.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/21. Common Keys to VBA/2. The Workbook and Worksheet Objects.srt
16.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/21. Common Keys to VBA/3. Using Errors to Guide You.srt
17.8 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/21. Common Keys to VBA/6. The Chart and ChartObject Objects.srt
13.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/21. Common Keys to VBA/7. The PageSetup Object and Print Ranges.srt
16.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/21. Common Keys to VBA/8. One Approach To Completing Exercise 8.srt
18.5 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/23. VBA Intermediate Training Discover Excel Automation Secrets/3.1 VBA-Intermediate-Exercise-Files.zip
1.3 MB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/23. VBA Intermediate Training Discover Excel Automation Secrets/4.1 VBA-Intermediate-Support-Files.zip
636.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/24. VBA Language Details/6. The VBA Project Model.srt
17.8 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/24. VBA Language Details/7. Advanced Parameter Definitions.srt
16 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/25. Excel Events/4. A Series Of Example Events.srt
13.8 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/11. Creating a Userform.srt
15.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/12. Designing a Userform.srt
17.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/13. Coding a Userform.srt
14.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/3. Create a New Class.srt
13.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/4. Defining a Class.srt
13.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/5. Practical Example of a Class.srt
15.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/7. Special Class Variables and Components.srt
13.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/26. Custom Objects/8. Initialization and Termination.srt
13.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/27. External References and Office Interop/1. Modding the Excel Interface.srt
17.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/27. External References and Office Interop/3. UI Interface Control Options and Access.srt
13.8 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/27. External References and Office Interop/4. Piecing the UI Pieces Together.srt
12.6 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/3. Date and Time Functions/3. Complex Date and Time Functions.srt
13 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/30. Power Pivot, Power Query & Dax Introduction/3.1 Exercise Files.zip
1.3 MB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/31. Getting Started with Power Query/4. Import Multiple Files from a Folder.srt
13.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/32. Useful Power Query Features/7. Conditional Columns in Power Query.srt
8 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/36. Using PivotTables and Slicers/1. Create PivotTables and PivotCharts.srt
13.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/38. Advanced Pivot Tables Introduction/5. PivotTables Recap.srt
18.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/39. Importing Data/1. Importing data from a text file.srt
14.6 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/4. Text Functions/1. Using Text Functions - Part 1.srt
14.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/4. Text Functions/2. Using Text Functions - Part 2.srt
13.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/4. Text Functions/3. Section 4 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/40. Preparing Data for Analysis/1. Cleaning Data.srt
25.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/40. Preparing Data for Analysis/2. Tabular Data.srt
22.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/41. Creating and Manipulating PivotTables/1. Creating and Manipulating a PivotTable.srt
17.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/41. Creating and Manipulating PivotTables/2. Combining Data from Multiple Worksheets.srt
17.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/41. Creating and Manipulating PivotTables/3. Grouping and Ungrouping.srt
15.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/41. Creating and Manipulating PivotTables/4. Report Layouts.srt
15.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/42. Formatting PivotTables/1. PivotTable Styles.srt
16.6 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/42. Formatting PivotTables/2. Custom Number Formatting.srt
23 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/43. Value Field Settings/1. Summarizing Values.srt
15.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/44. Sorting and Filtering/2. Advanced Filtering.srt
19.4 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/45. Interacting with PivotTables/1. Inserting and formatting Slicers.srt
19.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/46. Calculations/3. Solve Order and List Formulas.srt
13.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/47. Pivot Charts/1. Creating a Pivot Chart.srt
16.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/47. Pivot Charts/2. Formatting a Pivot Chart - Part 1.srt
22.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/47. Pivot Charts/3. Formatting a Pivot Chart - Part 2.srt
23.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/47. Pivot Charts/4. Creating a Map Chart using Pivot Data.srt
16.5 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/47. Pivot Charts/5. Dynamic Chart Titles.srt
19.5 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/47. Pivot Charts/6. Include a Sparkline with your PivotTable.srt
15 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/48. Conditional Formatting/1. Highlighting Cell Rules.srt
13.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/48. Conditional Formatting/2. Graphical Conditional Formats.srt
15 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/49. Dashboards/1. Creating an Interactive Dashboard - Part 1.srt
32.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/49. Dashboards/2. Creating an Interactive Dashboard - Part 2.srt
19.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/5. Logical Functions/2. Exercise 01.srt
2.5 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/5. Logical Functions/3. Section 5 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/51. Extras/1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4
555.3 MB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/51. Extras/1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.srt
83.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/51. Extras/2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html
29 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/52. Bonuses/1. Ten Excel Tips and Tricks - Part 1.mp4
336.6 MB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/52. Bonuses/1. Ten Excel Tips and Tricks - Part 1.srt
61.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/52. Bonuses/2. Ten Excel Tips and Tricks - Part 2.srt
58.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/52. Bonuses/3. Ten Excel Tips and Tricks - Part 3.srt
47.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/6. Lookup Functions/1. Lookup Functions - Part 1.srt
16.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/6. Lookup Functions/4. Section 6 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/7. Financial Functions/5. Exercise 03.srt
1.9 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/7. Financial Functions/6. Section 7 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/8. Statistical Functions/1. Statistical Functions for Description - Part 1.srt
14.6 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/8. Statistical Functions/2. Statistical Functions for Description - Part 2.srt
16.1 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/8. Statistical Functions/4. Statistical Functions for Forecasting - Part 2.srt
14 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/8. Statistical Functions/5. Exercise 04.srt
2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/8. Statistical Functions/7. Statistical Functions for Inference.srt
12.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/8. Statistical Functions/8. Section 8 Quiz.html
185 B
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/9. Connecting to External Data/1. Connecting to Other workbooks.srt
16.3 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/9. Connecting to External Data/2. Connecting to Access Databases.srt
15.7 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/9. Connecting to External Data/4. Get and Transform.srt
18.2 KB
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle/9. Connecting to External Data/6. Section 9 Quiz.html
