MS Office Tips
Tuesday, 17 June 2014

Calculate a Future Date in Excel

›
When working in Excel you may need to calculate a future date. This may be for example, when somebody’s work probation period ends, or the d...
Saturday, 7 June 2014

Return the Cell Reference instead of the Value from a Lookup

›
In Excel, Lookup functions such as Vlookup or Index and Match can be used to find a record and return a value. But what if you want to retur...
Monday, 2 June 2014

Fixing Formula Errors

›
Working with formulas is the building block of creating powerful and dynamic Excel spreadsheets. However when there is a problem, it is not ...
Saturday, 3 May 2014

5 Awesome Excel 2013 Flash Fill Examples

›
Flash Fill is one of the biggest new features to be released with Excel 2013. In fact let me re-phrase that. Flash Fill is one of the bigge...
Tuesday, 22 April 2014

Understanding Section Breaks in Microsoft Word

›
Section breaks are one of the most useful features of Microsoft Word, especially when working with long documents. They enable you to appl...
‹
›
Home
View web version
Powered by Blogger.