Primal EduWorld
Primal EduWorld
  • 14
  • 175 304
Advanced Excel Formulas for Job Interview
#MsExcel #excel #accounting
In this video, we will learn about How to clear Excel interviews.
Learn Basic Excel Formulas & functions to clear Excel Job interviews.
Most useful excel formulas for business and finance professionals.
These excel formulas include SUMIFS, 3D FORMULAS, IF, VLOOKUP, EOMONTH, AGGREGATE, EDATE, WORKDAY, ROUND & TRIM functions.
These awesome formulas will help you increase your productivity and impress your colleagues and superiors.
This video is suitable for all levels of excel and for beginners who are new to formulas and functions, and even more advanced users.
10 Advanced Excel Formulas You Must Know
Essential Excel Formulas for Accounting
Excel Formulas for job interview
Excel for Accountants
Excel Test for Job Interview
Excel Formulas & Functions Questions and Answers
10 Excel Formula used daily at WORK (Excel formula for job interview)
Most useful excel formulas for business & finance professionals.
Excel Formulas and Functions
Excel Interview Questions & Answers | Excel Job Interview
Excel Tutorial For Beginners
Top 10 Most Important Excel Formulas
How to Pass Excel Assessment Test For Job Applications
Excel interview questions for data analyst
Excel interview questions VLookup
Excel interview questions for financial analyst
Advanced excel interview questions and answers
Excel interview questions for business analyst
Excel interview questions quora
Excel question paper
Excel practice tests for interviews
Excel interview questions vlookup
Top 10 Excel Formulas Interview Questions and Answers
Basic excel questions and answers
Timestamps:
00:03 Channel Intro
00:18 Intro: Excel Functions for Interviews
00:51 ROUND Function
02:05 IF Function
03:15 EOMONTH Function
04:39 EDATE Function
06:13 WORKDAY Function
07:37 AGGREGATE Function
09:19 3D FORMALA Function
10:36 IFS Function
14:17 VLOOKUP Function
15:33 TRIM Function
16:24 Outro
zhlédnutí: 4 290

Video

How To Unlock Protected Excel Without Password 🔓
zhlédnutí 935Před 2 lety
#MsExcel Forgot Password for your protected Excel sheets? No Problem! In this video I have explained how to remove the password from a protected Excel spreadsheet. Remove Excel sheet protection without using any recovery software. All you need is a ZIP program like WinRAR or WINZIP! ❗🔐 Keep your data private and secure 🔐❗ ✰ Download Win-Rar here - www.win-rar.com/start.html?&L=0 ✰ ✰ Download Wi...
MAIL MERGE IN MICROSOFT WORD
zhlédnutí 1,8KPřed 2 lety
#mailmerge #emails #letters #preaddressedenvelopes #mailinglabels #MicrosoftWord #Microsoftexcel #document #template #datasource #mergefields #save #export #print #import In this video, we have shown how to perform a mail merge from Microsoft Excel to Microsoft Word so that you can send mass mails to a large group of people. Mail Merge is a powerful tool for writing a personalized letter or e-m...
Draw a House in Python Using Turtle Program *1K Special*
zhlédnutí 11KPřed 2 lety
In this video, we have explained how to draw a house using Turtle program in Python. Big Thank You to our In House Editor- Hifza, for the wonderful job she does at editing our videos!! Audio in this video: Song: Coco Step Alt-15638 Artist: Solomon Rodney, BMI Album: AT01369 Tronic DNA Licensed to CZcams by: AdRev for a 3rd Party (on behalf of Atomica B Publishing, BMI (Atomica Music)), AdRev Pu...
Learn How to draw Indian flag in Turtle. (Independence Day Special)
zhlédnutí 4,5KPřed 3 lety
Learn how to quickly draw the Indian flag using Python's Turtle module. Hope you like this video. Make sure you subscribe to the channel and drop in a comment if you have any doubts. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaleduworld/ Instagram: primal_eduworld Music in this video: Song: Hindustani Instrumental Artist: Variou...
QR Code Attendance System
zhlédnutí 71KPřed 3 lety
QR stands for Quick Response. The image consists of square dots in a unique configuration that provides information for the user. In education, QR Code can be used to hold URLs of online applications commonly used in the classroom, thus saving time logging in. Each student will be provided a QR Code. When they join google classroom or another platform like Zoom, teacher will generate QR Codes a...
CREATE LOGIN FORM IN ACCESS USING MACRO EVENT!!
zhlédnutí 53KPřed 3 lety
A Login form is used to enter authentication credentials to access a page or form. The login form contains a field for the username and another for the password. When the login form is submitted its given code checks that the credentials are authentic so that the user can access the page or form. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaled...
Learn How To Automate or Repeat Tasks in Excel Using Macro (In Hindi)
zhlédnutí 6KPřed 3 lety
An Excel macro is an action or a set of actions that you can record, give a name, save and run as many times as you want and whenever you want. Macro helps you to save time on repetitive tasks involved in data manipulation/data reports that are required to be done frequently. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaleduworld/ Instagram: in...
Pivot Table in Excel
zhlédnutí 4,3KPřed 3 lety
A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. In this video, we will learn how to effectively organize and present our data using pivot table. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaleduworld/ Instagram: prim...
If and Vlookup functions together in Excel
zhlédnutí 6KPřed 3 lety
Learn how to use the If and Vlookup functions together in Microsoft Excel. Also get a brief insight into Range lookup. With the help of these two functions, we will learn how to calculate staff commissions in different scenarios. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaleduworld/ Instagram: primal_eduworld How to Combine IF ...
Vlookup and Hlookup in Microsoft Excel
zhlédnutí 3,3KPřed 3 lety
The most commonly used LOOKUP functions in Excel are VLOOKUP and HLOOKUP. VLOOKUP allows you to find a data range that is set up vertically. HLOOKUP is the exact same function, but finds data that has been formatted by rows instead of columns. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaleduworld/ Instagram: primal_eduworld vloo...
Copying Excel table to Gmail
zhlédnutí 10KPřed 3 lety
Learn a quick and simple trick to copy tables from your Microsoft Excel sheet to your Gmail text. Channel link : czcams.com/channels/YyyJq-L5LQs4M8M0V1bnCw.html Facebook Page: primaleduworld/ Instagram: primal_eduworld how to insert excel table to gmail how to solve issue excel table pasted as a image in gmail excel table copy paste tricks in gmail

Komentáře

  • @techfuturereview
    @techfuturereview Před měsícem

    Hi Madame! i've watched the videos several times but i can't use the goggle api qr code, however i've used another online generator and my problem is that i have a cell with just the whole name instead of 2 cells with first and last name. Maybe someone else has the same situation and can help solve it! It reads the QR code but in the google sheet responses the name doesn't appear! is it because of the spaces inside the cell name? The name have more than 1 and some have ifen, muslin names. PLS I urgently need help.

    • @techfuturereview
      @techfuturereview Před měsícem

      I found a way to sentence the end of the formula ..../formResponse?entry.978995259=Abass+Danaa+Neindow" but now i have another issue, I have the same names (duplicate), which means I have to create a second or third criterion associated with the name, for example a function and the company it belongs to. Every time a problem arises... but that's just it LOL... if anyone can help I'd appreciate it!

  • @rahulhota5037
    @rahulhota5037 Před měsícem

    First of all when open the qr link it shows server not found. And if put image command nothing in the box specified for qr

  • @rahulhota5037
    @rahulhota5037 Před měsícem

    First of all excellent video.But my qr not showing.when i closed the google sheet and again opened it shows broken image on qr cell.after few second the broken image disappear and the cell will be blank. Plase help

    • @PrimalEduWorld
      @PrimalEduWorld Před měsícem

      Brother Thanks for visiting our channel, please do not save your data in normal excel, you have to save data in google excel sheet. So please watch the video 4 to 5 times carefully and you will get success Thank you 🙏🏼

  • @That1_Saj
    @That1_Saj Před 3 měsíci

    Deffo not gonna do this to cheat on my IT test eheh.

  • @natozeleo7579
    @natozeleo7579 Před 4 měsíci

    Nice ...got a spark

  • @user-fm4su2xv8c
    @user-fm4su2xv8c Před 5 měsíci

    I did not understand the first coding

    • @PrimalEduWorld
      @PrimalEduWorld Před 5 měsíci

      Thanks for visiting our channel, Watch the video again and again and you will understand the coding Please like and subscribe to our channel Thank you 🙏🏼

  • @jacobmathew4
    @jacobmathew4 Před 6 měsíci

    God presentation

  • @kenaknrodbrendan1126
    @kenaknrodbrendan1126 Před 7 měsíci

    which option can you use incase the password does not match

  • @Myspace757
    @Myspace757 Před 7 měsíci

    This was quite informative. Is there a way to do one QR for all the students, like they just scan one QR Code and all will do

  • @oxpertecautomations2858
    @oxpertecautomations2858 Před 9 měsíci

    I need this software

  • @iamDanielle2
    @iamDanielle2 Před 11 měsíci

    Does this help with the python code

    • @PrimalEduWorld
      @PrimalEduWorld Před 11 měsíci

      Yes

    • @iamDanielle2
      @iamDanielle2 Před 11 měsíci

      @@PrimalEduWorld I was asking because I made my house but my pixel is 400 by 400 and it won't fit in the square. I'm using codehs and I've been trying to pass that since last Friday

    • @PrimalEduWorld
      @PrimalEduWorld Před 11 měsíci

      @DanielleL8ve The code module used in our video is the Turtle module which is followed with commands like forward, left, right etc. Trying to do this code with turtle program and pixels will not work as it follows another module entirely. If this problem still continues or you find it difficult to write a code follow my code in description. You can easily copy-paste that code in python.

    • @iamDanielle2
      @iamDanielle2 Před 11 měsíci

      @@PrimalEduWorld I've been stuck on this code for a while now. My code consist of a 400 by 400 wide screen. I wish I could send u a pic

  • @3xtraptical587
    @3xtraptical587 Před 11 měsíci

    LIFE SAVERSSS

    • @PrimalEduWorld
      @PrimalEduWorld Před 11 měsíci

      Thanks for visiting our channel please watch our other videos they are more informative too. Also please like share and subscribe to my channel Thank you 🙏🏼

  • @nishankawasthi7034
    @nishankawasthi7034 Před 11 měsíci

    Hi Can you help in lots of cells the boxes are not being hyperlinked Just because of that I am not getting QR Code

    • @PrimalEduWorld
      @PrimalEduWorld Před 11 měsíci

      Brother Please watch video 4 to 5 times carefully, you have to use Google sheets and not normal excel. Try your best and you will get success. All the very best Thank you 🙏🏼

  • @asteriaiitula4107
    @asteriaiitula4107 Před rokem

    Now I have a clue to my project

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Dear Thanks for visiting our channel please watch our other videos they are more informative and subscribe like and share to your family and friends Thank you 🙏

  • @hiteshchourey9730
    @hiteshchourey9730 Před rokem

    Madam please video make hindi language and English languages

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Dear Thanks for your valuable suggestion, In future we will make videos in both the languages. 🙏🏼

  • @mosjany
    @mosjany Před rokem

    How do i pass the current loggon use to a form using the above macro

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Brother Mosjany, Thanks for visiting our channel, regarding your query firstly you must have IT professional and with the help of Visual Basis latest version you can pass the current logon! Hopefully you have got your answers. Please watch our other videos which are more informative, please like subscribe to our channel and share to your family and friends. Thank you 🙏

  • @prinxtushtech......1204

    post the macro command on the comments

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Dear Prinx, Please watch our the video 4 to 5 times and you will get macro commands. Also please watch our other videos they are more informative, please like subscribe and share to your family and friends. Thank you 🙏

  • @basilisayessicaokomo2248

    HELLO, I HAVE MANAGE TO VIEW PROPERLY WHAT I ASK FOR YSTERDAY THANK YOU SO MUCH FOR YOUR TUTORIAL I REALLY LEARN MUCH FROM YOU WELL DONE!!!!!

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thanks for visiting our channel, please watch other videos they are more informative and please like subscribe and share to your family and friends Thank you 🙏

  • @basilisayessicaokomo2248

    hello, you are teaching well may i please have the macro builder actions more clear i mean can you increase the zoom i can see properly in that part

  • @shilpaarora8027
    @shilpaarora8027 Před rokem

    nice video but lac of security any buddy can mark attendance of any one is there any security tips

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thanks for visiting our channel, regarding your query please go through the chat sections, I already reply to other subscribers. This QR code can be used under the camera surveillance, so no body can misuse. Please watch our other videos and like subscribe and share to your family and friends. Thank you 🙏

  • @nikhiljadhav8090
    @nikhiljadhav8090 Před rokem

    Very helpful

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Nikhil Jadhav, Thanks for visiting our channel please watch our other videos they are more informative too and please like subscribe and share to your family and friends. Thank you 🙏

  • @lustoricgaming1565
    @lustoricgaming1565 Před rokem

    Really Helped Me Out Thanks...

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thanks for visiting our channel, please watch other videos they are more informative. Please like and subscribe to our channel and share to your friends and family members. Thanks 🙏

  • @markperez8261
    @markperez8261 Před rokem

    Not working for me

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Brother, It won’t work in MS EXCEL, you should work in google sheets. Please watch our other videos they are more informative too, please like subscribe to our channel and share to your family and friends. Thank you 🙏

  • @ahmadsqalli3904
    @ahmadsqalli3904 Před rokem

    Timestamps: 00:03 Channel Intro 00:18 Intro: Excel Functions for Interviews 00:51 ROUND Function 02:05 IF Function 03:15 EOMONTH Function 04:39 EDATE Function 06:13 WORKDAY Function 07:37 AGGREGATE Function 09:19 3D FORMALA Function 10:36 IFS Function 14:17 VLOOKUP Function 15:33 TRIM Function 16:24 Outro

  • @dionukshini
    @dionukshini Před rokem

    So helpfull, Thanks :)

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Dear Dlon, Thanks for visiting our channel please watch our other videos they are more informative too, please like subscribe and share to your family and friends. Thank you 🙏

  • @MrCrazyApp
    @MrCrazyApp Před rokem

    Please create the continuation to this video. Once those macros are created? How do we limit the data the the users will view? And you may want to create other videos for example how to create an application where users don’t see anything about access comanda or other information. Basically how to create a shareable app. You can create also a video about how to create and app and distribute it (just for information purposes or to update a central database. And how users knows that there’s a change in the app and they need to make an update. This video is very well explain so I think that you have tue ability to teach very well.

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thanks for visiting our channel and glad to know that you like my work, regarding your questions if you will go through my comments section you will get answers of most of your questions. For many subscribers I already answered how to hide Access commands section etc. Please watch my other videos specifically QR CODE ATTENDANCE, I hope you will like most. Please like subscribe and share to your family and friends. Thank you 🙏

    • @MrCrazyApp
      @MrCrazyApp Před rokem

      @@PrimalEduWorld Thank you for your reply. But seeing the other posted questions, my humble suggestion is that you create a new video talking into consideration all aspects. You can divide it in parts. We can find other videos on CZcams but the way you explain is unique. So for the benefit of all of us, please think about it. Thanks!

    • @MrCrazyApp
      @MrCrazyApp Před rokem

      Also, I’m sure that we all can be share those videos in the different Specialize Access Forums that we are subscribed. That way, your work will be recognize by a lot of new people.

    • @MrCrazyApp
      @MrCrazyApp Před rokem

      One of the issues is the roll out of an app. There’s only a few ways to do it and some of them charge per user. I’m not sure about the share point option. Maybe that’s an alternative. Of course, we need to split the database. But using Dropbox and other spaces doesn’t work because the database could be corrupted. But if you accept to create a series of videos showing people how to create an application from start to end, definitely will need to evaluate what is the best option, depending if the creator wants to offer to the users just real time information or if the user wants to interact with the data. Those are two different approaches.

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thanks for your valuable suggestions, I will definitely work on it.

  • @user-pf2ie1fn1j
    @user-pf2ie1fn1j Před rokem

    Thank you for the informative video. I just want to ask how can I export the QR Codes as image individually?

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Dear Kristine, Please follow below steps to convert as a image 1) copy the cell containing QR Code. 2) open the Manu Paste Special > Picture 3) Now you have the image of your QR code and you can export it. Thanks for visiting our channel please watch our other videos they are more informative, like and subscribe and share to your family and friends. Thank you 🙏

  • @amanu78
    @amanu78 Před rokem

    Thank you very much

  • @jotbatalvi7635
    @jotbatalvi7635 Před rokem

    It was very helpful but i have question can we use same QR repeatedly? I think once we use the QR code it says ‘you already submit the answer or filled form’.

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thanks for visiting our channel, please be noted that you can save two different google sheets one for in other for out. Hopefully your problem will solve also please watched other videos they are more informative, like share and subscribe. Thank you 🙏

  • @cindyrussell5963
    @cindyrussell5963 Před rokem

    Thank you and will be looking forward to it

  • @cindyrussell5963
    @cindyrussell5963 Před rokem

    Hello, thank you so much for this simple video. I'm creating a simple database. How do you have the log in screen to appear first then the switch/dashboard in Access? Cam you do a video on that please?

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Sure, Thanks for visiting our channel, please watch other videos they are more informative and like, share and subscribe for more updates. Thank you 🙏

  • @BasamParkar
    @BasamParkar Před rokem

    Excel made easy for noobs👍🏻

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback. Glad you found it useful. Stay connected for more videos.

  • @faridaparkar7065
    @faridaparkar7065 Před rokem

    Best video 👍👍

  • @iraali3387
    @iraali3387 Před rokem

    Excellent video. Keep it up👍🏻

  • @NoorAli-go9bk
    @NoorAli-go9bk Před rokem

    Explanation to the point and in simple language. Very good video👍🏻

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @maysak3595
    @maysak3595 Před rokem

    Very detailed video. Definitely very useful👍🏻

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @ayyubali1456
    @ayyubali1456 Před rokem

    I was panicking about an Excel interview test but after watching this video I am quite calm and confident!

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Glad that our video was helpful to you. Wish you all the best for your interview. Stay tuned for more videos.

  • @maxautokuwait5083
    @maxautokuwait5083 Před rokem

    Very useful video. Explained very nicely. 👌

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @hanaali7111
    @hanaali7111 Před rokem

    👍👍

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @taraksingh8946
    @taraksingh8946 Před rokem

    The video is very useful ✔✔

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @mehekparkar1363
    @mehekparkar1363 Před rokem

    👏🏻👏🏻👏🏻

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @AhmadAli-ut9co
    @AhmadAli-ut9co Před rokem

    You are a PRO “MAM! This is super easy and straight to the point! Thank you for sharing such knowledge with us!

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @waleedparkar4442
    @waleedparkar4442 Před rokem

    Thanks for this video very useful❤

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @classictrendz4615
    @classictrendz4615 Před rokem

    Best video💕💕💖💖😊😊

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Thank you for the feedback! Stay tuned for more videos.

  • @tanurajput
    @tanurajput Před rokem

    Very useful and knowledgeval

  • @antonioramirez1865
    @antonioramirez1865 Před rokem

    GREAT VID, THOUGH, IS THERE ANY WAY THAT YOU COULD SHOW US HOW TO DO THIS IN EXCELL, I REALLY NEED IT FOR EXCELL, EVERYTHING IS GREAT THANKS FOR YOUR TIME..

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Hi brother, Thanks for visiting our channel, hopefully you are doing great. Please be noted that cannot generate QR codes din excel, it’s required google sheets only. You can watch other videos they are more informative, please like share and subscribe to my channel. Thank you 🙏

  • @rufi4you
    @rufi4you Před rokem

    sorry i don't understand why you use dcount. this way you only check if the textfields are not zero. neither the username nor the password are compared. or where am i making the mistake?

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Brother you are also correct and not doing mistakes, there are many ways we can do programming. All the very best and please do not forget to watch our other videos like and subscribe to my channel. Thank you 🙏

  • @yousfdahlawi7735
    @yousfdahlawi7735 Před rokem

    I need your file🥲

  • @bholebaba365
    @bholebaba365 Před rokem

    Nice explain

    • @PrimalEduWorld
      @PrimalEduWorld Před rokem

      Dear Sourav, Thanks for visiting our channel, please watch other educational videos they are very much informative. Like share with your friends and subscribe to my channel for new updates. Thank you 🙏

  • @vi_chitram
    @vi_chitram Před rokem

    Never seen before this video explains super QR attendance video in youtube