Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advance Excel Solved Assignments-Real Challenges - 13 hrs
Rating: 4.4 out of 5(16 ratings)
113 students

Advance Excel Solved Assignments-Real Challenges - 13 hrs

Crack your Advance Excel interview Tests - Solved Assignments
Created byajay parmar
Last updated 12/2024
English

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
  • VLookUp and Match Solved56:51
  • Vlookup and Match Assignments continues1:03:42
  • IF with Vlookup questions29:15
  • Error Handlers questions24:57
  • Error handlers questions continues30:42
  • TEXT function Part147:01
  • TEXT Functions more questions12:33
  • TEXT Functions continues12:37
  • INDEX and MATCH Questions - Part114:37
  • INDEX and MATCH Questions - Part25:32
  • 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
  • DATE and TIME Assignments59:21
  • OFFSET Assignments24:08
  • 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
  • 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.

Report abuse