Calculating Employee Holiday Allowance in Excel

This article looks at managing holiday using Excel 2010 and making use of the following Excel features: INDIRECT function NETWORKDAYS function Format as Table Conditional Formatting The finished file is available here (Holidays). However this article explains how to use the finished article and how to create it, so read on (or bookmark me for … Continue reading Calculating Employee Holiday Allowance in Excel

Advanced Formatting in Excel 2010

Comments Comments can be added to an Excel document for many purposes such as: Reviewing a document. Giving instructions to people completing a form. Explaining how a calculation works. Create a Comment To create a comment: Highlight the cell the comment is to be added to. On the Review tab, in the Comments group, click … Continue reading Advanced Formatting in Excel 2010