Every time you turn around, you run into Excel. It’s on your PC at work. It’s on your PC at home. You get Excel files from your boss. Wouldn’t you like to understand this powerful Microsoft Office spreadsheet program, once and for all? Now, you can crunch financial data, add sparkle to presentations, convert static lists of numbers into impressive charts, and discover what all the shouting’s about regarding databases, formulas, and cells. You may even decide that getting organized with a good spreadsheet is downright useful and fun! Flip open Excel 2003 For Dummies, and you’ll quickly start getting the basics of Excel in plain English. Written for the rest of us, this down-to-earth book gently shows you how to: Create a spreadsheet from scratch Apply the basics of formatting cells Take on database forms—even add records—and prevail Get organized and stay that way Save worksheets as Web pages for your company intranet In a clear and easy-to-understand style, veteran software trainer and technology writer Greg Harvey explains the basics of worksheets and workbooks, how to enter data and work with formulas, and how to print your masterpieces. When you’re feeling very bold, he’ll have you adding comments and pictures, saving files with security protection, and learning to zip between multiple worksheets in a workbook with ease. And there’s much more: Clip and save the Top Ten Beginner Basics of Excel 2003 Pay heed to the Top Ten Commandments of Excel 2003 Impress your colleagues by creating a company org chart Re-open those documents and add or edit new data with aplomb Move between these sheets without trouble Decipher and take charge of helpful tools and commands such as Sort, Filter, Format Cells, and PivotTable You’ll finally be able to stop pestering the Excel experts in your office. Become your own expert with the friendly and down-to-earth practical instruction you’ll find in Excel 2003 For Dummies.

If you’re using Excel 2003 and you’d rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including: Opening, saving protecting, and recovering workbook files and using workbook templates Adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web Entering and editing data and text and working with cells and ranges Creating formulas and functions Creating and using names Auditing, formatting, and printing your work Charting your data Analyzing data with pivot tables Complete with concise, step-by-step explanations (most of which take less than one page) and lots of screen shots and tables, this no nonsense guide gets you working instead of searching or reading, A detailed index makes it easy to find what you need to know fast. Excel 2003 For Dummies is a practical, at-a-glance reference for any Excel user.

Easy steps for creating spreadsheets you can really use Simple steps... ...for great results Use AutoOutline Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet. AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail. To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.) To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings. To remove the AutoOutline, choose Data Group and outline Clear Outline. Get ready to Format cells and data Build formulas and functions Save time with Excel tools Add color graphics toyour spreadsheets Analyze your data Create charts and PivotTables

Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant’s green sheet, and mastering even the most basic functions can be a challenge. Excel Workbook For Dummies is specially designed to give you the hands-on experience you need to start using this great program with confidence and efficiency. This guide is packed with hundreds of exercises that walk you through the ins and outs of Excel at your own pace. You’ll have all the tools you need to: Enter spreadsheet data Format, modify, and print your spreadsheet Copy and correct formulas Create date and time formulas Use math, statistical, lookup, and logical functions Chart spreadsheet data Add graphics to the spreadsheet Manage and secure your data Perform what-if analyses Generate pivot tables Publish spreadsheets as Web pages Add hyperlinks to spreadsheets Take advantage of Macros and Visual Basic Editor Included is a bonus CD-ROM full of useful features, including sample files for all exercises in the book, a variety of important Excel tools, worksheets, and templates for financial planning, and a trial version of Crystal Xcelsius to get you started making progress and becoming an Excel expert! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

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!

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here! If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done. You’ll discover how to: Rearrange, delete and insert new information Keep track of and organize data in a single worksheet Transfer data between the sheets of different workbooks Create a chart using the data in a worksheet Add hyperlinks and graphics to worksheets And more! Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.

Wouldn’t it be a waste to go on a spectacular, exotic vacation abroad and just hang out at the hotel pool? Wouldn’t it be a waste to buy a new iPod, download four favorite songs, and play them over and over? Most people with Office 2003 are wasting a lot of software power and a lot of time. They do the same routine things in the same routine ways and haven’t begun to explore the capabilities of Office 2003. If you’re one of them, Office 2003 Timesaving Techniques For Dummies gets you out of your rut and into action. It provides over 70 timesaving techniques for Word, Excel, Access, Outlook, and PowerPoint. (Most of the tips work with Office 2000 and Office XP, too.) You’ll customize Office to meet your needs and start working like a pro in no time with easy-to-use tricks, tips, and techniques for: Streamlining your toolbars (Word alone has dozens to choose from) Setting up Outlook, searching with folders, organizing with flags, and dealing with spam Taking proper security measures, including using and updating an antivirus package and avoiding potentially dangerous file extensions Editing and laying out impressive Word documents Using keyboard shortcuts Diving into more advanced Office skills such as writing macros, setting up templates, and using multimedia with PowerPoint Using Excel to build self-verifying spreadsheets Running totals and subtotals in Access Combining applications to print holiday greetings and run an electronic newsletter Written by Woody Leonhard, author of Windows XP Timesaving Techniques For Dummies and the bestseller Windows XP All-in-One Desk Reference For Dummies, this guides helps you eliminate extra steps and little annoyances and do things you probably didn’t know you could do, such as: Building e-mail stationery Calculating sales tax with the Lookup Wizard Making professional labels Encrypting messages Recording narration for PowerPoint presentations Complete with an index that lets you find what you want, fast. Office 2003 Timesaving Techniques For Dummies helps you get up to speed and down to work. After all, times a-wastin!

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel's menus and toolbars; modifying Excel's editing settings; using add-ins, AutoCorrect, AutoFill, AutoFormat, and data validation; copying and moving data between worksheets; encrypting workbook files; creating external database queries; converting worksheet data and charts into Web pages; and much more. * Written by Greg Harvey, one of the bestselling technology authors of all time, whose books have combined sales of more than four million copies * A unique, two-column format makes it easy for readers to grasp and apply each technique-and begin working more efficiently

This book utilizes a step-by-step process of creating a worksheet through Microsoft Excel to teach the novice user the basics, as well as some advanced techniques of the program. The book allows the student to become familiar with various key terms, processes, and functions of Excel, and effectively gives them hands-on training by creating an actual spreadsheet through various stages. When finished, the reader will have a general knowledge of Excel, and a foundation for continuance of that knowledge. This is not your typical tutorial, as it is not designed to teach you everything there is to know about Excel. It was written with the idea in mind of showing the student how truly intuitive the program is. You will essentially teach yourself upon completion of my book I will show you the basics of Microsoft Excel, and will detail how to continue learning even after you have finished

Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more. This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes: An introduction to the VBA language A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder The essential VBA language elements, including comments, variables and constants, and labels Working with Range objects and discovering useful Range objective properties and methods Using VBA and worksheet functions, including a list and examples Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop Automatic procedures and Workbook events, including a table and event-handler procedures Error-handling and bug extermination techniques, and using the Excel debugging tools Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks Customizing the Excel toolbars Using VBA code to modify the Excel menu system Creating worksheet functions and working with various types of arguments Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with: A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes Information to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to know What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it’s a Very Big Accomplishment.