Primal EduWorld
Primal EduWorld
  • Видео 14
  • Просмотров 171 320
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 in...
Просмотров: 4 268

Видео

How To Unlock Protected Excel Without Password 🔓
Просмотров 932Год назад
#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
Просмотров 1,8 тыс.2 года назад
#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*
Просмотров 10 тыс.2 года назад
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 RUclips by: AdRev for a 3rd Party (on behalf of Atomica B Publishing, BMI (Atomica Music)), AdRev P...
Learn How to draw Indian flag in Turtle. (Independence Day Special)
Просмотров 4,5 тыс.2 года назад
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 : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw Facebook Page: primaleduworld/ Instagram: primal_eduworld Music in this video: Song: Hindustani Instrumental Artist: Various A...
QR Code Attendance System
Просмотров 69 тыс.3 года назад
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!!
Просмотров 52 тыс.3 года назад
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 : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw Facebook Page: primaleduwo...
Learn How To Automate or Repeat Tasks in Excel Using Macro (In Hindi)
Просмотров 6 тыс.3 года назад
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 : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw Facebook Page: primaleduworld/ Instagram: insta...
Pivot Table in Excel
Просмотров 4,3 тыс.3 года назад
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 : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw Facebook Page: primaleduworld/ Instagram: primal_...
If and Vlookup functions together in Excel
Просмотров 6 тыс.3 года назад
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 : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw Facebook Page: primaleduworld/ Instagram: primal_eduworld How to Combine IF Fun...
Vlookup and Hlookup in Microsoft Excel
Просмотров 3,3 тыс.3 года назад
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 : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw Facebook Page: primaleduworld/ Instagram: primal_eduworld vlookup...
Copying Excel table to Gmail
Просмотров 9 тыс.3 года назад
Learn a quick and simple trick to copy tables from your Microsoft Excel sheet to your Gmail text. Channel link : ruclips.net/channel/UCYyyJq-L5LQs4M8M0V1bnCw 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

Комментарии

  • @rahulhota5037
    @rahulhota5037 5 дней назад

    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 8 дней назад

    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 8 дней назад

      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 Месяц назад

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

  • @natozeleo7579
    @natozeleo7579 2 месяца назад

    Nice ...got a spark

  • @user-fm4su2xv8c
    @user-fm4su2xv8c 4 месяца назад

    I did not understand the first coding

    • @PrimalEduWorld
      @PrimalEduWorld 4 месяца назад

      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 5 месяцев назад

    God presentation

  • @kenaknrodbrendan1126
    @kenaknrodbrendan1126 5 месяцев назад

    which option can you use incase the password does not match

  • @Myspace757
    @Myspace757 5 месяцев назад

    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 8 месяцев назад

    I need this software

  • @iamDanielle2
    @iamDanielle2 9 месяцев назад

    Does this help with the python code

    • @PrimalEduWorld
      @PrimalEduWorld 9 месяцев назад

      Yes

    • @iamDanielle2
      @iamDanielle2 9 месяцев назад

      @@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 9 месяцев назад

      @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 9 месяцев назад

      @@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 10 месяцев назад

    LIFE SAVERSSS

    • @PrimalEduWorld
      @PrimalEduWorld 10 месяцев назад

      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 10 месяцев назад

    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 10 месяцев назад

      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 10 месяцев назад

    Now I have a clue to my project

    • @PrimalEduWorld
      @PrimalEduWorld 10 месяцев назад

      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 10 месяцев назад

    Madam please video make hindi language and English languages

    • @PrimalEduWorld
      @PrimalEduWorld 10 месяцев назад

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

  • @mosjany
    @mosjany Год назад

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

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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
    @prinxtushtech......1204 Год назад

    post the macro command on the comments

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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
    @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 Год назад

      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
    @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 Год назад

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

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

    Very helpful

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

    Really Helped Me Out Thanks...

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

    Not working for me

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

    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 Год назад

    So helpfull, Thanks :)

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

    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 Год назад

      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 Год назад

      @@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 RUclips but the way you explain is unique. So for the benefit of all of us, please think about it. Thanks!

    • @MrCrazyApp
      @MrCrazyApp Год назад

      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 Год назад

      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 Год назад

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

  • @user-pf2ie1fn1j
    @user-pf2ie1fn1j Год назад

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

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

    Thank you very much

  • @jotbatalvi7635
    @jotbatalvi7635 Год назад

    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 Год назад

      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 Год назад

    Thank you and will be looking forward to it

  • @cindyrussell5963
    @cindyrussell5963 Год назад

    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 Год назад

      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 Год назад

    Excel made easy for noobs👍🏻

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @faridaparkar7065
    @faridaparkar7065 Год назад

    Best video 👍👍

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      Thank you! Stay connected for more videos😊

  • @iraali3387
    @iraali3387 Год назад

    Excellent video. Keep it up👍🏻

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      Thank you! Stay connected for more videos😊

  • @NoorAli-go9bk
    @NoorAli-go9bk Год назад

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

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @maysak3595
    @maysak3595 Год назад

    Very detailed video. Definitely very useful👍🏻

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @ayyubali1456
    @ayyubali1456 Год назад

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

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @maxautokuwait5083
    @maxautokuwait5083 Год назад

    Very useful video. Explained very nicely. 👌

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @hanaali7111
    @hanaali7111 Год назад

    👍👍

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @taraksingh8946
    @taraksingh8946 Год назад

    The video is very useful ✔✔

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @mehekparkar1363
    @mehekparkar1363 Год назад

    👏🏻👏🏻👏🏻

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @AhmadAli-ut9co
    @AhmadAli-ut9co Год назад

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

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @waleedparkar4442
    @waleedparkar4442 Год назад

    Thanks for this video very useful❤

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @classictrendz4615
    @classictrendz4615 Год назад

    Best video💕💕💖💖😊😊

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

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

  • @tanurajput
    @tanurajput Год назад

    Very useful and knowledgeval

  • @antonioramirez1865
    @antonioramirez1865 Год назад

    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 Год назад

      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 Год назад

    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 Год назад

      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 Год назад

    I need your file🥲

  • @bholebaba365
    @bholebaba365 Год назад

    Nice explain

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      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 Год назад

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

  • @chamilakulathunga5254
    @chamilakulathunga5254 Год назад

    Hi this is very useful video...But I tried doing it i have a problem. can help me sought it out. all steps are going well. but finally When I scan the QR code, in a Google page shows a error message " Sorry, unable to open the file at this time. Please can you help me with this 🙏🙏

    • @PrimalEduWorld
      @PrimalEduWorld Год назад

      Dear Chamila, In this video 2 steps are very important 1) google forms and 2) google.sheets You admitted that you generated QR Codes means your all steps are correct. I think here your phone is not supporting such type of programming so I suggest please try with other phone and you will be successful. Or Watch video 4 to 5 times carefully and you will know where doing mistakes. Also please watch other informative videos spread word with your friends like and subscribe to my channel. Thank you 🙏

    • @chamilakulathunga5254
      @chamilakulathunga5254 Год назад

      @@PrimalEduWorld thank you for your quick reply.....i will try with another mobile then. thank you again...😇😇

    • @chamilakulathunga5254
      @chamilakulathunga5254 Год назад

      i found my mistake...one letter in url Column code is wrong...thank you for your support...