Quick Study Reference Guide

Quick and easy 6 page laminated guide focuses on creating and using formulas efficiently and effectively in Excel 2016. Whether you are a beginner or experienced user, formulas are Excel's superpower that can be yours. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant use of formulas for users at different levels. Look for Excel 2016, Excel 2016 “Tips and Tricks”, “Advanced” and “Pivot Tables” QuickStudy guides to have a complete power-user reference set.

Topics covered include:

• Creating Formulas
• Using Tables in Formulas
• Organizing Data Using Named Ranges
• Summary & Statistical Functions
• Counting Values in Cell Ranges
• Performing Financial CalculationsPerforming Conditional Calculations Using IF & IFERROR
  • Principal & Interest Payments
  • Calculating Present & Future Value
  • Calculating Time to Reach an Investment Goal
  • Calculating Net Present Value
• Processing Text Using Formulas
• Performing Date Calculations
• Finding & Displaying Cell Values & Formula Text
• Division, Decimals & Rounding
• Auditing Formulas

Quick and easy answers to the essentials of Excel, handy enough to keep you working without Internet searches or long videos. Our author and expert Curtis Frye owns a corporate training company specifically for Excel, is also a LinkedIn Learning video author (formerly Linda.com) and a Microsoft author. The ability to choose what is covered in this reference comes from his vast experience working directly with users. This expertise is streamlined through clear and succinct answers provided to help accomplish tasks. Also includes labeled screen grabs and icons in a color-coded design. Durable and portable, this 6 page laminated guide can be stored and accessed quickly so you can find what you need fast. Corporations ranging from Ford Motor Company to the FBI have purchased QuickStudy software guides for their employee’s workspace to improve productivity and reduce support calls.

6 page laminated guide includes:

• Main Window
• New Features
• The Ribbon
• Document File Formats
• Microsoft Accounts
• Entering & Editing Cell Data
• Undo & Redo Changes
• Managing Cells, Rows, Columns & Data
• Formatting Cell Data
• Creating Formulas
• Creating Formulas Using Functions
• Defining Excel Tables
• Managing Workbooks & Worksheets
• Sorting & Filtering Data

Quick and easy 6 page laminated guide loaded with essential functions and how to perform them in Excel 365 (and Excel 2019). Beginners and experienced users, can find hundreds of the most popular and useful functions fast with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 365, Excel 365 “Tips and Tricks”, “Formulas” and “Pivot Tables” QuickStudy guides to have a complete power-user reference set.

6 page laminated reference guide includes:

• Conditional FormatsFiler Data Using Slicers
  • Highlighting Rules
  • Data Bar, Color Scale & Icon Set Formats
  • Managing Conditional Formats
• What-If AnalysisPivot Tables & Pivot Charts
  • Analyzing Data Using Scenarios
  • Calculating Alternatives Using Data Tables
  • Calculating Target Values Using Goal Seek
  • Finding Optimal Values Using Solver
• Timelines
• Excel Data Model
• Data Validation
• Sparklines

Guide to developing and using functions and formulas in Excel. This clear and concise coverage of the ins and outs of formula creation and use touches on many forms of math from statistics & trig to financial math. The sheer volume and wealth of information in these 6 pages is equal to 30 pages or more from your average book on the same subject. Includes screen shots.