Search Results for: excel-2010-for-dummies

Crunch numbers, create spreadsheets, and get up to speed onExcel 2010! This friendly book gets you started with the basics of Excel2010, such as creating a spreadsheet from scratch, selectingcommands from the Ribbon, customizing the Quick Access toolbar,creating simple formulas, moving and copying data with drag anddrop, using the AutoCorrect and AutoFill features, and more. Navigate effectively — see how the Ribbon interface andthe Backstage View give you access to all the tools you need forevery task Be a mover and a shaker — move and copy data with cut,copy, and paste or drag and drop Summing up — total columns and rows of numbers with theAutoSum button Making it pretty — format data tables, adjust columnwidths and row heights, hide columns and rows, and format withStyles or the Format Painter Safety net — save your work and recover spreadsheets aftera computer crash Open the book and find: What's new in Excel 2010 How to surf an Excel 2010 worksheet and workbook Instructions for entering data in a worksheet Tips for keeping your data secure How to enter and edit formulas with built-in functions Tips for undoing or deleting data entry mistakes Learn to: Get comfortable with Excel 2010 and Backstage View Create and edit spreadsheets Format cells, create formulas, and fix data entry errors Copy, cut, move, paste, or delete data

Reinforce your understanding of Excel with these Workbook exercises Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The For Dummies Workbook format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency. Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, Excel 2010 Workbook For Dummies helps you discover all the ways this program can work for you. Excel is the world's most popular number-crunching program, and For Dummies books are the most popular guides to Excel The Workbook approach offers practical application, with more than 100 exercises to work through and plenty of step-by-step guidance This guide covers the new features of Excel 2010, includes a section on creating graphic displays of information, and offers ideas for financial planners Also provides exercises on using formulas and functions, managing and securing data, and performing data analysis A companion CD-ROM includes screen shots and practice materials Excel 2010 Workbook For Dummies helps you get comfortable with Excel so you can take advantage of all it has to offer. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Find the answers to your most important Excel questions with this reference John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference. You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily. Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions Offers information in a highly organized, easy-to-understand format so you can find exactly what you need Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!

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.

Master the leading spreadsheet and data analysis tool with this book-and-CD package! Learn step by step to create worksheets, work with formulas and functions, format data, use financial functions, and more.

Two complete e-books covering beginning- to intermediate-level Excel for one low price! This unique value-priced e-book set brings together two bestselling For Dummies books in a single e-book file. Including a comprehensive table of contents and the full text of each book, complete with cover, this e-book set gives you in-depth information on Excel from basic worksheet creation to data management, data analysis, and VBA programming for custom applications. Best of all, you'll pay less than the cost of each book purchased separately. You'll get the complete text of: Excel 2010 All-in-One For Dummies, which covers Navigating the interface, customizing Excel, and using Backstage View Building, formatting, editing, proofing, managing, and printing worksheets Using formulas and functions Creating charts, sorting and filtering data, and performing what-if analysis Excel 2010 VBA Programming For Dummies, 2nd Edition, which shows you how to Use the essential tools and operations for Visual Basic for Applications Work with range objects and control program flow Handle errors and eliminate bugs in your code Develop custom user interfaces for your applications, including dialog boxes About the authors Greg Harvey, author of Excel 2010 All-in-One For Dummies, is an experienced educator and the author of all editions of Excel For Dummies. John Walkenbach, author of Excel 2010 VBA Programming For Dummies, is a leading authority on spreadsheet software and the author of more than 50 books on Excel, including Excel Bible.

A comprehensive, up-to-date, user-friendly guide to Excel 2010 Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface For Dummies books are the bestselling guides to Excel, with more than three million copies sold Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA. Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.

A friendly reference guide to Microsoft Project, the leading enterprise project management software As project management software, Microsoft Project allows you to oversee your business activities effectively. You can manage resources, share project info, perform modeling and scenario analysis, and standardize reporting processes. This easy-to-understand guide is completely updated to cover the latest changes and newest enhancements to Project 2010 and shows you how to get Project 2010 to work for you. After an introduction to basic project management concepts, you’ll discover the mechanics of using Project software to create and manage projects. Other topics covered include working with calendars, using and sharing resources, budgeting, formatting taskbars, gathering and tracking data, working with reports, and creating templates. Microsoft Project allows you to manage resources, share project information, perform scenario analysis, and standardize reporting processes Offers completely updated coverage of the new Project 2010, which is expected to implement the Office Ribbon Reviews formatting taskbars, gathering and tracking data, and working with reports Addresses using and sharing resources, creating templates, and managing projects Let the friendly For Dummies writing style guide you through maximizing the new features of Project 2010.

Create and work with Microsoft Office 2010 with this learning package Microsoft Office 2010 is the most commonly used office productivity suite and if you're eager to get started using all it has to offer, this value-packed eLearning kit is essential to your learning process. This complete Microsoft Office 2010 course includes a full-color printed book and a Dummies interactive eLearning course on CD. You'll discover the basics of the Office interface, how to navigate it, and how to use the features common to all Office programs. Then you'll get detailed instruction in working with Word, Excel, PowerPoint, and Outlook to make learning easier! Follow the material sequentially or jump in and out as you wish?it's set up so you can learn at your own pace. Throughout, you will benefit from illustrations, animations, voiceover explanations, and the option of closed captioning if you find you learn better when you can read the instructions. Helps self-motivated learners get familiar with Office 2010 Walks you through creating and formatting a Word document, creating and working with an Excel spreadsheet, managing e-mail and calendars with Outlook, and building a PowerPoint presentation with graphics and sound Includes an easy-to-follow, full-color book and an interactive Dummies eLearning Course that corresponds with the book on CD Allows you to follow the material sequentially or choose separate sections at your own time and pace Office 2010 eLearning Kit For Dummies helps you get the very most out of all the applications in the Office 2010 suite. NOTE: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.

The latest edition of one of the bestselling Microsoft Office books of all time! Spend less time figuring out Word, Excel, PowerPoint, Outlook, and Access and more time working on actual projects with this new edition of Office 2010 For Dummies. Filled with straightforward, friendly instruction, this book gets you thoroughly up to speed, and it actually makes doing Office work fun! First learn all the basics, then how to add more bells and whistles, including how to spice up your Word documents, edit Excel spreadsheets and create formulas, add sound to your PowerPoint presentation, and much more. Helps you harness the power of Microsoft Office 2010 and all of its new functionality; the book covers Word, Excel, PowerPoint, Outlook, and Access Explains and instructs in the straightforward, friendly, For Dummies style that makes instruction more accessible and skill-building easier Covers typing and formatting text in Word and spicing up your documents Shows you how to navigate and edit an Excel spreadsheet, create formulas, and chart and analyze Excel data Demonstrates how to create a PowerPoint presentation and add color, sound, and pictures Explores Outlook, including configuring e-mail, storing contacts, organizing tasks, scheduling your time, and setting appointments Delves into designing Access databases, including editing, modifying, searching, sorting, and querying; also covers viewing and printing reports, and more Be ready to take full advantage of Microsoft Office 2010 with this fun and easy guide.

Whatever you're now doing with Microsoft Excel there's much more you could be doing. The world's most popular spreadsheet program, Excel grows richer in features with each new release. Excel For Dummies puts at your disposal all the powerful capabilities of version 5 -- capabilities for everything from manipulating databases to creating three-dimensional charts. Whether you're new to Excel or just new to version 5, bestselling author Greg Harvey's concise, clear, how-to explanations get you doing what you need to do quickly -- without a lot of hair-pulling and staying late at the office.

Just what you need to know to take full advantage of your newBlackBerry smartphone The popular BlackBerry is used by millions of office workers andexecutives and has become an essential business tool. Now with aneven faster and more efficient 6.0 operating system, the newestBlackBerry devices have the potential to become pocket-sizedreplacements for the laptop. This fifth edition of the most popularBlackBerry guide explores all the features of the new BlackBerryand its upgraded OS. It covers setting up the device, organizing and managing yourappointments and to-do list, accessing the Internet, handlinge-mail, working with multimedia, synching your BlackBerry with yourdesktop, adding apps, and much more. The BlackBerry is the most popular handheld device for businessusers; an updated 6.0 operating system is being introduced for newmodels with an upgrade available for certain older models This edition of the popular BlackBerry guide covers the new OS,setting up your BlackBerry, organizing and managing your calendar,handling e-mail, and accessing the Internet Explores working with multimedia and taking great photos withyour BlackBerry Offers tips and shortcuts plus information about managing powerusage, synching your BlackBerry to your desktop, and takingadvantage of the expandable memory, as well as great apps you canadd Wise advice from BlackBerry experts makes this the guide youneed to get the most juice from your BlackBerry.