Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449394191

Category: Computers

Page: 898

View: 6339

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
Read More

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449394175

Category: Computers

Page: 834

View: 9903

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.
Read More

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449359515

Category: Computers

Page: 1020

View: 8699

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.
Read More

The Missing Manual

Author: J. D. Roth

Publisher: "O'Reilly Media, Inc."

ISBN: 0596809409

Category: Business & Economics

Page: 324

View: 1863

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.
Read More

The Missing Manual

Author: Bonnie Biafore

Publisher: "O'Reilly Media, Inc."

ISBN: 0596528361

Category: Business & Economics

Page: 682

View: 924

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.
Read More

Author: Nancy Conner,Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449359434

Category: Computers

Page: 1050

View: 4570

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.
Read More

Author: Tracy Syrstad,Bill Jelen

Publisher: Pearson Education

ISBN: 9780132182300

Category: Computers

Page: 320

View: 4287

Get comfortable with the latest versions of Microsoft Excel, Microsoft Excel Starter, and the Excel Web App. Don’t just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book, you get online access anywhere with a web connection–no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you’ll ever need…where you want, when you want! learn fast, learn easy, using web, video, and audio Show Me video walks through tasks you’ve just got to see–including bonus advanced techniques Tell Me More audio delivers practical insights straight from the experts UNLOCK THE FREE WEB EDITION—To register your USING book, visit quepublishing.com/using.
Read More

Author: Paul McFedries

Publisher: John Wiley & Sons

ISBN: 1118079280

Category: Computers

Page: 256

View: 3616

Get going with Excel 2010 quickly and easily with this Simplified guide Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away. With an easy-to-read design, numbered steps illustrated with full-color screen shots, concise information, and helpful tips, Excel 2010 Simplified makes learning faster and easier than ever before. Excel is the world's leading spreadsheet and data analysis tool; Excel 2010 includes numerous new features, a redesigned interface, a new focus on collaboration and application servers, and much more Its complexity makes Excel a perfect subject for the step-by-step visual instruction in this guide Numbered steps illustrated with full-color screen shots teach dozens of Excel 2010 tasks Covers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much more A quick and easy way to get up to speed on Excel 2010 for both novice users and those upgrading from an earlier version Excel 2010 Simplified tames this complicated application and gives you the skills to start using Excel with confidence.
Read More

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449359485

Category: Computers

Page: 866

View: 6929

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.
Read More

The Missing Manual

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 0596515391

Category: Computers

Page: 400

View: 9607

This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with: Clear explanations Step-by-step instructions Lots of illustrations Larger type Plenty of friendly advice Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate. One thing that hasn't improved is Microsoft's documentation. Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Read More

Author: Bill Jelen

Publisher: Que Publishing

ISBN: 0133259323

Category: Computers

Page: 1248

View: 832

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!
Read More

Author: Bonnie Biafore

Publisher: "O'Reilly Media, Inc."

ISBN: 144935792X

Category: Computers

Page: 808

View: 5358

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.
Read More

Author: Nancy Conner,Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449395919

Category: Computers

Page: 956

View: 2171

Microsoft Office is the most widely used software suite in the world. The half-dozen programs in Office 2010 are packed with amazing features, but most people just know the basics. This entertaining guide not only gets you started with Office, it reveals all kinds of useful things you didn't know the software could do -- with plenty of power-user tips and tricks when you're ready for more. Create professional-looking documents. Learn everything you need to know to craft beautiful Word documents. Stay organized. Keep track of your email, calendar, and contacts with Outlook. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and more. Build Access databases quickly. Make your data easy to find, sort, and manage. Manage your files more efficiently. Use the new Backstage view to quickly work with your Office files. Get to know the whole suite. Learn to use other handy Office tools: Publisher, OneNote, and Office Web Apps.
Read More

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 0764568329

Category: Computers

Page: 1080

View: 9973

"Today, no accomplished Excel programmer can afford to be without John's book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA." --Loren Abdulezer, Author of Excel Best Practices for Business Everything you need to know about: * Creating stellar UserForms and custom dialog box alternatives * Working with VBA subprocedures and function procedures * Incorporating event-handling and interactions with other applications * Building user-friendly toolbars, menus, and help systems * Manipulating files and Visual Basic components * Understanding class modules * Managing compatibility issues Feel the power of VBA and Excel No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away. CD-ROM Includes * Trial version of the author's award-winning Power Utility Pak * Over one hundred example Excel workbooks from the book System Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements.
Read More

The Official Intuit Guide to QuickBooks 2015

Author: Bonnie Biafore

Publisher: "O'Reilly Media, Inc."

ISBN: 149194871X

Category:

Page: 802

View: 806

How can you make your bookkeeping workflow smoother and faster? Simple. With this Missing Manual, 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. You’ll soon see why this book is the Official Intuit Guide to QuickBooks 2015. 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 new 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.
Read More

Author: Craig Stinson,Mark Dodge

Publisher: Pearson Education

ISBN: 0735652376

Category: Computers

Page: 1152

View: 5617

You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery! Learn expert techniques for designing powerful spreadsheets Apply built-in functions-or write your own-and carry out complex calculations Use rich charting and graphic capabilities to visualize data Perform sophisticated data analysis: financial, statistical, and "what-if" Design PivotTable reports to dynamically analyze data Share and collaborate with others-while managing sensitive data Link and embed Excel data into other documents Create macros with Microsoft Visual Basic for Applications Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support
Read More

Author: Chris Grover

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449302719

Category: Computers

Page: 816

View: 9857

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.
Read More

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 9780470634769

Category: Computers

Page: 1056

View: 2398

A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010. An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won’t find anywhere else. Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel Delivers essential coverage of all the newest features of Excel 2010 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak Excel 2010 Bible serves as an excellent resource on all things Excel! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Read More

Author: Curtis Frye

Publisher: Pearson Education

ISBN: 0735672687

Category: Computers

Page: 368

View: 8619

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here’s WHAT You’ll Learn Manage your data quickly and efficiently Filter, sort, summarize, and crunch your numbers Use formulas and functions to do the heavy lifting Bring data to life with charts and graphics Share data between Microsoft Office documents Work as a team, online and in the cloud Here’s HOW You’ll Learn It Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! exercises to apply what you learn right away
Read More

The Missing Manual

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 0596008422

Category: Computers

Page: 548

View: 3419

Provides information on creating a Web site, covering such topics as HTML, style sheets, frames, graphics, attracting visitors, JavaScript, and blogs.
Read More