Excel 2003 For Dummies Quick Reference


Book Description

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.




PCs For Dummies Quick Reference


Book Description

If you aren’t a proficient PC pro and you want to get answers and get going, this is your practical reference. In a concise, no frills style, it gives you the vital information on: Setting up and connecting your PC and peripherals, including your keyboard, digital camera, joystick, modem, monitor, printer, scanner, wireless gizmos, and more Installing hardware and software Creating, managing, naming, opening, saving, and finding files Organizing your stuff, with info on folders, Windows Explorer, Compressed (ZIP) folders, and more Networking, including accessing another computer or a shared folder, connecting to the network, and workgroups Creating your own CDs, including building and burning a playlist, importing music, and more The printer, keyboard and the mouse With step-by-step instructions and lots of screen shots, this book helps you walk the walk. In case you want to talk the talk, there’s a glossary with clear definitions of common PC terms. A detailed index helps you find the how-to you need fast. If you want to know the history of the PC and all of its intricacies, get a big book. If you want to know how to get your PC to do what you need it to do, get this handy little reference and get to work fast.




Excel 2003 For Dummies


Book Description

Every time you turn around, you run into Excel. It’s on yourPC at work. It’s on your PC at home. You get Excel files fromyour boss. Wouldn’t you like to understand this powerfulMicrosoft Office spreadsheet program, once and for all? Now, youcan crunch financial data, add sparkle to presentations, convertstatic lists of numbers into impressive charts, and discover whatall the shouting’s about regarding databases, formulas, andcells. You may even decide that getting organized with a goodspreadsheet is downright useful and fun! Flip open Excel 2003 For Dummies, and you’llquickly start getting the basics of Excel in plain English. Writtenfor the rest of us, this down-to-earth book gently shows you howto: Create a spreadsheet from scratch Apply the basics of formatting cells Take on database forms—even add records—andprevail Get organized and stay that way Save worksheets as Web pages for your company intranet In a clear and easy-to-understand style, veteran softwaretrainer and technology writer Greg Harvey explains the basics ofworksheets and workbooks, how to enter data and workwith formulas, and how to print your masterpieces. Whenyou’re feeling very bold, he’ll have you addingcomments and pictures, saving files with security protection, andlearning to zip between multiple worksheets in a workbook withease. 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 withaplomb Move between these sheets without trouble Decipher and take charge of helpful tools and commands such asSort, Filter, Format Cells, and PivotTable You’ll finally be able to stop pestering the Excel expertsin your office. Become your own expert with the friendly anddown-to-earth practical instruction you’ll find in Excel2003 For Dummies.




Windows XP For Dummies


Book Description

Windows XP is the most powerful of Microsoft’s Windows software – software that’s been updated many times since starting to breathe in January 1985. XP is short for Experience, but Microsoft calls it Windows XP to give it a more modern-day, "at-this-happening-moment" sound. Someday, sometime, something in Windows XP will eventually leave you scratching your head. No other program brings so many buttons, bars, and babble to the screen. Windows XP For Dummies is for everyone who has a clue about what they want to do with their computers. Bypassing the technical hoopla, this friendly reference comes to the rescue when Windows XP stumps you or when you're feeling spunky and want to dig into deeper details of the ever-popular operating system. In either case, you can expect to pick up information on Finding the file you saved or downloaded yesterday Moving those little windows around on the screen with the mouse Making Windows XP run like your older versions of Windows Starting and closing programs by clicking the mouse button Making Windows XP work again when it’s misbehaving Beginning with the basics, this book explains all the Windows XP stuff that everybody thinks they already know – until the program starts tossing them stumbling blocks. Windows XP For Dummies clears the way to Navigating the new Start menu and taskbar with ease Setting up a secure Internet connection Having a good time with digital photos, music, and videos Personalizing XP for each member of your family Fixing common problems using System Restore and online resources Most people meet up with Windows XP by something other than choice. Their new computer probably came with a version already installed; maybe the workplace introduced a Windows XP update; or perhaps the latest version of their favorite program required Windows XP. Any in case, Windows XP For Dummies helps you adjust easily to the new Windows kid in town – and even enjoy his company!




Microsoft Office Specialist


Book Description

Validate your expertise and get the attention of employers with Microsoft Office Specialist certification. This comprehensive guide is what you need to prepare for certification in Excel 2003, both the Specialist and Expert levels. Carefully planned by a seasoned Microsoft Office Specialist instructor, this invaluable study guide uses real-world scenarios to teach the full range of Excel 2003 skills you need-not only to prepare for the certification exams, but also to increase your ability and productivity in the workplace. Covering twenty-four Specialist exam objectives and thirty-three Expert exam objectives, the book progresses through the functions and features of Excel software. Even entry-level Excel users can rapidly build their skills. Excel 2003 Specialist Certification Skill Sets * Creating Data and Content * Analyzing Data * Formatting Data and Content * Collaborating * Managing Workbooks Excel 2003 Expert Certification Skill Sets * Organizing and Analyzing Data * Formatting Data and Content * Collaborating * Managing Data and Workbooks * Customizing Excel Plus, you'll find additional career preparation tools, including: * Solutions for real-world scenarios * Structured learning for quick productivity * Full glossary of terms Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what you've learned on your own. Visit www.sybex.com for all of your professional certification needs.




Windows Vista For Dummies Quick Reference


Book Description

Readers will save themselves time and energy by using this handy, A-to-Z reference to quickly find answers regarding the exciting new release of Windows Vista Includes helpful information on the new features of Vista, such as the task-based interface, sidebar, gadgets, new "Aero" interface, 3D-look option, heightened security, new search capabilities, and much more Covers navigating the desktop, launching programs, adding programs, removing programs, creating files, copying files and folders, and deleting files and folders Accessible organization of topics also shows readers how to create shortcuts, connect to the Internet, search the Web, add favorites, use the new file management system, and more




Excel 2007 VBA Programmer's Reference


Book Description

This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help. The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats. The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).




Yoga with Weights For Dummies


Book Description

An easy-to-follow guide to a hot new form of yoga Yoga with Weights is the latest breakthrough in mind-body exercise, integrating the mindfulness of yoga with the physical culture of body-building. Building on the strengths of both disciplines, this friendly guide shows readers how to safely combine yoga postures while simultaneously working out with lightweight hand-held free weights. It features customizable exercises that target specific areas of the body, each illustrated with multiple photos, and provides guidelines for combining healthy eating with workouts. Sherri Baptiste (Marin County, CA) is the founder of Baptiste Power of Yoga, a nationally recognized method of yoga offered throughout the United States. She teaches yoga classes throughout the United States and hosts retreats around the world.




Building Your Own Home For Dummies


Book Description

Keep construction on track with helpful checklists Turn your dream of a custom home into reality! Thinking about building your own home? This easy-to-follow guide shows you how to plan and build a beautiful home on any budget. From acquiring land to finding the best architect to overseeing the construction, you get lots of savvy tips on managing your new investment wisely -- and staying sane during the process! Discover how to: * Find the best homesite * Navigate the plan approval process * Obtain financing * Hire the right contractor * Cut design and construction costs * Avoid common mistakes




Python For Dummies


Book Description

Python is one of the most powerful, easy-to-read programming languages around, but it does have its limitations. This general purpose, high-level language that can be extended and embedded is a smart option for many programming problems, but a poor solution to others. Python For Dummies is the quick-and-easy guide to getting the most out of this robust program. This hands-on book will show you everything you need to know about building programs, debugging code, and simplifying development, as well as defining what actions it can perform. You’ll wrap yourself around all of its advanced features and become an expert Python user in no time. This guide gives you the tools you need to: Master basic elements and syntax Document, design, and debug programs Work with strings like a pro Direct a program with control structures Integrate integers, complex numbers, and modules Build lists, stacks, and queues Create an organized dictionary Handle functions, data, and namespace Construct applications with modules and packages Call, create, extend, and override classes Access the Internet to enhance your library Understand the new features of Python 2.5 Packed with critical idioms and great resources to maximize your productivity, Python For Dummies is the ultimate one-stop information guide. In a matter of minutes you’ll be familiar with Python’s building blocks, strings, dictionaries, and sets; and be on your way to writing the program that you’ve dreamed about!