The Copy and Paste functions are something we use practically every time we work with some Office document. But have you noticed that when you use the paste functionality, the Paste Options pop up menu lingers on and refuses to go away? This is quite annoying and often ends up … [Read more...] about How to Get Rid of the Paste Options Menu in Word, Excel and PPT
excel how to
How to Calculate Number of Days Between Two Dates in Excel
In a previous post, I showed you how to use the NETWORKDAYS() function in Excel to calculate the number of work days between two dates in Excel. In today’s post we’ll take a look at how you can use further Excel functions to calculate number of days between two dates in Excel. … [Read more...] about How to Calculate Number of Days Between Two Dates in Excel
How to Combine Text with a Date or Time in Excel
There is no straightforward way to enter a string of text in Excel along with a date or time. Excel simply does not allow you to combine text and dates or text and time together in the same cell. However, there is a simple workaround that makes it possible for you to do this. In … [Read more...] about How to Combine Text with a Date or Time in Excel
How to Hide Data in a Worksheet in Excel
There may be times when you want to share or view some data in an Excel worksheet, but not all of its contents. In such cases, you can hide the data from view. In this Excel tutorial, I’ll show you two ways in which to hide data in a worksheet in Excel 2016. … [Read more...] about How to Hide Data in a Worksheet in Excel
How to Calculate the Age of a Person in Excel
If you’re working with a lot of employee data and need to create an maintain a database with the employee’s ages, automatically updated every year, you can make use the the functions in Excel to do it. For this purpose all you need is the year of their birth or their date of … [Read more...] about How to Calculate the Age of a Person in Excel
How to Get the Name of a Day from a Date in Excel
Got a series of dates in Excel and want to know how to get the name of a days they fall on? Here’s a quick Excel guide to help you with that using a simple formula with some variations. Here's how to get the name of a day from a date. … [Read more...] about How to Get the Name of a Day from a Date in Excel
How to Calculate the Number of Work Days Between Two Dates in Excel
If you use Excel to calculate payment schedules in Excel, one of the most important calculations you do will involve computation of dats between dates. For this purpose you may want to exclude weekends, holidays and other specific days. Thankfully there’s a really useful function … [Read more...] about How to Calculate the Number of Work Days Between Two Dates in Excel
How to Convert Time to Minutes in Excel
If you are someone who does a lot of Excel work, you probably have found yourself in a situation where you had to convert time to minutes or minutes to a time format. For instance, you may have wanted to change 3:45 to 180 minutes or convert 225 minutes to hours and minutes … [Read more...] about How to Convert Time to Minutes in Excel