![Office Freak](/img/default-banner.jpg)
- Видео 133
- Просмотров 205 320
Office Freak
Индия
Добавлен 11 июл 2020
My goal is to help you save time at work, so you can spend it on activities that matter.
My office productivity tutorials cover: -
Microsoft Excel, MS Word, PowerPoint, MacBook,OneNote, and other Office Products - Google Sheets
Subscribe if you'd like to improve your skills. #OfficeFreak
My office productivity tutorials cover: -
Microsoft Excel, MS Word, PowerPoint, MacBook,OneNote, and other Office Products - Google Sheets
Subscribe if you'd like to improve your skills. #OfficeFreak
Task Management Tracker in Excel Hindi
In today's video we will see how can we create a fully automatic Task Management Tracker in Excel. I have created this format from scratch. I tried my best to include all the things in this format which will make the tracking system easy.
Aaj ke video me hum dekhenge ki hum Excel me ek Fully Automatic Task Management Tracker kaise bana sakte hain.
#excel #officefreak #taskmanagementtracker
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join the Channel Membership to download the file:
लिंक पर क्लिक कर के आप चैनल मेम्बरशिप जॉइन कर सकते हैं
ruclips.net/channel/UCEoeqlCm-tZaHl9K9v7eeDgjoin
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 📚 File Link: Only for Channel Members सिर्फ़ चैनल मेंबर्स के लि...
Aaj ke video me hum dekhenge ki hum Excel me ek Fully Automatic Task Management Tracker kaise bana sakte hain.
#excel #officefreak #taskmanagementtracker
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join the Channel Membership to download the file:
लिंक पर क्लिक कर के आप चैनल मेम्बरशिप जॉइन कर सकते हैं
ruclips.net/channel/UCEoeqlCm-tZaHl9K9v7eeDgjoin
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 📚 File Link: Only for Channel Members सिर्फ़ चैनल मेंबर्स के लि...
Просмотров: 16
Видео
Task Planner To Do List in Excel Hindi 2024
Просмотров 17714 часов назад
आज के वीडियो में हम देखेंगे कि हम एक्सेल में एक To Do List या फिर Task Planner कैसे बना सकते हैं। In today's video we will see how to create a To Do List or Task Planner. #excel #officefreak #todolist #taskplanner ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join the Channel Membership to download the file: लिंक पर क्लिक कर के आप चैनल मेम्बरशिप जॉइन कर सकते हैं ruclips.net/channel/UCEoeqlC...
Leave Tracker in Excel Advanced (Hindi) 2024 / एक्सेल में लीव ट्रैकर कैसे बनाते हैं
Просмотров 13519 часов назад
आज के वीडियो में हम देखेंगे कि हम एक्सेल में एक फुल्ली ऑटोमैटिक लीव ट्रैकर कैसे बना सकते हैं। #excel #officefreak #leavetracker ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join the Channel Membership to download the file: लिंक पर क्लिक कर के आप चैनल मेम्बरशिप जॉइन कर सकते हैं ruclips.net/channel/UCEoeqlCm-tZaHl9K9v7eeDgjoin ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 📚 File Link: Only for ...
Dynamic Dashboard in Excel 2024 | How to Build MODERN Interactive Dashboard in Excel (Hindi)
Просмотров 80День назад
Excel me modern & impressive dashboard kaise bnaye? is video me maine step by step btaya hai ki aap excel me bina vba & macro ke modren dashboard kaise bna saktey hain. is excel dashboard video me seekhne ke liye bahut kuch hai kyun ki isme humne pivot table ka use kar ke bahut sara smart work kiya hai. aasha hai ye excel interactive dashboard apko jarur pasand aayega. In this video, You will l...
Excel Shortcuts 2024 | Best Excel Shortcuts in Hindi | Keyboard Shortcuts Computer user must Know
Просмотров 6914 дней назад
Excel Shortcuts 2024 | Best Excel Shortcuts in Hindi | Keyboard Shortcuts Computer user must Know Agar aap Excel (एक्सेल) expert Banna Chahte Hain To aapko Excel (एक्सेल) keyboard shortcut keys ke bare mein Jankari Hona bahut jaruri hai is video mein Humne Excel (एक्सेल) keyboard ke sabhi shortcut keys ke bare mein Jankari Di Hai jisme Humne bataya hai yah video dekhne ke bad aap keyboard se...
Daily Sales Report in Excel Hindi 2024 / How to Create a Daily Sales Report in Excel
Просмотров 12814 дней назад
Daily Sales Report in Excel Hindi 2024 / How to Create a Daily Sales Report in Excel आज के वीडियो में हम देखेंगे की हम एक्सेल में Daily Sales Report Multiple Stores के लिए कैसे बना सकते हैं। ये एक्सेल शीट फुल्ली ऑटोमैटिक होगा ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join the Channel Membership to download the file: लिंक पर क्लिक कर के आप चैनल मेम्बरशिप जॉइन कर सकते हैं ruclips.net/chan...
Daily Production Report DPR in EXCEL 2024 | How to make DPR in EXCEL | DPR
Просмотров 13821 день назад
Daily Production Report DPR in EXCEL 2024 | How to make DPR in EXCEL | DPR आज के वीडियो में हम देखेंगे कि हम एक्सेल में एक DPR या फिर Daily Production Report कैसे बना सकते हैं। In today's video we will see how can we create a Daily Production Report or DPR in Excel. #officemonk #excel #dailyproductionreport ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join the Channel Membership to downloa...
Automatic Transfer Data From Master Sheet to Another Sheets in Excel | Office Freak
Просмотров 9128 дней назад
In This excel Tutorial you will learn how to transfer data automatically from master sheet to another sheet. Just enter data into master sheet the entries automatically transfer their related sheets. आज के वीडियो में हम देखेंगे कि हम मास्टर शीट से डेटा मल्टीपल शीट में कैसे ट्रांसफ़र कर सकते हैं। इस वीडियो में मैंने सात तरीक़े बताये हैं जो की काफ़ी आसान हैं। आप अपनी ज़रूरत के हिसाब से कोई भी तरी...
Attendance Sheet with Check Boxes in Excel Hindi 2024 | Attendance Sheet कैसे बनाएँ | Attendance
Просмотров 63428 дней назад
आज के वीडियो में हम देखेंगे कि हम Excel में एक Attendace Sheet कैसे बना सकते हैं। इस Attendace Sheet में Check Boxes होंगे जिसके माध्यम से में हम अपने Attendance को मार्क करेंगे In today's video we will see how can we create a fully dynamic attendance sheet in excel. Attendance will be marked through check boxes in this format. Attendance Sheet with Check Boxes in Excel Hindi 2024 | Attendance ...
Daily Sales Report with Categories in Excel Hindi / DSR Report / Sales Report
Просмотров 694Месяц назад
आज के इस वीडियो में हम देखेंगे कि हम Excel में एक Daily Sales Report with Categories कैसे बना सकते हैं। ये Daily Sales Report fully automatic होगा और आपको पूरा का पूरा रिपोर्ट सिर्फ़ एक ही क्लिक से मिल जाएगा In today's video we will see how can we create a Daily Sales Report with Categories in Excel. This Daily Sales Report will be fully automatic and you will have to do minimum manual entries....
Complaint Maintenance Log Sheet in Excel Hindi 2024 | Snag List | Maintenance Log कैसे बनाते हैं
Просмотров 322Месяц назад
आज के वीडियो में हम देखेंगे कि हम Excel में एक fully automatic Maintenance Tracker कैसे बना सकते हैं।ये Maintenance Tracker काफ़ी user friendly है और इसे बनाना भी काफ़ी आसान है। मैंने इस फॉर्मेट में कोई Macros या VBA का इस्तेमाल नहीं किया है। In today's video we will see how to create a fully dynamic aur automated Maintenance Tracker in Excel. This format is very user friendly and I have used v...
Report Card Quarterly in Excel Hindi 2024 | How to Create Marksheet in Excel | Excel Marksheet
Просмотров 133Месяц назад
How to Make Marksheet in Excel in Hindi - एम एस एक्सेल में मार्कशीट कैसे बनाएं? | Marksheet in Excel Aaj ke Video me hum dekhnege ki hum Ms Excel me ek Quarterly Marksheet kaise bana sakte hain. Ye Marksheet Fully automatic hoga aur aap isme multiple classes ke marksheets bana skakte hain. In today's video we will see how can we create a Quarterly Mark sheet or Report card of Students #markshee...
Search Bar in Excel Fully Automatic 2024 | How to Build Search Box in Excel | You NEVER Knew About!
Просмотров 511Месяц назад
In today's video we will see how can we create dynamic search box or search bar in excel WITHOUT any Macros or VBA. आज के वीडियो में हम देखेंगे कि हम Excel में एक Fully Automatic Search Bar कैसे बना सकते हैं। ये Search Bar fully automatic होगा। ये search bar हम WITHOUT Macros और WITHOUT किसी VBA Code के बनायेंगे #excelformula #exceltips #ExcelSearchBar ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚...
Automatic Report Card in Excel | Student Result Card in Excel Hindi 2024
Просмотров 258Месяц назад
Automatic Report Card in Excel | Student Result Card in Excel In today's video we will see how can we create Automatic Report Card in Excel of Student Result Card in Excel. This Report card will be fully automated or Dynamic and with the help of your data, you can create mark sheets or report cards for various classes. आज के Video में हम देखेंगे कि हम Excel में एक Automatic Report Card in Excel...
Daily Payment Collection Report in Excel Hindi 2024
Просмотров 611Месяц назад
A daily payment collection sheet is a document used by a business or organization to record daily transactions. It details all payments received throughout the day. आज के वीडियो में हम देखेंगे कि हम Excel में Daily Payment Collection Sheet कैसे बना सकते हैं। #paymentcollectionsheetinexcel #excel #officefreak #exceltutorial #exceltraining #exceltips #excelsolutions #exceltech #exceltricks #micro...
Student Fee Record Sheet in Excel Hindi 2024 | Create Automatic Student Fee Management in MS Excel
Просмотров 261Месяц назад
Student Fee Record Sheet in Excel Hindi 2024 | Create Automatic Student Fee Management in MS Excel
Stock / Inventory Consumption Software in Excel Hindi 2024 Inventory Management in Excel
Просмотров 216Месяц назад
Stock / Inventory Consumption Software in Excel Hindi 2024 Inventory Management in Excel
Fully Automated Attendance Sheet with 2nd and 4th Saturday Week Off
Просмотров 293Месяц назад
Fully Automated Attendance Sheet with 2nd and 4th Saturday Week Off
🔥 Automated EXPENSE TRACKER Software in Excel 2024 | Daily Expense Tracker in Excel Hindi 2024
Просмотров 5572 месяца назад
🔥 Automated EXPENSE TRACKER Software in Excel 2024 | Daily Expense Tracker in Excel Hindi 2024
How To Maintain INCOME & EXPENSE With PROFIT & LOSS in Excel ? / Income Expense Tracker in Excel
Просмотров 6442 месяца назад
How To Maintain INCOME & EXPENSE With PROFIT & LOSS in Excel ? / Income Expense Tracker in Excel
How To Make Professional DEBIT and CREDIT Sheet in MS Excel ? Debit & Credit Sheet in Excel Hindi
Просмотров 5382 месяца назад
How To Make Professional DEBIT and CREDIT Sheet in MS Excel ? Debit & Credit Sheet in Excel Hindi
OMG🔥Microsoft excel Unstack Data in Hindi 2024 | How to Unstack Data in excel | Excel Formula
Просмотров 1392 месяца назад
OMG🔥Microsoft excel Unstack Data in Hindi 2024 | How to Unstack Data in excel | Excel Formula
Staff Scheduling in Excel / How to create a work schedule in Excel / Duty Roaster
Просмотров 2062 месяца назад
Staff Scheduling in Excel / How to create a work schedule in Excel / Duty Roaster
Data Cleaning Tips & Tricks in Excel Hindi 2024 | Master Data Cleaning Essentials on Excel
Просмотров 4522 месяца назад
Data Cleaning Tips & Tricks in Excel Hindi 2024 | Master Data Cleaning Essentials on Excel
Cleaning Schedule in Excel Fully Dynamic Hindi | Daily Weekly Monthly Quarterly Half Yearly & Yearly
Просмотров 2492 месяца назад
Cleaning Schedule in Excel Fully Dynamic Hindi | Daily Weekly Monthly Quarterly Half Yearly & Yearly
Yearly Calendar in Excel in Hindi 2024 / Excel Yearly Calendar / Calendar
Просмотров 562 месяца назад
Yearly Calendar in Excel in Hindi 2024 / Excel Yearly Calendar / Calendar
Yearly Attendance Tracker in Google Sheets 2024 | Attendance Sheet | Attendance Sheet Google Sheets
Просмотров 8372 месяца назад
Yearly Attendance Tracker in Google Sheets 2024 | Attendance Sheet | Attendance Sheet Google Sheets
OMG 🔥 Excel Advanced Shortcuts in Hindi / Excel Shortcuts / Microsoft Excel / Data Cleaning
Просмотров 6512 месяца назад
OMG 🔥 Excel Advanced Shortcuts in Hindi / Excel Shortcuts / Microsoft Excel / Data Cleaning
Mastering IF Formulas in Excel Hindi / Become Excel Master With 10 Useful IF Formula Examples
Просмотров 1113 месяца назад
Mastering IF Formulas in Excel Hindi / Become Excel Master With 10 Useful IF Formula Examples
Employee Productivity Tracker in Excel Hindi | Productivity Tracker | Employee Productivity
Просмотров 1343 месяца назад
Employee Productivity Tracker in Excel Hindi | Productivity Tracker | Employee Productivity
Hi Sir
Hello 👋
at 13:55, how avoid to replace a State that initiate with C letter?
11:21 I have demonstrated another way to unstack data.
@@OfficeFreak the first ok ,thx
@Anomaliateam my pleasure
Dear sir, Need a Tutorial to get Specific range Data from multiple select file to Active Sheet , I have seen Many kinds of Video tutorials From your channel ,But i haven't Found As a Tutorial . I Have a need : get Specific range Data as a Range (A29:D29) to Active Sheet From All selected Workbooks . And Past Active Sheet ,Destination Range (A29:D29) .xldown Please help To get Tutorial or Code. Please see my Request. Best Regards Mostain Bangladesh
Hi Mostain, This can be done through Sum function. Please mail me your format, let me check what can be done. My mail id is vijaymuukh@gmail.com
sheet is protected so its just waste of time to watch as he coiped and then explained in this video
So please don't waste your time. Each and everything is explained in detail, how to create the format. Thn also you guys need unlocked format. Why ? Put some effort and pain to create the formats. Why you guys need everything cooked and served in a plate for free ? Grow up
Dear Sir Kindly Send me practice file because my Hard Didsk Broken/damage so I lost my all save files please cooperate me if possible send me all downloads, files, thank you
Download and editing access are exclusively for Channel Members. To gain these benefits and access the file, please become a Channel Member by joining through the link below. Your membership not only grants access but also supports our continued content creation. Be part of OfficeMonk Family from the link below ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin
Informative content, very useful in real life, Immense Thanks
Thank you so much for loving the video and getting connected with the Channel. Please stay connected for such interesting videos and topics. 😊😊😊
can use for arabic font??
Excel functions and formulas will be same for any language
Sir I am supervisor job my company attendance sheet start 16 to 15 how to setting please reply
Instead or 1st date in the beginning , put 16th as start date
Sir, can you provide sane output using INDEX SMALL IF function for older versions of excel. Thank you.
Will upload soon
Thanks. Supreb. Colour ful
Thank you so much 😊
Learnt some new things in dashboard. It will add value.
Thank you so much Umesh 😊😊😊
You deserved million of like and subscribe love and respect from 🇵🇰
Thank you so much for your kind words. It really means a lot
Great making
Sir Good Evening. Request u to do something for expenses of project expenses incurred during. Extra costs involved in it. Need of the hour. Thanks
Noted Umesh. I will try to come up with such format soon
Sir Sunday lock nahi Ho rha hai
vijaymuukh@gmail.com Aap format bhej dijiye. Main check kar leta hun
Super great learning experience. Keep it up
Thank you so much Umesh 😊😊😊
Sir, create automed dashboard for managing office expenses or project related expenses for different sites. Expenses clsimed by employees . Traveling expenses
Sure, I will try
Me heard@@OfficeFreak
Agr sir all employees ki over time bhi niklna ho aur salary add on krni ho to kasa krnga
@Office-Monk Ye mera English Channel hai. Aapko yahan Over Time nikalna aur uska Salary kaise calculate karna hai, iske related videos mil jayenge
Please share the spreadsheet
Link is in the description box
Hi, unable to download the sheet. Is this a paid one?
Download or edit access is only for Channel Members. You can join the Channel Membership to download the file. Membership fees is hardly something.
Really great work done by you Sir, G. Regards from Pakistan.
Thank you so much Mustafa. Stay connected 😊😊😊
Can I get this excle file
Download or edit access is only for Channel Members. You can join the Channel Membership to download the file
sir, month to change nahi ho raha hai, kya karna chahiye
Month change nahin ho raha, matlab ? Main samjha nahin. Plz detail me bataiye
A kounsa Excel hai
Ms Office 365, for MacBook
Hi sir if, I select the another year data shows that the previous attendance that have been already filled, it should be the blank one right .
It will not be Blank as it's the format of just one month. For 12 months you will have to create 12 Sheets.
@@OfficeFreak sure thank you sir. 🙏
sir,jo present absent h vo dusri row me show ho rha h usse same row me show krwana h pls formula bta do
vijaymuukh@gmail.com Aap apna format share kar do. Main check kar lunga
@@OfficeFreak thankyou sir for reply but sir ho gya he thik double kiya tha thodi si mistake thi
@NikitaPatidar-vk7md aap mere latest videos dekhiye Attendance Sheet ke. New formats kaafi Advanced hain
@@OfficeFreak ok sir thankyou
Second and fourth saturday restrict nahin ho raha
Umesh, aap apna format mujhe mail kar den, main dekh lunga vijaymuukh@gmail.com
It's not working 👎👎👎
Might not be working for you but it's working perfectly on my system and no one till date had any issues. Will recommend to upgrade your Ms Office. Thanks
Sir leave ko kaise credit karte hai aur fir agr person leave debit kr leta h to use kaise maintain karen. For example har month kisi person ko 2 leaves credit karni to fir use kaise karenge aur final balance kaise nikalte hai
Hi Umakant, leave debit aur credit karne ke liye humay dusra format create kakrna hoga with multiple criterias
Wow...
Thank you 😊
Excelent & valueable information with your perfect knowledge on Subject. I have to watch your maximum videos to learn valuable & worth information in minimum time & to improve myself, my interest is in Excel , Power Bi, SQL & Power Point Presentations as afreelancer
Thank you so much for the appreciation. Will request you to check my English Channel once. Name or the Channel is Office Monk
Nice sir
Thank you so much 😊
Thanks from Bangladesh
Thank you so much 😊
Sir monthly class wise outstanding kaisa nikla vo be seekho plz😊
Aap har class ke liye =Sum use kar sakte ho
Thanks ur method is excellent ❤
Thank you so much for loving the video 😊. Stay connected for such interesting formats and videos
Great 👍 work..... Best wishes.....
Thank you so much for the appreciation 😊
Awesome ❤.. sir.. we actually require a mentor like you
Thank you so much 😊
Wow, this is very helpful to track my employees.
Thank you so much Avtar. 😊
Excellent but which Ms Office/ Windows version have available this option.
Office 2016 and above that
Mobil se kese kare
Laptop ya desktop use kar lijiye aap. Mobile me saare features nahin rehte
Sirr financial analyst ke practical video banayi kaise work kiya jaata haii plzzz
Sure. Will try
From mobile not possible!
No, it's not possible from Mobile
Very nice sir, 👍. I have sent request for being an editor to the link you provided. Also would like to ask do you also make tutorials on Google AppSheet?
Thanks a lot Dinesh. Nope, I don't create videos on Google AppSheet
How we add all months in one cell?
It can be added in next columns. Format would be bit lengthy but ya, it can be adjusted
@@OfficeFreak can you please make a video on this?
Sure. You can check more formats on my other Channel, Office Monk
@@OfficeFreak thank you
Thanks you sir AAP ke es tarike se meri bohat help hui hai
My pleasure 😊
Bahut accha sir
Thank you so much Amit 😊
Best
Thank you so much 😊
Sir, in attendance sheet how to select all are present instead to do individual for perticular day.
Or in other way make present as a default and we do absent or other things as per need
=Countif(select whole range,"P")
@@OfficeFreak Thank you Sir
window7 does fn.f5 it does not active
Instead of Fn. F5, use F5
Thank you very much sir very helpful
Thanks a lot for loving the video and getting connected with the Channel