Zdjęcie 1 z 2
Zdjęcie 1 z 2
Formulas and Functions with Microsoft Office Excel 2007 by Paul McFedries (2007,
US $9,99
Około38,38 zł
Stan:
Dobry
Książka, która była czytana, ale nadal jest w dobrym stanie. Na okładce widoczne są nieznaczne ślady używania, np. zadrapania, ale książka nie jest rozerwana i nie ma dziur. Przy książkach w twardej oprawie mogą brakować obwoluty. Większość stron jest nieuszkodzona tzn., że ewentualne zagięcia lub rozdarcia są sporadyczne, podkreślenia ołówkiem są minimalne i nie ma żadnych zaznaczeń markerem czy notatek na marginesach. Książka ma wszystkie strony. Aby poznać więcej szczegółów i opis uszkodzeń lub wad, zobacz aukcję sprzedającego.
Wysyłka:
US $5,38 (około 20,67 zł) USPS Media MailTM.
Znajduje się w: Dallas, Texas, Stany Zjednoczone
Dostawa:
Szacowana między So, 28 wrz a Śr, 2 paź do 43230
Zwroty:
Zwroty nie są przyjmowane.
Płatności:
Kupuj bez obaw
Sprzedawca ponosi pełną odpowiedzialność za wystawienie tej oferty sprzedaży.
Nr przedmiotu eBay: 333652593396
Ostatnia aktualizacja: 23-08-2024 03:27:55 CEST Wyświetl wszystkie poprawkiWyświetl wszystkie poprawki
Parametry przedmiotu
- Stan
- Topic
- Microsoft
- ISBN
- 9780789736680
- Subject Area
- Computers
- Publication Name
- Formulas and Functions with Microsoft Office Excel 2007
- Publisher
- Pearson Education
- Item Length
- 9.1 in
- Subject
- Desktop Applications / Spreadsheets, Enterprise Applications / General
- Publication Year
- 2007
- Type
- Textbook
- Format
- Perfect
- Language
- English
- Item Height
- 1.2 in
- Item Weight
- 29.8 Oz
- Item Width
- 7 in
- Number of Pages
- 552 Pages
O tym produkcie
Product Identifiers
Publisher
Pearson Education
ISBN-10
0789736683
ISBN-13
9780789736680
eBay Product ID (ePID)
58649878
Product Key Features
Number of Pages
552 Pages
Language
English
Publication Name
Formulas and Functions with Microsoft Office Excel 2007
Subject
Desktop Applications / Spreadsheets, Enterprise Applications / General
Publication Year
2007
Type
Textbook
Subject Area
Computers
Format
Perfect
Dimensions
Item Height
1.2 in
Item Weight
29.8 Oz
Item Length
9.1 in
Item Width
7 in
Additional Product Features
Intended Audience
Trade
LCCN
2007-003274
Dewey Edition
22
Illustrated
Yes
Dewey Decimal
005.54
Table Of Content
Introduction Whats in the Book This Books Special Features I Mastering Excel Ranges and Formulas 1 Getting the Most Out of Ranges Advanced Range-Selection Techniques Mouse Range-Selection Tricks Keyboard Range-Selection Tricks Working with 3D Ranges Selecting a Range Using Go To Using the Go To Special Dialog Box Data Entry in a Range Filling a Range Using the Fill Handle Using AutoFill to Create Text and Numeric Series Creating a Custom AutoFill List Filling a Range Creating a Series Advanced Range Copying Copying Selected Cell Attributes Combining the Source and Destination Arithmetically Transposing Rows and Columns Clearing a Range Applying Conditional Formatting to a Range Creating Highlight Cells Rules Creating Top/Bottom Rules Adding Data Bars Adding Color Scales Adding Icon Sets From Here 2 Using Range Names Defining a Range Name Working with the Name Box Using the New Name Dialog Box Changing the Scope to Define Sheet-Level Names Using Worksheet Text to Define Names Naming Constants Working with Range Names Referring to a Range Name Working with Name AutoComplete Navigating Using Range Names Pasting a List of Range Names in a Worksheet Displaying the Name Manager Filtering Names Editing a Range Names Coordinates Adjusting Range Name Coordinates Automatically Changing a Range Name Deleting a Range Name Using Names with the Intersection Operator From Here 3 Building Basic Formulas Understanding Formula Basics Formula Limits in Excel 2007 Entering and Editing Formulas Using Arithmetic Formulas Using Comparison Formulas Using Text Formulas Using Reference Formulas Understanding Operator Precedence The Order of Precedence Controlling the Order of Precedence Controlling Worksheet Calculation Copying and Moving Formulas Understanding Relative Reference Format Understanding Absolute Reference Format Copying a Formula Without Adjusting Relative References Displaying Worksheet Formulas Converting a Formula to a Value Working with Range Names in Formulas Pasting a Name into a Formula Applying Names to Formulas Naming Formulas Working with Links in Formulas Understanding External References Updating Links Changing the Link Source Formatting Numbers, Dates, and Times Numeric Display Formats Date and Time Display Formats Deleting Custom Formats From Here 4 Creating Advanced Formulas Working with Arrays Using Array Formulas Using Array Constants Functions That Use or Return Arrays Using Iteration and Circular References Consolidating Multisheet Data Consolidating by Position Consolidating by Category Applying Data-Validation Rules to Cells Using Dialog Box Controls on a Worksheet Using the Form Controls Adding a Control to a Worksheet Linking a Control to a Cell Value Understanding the Worksheet Controls From Here 5 Troubleshooting Formulas Understanding Excels Error Values #DIV/0! #N/A #NAME? Avoiding #NAME? Errors When Deleting Range Names #NULL! #NUM! #REF! #VALUE! Fixing Other Formula Errors Missing or Mismatched Parentheses Erroneous Formula Results Fixing Circular References Handling Formula Errors with IFERROR() Using the Formula Error Checker Choosing an Error Action Setting Error Checker Options Auditing a Worksheet Understanding
Synopsis
"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 Microsoft 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 Microsoft 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 15 Using Excel's Business-Modeling Tools 16 Using Regression to Track Trends and Make Forecasts 17 Solving Complex Problems with Solver IV Building Financial Formulas 18 Building Loan Formulas 19 Building Investment Formulas 20 Building Discount Formulas Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity Suite Covers Microsoft Office Excel 2007 User Level Intermediate - Advanced, This resource not only takes Excel users through the applications intermediate and advanced options, but it also tells why these options are useful and shows how to use them in everyday situations and real-world models. No-nonsense, step-by-step tutorials and lots of practical, useful examples are aimed directly at business users., "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 Microsoft(R) 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 Microsoft(R) 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. - Shunsspreadsheet 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 Ranges2 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 withStatistical Functions III Building Business Models 13 Analyzing Data with Tables14 Analyzing Data with PivotTables15 Using Excel's Business-Modeling Tools 16 Using Regression to Track Trends and Make Forecasts 17 Solving Complex Problems with SolverIV Building Financial Formulas 18 Building Loan Formulas19 Building Investment Formulas 20 Building Discount Formulas Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity Suite Covers Microsoft Office Excel 2007 User Level Intermediate - Advanced, "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 Microsoft(R) 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 Microsoft(R) 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 15 Using Excel's Business-Modeling Tools 16 Using Regression to Track Trends and Make Forecasts 17 Solving Complex Problems with Solver IV Building Financial Formulas 18 Building Loan Formulas 19 Building Investment Formulas 20 Building Discount Formulas Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity Suite Covers Microsoft Office Excel 2007 User Level Intermediate - Advanced, "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 Microsoft 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 Microsoft 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 15 Using Excel''s Business-Modeling Tools 16 Using Regression to Track Trends and Make Forecasts 17 Solving Complex Problems with Solver IV Building Financial Formulas 18 Building Loan Formulas 19 Building Investment Formulas 20 Building Discount Formulas Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity Suite Covers Microsoft Office Excel 2007 User Level Intermediate - Advanced
LC Classification Number
HF5548.4.M523M3756
Opis przedmiotu podany przez sprzedawcę
Popularne kategorie z tego Sklepu
Zarejestrowany jako prywatny sprzedawca
W związku z tym prawa konsumenckie wynikające z przepisów EU o ochronie konsumentów nie obowiązują. W przypadku większości zakupów nadal obowiązuje Ochrona kupujących eBay. Dowiedz się więcejDowiedz się więcej
Opinie sprzedawców (747)
- n***d (480)- Opinie wystawione przez kupującego.Ostatni miesiącZakup potwierdzonyWorks great, no issues. Updated to the latest firmware. Nice and easy seller.
- e***u (1258)- Opinie wystawione przez kupującego.Ostatni miesiącZakup potwierdzonyWell Packed, Fast shipping , As described, Good Seller AAAAAAAAAAAAAAAAAAAAAA++++++++++
- i***o (1630)- Opinie wystawione przez kupującego.Ostatni miesiącZakup potwierdzonygoodTimberland Moc Toe Boots 8US Black Timberdry Ortholite (nr 335436633553)