KEY FEATURES
The course discusses a dynamic formula and lets students consider if VLOOKUP is a dynamic formula. The course also illustrates the top 10 dynamic formulas, including dynamic range, formula, table formula, conditional formula, sumproduct, indirect address, an array formula. Lastly, the course explores the latest features from Excel 365 that are considered by many to be amazing. They include sort and Xlookup.
- Access 23 lectures & 2 hours of content 24/7
- Learn about intermediate to advance Excel skills that will help you
- Understand Excel's state-of-the-art functions
- Ace your Excel skills
- Make yourself the go-to-person in your office
- Become well-positioned for your next prmotion
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
The course is presented in five parts. First, the course relates to the earlier course of Top 5 Excel Skills to drive the concept home: Building your own “Bot” is your ticket to full automation in Excel Modeling. Next, the course discusses what VBA macro is and lets students consider when to and when not to build a macro. Third, this course illustrates 6 required steps to build your own report generating “Bot.” Fourth, the course illustrates 4 real cases that should not require building a VBA macro. Lastly, the course explores best practices in building VBA macros.
- Access 23 lectures & 2 hours of content 24/7
- Discover & understand VBA macro as 4th Gen of Excel modeling techniques
- Identify 3 elements of a VBA macro
- Recognize when to build a VBA macro and when not to
- Discover 5 elements of a VBA environment
- Explore 5 steps required to build a reporting generating “Bot”
- Discover & understand 4 best practices of building a VBA macro
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
The course is presented in three parts. First, the course introduces the concept of automatically connecting to the external data sources with the latest technologies to save time by avoiding manual data entry as much as possible. Next, the course raises 4 areas where data entry can be automated. Last, the course demonstrates how to connect to external data to obtain the real-time update of data – all without typing. By the end of this course, you will learn how to eliminate data entry.
- Access 21 lectures & 1.5 hours of content 24/7
- Discover & understand 4 situations we can automate data entries
- Recognize 3 different ways to convert data in a PDF file to an Excel file
- Identify 2 Excel functions to connect to online tables and refresh instantly
- Explore & master 11 essential text converting formulas in Excel to transform poor-formatted data in banking statements to analyzable data
- Discover 2 methodologies in modern accounting systems that can integrate system data into Excel files
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
The course is presented in four parts. First, the course reviews the 4 reporting methods introduced in an earlier course. Next, the course furthers the idea of API reporting in Excel and demonstrates all 4 methodologies by using one state-of-the-art cloud planning software. Last, we illustrate the top 7 features of Excel API Add-in in generating low-maintenance, fully automated financial reports. By the end of this course, you will have learned API reporting in Excel.
- Access 26 lectures & 1 hours of content 24/7
- Understand key features of API reporting
- Discover 5 ways of reporting out of a financial system
- Differentiate between reporting based on “extracted” Excel report & “attached” Excel report
- Discover latest technology of “writing back” data from Excel into the system
- Explore 7 amazing features OfficeConnect brings to us in dynamic API reporting
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
The course is presented in three parts. First, this course reveals the 3 environment forecasts and budgets made and compared with each other. Next, the course preset 6 challenges in budget modeling and reporting. Lastly, the course will provide 6 solutions to the challenges mentioned not too long ago. By the end of this course, you will have learned how to build interactive budgeting models in Excel.
- Access 22 lectures & 1.5 hours of content 24/7
- Understand when & how to build an interactive budgeting model in Excel
- Identify reasons in building a Pivot Table report vs a regular report with formulas
- Discover techniques on building an “editable” Pivot Table
- Understand ways to report budgets from the System using a Pivot Table
- Explore methods of consolidating Actuals & Budgets from multiple data sources
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
The course is presented in five parts. The first part reveals that Excel has as many as 7 languages needed for proper modeling. The next part shows as many as 4 types of formulas in Excel, and they are regular formulas, text formulas, table formulas, and conditional formulas. Third, this course explains in detail how to decipher the custom formatting language and proper ways of displaying in thousands, in color, or hidden in its entirety. Lastly, the course reviews the formulas of calculated fields and calculated items using Pivot tables.
- Access 24 lectures & 1 hour of content 24/7
- Master four types of formulas to use in Excel
- Identify two methodologies to format a cell display
- Understand two calculation formulas built in a pivot table
- Discover ways to build a dynamic named range in Excel
- Explore basic VBA codes, M language & DAX language in Excel
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
This course is presented in 4 parts. The first part illustrates where does pivot table stand in Excel techniques, bringing up the topic of when to and when not to use a pivot table. The second part uses a business case to compare ways of reporting on huge data. The third part of this course illustrates the 6 basic and 6 intermediate maneuvers to tame the Pivot Table beast. And for the last part, this course explores the best practices in building a pivot table.
- Access 28 lectures & 1 hour of content 24/7
- Illustrate where the pivot table stand in the Excel techniques
- Know when to & when not to use a Pivot table
- Use a business case to compare ways of reporting huge data
- Illustrate 6 basic & 6 intermediate maneuvers to tame the pivot table beast
- Explore best practices in building a pivot table
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Lenny Wu, MBA, CPA, CGA | Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada. He has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
KEY FEATURES
In Excel, sometimes there is a need to look up information from a table or a different sheet or link the sheets together. This course will show you how to do that with the following functions/formulas: VLOOKUP, HLOOKUP, XLOOKUP, match, index, Xmatch, linking sheets with formulas, and data consolidation. By the end of this course, you will have learned different ways to look up information in Excel.
- Access 8 lectures & 0.5 hours of content 24/7
- Learn different functions or formulas to look up information in Excel
- Understand VLOOKUP, XLOOKUP & HLOOKUP
- Learn how to link sheets & consolidate data
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Thomas Fragale | Microsoft Certified Trainer
Thomas Fragale is a Microsoft Certified Trainer and a computer professional with over 30 years of experience. He has conducted 100 successful webinars and have trained over 300,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and more.
KEY FEATURES
These days, there are tons of data coming in from many sources. You are expected to import all of that data and then get meaningful results from that data. This course will help you do all that. Here, you will learn the fundamentals of Pivot tables, Power Query, and Power Pivot and get meaningful results from tons of data from different sources. You will also learn the importance of these three and how they interact with each other. By the end of this course, you will learn how to use Pivot Tables, Power Query, and Power Pivot.
- Access 27 lectures & 1.5 hours of content 24/7
- Learn the fundamentals of Excel tables, Power Query & Power Pivot
- Get meaningful results from tons of data coming from different sources
- Learn the significance of Excel tables, Power Query & Power Pivot
- Gain knowledge on how to use them effectively
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Thomas Fragale | Microsoft Certified Trainer
Thomas Fragale is a Microsoft Certified Trainer and a computer professional with over 30 years of experience. He has conducted 100 successful webinars and have trained over 300,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and more.
KEY FEATURES
Do you struggle with Excel formulas? Do calculations take a long time, and you know there must be a better way to accomplish things in Excel, but you don’t know where to turn? Then, this course is for you. This course will show you the most popular functions and formulas in Excel and use them very efficiently. You will also be taught how to incorporate these formulas and functions in real documents. This course will make you more productive in Excel.
- Access 13 lectures & 1.5 hours of content 24/7
- Build basic math fomulas
- Understand AutoSum & relative references
- Know absolute references
- Link sheets & workbooks
- Discover formulas & functions in Excel that will help you with your project
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
Thomas Fragale | Microsoft Certified Trainer
Thomas Fragale is a Microsoft Certified Trainer and a computer professional with over 30 years of experience. He has conducted 100 successful webinars and have trained over 300,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and more.
KEY FEATURES
Whether it's for business or personal related projects, everyone wants to be able to use these formulas freely and easily. If you’re ready to gain full control of Excel Formulas today, take the course right now and master the different Microsoft Excel formulas. Here, you will understand the essence of these formulas even without memorizing them. You will also see how each of these formulas is used with real examples. By the end of this course, you will have learned the top 50 Microsoft Excel formulas.
- Access 22 lectures & 1 hour of content 24/7
- Master the top 50 formulas in just 50 minutes
- Understand the essence of these formulas, without memorizing them
- See how each of these formulas is used with real examples
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner/li>
Requirements
- Microsoft Excel
THE EXPERT
SkillSuccess | 2,000+ carefully curated online video courses As featured on CNN, Entrepreneur, Mashable, CNET, TechRadar, and more!SkillSuccess is the hub to learn any skill on your own time, at your own pace. Take your learning anywhere you go on any device including your computer, TV, tablet, or mobile phone. SkillSuccess provides 1,000+ carefully curated and organized online video courses on different categories: from business to lifestyle. Their support team is at your service with a click of a button. Emails answered quickly and live chat standing by. Learn from the experts, earn your skill certificate and share your feedback.
BizTech Matters
Biztech is the book author of 101 Excel Series paperback books, and his courses are focused on SQL, Excel Formulas, Power Query, Power BI, and much more. His passion lies in helping my students in whatever means possible, whether it be reaching them via courses or by books.