Formulas and Functions Microsoft Excel 2010 1st Edition by Paul McFedries ISBN 078974306X 9780470685433

Formulas and Functions Microsoft Excel 2010 1st Edition by Paul McFedries – Ebook PDF Instant Download/Delivery. 078974306X, 9780470685433
Full download Formulas and Functions Microsoft Excel 2010 1st Edition after payment

Product details:

ISBN 10: 078974306X 
ISBN 13: 9780470685433
Author: Paul McFedries

MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS!

Excel expert Paul McFedries shows how to use Excel 2010’s core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you’ll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions… insider insights… even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.

• Create more powerful formulas

• Use conditional formatting to instantly reveal anomalies, problems, or opportunities

• Analyze your data with standard tables and PivotTables

• Use complex criteria to filter data in lists

• Understand correlations between data

• Perform sophisticated what-if analyses

• Use regression to track trends and make forecasts

• Build loan, investment, and discount formulas

• Troubleshoot problems with formulas, ranges, and functions

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excelskills, and presents focused tasks and examples for performing them rapidly and effectively. Selectedby Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will:

• Dramatically increase your productivity–saving you 50 hours a year, or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make

Paul McFedries, president of Logophilia Limited, is a Microsoft Office expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 70 books to his credit, which combined have sold more than three million copies worldwide. His recent titles include Using the Microsoft Office Web Apps, and Microsoft Windows 7 Unleashed. He is also proprietor of Word Spy (www.wordspy.com), a website that tracks new words and phrases as they enter the English language.

Formulas and Functions Microsoft Excel 2010 1st Table of contents:

Chapter 1: Introduction to Excel Formulas and Functions

1. What is a Formula in Excel?
2. Understanding Excel’s Formula Bar
3. Structure of a Formula: Operators and Functions
4. Basic Arithmetic Operations in Excel
5. Using Cell References in Formulas
6. Relative, Absolute, and Mixed Cell References
7. Introduction to Function Syntax

Chapter 2: Basic Excel Functions

1. SUM: Adding Numbers
2. AVERAGE: Finding the Mean
3. MIN and MAX: Finding the Lowest and Highest Values
4. COUNT and COUNTA: Counting Numbers and All Entries
5. IF Function: Conditional Statements
6. Using DATE and TIME Functions
7. Concatenating Text with the CONCATENATE Function

Chapter 3: Working with Text Functions

1. LEFT, RIGHT, and MID: Extracting Parts of a String
2. LEN: Counting Characters in a String
3. FIND and SEARCH: Locating Text in a String
4. UPPER, LOWER, and PROPER: Changing Text Case
5. TRIM: Removing Extra Spaces
6. TEXT: Formatting Numbers as Text

Chapter 4: Logical Functions and Conditional Formulas

1. Using the IF Function for Conditional Logic
2. Nested IF Statements
3. AND and OR Functions: Combining Conditions
4. IFERROR: Handling Errors in Formulas
5. SWITCH: An Alternative to Nested IF
6. TRUE and FALSE: Working with Boolean Values

Chapter 5: Lookup and Reference Functions

1. VLOOKUP: Vertical Lookup for Data Retrieval
2. HLOOKUP: Horizontal Lookup for Data Retrieval
3. INDEX and MATCH: Powerful Alternatives to VLOOKUP
4. LOOKUP Function: A Versatile Lookup Tool
5. OFFSET: Returning a Value from a Specified Range
6. ROW and COLUMN: Returning Row and Column Numbers

Chapter 6: Financial Functions

1. PMT: Calculating Loan Payments
2. FV: Calculating Future Value
3. PV: Calculating Present Value
4. NPV: Net Present Value Calculation
5. RATE: Finding Interest Rates for Loans
6. IRR: Internal Rate of Return

Chapter 7: Statistical Functions

1. SUMIF and COUNTIF: Conditional Summing and Counting
2. AVERAGEIF: Conditional Averaging
3. MEDIAN and MODE: Finding the Middle Value and Most Frequent
4. STDEV: Calculating Standard Deviation
5. CORREL: Finding Correlation Between Two Data Sets
6. TREND: Fitting a Linear Trend Line to Data

Chapter 8: Date and Time Functions

1. TODAY and NOW: Returning Current Date and Time
2. DATE, YEAR, MONTH, DAY: Extracting Date Components
3. EDATE and EOMONTH: Working with Dates in the Future and Past
4. DATEDIF: Calculating the Difference Between Two Dates
5. WEEKDAY and WEEKNUM: Working with Days of the Week
6. NETWORKDAYS: Counting Business Days Between Dates

Chapter 9: Array Functions and Formulas

1. What are Array Formulas?
2. Creating Simple Array Formulas
3. Using the SUMPRODUCT Function
4. Array Formulas for Complex Calculations
5. Using TRANSPOSE to Change Rows and Columns
6. CSE (Ctrl+Shift+Enter) Formulas: An Introduction

Chapter 10: Advanced Excel Functions

1. Using INDIRECT for Dynamic Cell References
2. Using OFFSET for Dynamic Ranges
3. The CHOOSE Function: Creating Complex Formulas
4. The CELL Function: Returning Information About a Cell
5. The RAND and RANDBETWEEN Functions: Generating Random Numbers
6. Array Formulas in Complex Models

Chapter 11: Error Handling and Troubleshooting Formulas

1. Common Excel Formula Errors: #VALUE!, #REF!, #DIV/0!
2. Using IFERROR to Handle Errors
3. Evaluating Formulas with the Formula Auditing Tools
4. Tracing Precedents and Dependents
5. Using Error Checking Features to Find Problems
6. Debugging Complex Formulas

Chapter 12: Working with Named Ranges and Functions

1. Defining Named Ranges in Excel
2. Using Named Ranges in Formulas
3. Named Functions: Creating Custom Functions
4. Benefits of Using Named Ranges
5. Managing Named Ranges
6. Scope of Named Ranges: Workbook vs. Worksheet

Chapter 13: Data Validation and Conditional Formatting

1. Using Data Validation to Control User Input
2. Creating Drop-Down Lists for Data Entry
3. Setting Data Validation Rules for Dates, Numbers, and Text
4. Using Conditional Formatting to Highlight Data
5. Advanced Conditional Formatting Techniques
6. Combining Data Validation and Conditional Formatting

Chapter 14: Creating Dynamic Dashboards with Formulas

1. Planning and Designing a Dashboard
2. Using Excel Functions to Pull Data for Dashboards
3. Creating Interactive Dashboards with Formulas
4. Using Excel’s Formulas for Data Visualization
5. Combining Multiple Functions for Dynamic Reports
6. Advanced Techniques for Data Summary and Analysis

People also search for Formulas and Functions Microsoft Excel 2010 1st:

formulas and functions: microsoft excel
    
microsoft excel features functions and formulas
    
microsoft excel functions and formulas
    
microsoft excel functions and formulas pdf
    
using basic formulas and functions in microsoft excel