Microsoft Excel 2013 Quick Reference Guide - Important Worksheet Functions & Formulas (302)
Descripción
- 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. Formulas are a must in almost any worksheet. Being comfortable with formulas and being able to create them will give you an edge and allow you to expand your horizons so that you do more with your data.
- Unlike the competition, our quick reference guides are designed with clear step by step instructions based on exercises that you perform. There are eight pages of instructions presented in a clear and concise manner. We do not waste your time with information you already know. We focus on specific topics so that you can master such topics in a short amount of time. Save valuable time and increase productivity with this quick reference guide.
- 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 New Features, Excel 2013-202: Introduction to Charts & Graphs, Excel 2013-203: Sorting & Data Filters, Excel 2013-204: Data Analysis Using PivotTables, Excel 2013-205: Using Tables & Slicers, Excel 2013-206: Worksheet Linking & Auditing, Excel 2013-301: Data Modeling & Conditional Formatting, Excel 2013-302: Formulas & Functions, Excel 2013-303: Using Excel As A Database, Excel 2013-304: Macros & VBA Basics, Excel 2013-401: Productivity Tips & Tricks, Excel 2013-402: PowerPivot Analysis and much more.
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. Preserve the investment you have made in your employees, by offering them this quick reference guide, either as a self-learning tool or as part of your corporate training strategy.
Preguntas comunes
Trustpilot
Hace 2 semanas
Hace 2 semanas
