Advance Excel Solved Assignments-Real Challenges - 13 hrs

Name: Advance Excel Solved Assignments-Real Challenges - 13 hrs
Rating: 4.4 (16 reviews)

Crack your Advance Excel interview Tests - Solved Assignments

Created byajay parmar

Last updated 12/2024

English

English [Auto],

What you'll learn

This course has Solved Assignments on Basic plus Advance Excel topics. Mostly, it is advance level questions solved on every topic.
If you are good in advance excel and want to gain more confidence and clear interviews or want to see how real situations confuses, you can join this course.
It will help you in preparing for advance excel interviews.
Assignments are on Vlookup, Match, Index, SumIFs, CountIFs, Mid, Left, Right , substitute, Data validation, Indirect, Offset, conditional formatting ,chart , pivot level advance topics.
I conducted a surprise test for my live online students and giving you same in this course. Lecture has detailed discussion on how each student had solved it and if correction required, it is done and explained in lecture for your benefit.

Course content

1 section • 23 lectures • 13h 5m total length

A Quick Walk-through- What are we covering and Why you need it?8:53
Discover advanced Excel assignments with real-world challenges. Learn to select and combine formulas—lookup, index, and match—master conditional formatting and date/time functions, with downloadable solutions.
VLookUp and Match Solved56:51
Master vlookup and match to solve real excel assignments, retrieving exact matches from single and multiple tables, handling horizontal layouts, dynamic headers, and common data-cleaning issues.
Vlookup and Match Assignments continues1:03:42
IF with Vlookup questions29:15
Error Handlers questions24:57
Master error handling in Excel by using vlookup with iferror and iserror across multiple tables, with practical exercises on not found scenarios, and applying salary hike logic based on tenure.
Error handlers questions continues30:42
TEXT function Part147:01
Learn to extract substrings in Excel using text functions, mid, find, left, and right. Apply trim and substitute, and explore vlookup, hlookup, and xlookup for data retrieval.
TEXT Functions more questions12:33
TEXT Functions continues12:37
Master text functions in excel by extracting last names with mid and find, trimming spaces, and applying vlookup with trimmed keys and iserror handling to return rank and status.
INDEX and MATCH Questions - Part114:37
INDEX and MATCH Questions - Part25:32
Apply index and match to locate an employee id in a table, determine the row number and header, and handle not found errors with vlookup as an alternative.
INDEX and MATCH Questions - Part35:28
count and sum family questions34:51
INDIRECT FUNCTION Solved Assignments1:18:38
Super advance level fun with INDIRECT Function. Its a magical function , When there is no one, there is INDIRECT to rescue you.
CONDITIONAL FORMATTING Assignments35:18
Master conditional formatting in Excel using formulas and rules to color values over 75 or under 50, highlight entire rows, test lists, and flag dates within 30 days.
DATE and TIME Assignments59:21
Master date and time concepts in Excel, including month start, week numbers, quarters, end-of-month, day names, holidays, and age calculations with datedif.
OFFSET Assignments24:08
Master offset assignments in Excel by using a dynamic starting point and a reference to move through rows and columns, creating robust arrays.
A Surprise Test I had conducted in my Training - Part156:37
I given a surprise test to students and duration was 1 hour. You can download the Excel test file , if you like to attempt it before watching the solutions.
Surprise Test Part229:30
In continuation to part1....
Surprise Test Part339:19
Recently, I had conducted one more test in my new batch. They did a good job in the test. Why dont you go ahead and try first doing all question . You have 30 min to 1 hour depending on your speed in excel but not more than 1 hour.
This test was covering Hlookup , match, vlookup, if functions, countifs, sumifs and most importantly pivot and its slicers along-with charts. All the best
Find Latest Date Sales Count if it is not zero - Filter -Sort and Index together13:40
How to create a template which shuffles the list of offers randomly25:11
Create a reusable Excel template that shuffles top offers using random between, indirect and address, then ensure uniqueness with ranking and countif so each daily extract remains non-repetitive.
15 Questions - Mix exercise - Indirect | Row | IF | Vlookups1:16:26

Requirements

You should have a good knowledge of advance excel functions including basics.
Not meant for basic excel users. It has difficult questions solved and one should know basics and have clear understanding of functions before taking this course.

Description

This course is strictly for intermediate and advance excel Users. We are providing solution to complex scenarios in excel which will help you data handling and analysis very well.
if you are not expert or use Excel very often , this course is not for you, This course expects a good knowledge of Excel functions from you.
Course is covering all Excel functions one by one starting from basic to advance. It has assignments and solutions too for your help.
INDEX, MATCH, VLOOKUP. HLOOKUP, IF, NESTED IFs, CONDTIONAL FORMATTING Amazing challenges, Difficult INDIRECT questions, verstaitl ADDRESS function, simple yet useful ROW, COLUMN functions, SUMIF,COUNTIF, WILD CHARACTERS, use , ADVANCE FILTER , OFFSET, CHARTS, PIVOTS - all such amazing functions and topics are covered in the form of assignments with solutions.
It is not just a function but how we can solve the questions by writing more than one function in a single formula is what you are going to learn.
Solutions provided for above functions are mainly on advance level complex situations to train your mind harder and make you ready to face the real world challenges.
By finishing this course, you will never face any difficulties in solving any difficult situation. You mind will be more creative , innovative and you will have more than one solution for every situation. You shall be able to clear any written Excel test from the moment you finish the course.

Who this course is for:

All those professionals or students who work in excel and are not able to think or imagine how to handle a complex task beyond certain point.
You know Excel functions but get confused when it comes to real world data handling.