If you ever need to send an Excel workbook by email to someone else, you may want to hide certain worksheets. When they receive the file, you want to ensure they cannot unhide any hidden worksheets. After attending an excel training course you may only learn the skills of how to protect a worksheet with […]
If you have an Excel Worksheet that contains Data relating to the hours of training for each Employee for Microsoft Excel Training London on Monday, Tuesday and Wednesday, you may want to return the hours trained for a particular employee on a particular day in another Excel Workbook or Excel Worksheet. The spreadsheet shown below is the […]
One of the great new features of Excel that users enjoy employing during our Microsoft Excel Courses here in London is the Sparklines. These can be thought of as mini-Charts that reside in a cell, and can show a trend visually of a group of values. In the example shown below there are sales figures from […]