The easiest way for visual learners to get started with Windows 8

The popular Simplified series makes visual learning easier than ever, and with more than 360,000 copies sold, previous Windows editions are among the bestselling Visual books. This guide goes straight to the point with easy-to-follow, two-page tutorials for each task. With full-color screen shots and step-by-step directions, it gets beginners up and running on the newest version of Windows right away. Learn to work with the new interface and improved Internet Explorer, manage files, share your computer, and much more.

• Perfect for the absolute beginner, with easy-to-follow instructions and colorful illustrations that show what's happening on the screen
• Covers Windows basics, navigating the interface, creating accounts to share a computer, customizing Windows, and working with files
• Demonstrates how to browse the web with the new version of Internet Explorer, how to use media features, and much more
• The bestselling Simplified series is designed to make it easy for visual learners to start using new technologies right away

Windows 8 Simplified gives visual learners confidence as they start using the new version of Windows quickly and easily.

Each book offers a complete overview of a particular topic--along with call-out boxes highlighting definitions, insights and more; appendices; and an index--in a series designed for smart and curious readers who are interested in learning.

Everything you need to know about the iPad 2!

Finally decided to get the hottest device on the planet? If so, don't go far without the iPad's must-have accessory—your own copy of iPad 2 Portable Genius. This hip little guide will show you how to get the very most out of your iPad 2. Being a Portable Genius, it gives you tips and useful information in a handy, compact size, so you can carry it along as easily as your iPad—and it doesn't skimp on any of the essentials.

• Zeros in on the hottest tricks and tips for the most-used features of your iPad 2
• Makes sure you get the most out of the all the different things the iPad 2 can do—as an e-reader, a small computer, and a large iPod touch
• Provides Genius icons to show you the smartest ways to do things
• Helps you save time and avoid hassles as you get up to speed
• Looks good! Full color and a clean layout makes it easy to access the information you need
• Compact size makes this a very portable helper you can take with you

Collect the whole Portable Genius series and make the most of your Apple digital lifestyle.

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

• Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets
• Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more
• Uses step-by-step tutorials and easy-to-follow screenshots, a 'learn by seeing' approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

Maximize your fun and boost your productivity with this updated, full-color guide to tantalizing Twitter tips!

The popularity of Twitter continues to soar, and is fast becoming the most popular social networking site online. Whether you're looking to learn how to set up an account for the first time or are on the prowl for some cool third-party Twitter apps, this full-color guide will boost your entire Twitter experience.

Allowing you to communicate with fellow Twitters within a 140-character limit, this fun and fascinating social networking tool is easier than maintaining a blog and quicker than sending an e-mail or text. With these tips, tricks, and tweets, you'll stay in the know and up to date on anything and everything you find interesting.

• Explores the newest Twitter features, including the new re-tweet feature, which adds a re-tweet button to each tweet on a person's timeline, much like the sites current 'reply' button
• Discusses Twitter's new search widget, which is more sophisticated and precise
• Shows how to use the just-announced Geolocation API, which adds location-based information to tweets
• Explains how to tweet from mobile devices
• Shows how to add Twitter to a blog or to other social networking sites such as Facebook
• Offers ideas for using Twitter in business as well as for personal contacts
• Covers Twitter terminology and provides helpful tips and tricks for expanding Twitter's usefulness through third-party applications

Explore the possibilities of Twitter and discover what the buzz is all about with this tremendously terrific guide to Twitter!

MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS!

 

Excel expert Paul McFedries shows how to use Excel 2010's core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you'll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You'll find crystal-clear instructions… insider insights… even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.

 

• Create more powerful formulas

• Use conditional formatting to instantly reveal anomalies, problems, or opportunities

• Analyze your data with standard tables and PivotTables

• Use complex criteria to filter data in lists

• Understand correlations between data

 

• Perform sophisticated what-if analyses

• Use regression to track trends and make forecasts

• Build loan, investment, and discount formulas

• Troubleshoot problems with formulas, ranges, and functions

 

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excelskills, and presents focused tasks and examples for performing them rapidly and effectively. Selectedby Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will:

 

• Dramatically increase your productivity–saving you 50 hours a year, or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make

 

Paul McFedries, president of Logophilia Limited, is a Microsoft Office expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 70 books to his credit, which combined have sold more than three million copies worldwide. His recent titles include Using the Microsoft Office Web Apps, and Microsoft Windows 7 Unleashed. He is also proprietor of Word Spy (www.wordspy.com), a website that tracks new words and phrases as they enter the English language.

 

See your way to super spreadsheets with Excel 2010 and this visual guide!

If you're always hearing about the cool things that Excel can do, here's your chance to see how to do them! With pages of full-color, step-by-step instructions and crystal-clear screen shots, this guide shows you how to get the most out of Excel 2010. The book covers all the basics as well as Excel 2010's new features and functions, including a new interface and better collaboration tools. Crunch and chart your data over a network, over the Web, or at home-helpful tips on every page will get you there even faster!

• Provides a clear look at Excel 2010, the newest version of the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
• Demonstrates how to create spreadsheets and charts, filter and sort data, work with PivotTable, and present your data-on a network, on the Web, or on your laptop
• Explores all features and functions in full-color pages packed with screen shots and other visual graphics that clearly show you how to accomplish tasks
• Includes practical examples, tips, and advice on how to use all the tools more effectively

Get the very most out of Excel 2010 with this easy-to-follow guide!

The content boom on the Internet has been explosive in the past few years with more than a billion people surfing worldwide. Internet Simplified shows beginning level computer users how to get comfortable surfing the web and how to navigate the flood of information once they find what they're looking for. Users will find helpful information on the most talked about newcomers to the online world such as social networking sites like Facebook and MySpace, blogging, and downloading media content from YouTube and iTunes, as well as an introduction to the old standbys such as email, auction sites, and instruction for safe surfing. Coverage on how to safeguard against viruses and SPAM and keep computers free from unwanted visitors is approached in a gentle, user-friendly manner so anyone can apply the techniques and be free from troublesome intrusions. Full-color screen shots and numbered, step-by-step instructions guide readers through the intricacies of navigating the web in a friendly, approachable way. The updated design features a more sophisticated look and larger fonts and images to make this a perfect reference for all ages.

With a sense of humor and a conversational writing style, this book/CD- ROM package shows how to build, host, and track a website. The first section, 'Building a Website with Your Bare Hands,' explains basics of getting the site up and running, and covers more advanced topics such as news feeds, chat rooms, and forums. Part II explains details of site design, and Part III shows how to check for errors, publish the site to the web, run a web server, and bring traffic to the site. Part IV explains how to automate the site with JavaScripts. The final section tells how to get started as a professional web designer, how to make money from the site with ads and links, and how to set up an online store within the site. A glossary of Internet, web, and HTML terms is included. The CD-ROM contains Cascading Style Sheets, HTML tags, JavaScripts, examples, and sample website templates. McFedries has written other books on computing. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com)

Gran parte degli utenti di Excel conosce e utilizza in modo veramente parziale le funzionalità del programma, in particolare quelle che riguardano le formule e le funzioni che (anche a chi non è proprio alle prime armi) appaiono oscure e complesse, a cavallo tra matematica e finanza. Questo volume risponde alle esigenze di quanti quotidianamente si trovano a dover costruire, utilizzare e leggere le formule e le funzioni in un foglio di calcolo. Il testo è rivolto a uomini d'affari, decisori d'azienda, manager, personale amministrativo, forze vendita e commerciali che debbano realizzare fogli di calcolo in Excel come parte della propria professione e ai quali sia necessario imparare a usare modelli avanzati per il calcolo economico e finanziario. Oltre ad affrontare in dettaglio funzionalità di calcolo di livello intermedio e avanzato, il testo consente di risolvere problemi attraverso le funzioni, validare dati nei fogli di calcolo, eseguire analisi, preparare un modello, calcolare tendenze e forecast, analizzare dati e costruire modelli dinamici. A completare la trattazione vengono resi disponibili casi d'uso reali, tutorial semplici e numerosi esempi pratici specificatamente pensati per gli utenti aziendali.

Your Guide to Easy and Secure Windows Vista Networking is a complete beginner's guide to creating, configuring, administering, and using a small network using Windows Vista computers. Inside you'll find comprehensive coverage of networking hardware, including Ethernet (wired) hardware (from NICs to cables to switches to routers) and wireless Hardware--from wireless NICs to access points to range extenders.

 

We include handy “buyer's guides” that tell you how to make smart choices when purchasing network hardware. With hardware in hand, we then show you how to roll up your shirtsleeves and put everything together, including configuring a router, laying cable, and connecting the devices. Next, we then show you how to wrangle with Windows Vista's networking features. These techniques include using the Network and Sharing Center, managing wired and wireless connections, accessing shared network resources, sharing local resources on the network, and working with network files offline. And if you are a music and video aficionado, we've got you covered with a special chapter that shows you just how to set up a networked Vista PC as your digital media hub!

 

No networking book would be complete without extensive coverage of security issues that affect anyone connected to the Internet. We show you how to secure each computer, secure your global networking settings, and batten down your wireless connections. The last part of the book includes intermediate networking tasks such as

making remote connections, monitoring the network, troubleshooting network problems, and setting up Vista's built-in web server and FTP server.

 

•    No longer is networking a topic that only geeks need to understand.

If you have even one computer on the Internet or if you use wireless

in your home or office, you need this book!

•    Extensive hardware coverage that shows you what equipment to

buy and how to set it up!

•    Easy to follow buyer's guides that enable anyone to make smart

and informed choices when purchasing networking hardware.

•    Complete and comprehensive coverage of Windows Vista's

networking features.

•    Thwart hackers, crackers, thieves and other Internet malefactors

by following our easy to understand chapters on security!

•    Loaded with tips, tricks, and shortcuts to make networking easier

and more secure.

•    Chock full of real-world examples and network configurations that

you can put to work today!

• Readers get more bang for their buck! At just $12.99, this easy-to-use, full-color guide provides secrets, tips, and techniques to becoming efficient with Word, Excel, Access, Outlook, and PowerPoint
• Offers straightforward task descriptions and full-color screen shots with step-by-step instructions that show how to increase productivity with Office 2007
• Helps readers to get down to work and get more done in less time
• Addresses new Office 2007 features, including how to improve database productivity in Access, create dynamic PowerPoint presentations, and use new tools for image editing and research

A practical handbook for visual learners offers quick and easy answers to frequently asked technology questions, while presenting dozens of useful tips, tricks, tools, and techniques to help them get the most from the Windows Vista operating system, along with step-by-step instructions and explanations of Vista's new navigation and folder system, changes to the Windows interface, new features, and more. Original. (All Users)

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key techniques for creating PivotTables and PivotCharts, including:
* Building a basic PivotTable? report
* Pivoting fields to different areas
* Filtering PivotTable data
* Organizing PivotTable data into groups
* Formatting a PivotTable
* Changing the summary calculation
* Creating custom calculations
* Publishing a PivotTable to the Web
* Creating a PivotChart? from a PivotTable
* Building a PivotTable from external data


'I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss.'
--Rob L. Meerscheidt (The Woodlands, TX)
* High-resolution screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules
* 'Apply It' and 'Extra' sidebars highlight useful tips