COPYRIGHT SPECIAL SALES MYEXCELONLINE ACADEMY COURSE CONNECT WITH US AUTHOR BIOGRAPHY HOW TO USE THIS E-BOOK Formulas VS Functions FORMULA TIPS The Function Wizard F9 to Evaluate a Formula Named Ranges Absolute & Relative References Evaluate Formulas Step By Step Highlight All Excel Formula Cells How to Convert Formulas to Values How to Show & Hide Formulas in Excel Jump to a Cell Reference in a Formula LOOKUP FUNCTIONS ADDRESS CHOOSE HLOOKUP HYPERLINK INDEX INDEX-MATCH INDIRECT LOOKUP MATCH VLOOKUP LOGICAL FUNCTIONS AND IF IFERROR OR MATH FUNCTIONS COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS MOD PERCENTAGE RAND RANDBETWEEN ROUND SUBTOTAL SUMIF SUMIFS SUMPRODUCT STATISTICAL FUNCTIONS AVERAGE LARGE MAX MEDIAN MIN SMALL DATE & TIME FUNCTIONS DATE DATEDIF DATEVALUE DAY DAY360 DAYS ENDOFMONTH HOUR MONTH NETWORKDAYS TODAY WEEKDAY WEEKNUM WORKDAY YEAR TEXT FUNCTIONS CLEAN CONCATENATE EXACT FIND LEFT LEN LOWER MID PROPER REPLACE RIGHT SEARCH SUBSTITUTE TEXT TRIM UPPER VALUE INFORMATION FUNCTIONS ISBLANK ISERROR ISNUMBER ISTEXT TYPE OTHER FUNCTIONS FV – Compound Interest FV – Monthly Investment EXCEL 2019 CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN OFFICE 365 (AS OF SEPTEMBER 2018) FILTER RANDARRAY SEQUENCE SORT SORTBY UNIQUE ADVANCED FORMULAS 3D Formulas ARRAY Formulas BETWEEN Extract First Name from Full Name Extract Last Name - REPLACE Function GETPIVOTDATA IF Combined With The AND Function INDEX-MATCH 2 Criteria with Validation Match Two Lists With MATCH Function Named Ranges with VLOOKUP Function REPT Sum a Range Using the INDEX Function SUMPRODUCT: Sum Multiple Criteria SUMPRODUCT: Sum the Top 3 Sales TIME – Get Elapsed Time TRANSPOSE VLOOKUP Approximate Match VLOOKUP with a Drop Down List VLOOKUP Multiple Columns VLOOKUP with Multiple Criteria COPYRIGHT Copyright © 2019 by MyExcelOnline.com – Version 1.2019 All rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, email, mechanical, photocopying, recording or likewise. SPECIAL SALES For more information about buying this eBook in bulk quantities, or for special sales opportunities (which may include custom cover designs, and content particular to your business or training goals), please send us an email to [email protected] MYEXCELONLINE ACADEMY COURSE We are offering you access to our online Excel membership course – The MyExcelOnline Academy – for only $1 for the first 30 days! Click on this $1 Trial link to get access to this special reader offer! CONNECT WITH US Website, blog & podcast: https://www.myexcelonline.com/ Download Our App: Android or iPhone Email: [email protected] AUTHOR BIOGRAPHY John Michaloudis is the founder of MyExcelOnline.com. John is currently living in the North of Spain, married and have two beautiful kids. John holds a bachelor’s degree in Commerce (Major in Accounting) and speak English/Australian, Greek and Spanish. Bryan Hong is a contributor of MyExcelOnline.com. He is currently living in the Philippines and is married to his wonderful wife Esther. Bryan is also a Microsoft Certified Systems Engineer with over 10 years of IT and teaching experience!