Category Archives: Microsoft Office

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 grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns […]

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, the current time, or the day of the week. This article covers using the most […]

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, 1904. Don’t ask me why. Note: There are several different ways to do everything in […]

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 Range Select a range of cells using the Shift key, Shift+Ctrl, or Ctrl keys (yes, […]