Conquer Excel: Unlocking Solutions To Solve Any Problem

Master Key Excel Functions and Tools to Simplify Complex Challenges Effortlessly

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.

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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Expert Techniques and Hidden Features

Lecture 2 Download practice file

Lecture 3 How to navigate multiple sheets easily

Lecture 4 Copy data from excel Status bar

Lecture 5 Quickly Filter your data by right clicking

Lecture 6 How to use Format painter to format multiple cells

Lecture 7 Duplicate window of same workbook

Lecture 8 Generate a series of number using Fill series

Lecture 9 How to Insert blank row after every n number of rows

Lecture 10 Excel Fill Series - Create a List Increasing by 10% Each Time

Lecture 11 Auto-fill Complex Date Sequences

Lecture 12 Excel Flash Fill feature Masterclass

Lecture 13 Excel Paste Special Technique - Perform arithmetical calculations

Lecture 14 Excel Paste Special Technique - Excel Skip blank feature

Lecture 15 Excel Auto Sum Trick

Lecture 16 Emoticons in excel formulas

Lecture 17 Excel Shift cell features for inserting and deleting cells and range

Lecture 18 How to delete blank rows in a dataset

Lecture 19 How to fill down cells with value above it

Lecture 20 How to fill above cells with values below it

Lecture 21 Data validation Basics

Lecture 22 How to search data validation cells in a sheet

Lecture 23 Excel Goal seek

Lecture 24 Excel Name Manager

Lecture 25 MS Excel Tables And Table slicers

Lecture 26 How to convert a table back to normal range

Lecture 27 Find and replace formats

Lecture 28 How to clear existing formats from the Find and replace function

Lecture 29 Find and replace using wildcards

Lecture 30 How to apply same function / formula on multiple sheets

Lecture 31 Get sum of only visible rows in excel

Lecture 32 Excel Hack - Apply a formula at multiple places

Lecture 33 Rearrange Data using "SORT" function

Lecture 34 Excel Consolidate

Lecture 35 Excel Consolidate - Consolidate data from different worksheets

Lecture 36 Find a function in Search Bar and add it to Quick Access Toolbar

Section 3: Advance Filter Masterclass

Lecture 37 Download working file

Lecture 38 How to use Advance Filter

Lecture 39 Advance Filter function to get data based on headings

Lecture 40 Using Advance Filter with wildcards

Lecture 41 Filter data with multiple criteria's "AND logic"

Lecture 42 Filter data with multiple criteria's "OR logic"

Lecture 43 Filter data using both "AND" and "OR" logic at the same time

Lecture 44 Filter data that contain blanks

Lecture 45 Filter dataset excluding blanks

Lecture 46 Filter based on Range

Section 4: Filtering data with "Filter" formula

Lecture 47 Download working File

Lecture 48 Filter Function - Formula

Lecture 49 Difference between Advance Filter function and FILTER formula in excel

Lecture 50 Use Filter formula for "AND" logic

Lecture 51 Use Filer formula for "OR" logic

Lecture 52 How to use Filter formula for using both "AND" and "OR" logic

Lecture 53 Use Filter with other formulas

Section 5: Advance Lookups Techniques

Lecture 54 Download working file

Lecture 55 How to use X lookup for lookup and reverse lookup

Lecture 56 Vlookup with Match function

Lecture 57 Lookup to return a list with horizontal form of data

Lecture 58 Lookup to return a list when the data is in vertical form

Lecture 59 Two ways to get an approximate match using Xlookup and Vlookup

Lecture 60 Get Lookup value based on multiple criteria's

Lecture 61 Perform X lookup on multiple sheets at a same time

Lecture 62 Two way lookup

Lecture 63 Index Match Dynamic Lookup

Lecture 64 Xlookup with "MAX" formula scenario

Section 6: How to solve complex excel problems in minutes with these lesser used functions

Lecture 65 Download Practice File

Lecture 66 Search Function

Lecture 67 Textjoin and Textsplit Function

Lecture 68 Text After and Text Before Function

Lecture 69 Vstack Function

Lecture 70 Hstack Function

Lecture 71 ToRows and ToCols function

Lecture 72 Sumifs and Countifs

Lecture 73 Choose Function

Lecture 74 Indirect Function

Lecture 75 Aggregate Function

Lecture 76 Replace and Substitute Formula

Section 7: Excel Challanges

Lecture 77 Download Working File

Lecture 78 Get unique values from a table in a single column

Lecture 79 Get multiple matches of a lookup value

Lecture 80 How to get Lookup value from a data which is in table format

Lecture 81 Lookup for partial matches using Filter formula_1st scenario

Lecture 82 Lookup for partial matches using Filter formula_2nd scenario

Lecture 83 Merge Data from different sheets in a single sheet

Lecture 84 Match positive and negative numbers in a column

Lecture 85 Split Data in multiple sheets trick

Lecture 86 Prevent duplicate entry in a list through data validation

Lecture 87 Create an ageing report

Lecture 88 Auto updating of dropdown list

Section 8: The Excel-Tailor Addin to solve complex excel problems

Lecture 89 Download Excel Tailor Add-in with more then 50 functions

Lecture 90 How to add this add-in in your workbook

Lecture 91 Create a table of content

Lecture 92 Create Multiple Folders / Workbook from a range

Lecture 93 Rename multiple sheets, Import workbook, Export Sheets, Arrange sheet in order

Lecture 94 Select data till last row, Date picker in Excel, Trim data and Insert Calendars

Lecture 95 Easy Data Validation

Lecture 96 Copy Formula as values in filtered cells

Lecture 97 Get Auto sum at top of columns and Add text feature

Lecture 98 Dynamic Filter

Lecture 99 Get Header Data

Lecture 100 Dynamic Lookup

Lecture 101 Match data

Lecture 102 Split Data

Lecture 103 Highlight each pair of duplicate in different color

Lecture 104 Formulas and functions

Lecture 105 Excel Protection

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.