We continue this series by providing another assortment of simple, yet often “invisible” features in Office. According to Microsoft, around 80% of the feature requests they get for Office are already currently within the applications. Last year we started a series of articles in Office for Mere Mortals about this so-called “Invisible 80% of Office”. […]
We round off our date functions in Excel topic with a look at custom date formats, the NETWORKDAYS() function, and an in-depth discussion on sharing date-related worksheets between Mac and Windows. By Michael Barden In the last edition of Office for Mere Mortals, we used the basic date formulas in Excel as building blocks and […]
We have a look at some of the basic date formulas and how to combine them to make more powerful date-based functions. By Michael Barden In the last edition of Office for Mere Mortals we looked at the basics of the date and time formats, the different ways they can and should be displayed, and […]
What happens when a good Excel worksheet goes bad. Based on an article by Helen Bradley What happens when there’s an error in a worksheet? The answer is that it depends on what the worksheet is calculating and how bad the error is. Theoretically if an error were to over calculate doses of a highly […]
We run through the basics related to date and time formats in Excel 2003. By Michael Barden Working with dates in Excel is a common task: Are you trying to determine the number of days between two dates? Do you need to know the date that is X number of days in the future? Do […]
