If you work with Excel spreadsheets, you’ve likely ended up with the need to compare two dates to find the number of days, months, or years between them. Using the DATEDIF function, you can easily accomplish that.
Tag: Excel
Clearing all filters with a single click in Excel
One of my colleagues at work wondered if there was an easy way to clear out multiple column filters in Excel without having to go into each column separately. A quick search on Google showed that you definitely can do that…
Conditional Formatting in Excel
This isn’t so much a cool “magical” tip as much as it’s a reminder to myself that it exists and I should use it more often. Excel has a Conditional Formatting feature that allows you to apply rules to a spreadsheet to have certain data situations display in different ways automatically.
Using the Format Painter in Excel
This was a feature I never used before, but I can see where it would come in very handy at times… the Format Painter in Excel.
Getting a list of email addresses in Excel into Outlook
This little trick is handy if you have a list of email addresses in Excel, and you want to use that list to send everyone an email using Outlook. It’s really nothing more than copy and paste!
Free tech books and documents from Microsoft!
It’s that time of year again!
Each year, Eric Ligman from Microsoft has a blog entry that posts links to a LARGE collection of FREE ebooks on Microsoft technology. There’s no catch, it’s all legal, and it’s simply a “thank you” to everyone who is a Microsoft customer or partner. They are full versions of the titles, they are not time-bombed, etc. They are really and truly FREE for downloading.
Break out of your rut with Office templates
When I go to start a new Word document or Excel file, I nearly always take the default blank template in the upper left corner. However, I recently decided to scroll down and see what Excel file templates were out there. I was amazed at what options I had to create something that was “out of the ordinary”.
Removing excess formatting from an Excel spreadsheet
Sometimes when working with Excel, you may end up with a spreadsheet that has an excessive amount of formatting. That formatting can come with a cost, such as large file sizes and long wait times to launch the spreadsheet.
File protection for Excel, Word, and PowerPoint files
I had a question yesterday from someone asking if there was a way to password protect an Excel file. I just assumed that everyone knew that was possible, but I didn’t have a direct answer that said “click here, here, and here” to help her. Thus, today’s tip on how to password protect files in Excel, Word, and PowerPoint.
