Conquer Excel: Unlocking Solutions to Solve Any Problem

Name: Conquer Excel: Unlocking Solutions to Solve Any Problem
Rating: 4.4 (3 reviews)

Master Key Excel Functions and Tools to Simplify Complex Challenges Effortlessly with Free Excel Add-in

Created byRobin Gupta

Last updated 2/2026

English

What you'll learn

Fundamentals of Excel including navigation, data entry, and the principles of spreadsheet organization.
Complex formulas and functions to analyze data, including logical functions , lookup functions , and other features like Advance Filter
How to use dynamic arrays and new functions like FILTER, SORT, UNIQUE, SEQUENCE, and XLOOKUP to manage and analyze datasets efficiently.
Solving Real-World Problems through practical examples and case studies that show how to solve common business and data analysis problems with Excel.
By the end of this course, students will be equipped with the knowledge and skills to tackle any problem in Excel.

Course content

7 sections • 68 lectures • 2h 0m total length

Introduction0:47
Master Excel problem solving with a handful of powerful functions to simplify complex challenges and streamline your workflow, one formula at a time.

Download practice file
How to navigate multiple sheets easily1:19
Copy data from excel Status bar1:03
Quickly Filter your data by right clicking0:51
How to use Format painter to format multiple cells1:14
Generate a series of number using Fill series1:55
How to Insert blank row after every n number of rows1:59
Excel Fill Series - Create a List Increasing by 10% Each Time2:04
Auto-fill Complex Date Sequences1:35
Excel Flash Fill feature Masterclass2:53
Excel Paste Special Technique - Perform arithmetical calculations1:40
Excel Paste Special Technique - Excel Skip blank feature0:59
Excel Auto Sum Trick0:50
Emoticons in excel formulas2:21
Excel Shift cell features for inserting and deleting cells and range2:17
How to delete blank rows in a dataset1:02
How to fill down cells with value above it1:09
How to fill above cells with values below it1:37
Data validation Basics1:52
How to search data validation cells in a sheet1:02
Excel Goal seek1:51
Excel Name Manager2:15
MS Excel Tables And Table slicers3:47
How to convert a table back to normal range0:46
Find and replace formats1:47
How to clear existing formats from the Find and replace function0:55
Find and replace using wildcards1:08
How to apply same function / formula on multiple sheets1:02
Get sum of only visible rows in excel1:12
Excel Hack - Apply a formula at multiple places2:04
Find a function in Search Bar and add it to Quick Access Toolbar1:00

Download working file0:01
How to use Advance Filter2:19
Advance Filter function to get data based on headings2:45
Using Advance Filter with wildcards5:30
Filter data with multiple criteria's "AND logic"1:37
Filter data with multiple criteria's "OR logic"1:22
Filter data using both "AND" and "OR" logic at the same time1:43
Filter data that contain blanks1:51
Filter dataset excluding blanks1:16
Filter based on Range1:22

Download Practice File0:01
Search Function2:38
Discover how the Excel search function locates text within a range, returning the starting position, with examples using Emily, Reynolds, and car, and its use with other formulas.
Textjoin and Textsplit Function2:55
Master text join and text split in Excel to merge a range with a delimiter and split data into rows or columns while ignoring empty text.
Text After and Text Before Function3:29
Master text after and text before formulas in Excel 365 to extract text using a space delimiter and instance number, pulling items such as Excel 365 or 365.
Vstack Function1:20
Discover how to use the Vstack function to vertically stack multiple arrays into a single column in Excel, demonstrated by aligning month names from January to December.
Hstack Function1:11
Demonstrate how to use the HStack function to horizontally combine two arrays, linking data from different sheets and applying a familiar VStack approach for efficient data consolidation.
ToRows and ToCols function1:26
Explore the ToRows and ToCols functions in Excel Office 365 to reshape data arrays into a single row or a single column.
Sumifs and Countifs2:56
Learn how to use sumifs and countifs with sum ranges, criteria ranges, and multiple criteria, make references absolute, and apply formulas across countries.
Choose Function3:56
Master the dynamic choose formula to select data by index, using it with data validation and xlookup or vlookup for country-based lookups across ranges and tabs.
Indirect Function3:13
Learn to use the indirect formula in Excel to pull a country’s sum and average from separate sheets by constructing dynamic sheet references and dragging the formula.
Aggregate Function2:22
Learn to use the aggregate function in Excel to handle errors, such as division by zero, by ignoring error values for accurate sums and averages.
Replace and Substitute Formula2:54
Learn to use the replace function to mask digits in a cell by replacing two characters with an asterisk, and apply the substitute function to replace a substring like 'sun'.

Requirements

Basic Excel Knowledge

Description

Do you struggle with solving complex problems in Excel?

Welcome to Conquer Excel: Unlocking Solutions to Solve Any Problem—a comprehensive course designed to help you master Excel with simplicity and precision.

In this course, you’ll discover how a few powerful Excel functions can handle the majority of challenges, eliminating the need to memorize hundreds of formulas. Learn practical tips, tricks, and techniques that save time, improve efficiency, and make you an Excel expert.

Here’s what you’ll gain:

A deep understanding of the most impactful Excel functions.
The ability to solve real-world problems with minimal effort.
Insights into simplifying data analysis and automation.
Access to the Excel Tailor add-in—your free companion with 50+ custom functions to enhance your workflow.

Who is this course for?
This course is perfect for professionals, students, or anyone who wants to tackle Excel challenges with ease, whether you're a beginner or have years of experience.

With this course, you'll transform the way you work in Excel, turning hours of frustration into minutes of seamless productivity!

By the end of this course, you’ll not only conquer complex Excel problems but also gain the confidence to approach any spreadsheet with clarity and mastery.

Join us now and unlock the full potential of Excel!

Who this course is for:

Intermediate Excel Users who have a basic understanding of Excel but wish to advance their skills in analyzing data, using complex formulas, and creating dynamic reports
Advanced Excel Users looking for a refresher course on new Excel features or to deepen their knowledge in specific areas like dynamic arrays, advanced data analysis techniques
Business Professionals across various sectors (finance, marketing, HR, operations, etc.) who rely on Excel for data analysis, reporting, budgeting, and decision-making processes.
Educators and Trainers looking to enhance their teaching methodologies and incorporate Excel into their curriculum.
Anyone with a curiosity about Excel and a desire to unlock its full potential to make informed decisions based on data analysis.

Conquer Excel: Unlocking Solutions to Solve Any Problem

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Expert Techniques and Hidden Features31 lectures • 47min

Advance Filter Masterclass10 lectures • 20min

Filtering data with "Filter" formula5 lectures • 9min

Advance Lookups Techniques8 lectures • 15min

How to solve complex excel problems in minutes with these lesser used functions12 lectures • 28min

Excel Challanges1 lecture • 1min

Requirements

Description

Who this course is for: