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

Offers an easy-to-navigate design featuring a two-column landscape layout loaded with step-by-step instructions and illustrations to help readers get up to speed fast on key PowerPoint tasks-and create effective and striking presentations Covers creating a new presentation, resizing or moving an object, duplicating a slide, using the outlining toolbar, and adding notes to a slide Shows how to print a presentation, set up a slide show, work with pictures and clip art, color text and objects, modify the slide master, create a template, insert a diagram or chart, add sound and video, and much more

Pick your Excel task, find it fast, and get it done with Just the Steps! If you want to see how to do a particular Excel task, this is the perfect book. Each page includes step-by-step instruction in one column and illustrations and screenshots in the other column, so you have all the information you need in one place—no flipping pages! Improve your Excel skills with just the steps for entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, building macros, integrating Excel into other Office programs, and—whew!—still more. Explains essentials tasks for Excel 2010, the spreadsheet application that is part of the Microsoft Office 2010 suite Shows you just the steps for numerous Excel tasks using an easy-to-follow, two-column page layout, with step-by-step instruction on one side and illustrations and screenshots on the other Covers entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, and building macros Walks you step by step through collaborating in Excel and integrating or using Excel with Word, PowerPoint, and Access Make your tasks easier, improve your Excel skills, and get better results with this step-by-step guide.

Quickly and easily perform tasks in any Microsoft Office 2010 application! As the world's leading suite of productivity software, Microsoft Office enables you to complete common business tasks, including word processing, e-mail, presentations, data management and analysis, and much more. With this fun and friendly guide, veteran author Elaine Marmel presents you with concise, step-by-step instructions for quickly and easily accomplishing the most popular tasks in Word, Excel, Outlook, and PowerPoint. Decide on a task you are eager to undertake, find it quickly in the featured easy-to-read format, and get it done smoothly with this Just the Steps guide! You’ll discover how to insert pictures into a Word document, create PivotTables in Excel, add sound to a PowerPoint presentation, import contacts into Outlook, create a mail merge document with Outlook contacts, and much more. Presents indispensible advice for accomplishing specific tasks in any of the applications included in Microsoft Office 2010, including Word, Excel, Outlook, and PowerPoint Demonstrates how to insert pictures in a Word document, create PivotTables in Excel, add sound to a PowerPoint presentation, and import contacts into Outlook Includes unique coverage of performing tasks that work across programs, such as creating a mail merge using Word and Outlook, and embedding an Excel chart in PowerPoint With this efficient guide helping you quickly accomplish specific tasks in Office 2010, you won't know what to do with all your free time!

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.

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!

When they first told you that forecasting sales would be part of your job, did you feel just the tiniest bit of panic? Did you momentarily consider consulting the Yellow Pages for listings of “Psychics” or “Tea Leaf Readers”? Well, fear not. Excel Sales Forecasting For Dummies can help you predict the future without incense or a crystal ball. Excel Sales Forecasting For Dummies shows you how to use the number one workbook program, Microsoft Excel, to predict trends and future sales based on something not quite so ethereal—numbers. You use data about the past to forecast the future. Excel provides all sorts of tools to help you do that, and this book shows you how to use them. From recognizing why forecasting is a good idea to making sense of exponential smoothing, Excel Sales Forecasting For Dummies has you covered. If you have a basic grasp of how to use Excel, you’ll be ready to discover how to Select and use the right forecasting method for your business Choose and arrange data in lists, then manage that data with pivot tables Filter lists and turn them into charts that illustrate what’s going on Find relationships in your data Use Excel’s Analysis Toolpak feature to create forecasts automatically, or venture into advanced forecasts using worksheet functions Gain more control over your forecasting and target specific types of predictions Use moving averages and predict seasonal sales Written by Conrad Carlberg, a nationally recognized expert on Excel who also has experience in sales and marketing, this friendly guide gets you up and running quickly and easily. You’ll soon be setting up a baseline you can chart and label, summarizing data with pivot tables, making forecasts based on regression, understanding correlation, and discovering how smoothing lets us profit from our mistakes. You’ll find your confidence in your ability to make sales predictions has soared right off the chart.

8 books in 1- your key to QuickBooks 2007 success! Your one-stop guide to managing your small business finances more efficiently QuickBooks is the leading accounting program for small businesses, and this book gives you a handy reference to all its parts. Set up QuickBooks for your business, load your files, create invoices, pay vendors, understand job costing and capital budgeting, and even get tips on writing your business plan. It all adds up to success! Discover how to Install and set up QuickBooks Track your inventory and items Prepare financial statements and reports Set up project and job costing systems Protect your data Save on business taxes

One of the principles of good business and good money management is to make the most of what you have. QuickBooks All-In-One Desk Reference For Dummies helps you make the most of QuickBooks business accounting software. Updated to cover changes and enhancements to the software, it combines eight quick reference guides: An Accounting Primer that covers basic principles, double-entry bookkeeping, and special accounting problems Getting Ready to Use QuickBooks with information on setting up QuickBooks, loading the master file lists, and fine-tuning QuickBooks Bookkeeping Chores, covering invoicing customers, paying vendors, tracking inventory, and more Accounting Chores including financial statements, reports, and budgets, using activity-based costing, and setting up project and job costing systems Financial Management such as ratio analysis, economic value-added analysis, and capital budgeting Business Plans, featuring profit-volume-cost analysis, forecasting, and writing a business plan Care and Maintenance, with information on protecting data, troubleshooting, and more Additional Business Resources including a crash course in Excel, a glossary, and more Written by veteran Dummies author Stephen L. Nelson, MBA, CPA, and author of more than 100 books with more than four million copies in print, QuickBooks All-In-One Desk Reference For Dummies goes beyond the basics of how to use QuickBooks and provides expert advice on accounting chores, financial management, business planning, and much more. With a comprehensive index, it’s your instant, at-your-fingertips reference for everything from how to handle everyday accounting tasks to long-term planning for your business. Fine-tune QuickBooks for your business and your accounting systems Calculate breakeven points Budget for capital expenditures Take advantage of online banking There’s even a companion Web site where you can take advantage of a sample business plan workbook and download a profit-volume cost analysis workbook. You won’t find a more comprehensive, authoritative, yet understandable guide to QuickBooks.

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!