The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time. 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.
Microsoft Office is the most widely used productivity software in the world, but most people just know the basics. This helpful guide gets you started with the programs in Office 2013, and provides lots of power-user tips and tricks when you’re ready for more. You’ll learn about Office’s new templates and themes, touchscreen features, and other advances, including Excel’s Quick Analysis tool. The important stuff you need to know: Create professional-looking documents. Use Word to craft reports, newsletters, and brochures for the Web and desktop. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Work faster with Excel. Determine the best way to present your data with the new Quick Analysis tool. Make inspiring presentations. Build PowerPoint slideshows with video and audio clips, charts and graphs, and animations. Share your Access database. Design a custom database and let other people view it in their web browsers. Get to know the whole suite. Use other handy Office tools: Publisher, OneNote, and a full range of Office Web Apps. Create and share documents in the cloud. Upload and work with your Office files in Microsoft’s SkyDrive.
Unlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book’s easy step-by-step instructions, you’ll learn how to build and maintain a full-featured database and even turn it into a web app. You also get tips and practices from the pros for good database design—ideal whether you’re using Access for business, school, or at home. The important stuff you need to know Build a database with ease. Organize and update lists, documents, catalogs, and other types of information. Create your own web app. Let your whole team work on a database in the cloud. Share your database on a network. Link your Access database to SQL Server or SharePoint. Customize the interface. Make data entry a breeze by building your own templates Find what you need fast. Search, sort, and summarize huge amounts of data in minutes. Put your info to use. Turn raw info into well-formatted printed reports. Dive into Access programming. Automate complex tasks and solve common challenges.
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. Navigate with ease. Master Excel's tabbed toolbar and its new backstage view Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more Organize your data. Search, sort, and filter huge amounts of information Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Author: J. D. Roth
Publisher: "O'Reilly Media, Inc."
Release Date: 2010-03-11
Genre: Business & Economics
Guides readers with practical advice for getting -- and keeping -- their finances in order, covering all the money-management bases, from saving and spending to getting out of debt to investing, and planning for retirement.
A guide to the project management tool covers such topics as estimating work time, setting up a project schedule, building a team, setting up a budget, tracking progress, evaluating performance, and reporting on projects.
Get up to speed on Microsoft Project 2013 and learn how to manage projects large and small. This crystal-clear book not only guides you step-by-step through Project 2013’s new features, it also gives you real-world guidance: how to prep a project before touching your PC, and which Project tools will keep you on target. With this Missing Manual, you’ll go from project manager to Project master. The important stuff you need to know Learn Project 2013 inside out. Get hands-on instructions for the Standard and Professional editions. Start with a project management primer. Discover what it takes to handle a project successfully. Build and refine your plan. Put together your team, schedule, and budget. Achieve the results you want. Build realistic schedules with Project, and learn how to keep costs under control. Track your progress. Measure your performance, make course corrections, and manage changes. Create attractive reports. Communicate clearly to stakeholders and team members using charts, tables, and dashboards. Use Project’s power tools. Customize Project’s features and views, and transfer info via the cloud, using Microsoft SkyDrive.
Author: Bill Jelen
Publisher: Que Publishing
Release Date: 2013-01-08
Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets Get more productive with Excel 2013’s new Start Screen and Timelines Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens Quickly apply attractive, consistent formats Master every function you’ll ever need,- including powerful new web services functions Solve real-world business intelligence analysis problems Create amazing PowerPivot data mashups that integrate information from anywhere Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations Share workbooks on the Web and social networks Leverage the improved Excel Web App to create highly interactive web pages and online surveys Automate repetitive functions using Excel macros Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!
Author: Joe Habraken
Publisher: Que Publishing
Release Date: 2013-03-23
Both an unparalleled reference and an exceptionally practical deskside resource, Office 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for Office 2013 users who wants to maximize their productivity. ¿ Renowned Office 2013 expert and college instructor Joe Habraken delivers specific, proven solutions through a task-based approach that introduces features within the context of how they are used in the real world. Throughout, Habraken illuminates the most valuable new features in Word, Excel, PowerPoint, Outlook, and Publisher. ¿ Straightforward and conversational, Office 2013 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Packed with insights, techniques, tips, and shortcuts, it’s all you need to master all these programs: Word 2013, Excel 2013, PowerPoint 2013, Outlook 2013, Publisher 2013, and OneNote 2013! ¿
Showcases the word processing, graphics, database, Web design, spreadsheet, and slide-show capabilities of AppleWorks 6, including the new interface, macros, templates, document exchange, and troubleshooting.
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks. What you’ll learn The secrets of the Excel for Mac interface! How to create effective workbooks and templates How to quickly format worksheets How to perform custom calculations and formulas What kind of creative and persuasive charts How to illustrate your worksheets with SmartArt, pictures, and more What business problem solving can be done with Excel How to analyze data with pivot tables How to automate tasks with Visual Basic for Applications (VBA) Who this book is for Beginning and intermediate users looking to get up to speed quickly with the Excel 2011 application and use it productively, both online and offline. Table of Contents Learning the Secrets of the Excel:Mac Interface Configuring Excel:Mac to Suit the Way You Work Creating Effective Workbooks and Templates Formatting Your Worksheets Quickly and Efficiently Performing Custom Calculations with Formulas Using Excel’s Built-In Functions Creating Clear and Persuasive Charts Using Data Bars, Color Scales, Icon Sets, and Sparklines Illustrating Your Worksheets with SmartArt, Pictures, and More Creating Databases Using Tables Solving Business Questions with What-If Analysis, Goal Seek, and Solver Analyzing Data with PivotTables Collaborating and Sharing with Macs and Windows Automating Tasks with Macros and VBA
Among its many amazing applications, Google now has web-based alternatives to many of the applications in Microsoft Office. This comprehensive and easy-to-follow new book enables you to explore Google's new office applications in detail. Once you do, you'll be in good company -- more than 100,000 small businesses and some corporations are already looking to take advantage of these free Google offerings. Google Apps: The Missing Manual teaches you how to use three relatively new applications from Google: "Docs and Spreadsheets", which provide many of the same core tools that you find in Word and Excel; and Google Calendar and Gmail, the applications that offer an alternative to Outlook. This book demonstrates how these applications together can ease your ability to collaborate with others, and allow you access to your documents, mail and appointments from any computer at any location. Of course, as remarkable as these applications are, Google's office suite is definitely a work-in-progress. Navigating what you can and can't do and -- more importantly -- understanding how to do it isn't always easy. And good luck finding enough help online. Google Apps: The Missing Manual is the one book you need to get the most out of this increasingly useful part of the Google empire. This book: Explains how to create, save and share each of Google's web-based office applications Offers separate sections for Docs and Spreadsheets, Google Calendar, and Gmail Demonstrates how to use these applications in conjunction with one another Gives you crystal-clear and jargon-free explanations that will satisfy users of all technical levels Many of you already use Gmail, but do you know its full potential? Do you know how you can increase its power by using Gmail with Doc and Spreadsheets and Google Calendar? You'll find out with Google Apps: The Missing Manual. You'll also come to understand why large corporations such as General Electric and Proctor & Gamble are taking a long, hard look at these applications.
The Official Intuit Guide to QuickBooks 2013 for Windows Your bookkeeping workflow will be smoother and faster with QuickBooks 2013 for Windows, and as the program's Official Guide, this Missing Manual puts you firmly in control. You get step-by-step instructions on how and when to use specific features, along with basic accounting advice to guide you through the learning process. The important stuff you need to know: Get started. Set up your accounts, customers, jobs, and invoice items quickly. Follow the money. Track everything from billable time and expenses to income and profit. Keep your company financially fit. Examine budgets and actual spending, income, inventory, assets, and liabilities. Spend less time on bookkeeping. Use QuickBooks to create and reuse bills, invoices, sales receipts, and timesheets. Find key info fast. Rely on QuickBooks’ Search and Find features, as well as the Vendor, Customer, Inventory, and Employee Centers. Exchange data with other programs. Move data between QuickBooks, Microsoft Office, and other programs.
Author: John Walkenbach
Publisher: John Wiley & Sons
Release Date: 2013-02-05
Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!
Author: John Walkenbach
Publisher: John Wiley & Sons
Release Date: 2013-05-06
The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.