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.
Offering an updated overview of the latest version of the spreadsheet program, a 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.
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.
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.
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.
How can you make your bookkeeping workflow smoother and faster? Simple. With this Missing Manual, you’re in control of QuickBooks 2014 for Windows. 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. That’s why this book is the Official Intuit Guide to QuickBooks 2014. The important stuff you need to know: Get started. Quickly set up your accounts, customers, jobs, and invoice items. Learn new features. Get up to speed on the Bank Feed Center, Income Tracker, and other improvements. Follow the money. Track everything from billable time and expenses to income and profit. Spend less time on bookkeeping. Use QuickBooks to create and reuse bills, invoices, sales receipts, and timesheets. Keep your company financially fit. Examine budgets and actual spending, income, inventory, assets, and liabilities. Find key info fast. Rely on QuickBooks’ Search and Find features, as well as the Vendor, Customer, Inventory, and Employee Centers.
Galaxy S4 is amazing right out of the box, but if you want to get the most of out your S4 or S4 Mini, start here. With clear instructions and savvy advice from technology expert Preston Gralla, you’ll learn how to go online, play games, listen to music, watch movies & TV, monitor your health, and answer calls with a wave of your hand. The important stuff you need to know: Be connected. Browse the Web, manage email, and download apps through WiFi or S4’s 3G/4G network. Navigate without touch. Use Air Gestures with your hand, or scroll with your eyes using Smart Screen. Find new ways to link up. Chat, videochat, and add photos, video, or entire slideshows to text messages. Get together with Group Play. Play games or share pictures, documents, and music with others nearby. Create amazing images. Shoot and edit photos and videos—and combine images from the front and back cameras. Keep music in the cloud. Use Google Play Music to store and access tunes. Check your schedule. Sync the S4 with your Google and Outlook calendars.
Amazon’s Kindle Fire HD combines the most popular e-reader and tablet features in one sleek package, and with this entertaining guide, you’ll master everything the Fire has to offer. With loads of illustrations, step-by-step instructions, and savvy tips, you’ll learn how to manage your media library in the cloud, find the coolest apps, and make the most of your Kindle Fire experience—no matter which model you choose. The important stuff you need to know: Read all about it. Find ebooks and newspapers in the Kindle Store, and add your own books and magazines. Use great new features. Discover Amazon’s X-Ray service, and parental controls for individual users. Take in a show. Watch movies and TV series, and display your photos and videos. Go online. Browse the Web and manage email with Wi-Fi and 4D LTE. Fill up your jukebox. Listen to your favorite music from Amazon and iTunes. Load up on apps. Get popular games, guides, and references with Amazon’s Apps for Android. Get to work. Read PDFs, Word files, Excel spreadsheets, and other docs.
Get the most out of Excel 2013 with this exceptional advicefrom Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to trulyexcel at Excel! In this latest addition to his popular Mr.Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr.Spreadsheet," shares new and exciting ways to accomplish and masterall of your spreadsheet tasks. From taming the Ribbon bar totesting and tables, creating custom functions, and overcoming"impossible" charts, mixing nesting limits, and more, 101 Excel2013 Tips, Tricks, & Timesavers will save you time and helpyou avoid common spreadsheet stumbling blocks. Reveals ways to maximize the power of Excel to create robustapplications Draws on John Walkenbach's years of experience using Excel andwriting more than 50 books Shares tips and tricks for dealing with function arguments,creating add-ins, using UserForms, working with dynamic chart data,and changing data entry orientation Provides shortcuts and helpful techniques for sorting more thanthree columns, entering fake data for testing purposes, and settingup powerful pivot tables 101 Excel 2013 Tips, Tricks, & Timesavers is packedwith information that you need to know in order to confidently andseamlessly master the challenges that come with using Excel!
Introduce your students to the latest that Microsoft Office has to offer with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Microsoft Office 2013, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In this text you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of Microsoft Office 2013 software through experimentation, critical thought, and personalization. With these enhancements and more, the Shelly Cashman Series continues to deliver the most effective educational materials for you and your students. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.