- 39
- 311 786
My WorkPlace 2
Pakistan
เข้าร่วมเมื่อ 8 พ.ย. 2019
Hope you will be doing good!. I created this channel with an intention to let others learn from youtube's platform as I have learnt many things watching online tutorials & training which greatly helped me in my professional career. I sincerely want to let others know as much as I can in the best possible way & I won't mind if I get a benefit in return from my youtube views & subscribers count.
Stay Blessed
Thank you.
kindly subscribe if you like my effort.
Stay Blessed
Thank you.
kindly subscribe if you like my effort.
#38 How to Calculate Running Balance | Finding Running Total based on Criteria | Advance MS Excel
#haqworkplace #runningtotal #advanceexcel
Dear Friends
I hope you will be doing good. In this video I have tried to show how to find running balance of a ledger and also how to find running total based on another cell value or running total by Customer.
don't forget to like & subscribe our channel if you like the video.
Download the file from the link below
docs.google.com/spreadsheets/d/1Z96ejs26YGl4fAknydmV4LEaYn4nsEes/edit?usp=sharing&ouid=115197046305255420725&rtpof=true&sd=true
Thanks for watching
Dear Friends
I hope you will be doing good. In this video I have tried to show how to find running balance of a ledger and also how to find running total based on another cell value or running total by Customer.
don't forget to like & subscribe our channel if you like the video.
Download the file from the link below
docs.google.com/spreadsheets/d/1Z96ejs26YGl4fAknydmV4LEaYn4nsEes/edit?usp=sharing&ouid=115197046305255420725&rtpof=true&sd=true
Thanks for watching
มุมมอง: 299
วีดีโอ
#39 Simplest Inventory / Stock Management System in MS Excel | Advance Excel
มุมมอง 5692 ปีที่แล้ว
#haqworkplace #Inventorymanagement #advanceexcel Dear Friends I hope you will be doing good. In this video I have tried to show how to manage or control you inventory in ms excel by using only one sumif formula. don't forget to like & subscribe our channel if you like the video. Download the file from the link below docs.google.com/spreadsheets/d/1_rYthuGqNKi-OImR4Tf9AUJLDNhkrJxg/edit?usp=shari...
#37 Dependent Drop Down List on Unpivoted Data | Drop Down List Based on Criteria Advance MS Excel
มุมมอง 832 ปีที่แล้ว
#haqworkplace #datavalidation #advanceexcel Hello Friends, in this video you will be learning about the advance data validation in MS excel where in you will also learn how to create a dependent drop down list when you have tabular or unpivoted data set or drop down list based on a criteria in another cell. Download the file from the link below docs.google.com/spreadsheets/d/1cUdXfdgEgEX5jzLHQD...
#36 Dependent Drop Down List | Drop Down List Based on Criteria | Advance Data Validation MS Excel.
มุมมอง 722 ปีที่แล้ว
#haqworkplace #datavalidation #advanceexcel Hello Friends, in this video you will be learning about the advance data validation in ms excel where in you will also learn how to create a dependent drop down list or drop down list based on a criteria in another cell. Download the file from link given docs.google.com/spreadsheets/d/1Z96ejs26YGl4fAknydmV4LEaYn4nsEes/edit?usp=sharing&ouid=11519704630...
#35 How to connect computer to attendance machine on LAN | Configure Attendance Machine zkteco
มุมมอง 120K3 ปีที่แล้ว
#haqworkplace #zkteco #attendancemachine In this video I will show you, how you can connect your computer to your attendance machine zkteco iface302 step by step. How you can configure LAN for your bio metric attendance device
#34 MS Excel Countif Function I Count Cells based on Single Criteria
มุมมอง 1203 ปีที่แล้ว
#counitf #exceltutorials #haqworkplace #34 MS Excel Countif Function I Count Cells based on Single Criteria After watching this video you will be able to ; how to count cells based on a single criteria. subscribe if you like the video.
#33 MS Excel Rounding Values to Desired Multiple | MROUND, FLOOR & CEILING Uses | Excel 2020
มุมมอง 604 ปีที่แล้ว
#roundvalues #exceltutorials #haqworkplace MS Excel Rounding Values to Desired Multiple | MROUND, FLOOR & CEILING Uses | Excel 2020 After watching this video you will be able to ; how to round values to nearest specified multiple, how to round values to nearest specified multiple upward, how to round values to nearest specified multiple downward. subscribe if you like the video. download file f...
#32 MS Excel Rounding Values | Round, Roundup & Rounddown Functions Uses | Excel 2020
มุมมอง 434 ปีที่แล้ว
#roundvalues #exceltutorials #haqworkplace MS Excel Rounding Values | Round, Roundup & Rounddown Functions Uses | Excel 2020 After watching this video you will be able to ; how to round values to nearest specified number, how to round values to nearest specified number upward, how to round values to nearest specified number downward. subscribe if you like the video.
#31 MS Excel Text Function in Detail | How to Change Date format into Text | Excel 2020
มุมมอง 504 ปีที่แล้ว
#textfunction #exceltutorials #haqworkplace MS Excel Text Function in Detail | How to Change Date format into Text | Excel 2020 Dear Friends, In above video, we have discussed a very important function of MS Excel Called the Text functions. We have explained text function in detail i.e. how to use text function, how do you change the format of a date which is in numbers, to text, formatting zip...
#30 Advanced Excel | Creating Automatic Students' Marks Sheet/Report Card | 2020
มุมมอง 7374 ปีที่แล้ว
#advancedexcel #reportcard #haqworkplace Advanced Excel | Creating Automatic Students' Marks Sheet/Report Card | 2020 Dear Viewers! In today's video we have recorded step by step information about how to create a students' report card in microsoft excel, where in you will be learning many advanced features, functions & formulas of MS Excel for example, using array formula, use of sumproduct fun...
#29 MS Excel Exact & Fixed Function | Rounding Values | Matching Data in Two Columns | 2020
มุมมอง 314 ปีที่แล้ว
#excelfunctions #learningexcel #haqworkplace MS Excel Exact & Fixed Function | Rounding Values | Matching Data in Two Columns | 2020 Dear Friends, In this video tutorial you will be learning how to match & find if values in two different cells are equal or not & also you will be learning how to round the values before decimal places & after decimals places. don't forget to subscribe the channel...
#28 How to Use Excel Replace & Substitute & LEN Functions | Urdu/Hindi
มุมมอง 1694 ปีที่แล้ว
#exceltutorials #excelfunctions #haqworkplace How to Use Excel Replace & Substitute & LEN Functions | Urdu/Hindi Dear Viewers, I hope that after watching this video you will be able to use Ms Excel substitute, replace & LEN Functions. don't forget to subscribe to. thank you file download from the link below drive.google.com/file/d/1utln7k0wFB6Ee80k2QfT-tnh6l-HBLfY/view?usp=drivesdk
#27 MS Excel Concatenate & Flash Fill Feature | Join Multiple Columns into One | Urdu/Hindi
มุมมอง 374 ปีที่แล้ว
#concatenate #flashfill #haqworkplace MS Excel Concatenate & Flash Fill Feature | Join Multiple Columns into One | Urdu/Hindi in today's video friends, you will be learning the MS Excel flash fill feature and different techniques to join multiple columns into one column i.e. Concatenate function, flash fill feature & other method. don't forget to subscribe to thank you. download the file from t...
#26 How to Split Column into Multiple Columns | Find Text within a Column | MS Excel Urdu/hindi
มุมมอง 354 ปีที่แล้ว
#excelfind #msexcel #haqworkplace How to Split Column into Multiple Columns | Find Text within a Column | MS Excel Urdu/hindi In this video friends, you will be learning i.e. how to get value from right side of a cell & past it into another cell. similarly how to copy from left side of the cell and how to copy from middle of a cell and past it into another cell by using the MS Excel left, right...
#25 How to Change Case in MS Excel | Proper, Lower & Upper functions | Urdu/Hindi
มุมมอง 164 ปีที่แล้ว
#excelcase #msexcel #haqworkplace How to Change Case in MS Excel | Proper, Lower & Upper functions | Urdu/Hindi Viewers, in this video you will be learning how to change the case of text in MS Excel. How to change text into proper case, how to change case in upper case and how to change it in lower case. Don't forget to subscribe to Thank you Download the Excel file from the link below drive.go...
#24 Logical Functions MS Excel | How to Use Iferror, Ifna & Not Functions | Urdu/Hindi
มุมมอง 2964 ปีที่แล้ว
#24 Logical Functions MS Excel | How to Use Iferror, Ifna & Not Functions | Urdu/Hindi
#23 MS Excel Info Functions | How to Use Information Functions In Excel | Urdu/Hindi
มุมมอง 554 ปีที่แล้ว
#23 MS Excel Info Functions | How to Use Information Functions In Excel | Urdu/Hindi
#22 How to Use Index & Match with Row Function in Excel | Index & Match Explained | Urdu/Hindi
มุมมอง 694 ปีที่แล้ว
#22 How to Use Index & Match with Row Function in Excel | Index & Match Explained | Urdu/Hindi
#21 How to use vlookup in Excel | vlookup in detail | Urdu/hindi
มุมมอง 334 ปีที่แล้ว
#21 How to use vlookup in Excel | vlookup in detail | Urdu/hindi
#20 How to Use Multiple IF | IF Function With in IF | Nested IF Formula | Urdu/Hindi
มุมมอง 454 ปีที่แล้ว
#20 How to Use Multiple IF | IF Function With in IF | Nested IF Formula | Urdu/Hindi
#19 How to Use Nested IF, MS Excel | IF with AND & OR Together | Advance IF Urdu/Hindi
มุมมอง 414 ปีที่แล้ว
#19 How to Use Nested IF, MS Excel | IF with AND & OR Together | Advance IF Urdu/Hindi
#18 Excel AND & OR Function | IF With AND Function | IF With OR Function | Urdu/Hindi
มุมมอง 304 ปีที่แล้ว
#18 Excel AND & OR Function | IF With AND Function | IF With OR Function | Urdu/Hindi
#17 MS Excel in 40 Minutes | Learn MS Excel In اردو/Hindi
มุมมอง 644 ปีที่แล้ว
#17 MS Excel in 40 Minutes | Learn MS Excel In اردو/Hindi
#16 How to Use IF Function | Writing Function | Basics of IF Function | MS Excel Urdu/Hindi
มุมมอง 294 ปีที่แล้ว
#16 How to Use IF Function | Writing Function | Basics of IF Function | MS Excel Urdu/Hindi
#15 MS Excel for Beginners | Past Special in Detail | Urdu/Hindi
มุมมอง 314 ปีที่แล้ว
#15 MS Excel for Beginners | Past Special in Detail | Urdu/Hindi
#14 MS Excel for Beginners | Cell Reference | Relative & Absolute Reference | Urdu/Hindi
มุมมอง 1074 ปีที่แล้ว
#14 MS Excel for Beginners | Cell Reference | Relative & Absolute Reference | Urdu/Hindi
#13 MS Excel for Beginners | Pivot Table Explained | Urdu/Hindi
มุมมอง 374 ปีที่แล้ว
#13 MS Excel for Beginners | Pivot Table Explained | Urdu/Hindi
#12 MS Excel for Beginners | Data Validation | Excel Basics | Urdu/Hindi
มุมมอง 634 ปีที่แล้ว
#12 MS Excel for Beginners | Data Validation | Excel Basics | Urdu/Hindi
#11 MS Excel Basics | Conditional Formatting | Excel for Beginners | Urdu/Hindi
มุมมอง 274 ปีที่แล้ว
#11 MS Excel Basics | Conditional Formatting | Excel for Beginners | Urdu/Hindi
#10 MS Excel Basics | Go to Special in Detail | Urdu/Hindi
มุมมอง 434 ปีที่แล้ว
#10 MS Excel Basics | Go to Special in Detail | Urdu/Hindi
Lopez Melissa Robinson Shirley Young John
Davis Matthew Martin Kimberly Anderson Susan
Yeh formula to physicly is not doing work
Agar time 23:00 rat ko suru hota hai aur subah 7:00 ko khatam hota hai to iska count kaise aayega
Bhai isko 31:00 karke count karenge
Sir Late time ka btaiye
Nice❤
Many many Thank's To you.............
Jay hind Kiya karo
Please where can I get the software
good machine
Make Ms Excel Full Course again from beginner To Advance, Pichli Videos Main Audio Sahi Nahi Thi 👍
yaar koi ye software dedo
Very nice 🎉🎉🎉
How to download attendece management program
10:40 bhai pura sunday ko red kaise kiya. mai kar raha hu tho 1 sub column hi ho raha hai sunday collumn se. please help
जय श्री राम सर जी
Hi there, When I do ping test I get message Time out from router. It never connects this just started happening since a month that after so many tries then the machine gets connected. But now even it is not.
This timeclock works well. Pretty simple to set up and use to run time sheets.
Sir aapka number milenga
Please send additional information
This works for one tym only i havse to check every month plz yell me how can i check every month Thank u
kya aap mera question solve kar sakte ho ?
Thanks bro ...your video is very useful may Allah bless you ...and have mercy on you where are you... I follow your channel can you give me the whatsapp number.
Kachara hai video
and ap WhatsApp group banay jis ap esy sheet and format shear kr sakain please
pata ni sb ne gongi videos kiyo banayee hain
Hard to see clearly because the camera was not closed.
Sir ag koi leave aa jati hai like 14 aug ya Eid ki tu phir us ko kesy manage karin gy
Us ko h sign ma hi rakha
sir nice mujy samj nai aaya k ap k views kiyun nai hain
Worked hours wrong calculate hai
Bhai aapne over time rate per day ka nikala he jab k over time rate per hour k hisaab se hota he. Kindly isko Sahi Karen aur mujhay correct formula bataega
Bakbaas video.to much boring
Please send the formula of total working hours and total I can't understand ur language bcoz I am south Indian Please guide me
Hello bro I want to count (Sunday + holiday) in months Please tell me.
Sahi to hi magar video saf nahi dikh raha hai kripya sahi video dikhayee
Is it possible to connect several computers ?
Thanks for the videos it hepls a lot
Connecting public intellectual property branches
Pls reply
Sir Time sheet ke upper apni biometric punching kaise ayegi
Hlo sir
How can we will import (biometric) data in time sheet
th-cam.com/video/yy0jdbppqN4/w-d-xo.html
Pls reply
Time sheet par ane k baad to salery slip ban hi jayegi
Time sheet par biometric Wali punching kaise ayegi
Hlo sir
th-cam.com/video/7zf9945Nsm0/w-d-xo.html
superb tutorial
best👌👌
thanks for the video, very useful