Excel X is the upgrade to Microsoft's market-dominating spreadsheet program. In addition to new spreadsheet features, this version of Excel contains enhanced Internet capabilities. The book leads the user through Excel fundamentals, then covers intermediate material in depth. Advanced topics such as VBA macros and programming, Web publishing, and Office integration are covered at length. Users will also learn to use and distribute Excel applications on the Web and how to integrate Excel with other Office applications.
Book Description
Editorial Reviews
From the Back Cover
Business Coverage for Business Users
The latest release of Excel is more about business productivity than ever before-and so is Mastering Microsoft Excel 2002, which has been designed specifically to help you tap into the unparalleled feature set Excel 2002 offers serious business users. Inside, two Excel experts give you not only the how but also the why-clear, concise explanations of the value you and the rest of your team will derive from a wide range of intermediate and advanced techniques. Coverage includes:
The latest release of Excel is more about business productivity than ever before-and so is Mastering Microsoft Excel 2002, which has been designed specifically to help you tap into the unparalleled feature set Excel 2002 offers serious business users. Inside, two Excel experts give you not only the how but also the why-clear, concise explanations of the value you and the rest of your team will derive from a wide range of intermediate and advanced techniques. Coverage includes:
• Creating worksheets
• Creating simple and complex formulas
• Using Excel's logic to handle decisions and worksheet errors
• Rearranging and manipulating data with text and date functions
• Constructing, editing, and formatting charts
• Sorting, filtering, and subtotaling databases
• Applying conditional formatting and data validation
• Summarizing data with pivot tables and pivot charts
• Importing data from the Web, SQL Server, Access, OLAP servers, and other sources
• Integrating Excel with Access, Word, PowerPoint, Outlook, and MapPoint 2002
• Collaborating with other users: workbook routing, file sharing, and SharePoint Team Services
• Modeling business data with the what-if tools: data tables, Goal Seek, Solver, and scenarios
• Using templates and reports to create workbooks for other users
• Recording and editing macros
• Building applications using Excel 2002 and VBA
• Creating simple smart tags
About the Author
Gini Courter is a co-owner of TRIAD Consulting, a computer consulting firm specializing in computer training customized solutions. She is the co-author of numerous books, including Mastering Office 2000, Mastering Outlook, Excel 2000 MOUS Study Guide, and Word 2000 MOUS Study Guide.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
There are no customer reviews yet.
|
|||
|
Video reviews
|
Inside This Book
(learn more)
First Sentence:
No matter what your experience level is with Excel, Excel 2002 has much to offer you that's new and improved. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
commission worksheet, fixing formula errors, payroll template, simple smart tags, size with cells, dependent workbook, existing pivot table, natural language formulas, donut chart, custom command bars, pivot table report, source workbook, interest worksheet, smart tag lists, print expenses, worksheets collection, serial value, current workbook, formatted cells, task pane, absolute cell reference, active workbook, formula bar, worksheet object, consecutive delimiters Key Phrases - Capitalized Phrases (CAPs): (learn more)
Visual Basic, Paste Special, Retirement Countdown, Microsoft Excel, Goal Seek, Microsoft Query, Frazier Fir, Microsoft Office, Traverse Tree Sales, Lake Blue Spruce, Las Vegas, End Sub, Formula Auditing, Query Wizard, Format Painter, Hello World, Lake White Pine, Chart Wizard, Page Break Preview, Template Wizard, Team Services, Internet Explorer, Format Control, Lookup Wizard, Automating Excel New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
No matter what your experience level is with Excel, Excel 2002 has much to offer you that's new and improved. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
commission worksheet, fixing formula errors, payroll template, simple smart tags, size with cells, dependent workbook, existing pivot table, natural language formulas, donut chart, custom command bars, pivot table report, source workbook, interest worksheet, smart tag lists, print expenses, worksheets collection, serial value, current workbook, formatted cells, task pane, absolute cell reference, active workbook, formula bar, worksheet object, consecutive delimiters Key Phrases - Capitalized Phrases (CAPs): (learn more)
Visual Basic, Paste Special, Retirement Countdown, Microsoft Excel, Goal Seek, Microsoft Query, Frazier Fir, Microsoft Office, Traverse Tree Sales, Lake Blue Spruce, Las Vegas, End Sub, Formula Auditing, Query Wizard, Format Painter, Hello World, Lake White Pine, Chart Wizard, Page Break Preview, Template Wizard, Team Services, Internet Explorer, Format Control, Lookup Wizard, Automating Excel New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
This book cites 3
books:
- Microsoft Office 2000 User Specialist Study Guide by Gini Courter in Back Cover
- Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design by Michael J. Hernandez on page 502
- Microsoft Office 2000: No Experience Required. by Gini Courter in Back Cover
Books on Related Topics
(learn more)
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
