Excel Functions and Formulas Pocketbook

Geared toward the intermediate to advanced Excel 2016 user, this pocketbook provides explanations and context for many powerful Excel 2016 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. Focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016. This guide is suitable as a training handout, or simply an easy to use reference guide.

Topics include:

1. Controlling Order of Precedence
2. Conditionally Summing/Counting Data (SUMIF, COUNTIF)
3. Being Precise (Rounding functions)
4. Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT)
5. New Functions for Office 365, Mobile & Online (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH)
6. Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)
7. Changing Results: IF, AND, OR, NOT
8. Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)
9. Error Recovery (ISNA, ISERROR)
10. Array Formulas (Single Cell & Multi-Cell Arrays)
11. Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE)
12. Using a Formula for Data Validation
13. Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows. 

Examples: 

• Summing Selected Data; Being Precise; Merging Text & Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays.
• Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT) 
• New Functions for Office 365, Mobile & Online (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH) 
• Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) 
• Changing Results: IF, AND, OR, NOT 
• Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) 
• Error Recovery (ISNA, ISERROR) 
• Array Formulas (Single Cell & Multi-Cell Arrays) 
• Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE) 
• Using a Formula for Data Validation 
• Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.

Ali Akbar is an Author who has more than 10 years of experience in IT consulting for more than 15 years. He has worked on design projects ranging from department store to transportation systems to the Smitdev project. He is the all-time best-selling Indonesian author and was cited as the favorite author.

Ali Akbar is the founder and CEO of The Semarang Method. In Ali's long career as an IT consultant, Ali specified, designed and delivered IT solutions for large corporations all over the world. In 2012 Ali decided to specialize in IT training and founded a retail business in Semarang.
Zico Pratama Putra , M.Sc. lives in make-believe worlds, talks to imaginary friends, and survives primarily on chocolate truffles and espresso. He is an active engineering practitioner and also an IT book writer. After graduating from Institute of Technology Bandung (ITB) in Aerospace Engineering, he spent years working as an IT consultant and telecommunications. In 2011, he continued his Master studies to Germany in the Rhein-Waal University of Applied Sciences while working in the field of computers in one company in Germany. He continued his PhD at the Queen Mary University of London in Human Computer Interaction field. He writes and speaks at various events in Germany & UK.