![Office Monk Ur Excel Coach](/img/default-banner.jpg)
- Видео 172
- Просмотров 620 535
Office Monk Ur Excel Coach
Индия
Добавлен 8 окт 2022
Welcome to my RUclips channel dedicated to Office Productivity and Technical skills. This channel features comprehensive tutorials and tips on Microsoft Excel, PowerPoint, Word, Google Sheets, MacBook, Video Editing, designed to help you master these tools and improve your productivity.
Whether you're a student, a professional, or just someone who wants to enhance their technical skills, my videos provide step-by-step guidance and practical insights to help you get the most out of these tools. I cover everything from basic features to advanced functions, and the content is suitable for beginners and experienced users
So, if you want to become an expert in Microsoft Excel, PowerPoint, Word, Google Sheets, MacBook, and video editing, be sure to subscribe to my channel and hit the notification bell to stay updated with latest content.
ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin
#officemonk
For Business
vijaymuukh@gmail.com
Whether you're a student, a professional, or just someone who wants to enhance their technical skills, my videos provide step-by-step guidance and practical insights to help you get the most out of these tools. I cover everything from basic features to advanced functions, and the content is suitable for beginners and experienced users
So, if you want to become an expert in Microsoft Excel, PowerPoint, Word, Google Sheets, MacBook, and video editing, be sure to subscribe to my channel and hit the notification bell to stay updated with latest content.
ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin
#officemonk
For Business
vijaymuukh@gmail.com
Most Common Excel Errors #️⃣ and How To Fix Them!
How to Fix Broken Excel Formulas ?
When using Excel, you might encounter formula errors. These errors aren't necessarily bad; they indicate something's wrong with your formula. Instead of deleting them, learn how to fix them. In today's video, we'll cover the 10 most common formula errors in Microsoft Excel and how to handle them properly.
Know the reasons behind common Excel errors like #VALUE!, #SPILL!, #NAME?, #REF!, #DIV/0!, and #N/A
#excel #excelerrors #officemonk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join this Channel Membership:
ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 File Link: Free
docs.google.com/spreadsheets/d/1UkkRISP-Qo_...
When using Excel, you might encounter formula errors. These errors aren't necessarily bad; they indicate something's wrong with your formula. Instead of deleting them, learn how to fix them. In today's video, we'll cover the 10 most common formula errors in Microsoft Excel and how to handle them properly.
Know the reasons behind common Excel errors like #VALUE!, #SPILL!, #NAME?, #REF!, #DIV/0!, and #N/A
#excel #excelerrors #officemonk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join this Channel Membership:
ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 File Link: Free
docs.google.com/spreadsheets/d/1UkkRISP-Qo_...
Просмотров: 242
Видео
Daily Sales Report with Multiple Criteria | How to Create a Daily Sales Report in Excel
Просмотров 7479 часов назад
In today's video we will see how can we create Daily Sales Report or DSR, criteria wise. We will maintain all the data in a single sheet and based on that data, we will create our report which will be fully dynamic, means fully automated. I am sure you will get lots of learnings from this format. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join this Channel Membership to download the file...
Maintenanace Tracker Log | Maintenance LOG SHEET | Snag List | Maintenance Checklist in Excel | PPM
Просмотров 59014 часов назад
In this video we will see how to create an automated maintenance complaint log sheet which will track all the things automatically. Only things which we will have to insert or mention will be information date and completion dates. Sheet will automatically track the status and rest of the things. As soon as the work will be done or completed, Days will reshuffle from pending to done column. ▬▬▬▬...
How to Create Student's Report Card Quarterly | Quarterly Mark Sheet | Quaterly Report Card!
Просмотров 25216 часов назад
In today's video we will see hoa can we create Student's Quarterly Report Card in Excel. We can also call it Quarterly Mark Sheet or Quaterly Report Card. This Report Card will be fully formulated and most of the things will be formulated. #marksheet #officemonk #studentmarksheet ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join this Channel Membership to download the file: You can join th...
Dynamic Search Bar in Excel 2024 | Make a Search Bar in Excel to Find Anything | No VBA
Просмотров 46021 час назад
Dynamic Search Bar in Excel 2024 | Make a Search Bar in Excel to Find Anything | No VBA In this video, we'll make a dynamic search bar so you can search for any values in your dataset. In this format we will not use any Macros or VBA. #searchbox #excel #officemonk #exceltraining #microsoft #excelcourse #smartexcel #exceltutorial #excel_online_course #excelcourse #excelsolutions ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬...
Students Report Card in Excel 2024 | Automatic Report Card in Excel | Student Result Card in Excel
Просмотров 607День назад
Students Report Card in Excel 2024 | Automatic Report Card in Excel | Student Result Card in Excel In today's video tutorial, you will learn how to create an automatic student result card in Excel. By simply typing or selecting a student's roll number from a dropdown menu, the report card will be generated automatically. This tutorial utilizes common Microsoft Excel formulas to achieve this fun...
Daily Payment Collection Report in Excel 2024, Fully Dynamic | Payment Collection Sheet in Excel
Просмотров 78714 дней назад
Daily Payment Collection Report in Excel 2024, Fully Dynamic | Payment Collection Sheet in Excel In this video tutorial, you'll discover how to manage daily market collections efficiently using Excel. This tool is invaluable for distributors across various sectors, aiding in the organisation and tracking of daily transactions. You'll learn how to input data accurately and apply formulas for aut...
Students Fee Record in Excel Fully Dynamic | Create Automatic Student Fee Management in MS Excel
Просмотров 54614 дней назад
Students Fee Record in Excel Fully Dynamic | Create Automatic Student Fee Management in MS Excel In this video, we will learn to manage student fee data structure in Microsoft excel. This format will be fully dynamic and all the things will be automatically calculated once we feed our data. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join this Channel Membership to download the file: rucl...
Stock [ Inventory ] Management in Excel - Stock Maintain in Excel - Stock Register
Просмотров 37321 день назад
Stock [ Inventory ] Management in Excel - Stock Maintain in Excel - Stock Register In this video you will learn how to manage stock in excel with inventory management - If you need to maintain stock in excel then this Fully Automatic Stock register will help you to manage sale, purchase and inventory of stock. You can use this as Stock register format in excel to maintain your automatic stock r...
Employee Attendance Sheet with 2nd and 4th Saturday Week Off
Просмотров 43921 день назад
Employee Attendance Sheet with 2nd and 4th Saturday Week Off In today's video we will see how we can we create Employee Attendance Sheet with 2nd and 4th Saturday Week Off in Excel. This format will be fully dynamic or automated. Holidays, Sundays, 2nd & 4th Saturday and Month ends will be highlighted as well as restricted. There will be total 14 sheets in the workbook. 1 for Settings, 12 sheet...
🔥 Automated EXPENSE TRACKER Software in Excel 2024 / No VBA / No Macros / No Pivot Table
Просмотров 62028 дней назад
Automated EXPENSE TRACKER Software in Excel 2024 / No VBA / No Macros / No Pivot Table In this video you will learn, how to create an expense tracking software 2024 in Excel, how to maintain expenses in excel. MS Excel Dashboard Tutorials ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📚 Please join this Channel Membership to download the file: Join this channel from the link below: ruclips.net/channe...
Income & Expense Tracker in Excel How To Maintain INCOME & EXPENSE With PROFIT & LOSS in Excel
Просмотров 638Месяц назад
Income & Expense Tracker in Excel How To Maintain INCOME & EXPENSE With PROFIT & LOSS in Excel. in this video you will learn, how to create INCOME & EXPENSE sheet With PROFIT & LOSS in Excel ? Balance sheet in excel #excel #incomeexpensesheet #profitlossinexcel #excel_online_course #ExpenseTracker #DailyExpenseTracker ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please join this Channel Membership ...
How to Create Debit and Credit Account Ledger in Microsoft Excel | Debit and Credit in Excel
Просмотров 1,2 тыс.Месяц назад
in this video you will learn, how to make a debit and credit sheet in microsoft excel. How to Create Debit and Credit Account Ledger in Microsoft Excel using basic formulas #debitcredit #debitandcredit #excel #debitandcredit #debit_and_credit_sheet_in_excel #excel_debit_credit #exceltutorial #excelforbeginners #workschedule #microsoftoffice ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please join t...
Unstack Data in Excel / Quick Excel Tricks to Unstack Data / Unstack Data
Просмотров 297Месяц назад
Master the art of unstacking column data in Excel with our straightforward and time-saving method. Say goodbye to complex formulas and embrace a simpler approach. Excel Hacks: Tips & Tricks #excel #exceltutorial #excelforbeginners #workschedule #microsoftoffice ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Join this channel to get access to perks: ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin ▬▬▬...
How To Create a Work Schedule in Excel
Просмотров 990Месяц назад
Dive into this step-by-step tutorial and learn how to create a work schedule in Excel. Regardless if you're an Excel veteran or just a beginner, this video will guide you through the simple steps in crafting your very own work schedule. The video includes everything from inputting data to formulating a schedule that suits your needs. Master this crucial technique that can streamline your daily ...
Master Data Cleaning Essentials on Excel in Just 20 Minutes / Data Cleaning Tricks in Excel 2024
Просмотров 460Месяц назад
Master Data Cleaning Essentials on Excel in Just 20 Minutes / Data Cleaning Tricks in Excel 2024
How To Create CLEANING SCHEDULE in Excel / Cleaning Schedule in Excel / Cleaning Schedule
Просмотров 939Месяц назад
How To Create CLEANING SCHEDULE in Excel / Cleaning Schedule in Excel / Cleaning Schedule
Calendar in Excel 2024 I Create Easy Yearly Calendar in Excel and Sheets with a SINGLE Formula
Просмотров 391Месяц назад
Calendar in Excel 2024 I Create Easy Yearly Calendar in Excel and Sheets with a SINGLE Formula
How To Make Staff Attendance in Google Sheets | Yearly Attendance Tracker in Google Sheets 2024
Просмотров 858Месяц назад
How To Make Staff Attendance in Google Sheets | Yearly Attendance Tracker in Google Sheets 2024
Excel Shortcuts for Data Cleaning / Excel Shortcuts / Excel Shortcuts You SHOULD Know!
Просмотров 917Месяц назад
Excel Shortcuts for Data Cleaning / Excel Shortcuts / Excel Shortcuts You SHOULD Know!
Create Employee ID CARDS in Bulk 2024 | Automatic ID Card using EXCEL Data | ID card in Excel
Просмотров 291Месяц назад
Create Employee ID CARDS in Bulk 2024 | Automatic ID Card using EXCEL Data | ID card in Excel
OMG🔥Microsoft excel all formulas | How to use excel formulas in Excel | Excel 25 Advanced Formulas
Просмотров 411Месяц назад
OMG🔥Microsoft excel all formulas | How to use excel formulas in Excel | Excel 25 Advanced Formulas
Employee Productivity Tracker in Excel 2024 | Productivity Tracker | Employee Productivity
Просмотров 3852 месяца назад
Employee Productivity Tracker in Excel 2024 | Productivity Tracker | Employee Productivity
Master the IF Formula in Excel (Beginner to Pro)
Просмотров 2162 месяца назад
Master the IF Formula in Excel (Beginner to Pro)
25 Basic Excel Formulas | How to use excel formula and functions in Excel | Excel Formulas
Просмотров 8122 месяца назад
25 Basic Excel Formulas | How to use excel formula and functions in Excel | Excel Formulas
Performance Appraisal Forms in Bulk / Performance Appraisal / Human Resource
Просмотров 2472 месяца назад
Performance Appraisal Forms in Bulk / Performance Appraisal / Human Resource
Advanced Annual Leave Tracker in Excel 2024 / Leave Tracker in Excel / Vacation Tracker
Просмотров 5752 месяца назад
Advanced Annual Leave Tracker in Excel 2024 / Leave Tracker in Excel / Vacation Tracker
Data Entry Sheet in Excel | New Automated Data Entry Software in Excel | Data Entry in Excel
Просмотров 7702 месяца назад
Data Entry Sheet in Excel | New Automated Data Entry Software in Excel | Data Entry in Excel
Complaint Maintenance Log in Google Sheets 2024 / Maintenance Log / Google Sheets
Просмотров 5152 месяца назад
Complaint Maintenance Log in Google Sheets 2024 / Maintenance Log / Google Sheets
Advanced Attendance Sheet in Excel 2024 / Corporate Attendance Sheet
Просмотров 7252 месяца назад
Advanced Attendance Sheet in Excel 2024 / Corporate Attendance Sheet
Hello sir, thank you for the video, I sent you an email, could you help me please?
Hi Carlos, I got your email. Will be back with you soon. Thanks for joining the Channel Membership
Thank You so much, Filter formula seems to be a much easier solution than macros or helper. I had a query. After copying data upto H column in all the sheets, i have 6 more columns which are there in all the other sheets except the main data sheet. There are formulae for each specific sheet. Is it possible that once new data is auto updated in a person's individual sheet, then automatically the formulae in the 6 columns after H column gets copied to the new data's rows ?
The filter formula is not enabled in my Excel sheet. How do I enable it?
The FILTER function is only available in Microsoft 365 and Excel 2021. The older versions of Excel do not have this function.
This is one of the perfect video i have been searched for. Very useful, doing great, Thank you!
Thank you so much for the appreciation. It really means a lot. Stay connected for such interesting formats and videos
Found it!
That's great
Good morning....where is the description box?
Very good morning. Just under video you will see the description of the video. In the end it will be written show more.... click on show more and the description box will open. Btw what are you looking for in description box? Please let me know, so that I can guide you that way
Hi I joined your membership and i am unable to download this sheet.
Drop me a mail on vijaymuukh@gmail.com
Second and fourth saturday restrict nahin ho raha. Pls help karein
Umesh, aap apna format mujhe mail kar den, main dekh lunga vijaymuukh@gmail.com
Thank you Sir for the video, its useful.
Thanks a lot MK for the appreciation 😊
can you send me this sheet
Hi Siddharth, File download or edit access is only for Channel Members. Please join the Channel Membership and I will share the Excel file. You will get the link in description box to join the Channel Membership
i have join your membership how that i open the sheet in edit version
Hi Gnanasekaran, I have mailed you the format. Please check your mail and drop a comment if you received
@@Office-Monk thanks for sharing
@gnanasekaranp2976 thank you so much for joining the Channel Membership
Thank you 💕💕 But these conditions are not working in my excel sheet, I am using Excel 2013, or does it not support these conditions?
Which conditions are not working? Please let me know in detail
sir kindly share this link . Nhi mil rha
Download or edit access is only for Channel Members. Please join the Channel Membership and I will share the file
Sir ye A4 paper hy or A3
Formats me main print area set nahin karta. Aap apni requirements ke hisab se set kar sakte hain
What is the meaning of TA.. DA and PF?
TA means Travel Allowance, DA means Dearness Allowance, HRA means House Rent Allowance and PF means Provident Fund. These are part of an Employee Salary which is applicable in India. Every country has different rules and policies, so I am really not sure what rules and policies are applicable in your country regarding wages or salary of an employee.
I have been looking for such things in 2 years thank u so much. Where can i contact u from
You can message me on my Instagram
Thanks @OfficeMonk for your videos
Thank you so much MK for the appreciation 😊😊😊
@@Office-Monk how will I join your membership sir?
ruclips.net/channel/UCBz4_fNn1dN4IiS3KWleoKQjoin You can join the Channel Membership from the link. Thanks in advance MK
How would I print all the reports for each students in a class Sir
Thorough this format you can print one marksheet at a time. In case you want to generate bulk marksheets at one time, you will have to use mail merge. Request you to watch the video of, How to create bulk marksheets. You will get the video on my Channel
Enclosed link deleted
docs.google.com/spreadsheets/d/1fK0QQpBa1sRQ76EbEMMcJYgHPjjZ61Oz/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
Photo function not working 😭 in my excel
Oops. You will have to manage without pictures thn. Will suggest you to download excel 365 or 2021
Nice sir,
Thank you so much 😊
9 number viewr
Saw your comment for the very 1st time. Stay connected 😊
sir i want to download the sheet and already join the channel how can i download it
Thanks a lot for joining the Channel Membership Saleh. I have mailed you the Excel sheet of PPM Tracker
Thank you so much sir apke video se mujhe bahut help mila ❤
Thank you so much 😊
I have cake shop like mio Amore but i have no idea about daily sales report and i want to note that in excel every item purchased and sale report and please make a video of easy to work please
Sure, I will try
Aap isako hindi me bhi translet kijiye
Office Freak. Ye mera Hindi Channel hai. Aapko same video Hindi me wahan mil jayega
@@Office-Monk ok
Thanks a lot for the video. I am a channel member, but i cannot download the file.
Can't see you in my Membership list.
how to apply WO only for second and fourth saturday?
Please watch my latest video of Attendance Sheet. In new video I have highlighted and restricted 2nd and 4th Saturday
Sir,in quarter and half year formula why -1 is done in month.Pl clear it.
I am unable to understand the query. Please tell me in detail
Thanks for the video @OfficeMonk
Thanks a lot MK 😊
Hi there, I am getting error in the sheet, the pto is getting highlighted in the cell when i am changing the months , its reflecting in other months as well. Can you please hlep me with the error what mistake did i make
vijaymuukh@gmail.com Mail me the format
The inputs are still there evn after changing the year/months. What shall i do?
The format is only for 1 month. For 12 months you will have to create 12 sheets and 1 sheet will be for Annual. I have created one more format in which you can do entries of 12 months in a single sheet. just check that video too
Sir jab total amount 8000 hua usme advance 5000 kr chuka h to payable amt 3000 hi na hoga sir
Video ke kis minute par maine ye bataya hai ? Aap ek baar batao, main check kar leta hun
Dear Sir, The video is not clear its blarred
Click on Settings on right hand top side of Video and increase the quality. Do it hight quality and video will be clear. I posted the Video in 4k quality
@@Office-Monk Thank u for the advice
Its outstanding information
Thank you so much for loving the video and getting connected with the Channel 😊
Thank you, I am create a annual leave tracker using your method. but some formula don't work, I will be grateful if you sent me Annual Leave Tracking excel sheet. Thank you
Please mail me your format. I will check what's the issue vijaymuukh@gmail.com
Thank you for this video, it is very helpful. Is there a way to add another sheet which would take data from each month and show a snapshot of all leave entered for all employees for the whole year on one page
I have created many Leave Tracker videos on my channel. Will suggest you to watch most recent ones. I am sure you will get, whatever you are looking for
Sir file is downloading it shows only view give permission so we can download
You can join the Channel Membership to download the file
How about daily sales for jewelry shop
All Sales Report work on the same format where you have to track Sales and Transactions. In case you want to add more heads like Mode of Payment (Online, Card or Cash), you can
Can i purchased it
You can join the Channel Membership from the link provided in the description box for editable file
In situations where there is no employee code, what will be the formula to use?
In that case, take employee name as lookup value. Simple
can you email the file please? i cant download it. Export mode is off
Please join the channel membership from the link provided in the description box to download the file. Thanks.
please send me email for this file
I have never seen a video like this, sir
In positive or negative way ?
Is it working on Android Mobile ? Sir please reply
We have limited features on mobile if we compare from Laptop or Desktop. So it may not work in Mobile, either Android or Apple
The very first one to watch the video with full attention!
Thanks a lot Sani. This Attendance sheet is totally different with 2nd and 4th Saturday Weekoffs. Some new formulas are also used
@@Office-Monk please sir send this file into my email.
Thanks Vijay. it is Very helpful and useful system.
Sir, I downloaded the file from the link, it is not working. Plz help me
By what mail id you have requested the access?
ask.ashu10
Gmail