Pay What You Want: The Essential 2021 Excel Wizard Bundle for $1

Purchase Now!
Time-limited Discount

Expires May 01, 2121 23:59 PST
Buy now and get 99% off

Excel Magic 1: Build Dynamic Formulas with Excel

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Excel Magic 2: Build Your Own Report Generating Bots with Excel

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Excel Magic 3: Automating Data Entry with Data Feeds

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Excel Magic 4: Ultimate API Reporting in Excel

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Excel Magic 5: Building Interactive Budgeting Model in Excel

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Excel Magic Part 6: Speaking the 7 Languages in Excel

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Excel Pivot Table: How to Tame the Excel Beast

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Using VLOOKUP, XLOOKUP & Other Functions

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Getting Results with Excel Pivot Tables, Power Query & Power Pivot

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Must-Know Formulas & Functions in Excel

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

NOTE: Software NOT included.

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

4.0/5 Instructor Rating:
★ ★ ★ ★
★ ★

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.

Learn to Use the Top 50 Microsoft Excel Formulas in 50 Minutes

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

NOTE: Software NOT included.

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.

Buy Now!

Featured Products

Special Discounts

Disclosure

Some of the links on this website are ‘affiliate links.’ This means if you click on the link and purchase the item, I will receive an affiliate commission.