Download or read book Advanced Spreadsheet Functions and Formulas written by Jack Hawkins and published by . This book was released on 2021-07-15 with total page 62 pages. Available in PDF, EPUB and Kindle. Book excerpt: Always using spreadsheets but always having to look up the correct formulas? This handy reference guide can help! It contains many of the most used and most useful functions in Microsoft Excel, Google Sheets and Apple Numbers. Functions are an essential part of spreadsheets: they can be deployed within formulas to streamline your work and increase your efficiency. They make heavy tasks lightweight, and constant updating and reevaluating easy. PLUS: The book contains a scannable QR code (or just copy the link into your browser) to see example files in action online. Follow the QR code link to download an .xlsx file of sample spreadsheets! The book assumes a basic knowledge of the functioning of your chosen spreadsheet application, and the workings of formulas within it. It's aimed at an intermediate user, who knows their way around the software, but wants to develop their skills in the more complex functions and formulas. Learn how to: Use If Functions Clean Data Analyze Data Using Various Models Reference Arrays Using Vlookup Convert Between Units Manipulate Dates Calculate Loan Payments And More!