Excel 2013: The Missing Manual


Author: Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1449359523
Category: Computers
Page: 1020
View: 1668
DOWNLOAD NOW »
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.

Access 2013: The Missing Manual


Author: Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1449359485
Category: Computers
Page: 866
View: 2782
DOWNLOAD NOW »
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.

Office 2013: The Missing Manual


Author: Nancy Conner,Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1449359434
Category: Computers
Page: 1050
View: 3603
DOWNLOAD NOW »
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.

Excel 2010: The Missing Manual


Author: Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1449394191
Category: Computers
Page: 898
View: 3828
DOWNLOAD NOW »
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

Your Money

The Missing Manual
Author: J. D. Roth
Publisher: "O'Reilly Media, Inc."
ISBN: 0596809409
Category: Business & Economics
Page: 324
View: 3674
DOWNLOAD NOW »
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.

Microsoft Project 2013: The Missing Manual


Author: Bonnie Biafore
Publisher: "O'Reilly Media, Inc."
ISBN: 144935792X
Category: Computers
Page: 808
View: 8180
DOWNLOAD NOW »
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.

Office 2013 In Depth


Author: Joe Habraken
Publisher: Que Publishing
ISBN: 0133260879
Category: Computers
Page: 1032
View: 5065
DOWNLOAD NOW »
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! ¿

Learn Excel 2011 for Mac


Author: Guy Hart-Davis
Publisher: Apress
ISBN: 1430235217
Category: Computers
Page: 488
View: 8155
DOWNLOAD NOW »
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

Excel 2016 In Depth (includes Content Update Program)


Author: Bill Jelen
Publisher: Que Publishing
ISBN: 0134386884
Category: Computers
Page: 656
View: 5569
DOWNLOAD NOW »
Excel 2016 In Depth Full Color: Figures and code appear as they do in Excel 2016 Beyond the Basics…Beneath the Surface...In Depth Do more in less time! Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning. Excel 2016 In Depth is the fastest, smartest way to master Excel 2016’s full power and updated interface. You’ll discover how to leverage Excel’s new tools for charting, business analysis, data visualization, forecasting, and more. • Quickly clean your data with Excel 2016’s powerful Get & Transform tools • Discover Excel 2016’s newest charts: waterfall, histogram, Pareto, sunburst, TreeMap, and Box and Whisker • Use Forecast Sheets to forecast the future, including seasonal adjustments • Pivot data on maps with 3D Maps, and animate your maps over time • Create formulas, charts, subtotals, and pivot tables faster than ever • Create amazing PowerPivot data mashups that integrate information from anywhere • Automate repetitive functions using Excel macros • Solve real-world business intelligence analysis problems • Use PowerPivot Data Model to create pivot tables from multiple data sets without VLOOKUP • Share workbooks on the Web and social networks • Leverage Excel to create highly interactive web pages and online surveys • Quickly apply attractive, consistent formats This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.

Excel 2013 In Depth


Author: Bill Jelen
Publisher: Que Publishing
ISBN: 0133259323
Category: Computers
Page: 1248
View: 4642
DOWNLOAD NOW »
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!

Google SketchUp: The Missing Manual

The Missing Manual
Author: Chris Grover
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596555764
Category: Computers
Page: 602
View: 722
DOWNLOAD NOW »
If you want to learn to create 3-D models using Google SketchUp, this Missing Manual is the ideal place to start. Filled with step-by-step tutorials, this entertaining, reader-friendly guide will have you creating detailed 3-D objects, including building plans, furniture, landscaping plans -- even characters for computer games -- in no time. Google SketchUp: The Missing Manual offers a hands-on tour of the program, with crystal-clear instructions for using every feature and lots of real-world examples to help you pick up the practical skills you need. Learn to use the basic tools, build and animate models, and place your objects in Google Earth. With this book, you will: Learn your way around the SketchUp workspace, and explore the differences between working in 2-D and 3-D Build simple 3-D shapes, save them as reusable components, and use SketchUp's Outliner to show or hide them as you work Tackle a complicated model building with lots of detail, and discover timesaving tools for using many components Animate the model by creating an interior walkthrough of your building Dress up your model with realistic material shading and shadows, and place it in Google Earth It's easy to get started. Just download the program from Google.com, and follow the instructions in this book. You'll become a SketchUp master in a jiffy.

Microsoft Project 2007

The Missing Manual
Author: Bonnie Biafore
Publisher: "O'Reilly Media, Inc."
ISBN: 0596528361
Category: Business & Economics
Page: 682
View: 5510
DOWNLOAD NOW »
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.

Access 2010: The Missing Manual


Author: Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1449394175
Category: Computers
Page: 834
View: 5231
DOWNLOAD NOW »
Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book’s easy step-by-step process, you’ll quickly learn how to build and maintain a complete Access database, using Access 2013’s new, simpler user interface and templates. You also get practices and tips from the pros for good database design—ideal whether you’re using Access for school, business, or at home. The important stuff you need to know: Build a database with ease. Store information to track numbers, products, documents, and more. Customize the interface. Build your own forms to make data entry a snap. Find what you need fast. Search, sort, and summarize huge amounts of information. Put your data to use. Turn raw info into printed reports with attractive formatting. Share your data. Collaborate online with SharePoint and the Access web database. Dive into Access programming. Get tricks and techniques to automate common tasks. Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.

Excel Hacks

Tips & Tools for Streamlining Your Spreadsheets
Author: David Hawley,Raina Hawley
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596555283
Category: Computers
Page: 412
View: 6812
DOWNLOAD NOW »
Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to: Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption. Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform. Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet. Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them. Create customized charts -- tweak and combine Excel's built-in charting capabilities. Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time. Make the most of macros -- including ways to manage them and use them to extend other features. Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook. You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Windows 8.1: The Missing Manual


Author: David Pogue
Publisher: "O'Reilly Media, Inc."
ISBN: 1449371817
Category: Computers
Page: 950
View: 3096
DOWNLOAD NOW »
Windows 8.1 continues the evolution of the most radical redesign in Microsoft’s history. It combines the familiar Windows desktop with a new, touchscreen-friendly world of tiles and full-screen apps. Luckily, David Pogue is back to help you make sense of it—with humor, authority, and 500 illustrations. The important stuff you need to know: What’s new in 8.1. The update to 8.1 offers new apps, a universal Search, the return of the Start menu, and several zillion other nips and tucks. New features. Storage Spaces, Windows To Go, File Histories—if Microsoft wrote it, this book covers it. Security. Protect your PC from viruses, spyware, spam, sick hard drives, and out-of-control kids. The network. HomeGroups, connecting from the road, mail, Web, music streaming among PCs—this book has your network covered. The software. Media Center, Photo Gallery, Internet Explorer, speech recognition—this one authoritative, witty guide makes it all crystal clear. It’s the book that should have been in the box.

The R Book


Author: Michael J. Crawley
Publisher: John Wiley & Sons
ISBN: 1118448960
Category: Mathematics
Page: 1080
View: 7074
DOWNLOAD NOW »
Hugely successful and popular text presenting an extensive and comprehensive guide for all R users The R language is recognized as one of the most powerful and flexible statistical software packages, enabling users to apply many statistical techniques that would be impossible without such software to help implement such large data sets. R has become an essential tool for understanding and carrying out research. This edition: Features full colour text and extensive graphics throughout. Introduces a clear structure with numbered section headings to help readers locate information more efficiently. Looks at the evolution of R over the past five years. Features a new chapter on Bayesian Analysis and Meta-Analysis. Presents a fully revised and updated bibliography and reference section. Is supported by an accompanying website allowing examples from the text to be run by the user. Praise for the first edition: ‘…if you are an R user or wannabe R user, this text is the one that should be on your shelf. The breadth of topics covered is unsurpassed when it comes to texts on data analysis in R.’ (The American Statistician, August 2008) ‘The High-level software language of R is setting standards in quantitative analysis. And now anybody can get to grips with it thanks to The R Book…’ (Professional Pensions, July 2007)

QuickBooks 2016: The Missing Manual

The Official Intuit Guide to QuickBooks 2016
Author: Bonnie Biafore
Publisher: "O'Reilly Media, Inc."
ISBN: 1491935626
Category: BUSINESS & ECONOMICS
Page: 822
View: 6374
DOWNLOAD NOW »
How can you make your bookkeeping workflow smoother and faster? Simple. With QuickBooks 2016: The Missing Manual (which covers the Windows version of QuickBooks), you’re in control: you get step-by-step instructions on how and when to use specific features, along with basic bookkeeping and accounting advice to guide you through the learning process. Discover new and improved features like the Insights dashboard and easy report commenting. The important stuff you need to know: Get started fast. Quickly set up accounts, customers, jobs, and invoice items. Follow the money. Track everything from billable and unbillable time and expenses to income and profit. Keep your company financially fit. Examine budgets and actual spending, income, inventory, assets, and liabilities. Gain insights. Open a dashboard that highlights your company’s financial activity and status the moment you log in. Spend less time on bookkeeping. Create and reuse bills, invoices, sales receipts, and timesheets. Find key info. Use QuickBooks’ Search and Find features, as well as the Vendor, Customer, Inventory, and Employee Centers.

QuickBooks 2014: The Missing Manual

The Official Intuit Guide to QuickBooks 2014
Author: Bonnie Biafore
Publisher: "O'Reilly Media, Inc."
ISBN: 1449341713
Category: Computers
Page: 810
View: 5790
DOWNLOAD NOW »
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.

Creating a Website: The Missing Manual


Author: Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1491936177
Category: Computers
Page: 622
View: 1381
DOWNLOAD NOW »
You can easily create a professional-looking website with nothing more than an ordinary computer and some raw ambition. Want to build a blog, sell products, create forums, or promote an event? No problem! This friendly, jargon-free book gives you the techniques, tools, and advice you need to build a site and get it up on the Web. The important stuff you need to know: Master the basics. Learn HTML5, the language of the Web. Design good-looking pages. Use styles to build polished layouts. Get it online. Find a reliable web host and pick a good web address. Use time-saving tools. Learn free tools for creating web pages and tracking your visitors. Attract visitors. Make sure people can find your site through popular search engines like Google. Build a community. Encourage repeat visits with social media. Bring in the cash. Host Google ads, sell Amazon’s wares, or push your own products that people can buy via PayPal. Add pizzazz. Include audio, video, interactive menus, and a pinch of JavaScript.

Office 2011 for Macintosh: The Missing Manual


Author: Chris Grover
Publisher: "O'Reilly Media, Inc."
ISBN: 9781449302719
Category: Computers
Page: 816
View: 9670
DOWNLOAD NOW »
Office 2011 for Mac is easy to use, but to unleash its full power, you need to go beyond the basics. This entertaining guide not only gets you started with Word, Excel, PowerPoint, and the new Outlook for Mac, it also reveals useful lots of things you didn't know the software could do. Get crystal-clear explanations on the features you use most -- and plenty of power-user tips when you're ready for more. Take advantage of new tools. Navigate with the Ribbon, use SmartArt graphics, and work online with Office Web Apps. Create professional-looking documents. Use Word to craft beautiful reports, newsletters, brochures, and posters. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and other features. Use the programs together. Discover how to be more productive and creative by drawing directly in Word documents, adding spreadsheets to your slides, and more.