Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Here's WHAT you'll learn:Manage your financial data and personal expenses Get started quickly with prebuilt templates Create formulas and functions to do the hard work Sort, filter, update, and copy your data Use charts and graphics to bring data to life Collaborate with colleagues by sharing spreadsheets online
Here's HOW you'll learn it:Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.
My Microsoft® Windows® 10 is an easy, full-color tutorial on the latest operating system from Microsoft. It includes 2 hours of FREE step-by-step video tutorials to help you learn how to navigate and customize the new Windows 10 desktop.
In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Windows 10, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.
How to access the free video and web edition: Follow the instructions within the book to learn how to register your book to access the 2 hours of FREE step-by-step video and the FREE Web Edition.
Author Katherine Murray has been writing about technology for more than 25 years and has worked with every consumer version of Windows since Windows 3.1. Murray will help you learn how to:Master Windows 10 innovations you like and keep the older techniques you’re comfortable with Let Cortana, your new personal digital assistant, help you find what you need Adjust the Start menu so it works the way you want (not the other way around!) Learn to use Windows 10 on PC or tablet Streamline your browsing experience with Microsoft® Edge, the new state-of-the-art web browser Find, download, install, and work with the best new Windows Store apps Copy, move, and share files using File Explorer Use the Skype app to make super-easy, free video calls Access all your favorite media with the new Groove Music and Movies & TV apps
The important stuff you need to know:Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results.Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature.Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives.Import data. Pull data from a variety of sources, including website data feeds and corporate databases.Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App.Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn.Master the new data model. Use PowerPivot to work with millions of rows of data.Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.