How to Calculate Expiry Date and Days Left in Excel / Office Monk
In this video we'll be learning how to use conditional formatting to create expiration alerts in Excel. In order to actually get to the conditional formatting, we'll need to know how to use the IF function, the TODAY function, a simple subtraction. The Today function in excel is going to be necessary in order to figure out which dates are due, or nearing due. =TODAY() in excel is dependent on the computer clock. The =IF() function in excel will figure out, using conditional logic, if we have an expired or non expired invoice. We'll also use a nested if function to add a middle "about to expire" warning. Finally, we'll be using the Text that Contains conditional formatting rule to highlight with different colors the cells that are expired or on time.
#excelformula #exceltip #exceltrick
FIle Link:
https://docs.google.com/spreadsheets/d/1D9lkRlSYOpALxJbG5u_BZ2WunqwjXUAV/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
Please Like, Share and Subscribe: #OfficeMonk
1
view
Add HINDI or any other Regional LANGUAGE in MacBook / Office Monk
Add HINDI or any other Regional LANGUAGE in MacBook / Office Monk
Typing and choosing different font styles is easy in English language but when it comes to Hindi, we find it difficult or Complicated. Today we will see how we can use Mangal font, hindi fonts or other regional languages on Apple Devices (Macbook Pro, Macbook Air, i mac)
#hindiinmac #hindiinmacbook #HowToUseHindiFontsInMac #HowToUseRegionalLanguagesinMac
1
view
Best Ever Intro Slide in PPT / Create the Fanciest PowerPoint Intro slide
How to Create an Awesome Introduction Slide in PowerPoint Presentation
Are you looking for ways to create an engaging and impressive introduction slide for your next PowerPoint presentation? Look no further! In today's video, I'll show you step-by-step how to create an awesome introduction slide that will capture your audience's attention right from the start.
#powerpoint #introslide #Officemonk
4
views
Chat 🔥🔥🔥 GPT in Excel / 10X Your Excel Skills with ChatGPT 🚀
n this video, we explore how to use ChatGPT, a powerful language model from OpenAI, directly in Excel. By leveraging the power of the GPT-3 API and some clever Excel formulas, you can generate natural language text and even answer questions
If you're looking to take your Excel skills to the next level and leverage the power of AI, this video is for you. So grab a cup of coffee, fire up Excel, and let's get started.
#officemonk #chatgpt #excel
5
views
INCOME and EXPENSE Tracker in Excel
Looking for a simple and efficient way to keep track of your finances ? Then look no further than this Income and Expense Tracker in Excel video tutorial! In this step-by-step guide, you'll learn how to create a personalized spreadsheet that allows you to easily monitor your income and expenses.
Whether you're a freelancer, small business owner, or simply trying to stay on top of your personal finances, this Excel tracker is the perfect solution. You'll learn how to input your income and expenses, categorize your spending, and generate reports that provide valuable insights into your financial habits.
📂 File Link:
https://docs.google.com/spreadsheets/d/1Q7tMi7ULwwUDZEHlzozcNpE9XcWPC4tt/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
=============================================
#incomeandexpensetracker #excel #exceltutorial #exceltips #exceltricks #excelhacks #income #expense #expensetracker #expensemanagement #expenses #incometracker #expeseandincometracker
2
views
Most Advanced Excel Shortcuts You Must Know
Most Advanced Excel Shortcuts You Must Know
Looking to take your Excel skills to the next level ? In this video, we'll be going over some of the most advanced Excel shortcuts you need to know to save time and boost your productivity.
I'll cover nearly 15 Shortcuts which will Boost your Productivity . Whether you're a seasoned Excel pro or just getting started, you're sure to learn something new and valuable.
So sit back, grab your favorite beverage, and get ready to become an Excel power user with these essential shortcuts.
📂 File Link:
https://docs.google.com/spreadsheets/d/1scfBU3FfJ_fyDVvevriR29KCb5zDQTun/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
=================================================
#excel #excelshortcuts #advancedexcel #excelhacks #exceltips #exceltricks #exceltutorial
1
view
Calculate Daily Working Hours and Overtime / How to Calculate Hours Worked in Excel
Learn how to calculate the number of hours worked in Excel in a few simple steps. The table here contains the time when an employee started and finished work. Hours worked as well as OVertime can be calculated easily, as time difference – simply take the later time and subtract the earlier one. Watch this excel video tutorial to learn how to do it. How to calculate time in excel. In this time calculating tutorial you will learn how we can easily calculate time difference in excel between 2 times and two dates this video will explain how we can calculate date & time difference in excel. calculate hours and minutes between two times & two dates.
#excel #exceltutorial #officemonk #workinghours
File Link:
https://docs.google.com/spreadsheets/d/1nbS1Qe-wXfhxYxrvVFjq6w5TFwa6iS3K/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
4
views
Housing Society Maintenance Sheet Fully Automated | Streamline Housing Society Maintenance Excel
Housing Society Maintenance Sheet Fully Automated | Streamline Housing Society Maintenance Excel
Are you a member of a housing society or responsible for managing its maintenance tasks? Look no further! In this comprehensive tutorial, we guide you through creating a user-friendly Housing Society Maintenance Sheet using Microsoft Excel.
📁 File Link:
https://docs.google.com/spreadsheets/d/1XmgPNFTaBdlC0_TU_3OBmWsETmASJ47H/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
======================================
#societymaintenancesheet #societymaitenance #excel #exceltutorial #exceltips #advancedexcel #advancedexceltraining
4
views
Most POWERFUL and Advanced Features of Excel | 🔥Advanced Excel Functions Excel | Advanced Features
📔📔Most POWERFUL and Advanced Features of Excel / Excel Advanced Features
In today's video we will see some of the most Powerful & Advanced features of Excel which will really ease your job. Features like, Getting headers on all pages while printing, Creating multiple worksheets in a single click, Inserting data in Multiple worksheets in one click, Analysing vast data by split screen, Rearranging data without inserting new columns, Auto inserting serial numbers, are really amazing and helpful.
📁 File Link:
https://docs.google.com/spreadsheets/d/1UgseEbgGdYQZ67XK7DQqyNBhUETkxqDk/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
#advancedExcel #advancedExcelTutorial #ExcelTraining #AdvancedExcelFormulas #AdvancedExcelFunctions #Vlookup #hlookup #xlookup #sumifs #concatinate #if #excelDashboard #excelReport #ExcelDataAnalytics #ExcelCourse #ExcelFullCourse #ExcelTutorial #MicrosoftExcelTutorial #ExcelTutorialForBeginners #LearnExcel
advanced excel,advanced excel formulas,advanced excel full course,advanced excel functions,beginners tutorial,complete excel course,concatinate,data analytics,excel 2019,excel crash course,excel dashboard,excel full course,excel fundamentals,excel important topics,excel interview,excel latest version tutorial,excel report,experienced,hlookup,if,index,lookup,lookup functions in excel,match,ms excel,simplilearn,sumifs in excel,vlookup,xlookup,office monk
14
views
How to Convert PDF to Word
Looking for an easy way to convert a PDF file to a Word document? Look no further. In this video, I'll show you step-by-step how to convert a PDF to a Word file using TWO Simple methods. First, I'll show you how to export the PDF to a Word file, and show you how to convert PDF online to Word, in simple steps.
Whether you need to edit a PDF document or simply want to convert it to a more easily editable format, this tutorial will guide you through the process. So sit back, relax, and let me show you how to convert your PDF to Word in just a few simple steps.
#pdftoword #pdf #msword
Office Monk,OfficeMonk,microsoft word,pdf file,word,office,office 365,microsoft office,adobe,converter,pdf to word,how to,tutorial,edit,editable,pdf converter,instant,convert,pdf to word doc,acrobat,conversion software,software,convert pdf to word,how to convert pdf to word,convert pdf to word free,pdf,pdf to word file,edit pdf
9
views
OMG🔥Auto Digital Signature | Create Digital Signature Within Minutes
OMG🔥Auto Digital Signature | Create Digital Signature Within Minutes
Welcome to today's video, where we will learn how to create a digital signature. Digital signatures are an essential part of online communication, and they provide a secure way to authenticate the identity of the sender and ensure the integrity of the data. In this tutorial, we will show you step-by-step how to create a digital signature, creating a signature template, and applying the signature to a document. Whether you are a business professional or a casual user, this tutorial will provide you with the knowledge you need to create your own digital signature and protect your online communications. So, grab your computer and let's get started.
#digitalsignature #tipsandtricks #officemonk
Office Monk,OfficeMonk,digital signature,electronic signature,how to make,word,cyber security,digital,handwrite,sign,digital signing,digital signatures,e-signature in word,electronic,signature,sign word,sign document,how to add digital signature,signature in word,word digital signature,microsoft word,computer,e-signature,e-signature on pdf,auto digital signature,create digital signature,digital signature in word
8
views
AMAZING Websites / 10 Best & Most Useful Websites 2023
10 Amazing Websites / 10 Best & Most Useful Websites 2023
In this overview video, find out about 10 extremely useful websites that you should be using. For example, learn how to edit photos directly in your browser, how to save time scheduling meetings, how to find alternatives to expensive software, and many more. This is just a sampling of the many sites we look at today.
#website #websites #amazingwebsite #amazingwebsites #magicalwebsites
Office Monk,OfficeMonk,best websites,websites,best,web sites,web site,useful websites,best sites,best free website,top 10 website,sites,10 best websites,most useful websites,calendly.com,com,net,alternativeto.net,free,interesting,new,best useful websites,free websites,laptop,computer students,tips & tricks,free software,technology,photo editing,android apps,office,cool websites,interesting websites,amazing websites,ai website,ai,most useful ai websites
14
views
Complete Functions of Count
In this Video we will see complete functions of Count in Excel, like Count, Counta,CountBlank, Countif and Countifs.
10
views
Remove Background From any Picture
Remove Background From any Picture
In this Video I will show you Five ways to remove background from pictures. Pictures without backgrounds can be used in many ways. In case you want to change the background color of any picture, just remove the current background and and add your desired color. Removing Background From any Picture is so easy, you really can't even imagine.
4
views
DYNAMIC Dashboard in Excel Without Any Formulas / Excel
DYNAMIC Dashboard in Excel Without Any Formulas
Learn how to create dynamic dashboards in Excel in this step-by-step tutorial. A dynamic dashboard is a powerful tool that lets you visualize data in a way that's interactive and easy to understand. With just a few clicks, you can create charts, graphs, and other visual elements that update automatically as you add new data or modify existing data. Whether you're a business analyst, a project manager, or just someone who wants to make sense of complex data, this video is for you. Follow along as I demonstrate how to build a dynamic dashboard from scratch, using advanced Excel features like Pivot tables, and Slicers. By the end of the video, you'll have a solid understanding of how to create dynamic dashboards in Excel and how to customize them to suit your needs.
📂 File Link:
https://docs.google.com/spreadsheets/d/1GLKAn_FKqGgwnv6uo9RXWTIMpasutar4/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
=============================================
12
views
Excel if Formula SIMPLE To ADVANCED / Nested IF, AND, OR functions
Excel if Formula Simple To Advance / Multiple Criteria, nested IF, AND, OR functions / IF Function
Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to make logical comparisons between a value and what you expect. An IF statement can have multiple results. The first result is if your comparison is True, the second if your comparison is False. You can use If / Ifs by selecting multiple criteria depending on your needs on requirements.
File Link:
https://docs.google.com/spreadsheets/d/1hem-k1Rb0OW1YAOKAyhqevKCpXNzmQ9-/edit?usp=share_link&ouid=109065873300131166242&rtpof=true&sd=true
4
views
All Sum and Count Functions in Excel
Sum and Count Functions / Formulas You Must Know
In this Video, we will cover two of the most commonly used yet advanced and awesome functions of Excel: Sum and Count. These functions are essential for analyzing and manipulating data in spreadsheets.
First, we will cover the Sum function. Sum allows you to add up a range of cells or values within a spreadsheet. We will explore various ways to use the Sum function, including adding up a single column, multiple columns, and using the AutoSum feature.
Next, we will cover the Count function. Count allows you to count the number of cells within a range that contain numerical data. We will also explore the CountA, Countif, Countifs, Countblank function, which will be really useful white preparing or analysing a data.
📂 File Link:
https://docs.google.com/spreadsheets/d/1v3d9XMkldOqy6IOqqyxnNkuk5XxjnExR/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
======================================
6
views