Sale!

Excel Formulas and Functions For Dummies For Dummies Computer Tech 2nd Edition by Ken Bluttman, Peter G Aitken ISBN 047056816X 9783175723998

Original price was: $50.00.Current price is: $35.00.

Excel Formulas and Functions For Dummies For Dummies Computer Tech 2nd Edition Ken Bluttman Digital Instant Download

Author(s): Ken Bluttman, Peter G. Aitken
ISBN(s): 9783175723998, 047056816X
Edition: 2
File Details: PDF, 4.26 MB
Year: 2010
Language: english
SKU: EB-1316466 Category: Tags: ,

Excel Formulas and Functions For Dummies For Dummies Computer Tech 2nd Edition by Ken Bluttman, Peter G Aitken – Ebook PDF Instant Download/Delivery: 047056816X 9783175723998
Full download Excel Formulas and Functions For Dummies For Dummies Computer Tech 2nd Edition after payment

Product details:

ISBN 10: 047056816X 
ISBN 13: 9783175723998
Author: Ken Bluttman, Peter G Aitken 

Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel’s built-in functions so you can put them to work.

You’ll find step-by-step instructions on 150 of Excel’s most useful functions, how they work within formulas, and how to use them to make your life easier.

  • See how to use 150 of Excel’s most useful functions, with real-world examples showing how each function is used within a formula
  • Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance
  • Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well
  • Includes essential coverage of an additional 85 functions

In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel’s power accessible to you.

Excel Formulas and Functions For Dummies For Dummies Computer Tech 2nd Table of contents:

Part 1: Getting Started with Formulas and Functions

  1. Chapter 1: Introduction to Formulas and Functions

    • What Are Formulas and Functions?
    • The Basics of Entering Formulas
    • Understanding Cell References and Operators
    • Using the Formula Bar and Function Wizard

  2. Chapter 2: Understanding Cell References

    • Relative vs. Absolute vs. Mixed References
    • How to Work with Cell Ranges
    • Naming Ranges for Easier Formulas

  3. Chapter 3: Using Basic Functions

    • The SUM Function: Adding Numbers Quickly
    • AVERAGE, MIN, and MAX Functions
    • COUNT, COUNTA, and COUNTIF Functions
    • Text Functions: LEFT, RIGHT, MID, and CONCATENATE

Part 2: Working with More Complex Functions

  1. Chapter 4: Date and Time Functions

    • Using TODAY, NOW, DATE, and TIME
    • Calculating Date Differences
    • Extracting Parts of Dates and Times (YEAR, MONTH, DAY)

  2. Chapter 5: Logical Functions and Conditional Statements

    • The IF Function: Making Logical Decisions
    • Nested IF Statements
    • The AND, OR, and NOT Functions

  3. Chapter 6: Lookup and Reference Functions

    • VLOOKUP and HLOOKUP Explained
    • Using INDEX and MATCH Together
    • The LOOKUP Function

  4. Chapter 7: Text Functions for Handling Data

    • Text Manipulation with TEXT, UPPER, LOWER, and PROPER
    • FIND, SEARCH, and REPLACE Functions
    • TRIM, CLEAN, and CONCATENATE for Managing Text

Part 3: Advanced Formulas and Functions

  1. Chapter 8: Advanced Mathematical Functions

    • Using SUMPRODUCT and Array Formulas
    • ROUND, ROUNDUP, ROUNDDOWN, and CEILING
    • POWER, SQRT, and Other Mathematical Functions

  2. Chapter 9: Financial Functions

    • Using PMT for Loan Calculations
    • Future Value (FV) and Present Value (PV) Functions
    • NPV, IRR, and Other Financial Functions

  3. Chapter 10: Statistical Functions

    • Using AVERAGEIF and SUMIF
    • Standard Deviation and Variance Functions
    • CORREL, COVAR, and Other Statistical Tools

Part 4: Troubleshooting and Tips

  1. Chapter 11: Troubleshooting Formulas

    • Common Formula Errors and How to Fix Them
    • Using Error Checking Tools in Excel
    • Troubleshooting with the Evaluate Formula Tool

  2. Chapter 12: Array Formulas and Advanced Techniques

    • What Are Array Formulas?
    • Working with Multi-Cell and Single-Cell Arrays
    • Tips for Using Array Formulas Effectively

Part 5: Putting It All Together

  1. Chapter 13: Creating Dynamic Reports with Functions

    • Building Interactive Dashboards
    • Combining Functions for Complex Calculations
    • Using PivotTables and Power Query with Functions

  2. Chapter 14: Excel and Data Analysis

    • Sorting and Filtering Data with Formulas
    • Analyzing Data with Advanced Functions
    • Creating and Using Named Ranges for Analysis

  3. Chapter 15: Macros and Automating Excel Tasks

    • Introduction to Macros in Excel
    • Writing Simple VBA Code for Automating Tasks
    • Combining Macros with Formulas for Efficiency

Part 6: The Part of Tens

  1. Chapter 16: Ten Excel Tips and Tricks to Boost Your Efficiency

    • Shortcuts for Faster Formula Entry
    • Tricks for Working with Large Data Sets
    • Advanced Functionality Tips

  2. Chapter 17: Ten Excel Formulas Every User Should Know

    • Must-Know Functions for Everyday Tasks
    • Building Quick Calculations for Your Workflow

People also search for Excel Formulas and Functions For Dummies For Dummies Computer Tech 2nd:

microsoft excel formulas and functions for dummies
    
excel formulas and functions for dummies pdf
    
excel formulas and functions for dummies pdf download
    
excel formulas and functions for dummies 6th edition pdf
    
basic excel formulas and functions

Tags:

Ken Bluttman,Peter G Aitken,Excel Formulas,Dummies,Computer Tech