101 Most Popular Excel Formulas

491 Pages·2019·9.59 MB·english

by  John Michaloudis

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!