Formulas and Functions With Microsoft Office Excel 2007
商品資訊
商品簡介
“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...”
—Thomas ‘Duffbert’ Duff, Duffbert’s Random Musings, http://www.twduff.com
Develop your Microsoft Excel expertise instantly with proven techniques
- Master Excel Ranges
- Create Powerful Arrays
- Troubleshoot Formula Problems
- Validate Worksheet Data
- Perform What-If Analysis
- Model Your Business
- Track Trends and Make
- Forecasts
- Analyze Data
- Find Optimal Solutions
- Build Dynamic Loan
- Schedules
Most MicrosoftR Excel users learn only a small percentage of the program’s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated—shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.
Sound familiar? If you’re a businessperson who needs to use Excel as an everyday part of your job, then you’ve come to the right book. Formulas and Functions with MicrosoftR Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way. This book not only takes you through Excel’s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you’ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.
‧ Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools.
‧ Shuns spreadsheet theory in favor of practical know-how that you can put to use right away.
‧ Provides numerous real-world examples and techniques to help you learn and understand the importance of each section.
Introduction
1 Getting the Most Out of Ranges
2 Using Range Names
3 Building Basic Formulas
4 Creating Advanced Formulas
5 Troubleshooting Formulas
II Harnessing the Power of Functions
6 Understanding Functions
7 Working with Text Functions
8 Working with Logical and Information Functions
9 Working with Lookup Functions
10 Working with Date and Time Functions
11 Working with Math Functions
12 Working with Statistical Functions
III Building Business Models
13 Analyzing Data with Tables
14 Analyzing Data with PivotTables
作者簡介
Paul McFedries is the president of Logophilia Limited, a technical writing company. Now primarily a writer, Paul has worked as a programmer, consultant, spreadsheet developer, and website developer. He has written more than 50 books that have sold more than three million copies worldwide. These books include Access 2007 Forms, Reports, and Queries (Que, 2007), Tricks of the Microsoft Office 2007 Gurus (Que, 2007), VBA for the 2007 Microsoft Office System (Que, 2007), and Windows Vista Unleashed (Sams, 2006).
您曾經瀏覽過的商品
購物須知
外文書商品之書封，為出版社提供之樣本。實際出貨商品，以出版社所提供之現有版本為主。部份書籍，因出版社供應狀況特殊，匯率將依實際狀況做調整。
無庫存之商品，在您完成訂單程序之後，將以空運的方式為你下單調貨。為了縮短等待的時間，建議您將外文書與其他商品分開下單，以獲得最快的取貨速度，平均調貨時間為1~2個月。
為了保護您的權益，「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。
若要辦理退貨，請在商品鑑賞期內寄回，且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。
(到貨天數約30-45天)