Synopses & Reviews
When you think of number-crunching and spreadsheets, you think of Excel, right? After Word, it’s the most popular program in the Microsoft Office suite. But if technical jargon isn’t your first language, you may have found Excel just a teeny bit frustrating. It can be really hard to pick your way through the many features and make Excel do what you need for it to do.
Once you know how, you can use Excel to
- Create fill-in-the-blank forms
- Prepare expense reports and invoices
- Manage all sorts of data
- Keep sales and inventory records
- Analyze financial data and create forecasts
- Present information in charts and graphs
Excel 2003 All-in-One Desk Reference For Dummies tames the Excel monster. Nine minibooks break things down into manageable, logical sections covering the basics, worksheet design, formulas and functions, worksheet collaboration, charts and graphics, data management, data analysis, working on the Web, and tweaking Excel with a programming language called Visual Basic for Applications, or VBA. In the friendly, plain-English For Dummies style, this book makes it easy to find what you’re looking for and get instructions for doing what you need to do. You’ll be able to
- Find your way around Excel’s menus, toolbars, and dialog boxes, and access online help
- Format a professional-looking spreadsheet that presents data the way you choose
- Edit an existing spreadsheet without disturbing its design or contents
- Build Excel formulas and use built-in functions to produce the calculations you want
- Share spreadsheet data with other people and programs, and collect comments
- Create great-looking charts and find out how to choose the right format to display your data effectively
- Use Excel to maintain large amounts of data, then filter the data to extract the information you need
- Publish spreadsheets and charts on the Web in HTML format
- Explore ways to customize Excel with VBA
Best of all, it’s easy to find what you need in Excel 2003 All-in-One Desk Reference For Dummies. Before you know it, you’ll discover you’ve developed a friendship with Excel that will make your life easier, boost your business, and impress your friends!
Excel dominates the international spreadsheet software market with more than 120 million licensed Office users worldwide. Excel is by far the leading spreadsheet software and, after Word, is the most used component of the Microsoft Office suite. Excel remains the industry-standard spreadsheet application and comes out on top in head-to-head spreadsheet comparisons. Excel is the spreadsheet and data analysis tool available as part of Microsoft's Office software package. Platforms: Windows; Company behind it: Microsoft (ww.microsoft.com/office/excel); Current version: Excel 2002; Expected Upgrade: Version "X" expected in Q3 of 2003
* Covers everything a reader needs to know to perform the task at hand, then goes a step beyond by outlining the most practical and useful applications for Excel in the workplace
* Organized in convenient minibooks to help the reader find necessary information about particular topics quickly and easily
* Includes basic coverage of importing data, building and editing worksheets, creating formulas, generating PivotTables, and performing financial functions, what-if scenarios, database functions, and Web que-ries
* Advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with VBA and the Web
Excel is the spreadsheet and data analysis tool included in Microsoft's Office software package. This handy desk reference gives the reader access to all the Excel basics as well as some more advanced spreadsheet applications, organized so information is easy to locate.
Excel is the spreadsheet and data analysis tool included in Microsoft's Office software package. With more than 120 million licensed Office users worldwide, Excel dominates the international spreadsheet software market. This handy desk reference covers the latest release and gives the reader access to all the Excel basics as well as some more advanced spreadsheet applications, organized so information is easy to locate.
9 books in 1 your key to Excel 2003 success!
Your one-stop guide to building worksheets, creating formulas, managing data, and more
Excel is famous for its incredible range of capabilities accompanied by incredibly complex explanations that only a devout techie can understand. Jettison the jargon with this perfectly organized reference guide! Youll discover how to use Excels every feature, and best of all, find the answer in a hurry should you still get stuck.
The Dummies Way
- Coverage of the essentials and beyond
- Explanations in plain English
- "Get in, get out" information
- Thumbtabs and other navigation aids
- Tear-out cheat sheet
- A dash of humor and fun
About the Author
Greg Harvey is a veteran computer trainer and consultant who has written more than 50 books. Hes the owner of a multimedia publishing venture called Mind Over Media.
Table of Contents
Book I: Excel Basics.
Chapter 1: Getting Acquainted with Excel.
Chapter 2: Getting Help.
Chapter 3: Customizing Excel.
Book II: Worksheet Design.
Chapter 1: Building Worksheets.
Chapter 2: Formatting Worksheets.
Chapter 3: Editing Worksheets.
Chapter 4: Managing Worksheets.
Chapter 5: Printing Worksheets.
Book III: Formulas and Functions.
Chapter 1: Building Basic Formulas
Chapter 2: Logical Functions and Error Trapping
Chapter 3: Date and Time Formulas
Chapter 4: Financial Formulas
Chapter 5: Math and Statistical Formulas
Chapter 6: Lookup, Information, and Text Formulas.
Book IV: Worksheet Collaboration.
Chapter 1: Sharing and Reviewing Workbooks.
Chapter 2: Protecting Worksheets.
Chapter 3: Sharing Data with Other Programs.
Chapter 4: Sharing Data via a SharePoint Team Services Web Site.
Book V: Charts and Graphics.
Chapter 1: Charting Worksheet Data.
Chapter 2: Adding Graphic Objects.
Book VI: Data Management.
Chapter 1: Building and Maintaining Data Lists.
Chapter 2: Filtering and Querying a Data List.
Book VII: Data Analysis.
Chapter 1: Performing What-If Scenarios.
Chapter 2: Generating Pivot Tables.
Book VIII: Excel and the Web.
Chapter 1: Worksheets As Web Pages.
Chapter 2: Adding Hyperlinks to Worksheets.
Book IX: Excel and Visual Basic for Applications.
Chapter 1: Building and Running Macros.
Chapter 2: VBA Programming.