Formulas and Functions: Microsoft Excel
Back to Search
Book Statistics
2 Views
0 Comments
0 Rating

Formulas and Functions: Microsoft Excel

Author: Paul McFedries

Description

Excel2010’s core features to solve problems and get the answers youneed! Using real-world examples, McFedries helps you get the absolutemost out of breakthrough Excel 2010 improvements–from Sparklines tothe brand-new version of Solver. Along the way, you’ll discover thefastest, best ways to handle essential day-to-day tasks ranging fromgenerating account numbers to projecting the impact ofinflation.Becoming an Excel expert has never been easier! You’llfind crystal-clear instructions… insider insights… even completestep-by-step projects for building timesheets, projecting cash flow,aging receivables, analyzing defects, and more.


• Createmore powerful formulas

• Useconditional formatting to instantly reveal anomalies, problems, oropportunities

• Analyzeyour data with standard tables and PivotTables

• Usecomplex criteria to filter data in lists

• Understandcorrelations between data

• Performsophisticated what-if analyses

• Useregression to track trends and make forecasts

• Buildloan, investment, and discount formulas

• Troubleshootproblems with formulas, ranges, and functions

Keywords

Range Names Basic Formulas Advanced Formulas Troubleshooting Formulas Text Functions Logical and Information Functions Lookup Functions Date and Time Functions Math Functions Statistical Functions Data with Tables PivotTables Business-Modeling Tools Regression trends forecasts Financial Formulas Loan Formulas Investment Formulas Discount Formulas Mastering Excel Ranges and Formulas Harnessing the Power of Functions Building Business Models Building Financial Formulas Getting the Most Out of Ranges Advanced Range-Selection Tec Mouse Range-Selection Tricks Keyboard Range-Selection Tricks Working with 3D Ranges Data Entry in a Range Filling a Range Creating a Series Clearing a Range Copying Selected Cell Attributes Clearing a Range Adding Icon Sets Adding Color Scales Adding Data Bars Using Range Names Naming Constants Building Basic Formulas Creating Advanced Formulas Working with Arrays Using Array Formulas Array Formulas Troubleshooting Formulas Extracting a Substring Manipulating Text Formatting Text Working with Logical Functions Lookup Functions The CHOOSE() Function Working with Date and Time Functions

Download & Read Options

Formulas.and.Functions.Microsoft.Excel.2010.pdf

PDF

Login to Read Login to Download

Reader's Comments (0)

Login to Comment
No Comments Yet

Be the first to share your thoughts about this book!

Related eBooks

Semantic Web

Gang Wu

View
Marine Sciences: Notable Research and Discoveries

Kyle Kirkland, Ph.D.,

View
Advanced Strategies for Robot Manipulators

Seyed Ehsan Shafi ei

View
The Finite Element Method for Solid and Structural

O.C. Zienkiewicz, R.L. Taylor

View