![Primal EduWorld](/img/default-banner.jpg)
- 14
- 175 304
Primal EduWorld
India
Registrace 8. 06. 2021
Learn Microsoft Access, Excel and Python starting with the basics. In this step-by-step tutorial, learn about Spreadsheets Microsoft Access tables, forms, templates, running SQL queries, and creating reports. How to work with SQL Server, DB2, and Oracle databases. In no time at all, create user-friendly front ends and develop web applications.
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
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
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.
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!
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
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
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 🙏🏼
Deffo not gonna do this to cheat on my IT test eheh.
Nice ...got a spark
I did not understand the first coding
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 🙏🏼
God presentation
Thank you
which option can you use incase the password does not match
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
I need this software
Does this help with the python code
Yes
@@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
@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.
@@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
LIFE SAVERSSS
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 🙏🏼
Hi Can you help in lots of cells the boxes are not being hyperlinked Just because of that I am not getting QR Code
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 🙏🏼
Now I have a clue to my project
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 🙏
Madam please video make hindi language and English languages
Dear Thanks for your valuable suggestion, In future we will make videos in both the languages. 🙏🏼
How do i pass the current loggon use to a form using the above macro
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 🙏
post the macro command on the comments
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 🙏
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!!!!!
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 🙏
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
nice video but lac of security any buddy can mark attendance of any one is there any security tips
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 🙏
Very helpful
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 🙏
Really Helped Me Out Thanks...
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 🙏
Not working for me
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 🙏
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
So helpfull, Thanks :)
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 🙏
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.
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 🙏
@@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!
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.
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.
Thanks for your valuable suggestions, I will definitely work on it.
Thank you for the informative video. I just want to ask how can I export the QR Codes as image individually?
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 🙏
Thank you very much
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’.
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 🙏
Thank you and will be looking forward to it
Great!
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?
Sure, Thanks for visiting our channel, please watch other videos they are more informative and like, share and subscribe for more updates. Thank you 🙏
Excel made easy for noobs👍🏻
Thank you for the feedback. Glad you found it useful. Stay connected for more videos.
Best video 👍👍
Thank you! Stay connected for more videos😊
Excellent video. Keep it up👍🏻
Thank you! Stay connected for more videos😊
Explanation to the point and in simple language. Very good video👍🏻
Thank you for the feedback! Stay tuned for more videos.
Very detailed video. Definitely very useful👍🏻
Thank you for the feedback! Stay tuned for more videos.
I was panicking about an Excel interview test but after watching this video I am quite calm and confident!
Glad that our video was helpful to you. Wish you all the best for your interview. Stay tuned for more videos.
Very useful video. Explained very nicely. 👌
Thank you for the feedback! Stay tuned for more videos.
👍👍
Thank you for the feedback! Stay tuned for more videos.
The video is very useful ✔✔
Thank you for the feedback! Stay tuned for more videos.
👏🏻👏🏻👏🏻
Thank you for the feedback! Stay tuned for more videos.
You are a PRO “MAM! This is super easy and straight to the point! Thank you for sharing such knowledge with us!
Thank you for the feedback! Stay tuned for more videos.
Thanks for this video very useful❤
Thank you for the feedback! Stay tuned for more videos.
Best video💕💕💖💖😊😊
Thank you for the feedback! Stay tuned for more videos.
Very useful and knowledgeval
Thanks for supporting 🙏
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..
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 🙏
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?
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 🙏
I need your file🥲
Nice explain
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 🙏
Never seen before this video explains super QR attendance video in youtube