Microsoft® Excel® 2007 Quick Reference Guide – Excel 302: Important Functions & Formulas by Excel 2007

Description

8-page bi-fold.

This quick reference guide is a comprehensive reference to important functions and formulas in Excel. While there are over 200 functions in Excel, in this guide you will learn how to use and apply a select few that are critical to becoming proficient in data analysis and calculations with functions.

The guide will help you learn how to use formulas in different categories. For example, you will create logical functions using IF, nested IF, AND, OR. Then you will create lookup functions such as VLOOKUP, ROWS, COLUMNS, MATH. Then you will create database functions such as DSUM, DAVERAGE, DMIN, DMAX. Then you will create text functions such as LEFT, RIGHT, MID, TRIM, CONCATENATE. Then you will create date/time functions using NOW, DATE, TIME, DAY, MONTH, YEAR, EDATE. 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. We will also discuss how to create a custom functions using simple Visual Basic commands.

The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.

Product Features

• Microsoft Excel 2007 Quick Reference Guide (8 guides available)
• Summary of important fucntions in various categories
• Examples include hands-on exercises covering Logical Functions, Date & Time Functions, Mathematical Functions, Lookup Functions.
• Additional examples cover Financial Functions, User Defined Functions, Database Functions and Statistical Functions
• Downloadable exercise file