Mar 17, 2014
So you have an Excel workbook that contains confidential information. You want to prevent unauthorised access to the file. One way is to assign a password to the file. When anyone tries to open the file, they are asked for the password: Warning! There are many...
Mar 10, 2014
So you have an Excel workbook that contains confidential information. You want to prevent unauthorised access to the file. One way is to assign a password to the file. When anyone tries to open the file, they are asked for the password: Warning! There are many...
May 10, 2013
In this video, a 10 minute clip taken from a webinar that I delivered in 2012, I build a spreadsheet that can be used by anyone planning a wedding. The video covers absolute cell references, SUMIF, COUNTIF and conditional formatting. I used Excel 2011 for Mac but...
