This
8-page bifold quick reference guide is dedicated to important functions in Excel 2013. In this guide, we will focus on important functions that are critical to becoming proficient in data analysis. For example, you will create logical functions using IF, AND, OR. Then you will create lookup functions such as VLOOKUP, ROWS, COLUMNS. Then you will create database functions such as DSUM, DMIN, DMAX. Then you will create text functions such as LEFT, RIGHT, MID, CONCATENATE. Then you will create date/time functions using NOW, DATE, TIME, DAY, MONTH. Then you will create information functions using NA, ISBLANK, ISERROR. Then you will create mathematical and statistical functions such as SUMIF, ROUND, MOD, INT, COMBIN, MIN, MAX, MODE, STDEV, AVDEV. Finally you will learn about useful financial functions such as PMT, FV, RATE, NPER.

All of our quick guides are developed, designed and published in the US. They are printed on a high-quality sustainable stock that features UV coating which resists fading and spills. Unlike the competition, our guides offer in-depth details, step-by-step exercises, structured content that is based on adult learning concepts and are written by expert instructors who are every day users of the software application. Yes, our guides are priced higher; however, the quality and value found in these guides are far superior to the competition. With our quick reference guides, you can achieve more today, and make a great investment for tomorrow.

Note for Corporate Training Departments: Save time and save money. Do not eliminate software training, improve it! With our unique and affordable quick reference guides, you will empower your employees to do more with less, to be more productive and learn what they need when they need it.

Product Features

• Part of a series of several quick reference guides for Excel 2013, each focusing on a set of specific and important topics such as Excel 2013-201, Excel 2013-202, Excel 2013-203, Excel 2013-204, Excel 2013-205, Excel 2013-206, Excel 2013-301, Excel 2013-302, Excel 2013-303, Excel 2013-304, Excel 2013-401, Excel 2013-402 and much more.
• Learn how to create and apply functions in various categories such as Logical functions, Lookup functions, Database functions, Informational functions and much more.
• Work with formula results to better understand your data and troubleshoot any errors.
• Create your own functions using simple VBA code & laubch formulas using keyboard shortcuts.
• Unlike the competition, our quick reference guides are designed with clear step by step instructions based on exercises that you perform.