Category Archives: Microsoft Office

What is Microsoft Excel and how use it?

Excel is an Electronic Spreadsheet Program Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. When you look at the Excel screen (refer to the example on this page) you see a rectangular table or

Date Functions in Excel 2003

Format options for date functions in Excel Using Date Functions in Excel 2003 There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date,

Date Formulas and Functions in Microsoft Excel

Excel stores dates in sequential serial numbers beginning with January 1st, 1900 as 1.  January 1st, 2006 is 38718 because it’s 38,718 days after January 1st, 1900.  Excel on MAC works the same, except the dates start on January 1st,

Named Ranges in Microsoft Excel

Names ranges can be very useful. Some people argue that point, whether using named ranges in VBA or formulas. The most common problem regarding names ranges, everyone agrees, is user ignorance of their existence in the application. Create a Named