Monthly Archives: April 2014

Calculating Age

Today’s Excel tip is one of my favorites, primarily because it’s an undocumented function. Meaning you will not find it in the Help. This week’s function is “DATEDIF”.  DATEDIF returns the number of years, months or days between a start … Continue reading

Posted in Blogging, Business, Ideal Real Estate Group, Networking, Professional Business Networking, Real Estate, Sandy Luedke | Leave a comment

Extracting Data from a Text String

Today’s Excel tip shows you how to extract information from a text file. In today’s example we have a list of street names with numbers and we want to sort by street name. There are several ways to accomplish this … Continue reading

Posted in Business, Ideal Real Estate Group, Interests, Microsoft Excel, Networking, Professional Business Networking | Leave a comment

Excel’s Concatenate – Put strings together

Many times you have data in two separate columns that would really be better shown in a single column. Excel has a way to make this easy.  On the Formulas tab, click on the Text category.  On the list is … Continue reading

Posted in Business, Ideal Real Estate Group, Interests, Networking, Professional Business Networking, Real Estate, Sandy Luedke | Leave a comment

Microsoft Excel Function: PMT (Payment)

If you have never checked out all the Functions available in Microsoft Excel, it is well worth your time to check them out. A function is simply a formula you don’t have to create. Simply fill in the values and … Continue reading

Posted in Business, Ideal Real Estate Group, Networking, Professional Business Networking, Real Estate, Sandy Luedke, Uncategorized | Tagged , , , , , , , | 2 Comments