PDF to Excel

PDF to Excel

PDF to Excel Click here to see our YouTube video on how to convert PDF files to Excel. Converting a PDF file to Excel can be quite straightforward provided that it is not a scanned document (i.e scanned from a paper copy).  If you're dealing with a scanned document, the likelihood of getting an accurate conversion is reduced; so if your scan is of really poor quality, maybe stop wasting time reading this tutorial, and get typing in that data instead. If you're fortunate enough to be dealing with a PDF that is not scanned from a paper document then you're in luck.  Although the layout doesn't always convert perfectly, it's still much faster than typing in a load of data. It's very easy to do; first head over to https://www.pdftoexcel.com/.  I will point out at this stage that we are not affiliated with pdftoexcel.com in any way, but I have used their website many times to convert PDF files to Excel with no problems. ...
Read More
How do I password protect an Excel spreadsheet?

How do I password protect an Excel spreadsheet?

How do I password protect an Excel spreadsheet? Link to YouTube video. There are many reasons you may want to password protect an Excel spreadsheet, but mainly to stop either unauthorised editing, or unauthorised access.  We'll show you how to password protect for both eventualities (either preventing someone from editing or entirely blocking access to the file). Firstly, lets assume you have a spreadsheet, and you want to allow others to access it, but make it so they cannot edit the file unless they have the password.  We do this by using the "Protect Sheet" feature. Follow the image below to Protect a Sheet: If your workbook has several sheets (tabs), then you will need to repeat this for each sheet you want to protect. Note:  The "Protect Workbook" button to the right of the "Protect Sheet" button acts in a different manner, and only protects the "structure" of the workbook (i.e. does not allow sheets to be added or deleted) but still allows editing of...
Read More

VLOOKUP in Google Sheets

VLOOKUP in Google Sheets VLOOKUP is a very commonly used formula within business and is easy to use in Google Sheets.  Once you realise how powerful it can be, you will begin using it for more and more time-saving exercises that would have otherwise taken ten times longer.  The formula is exactly the same in Google Sheets and all versions of Excel; these screenshots are from Google Sheets. In this example we have a column of reference codes in Column A, and the associated addresses in Column B.  We need to return the correct address when we type in the reference code into cell C1. VLOOKUP has 4 “arguments” (parts that need to be filled in to make the formula work, separated by commas), these are: lookup value, table array, column index, and range lookup. In this example, we want the result to appear in cell D1.  So begin by clicking in cell D1 and and typing: =VLOOKUP( Google Sheets will then give you a handy...
Read More