Author: Curtis Frye

Publisher: Pearson Education

ISBN: 0735672687

Category: Computers

Page: 368

View: 931

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

Author: Curtis Frye

Publisher: N.A

ISBN: 9780735672437

Category: Computers

Page: 351

View: 8489

Offers a step-by-step guide on how to navigate the latest version of Excel and explains how to build and format spreadsheets, filter and sort data, add graphics to spreadsheets, publish documents to the Web, and work with PivotTables.
Read More

Author: Jay Freedman

Publisher: Microsoft Press

ISBN: 0735672938

Category: Computers

Page: 272

View: 9837

Get the full-color, visual guide that makes learning Microsoft Word 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to create and share documents. Here’s WHAT you’ll learn: Create, edit, format, and share text Add graphics, data, table, and charts Improve page layout to best present your ideas Use and make templates for increased productivity Collaborate and present documents online Access your documents from almost any browser 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

Author: Peter Weverka

Publisher: Microsoft Press

ISBN: 0735665281

Category: Computers

Page: 256

View: 6791

Get the guide that makes learning Microsoft OneNote 2010 plain and simple! This full-color, no-nonsense book shows you the quickest ways to take, organize, and share great notes—with easy-to-follow steps, screenshots, and concise, straightforward language. Here's WHAT you'll learn: Take notes and organize them with ease Arrange notes in pages, sections, and notebooks Add pictures, drawings, and audio and video clips Apply readymade and custom tags to your notes Link notes to web pages and Microsoft Office files Share your notes and collaborate with others Here’s HOW you’ll learn it: Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Read More

Author: Jim Boyce

Publisher: "O'Reilly Media, Inc."

ISBN: 0735649243

Category: Computers

Page: 288

View: 9676

Get the guide that makes learning Microsoft Outlook 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to manage your email and schedule appointments, using easy-to-follow steps and concise, straightforward language. You'll learn how to stay productive and in touch with all of your personal and business networks. Here's WHAT you'll learn: Send and receive messages, files, and photos Set up e-mail filters to weed out the junk Manage your contacts and stay in touch Keep track of your calendar and manage your tasks Read RSS feeds right from your inbox Jot down e-notes and keep a journal Here's HOW you'll learn it: Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Read More

Author: Katherine Murray

Publisher: Microsoft Press

ISBN: 0735672121

Category: Computers

Page: 472

View: 3325

Learn the simplest ways to get things done with Microsoft Office 2013 Get the full-color, visual guide that makes learning Microsoft Office 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote. Here’s WHAT you’ll learn: Navigate with mouse, keyboard, or touch Create documents, reports, databases, and presentations Share your desktop, worksheets, and files Manage your email and organize your calendar Stay connected with online meetings and instant messaging Access your programs and your documents via 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

Author: Peter Weverka

Publisher: Pearson Education

ISBN: 0735672768

Category: Computers

Page: 288

View: 5746

Get the full-color, visual guide that makes learning Microsoft OneNote 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to organize information and manage your work and personal lives. Here’s WHAT you’ll learn: Take notes, organize, and share them Bookmark and tag notes for easier searching Add pictures, drawings, and spreadsheets Handwrite notes and convert them to text Record audio and video notes Access notes from the web or mobile device 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

Author: Katherine Murray

Publisher: Pearson Education

ISBN: 0735649197

Category: Computers

Page: 384

View: 4831

Get the fast facts that make learning Office 2010 plain and simple! This colorful, no-nonsense guide uses easy-to-follow steps and screenshots, and clear, concise language to show the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote. Here's WHAT You'll Learn Create documents, Web pages, and other publications Organize your e-mail, calendar, contacts and tasks Build spreadsheets to analyze and visualize data Set up a simple database Capture notes with ink, voice or text Here's HOW You'll Learn It Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! Exercises help you apply what you learn right away
Read More

Author: Ben Howard

Publisher: Pearson Education

ISBN: 073567289X

Category: Computers

Page: 240

View: 1723

Get the full-color, visual guide that makes learning Microsoft Project 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to effectively manage all your projects. Here’s WHAT you’ll learn: Develop a project plan and schedule resources Pull together your team and plan their assignments Understand dependencies and mitigate risks Stay on top of progress, delays, and costs Make adjustments and updates quickly Communicate with clear, customized reports 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

Author: Nancy Muir Boysen,Michael Miller

Publisher: Microsoft Press

ISBN: 1509306765

Category: Computers

Page: 320

View: 3631

Learn the simplest ways to get things done with Windows 10 Here’s WHAT you’ll learn • Navigate Windows 10 Fall Creators Update quickly, easily, and efficiently • Get online with the sleek Microsoft Edge web browser • Make the most of the Cortana personal assistant • Efficiently manage your email, calendar, photos, and more • Access your files from anywhere with Microsoft OneDrive • Help secure your computer and protect your data Here’s HOW you’ll learn • 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

Building Data Models with PowerPivot

Author: Alberto Ferrari,Marco Russo

Publisher: Pearson Education

ISBN: 0735676348

Category: Computers

Page: 487

View: 1929

Shows readers how to perform complex data analysis, create reports with the data analysis expressions language, and add hierarchies to data models to enable faster browsing.
Read More

Author: Tracy Syrstad

Publisher: Que Publishing

ISBN: 013335394X

Category: Computers

Page: 360

View: 4327

Make the most of Excel 2013–without becoming a technical expert! This book is the fastest way to master Excel…use it to build powerful, trustworthy, easy-to-understand workbooks…discover hidden patterns and make better decisions…visualize data so everyone understands it…share and present workbooks on the web, tablets, anywhere! Even if you’ve never used Excel before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Excel has never, ever been this simple! Who knew how simple Excel 2013 could be? This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Excel 2013 spreadsheet program…simple, reliable instructions for doing everything you really want to do! Here’s a small sample of what you’ll learn: Quickly create, edit, and format workbooks Enter formulas and use functions effectively Enter data more rapidly, easily, consistently, and accurately Master powerful ways to sort, filter, consolidate, or group data Visualize information through great charts, PivotTables, and Sparklines Illustrate workbooks with images, shapes, and SmartArt Explore and analyze data more easily with Excel 2013’s amazing new Power View Share, print, present, and secure your workbooks Store your workbooks online with SkyDrive Work with macros Build immense power into worksheet cells with UDFs
Read More

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449359515

Category: Computers

Page: 1020

View: 8719

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

Author: Michael Price,Mike McGrath

Publisher: In Easy Steps

ISBN: 1840787244

Category: Computers

Page: 192

View: 7465

Excel 2016 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include: Creating, editing and manipulating worksheets Formulas, Functions and Pivot Tables Handy templates to give you a head start Macros for everyday tasks to save time Charts to get an overview of your data Linking workbooks for automatic updates Using the Excel Online app to share and collaborate on spreadsheets and workbooks Adding images and illustrations to your spreadsheet to impress your colleagues! Whether you’re upgrading to Excel 2016 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2016 – in easy steps!
Read More

Author: Katherine Murray

Publisher: Pearson Education

ISBN: 0735652325

Category: Computers

Page: 272

View: 5276

Get the guide that makes learning Microsoft Word 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn new skills, using easy-to-follow steps and concise, straightforward language. You'll create professional-quality documents in no time. Here’s WHAT you'll learn: Create professional-looking documents with ease Organize, edit, and format text Apply themes, styles, and other design elements Work with graphics, tables, and charts Take advantage of pre-built templates, or make your own Edit a document with others simultaneously -- online Here's HOW you’ll learn it: Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Read More

Author: Curtis D. Frye

Publisher: N.A

ISBN: 9780735681019

Category: Computers

Page: 484

View: 4877

Describes the features of the software program, including writing formulas, presenting data visually, linking worksheets, using PivotTables, and collaborating online.
Read More

Author: Bill Jelen

Publisher: Que Publishing

ISBN: 0133259323

Category: Computers

Page: 1248

View: 4780

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: Wayne Winston

Publisher: Microsoft Press

ISBN: 1509304223

Category: Computers

Page: 984

View: 534

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel–and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes’ Theorem Automate repetitive tasks by using macros
Read More

Author: Alberto Ferrari,Marco Russo

Publisher: Microsoft Press

ISBN: 1509302816

Category: Computers

Page: 320

View: 2052

Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data
Read More

Author: Andrew Couch

Publisher: Microsoft Press

ISBN: 0735672644

Category: Computers

Page: 272

View: 3985

Learn the simplest ways to get things done with Microsoft Access 2013 Get the full-color, visual guide that makes learning Microsoft Access 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to build a database and sort information. Here’s WHAT you’ll learn: Build and manage your own database Apply professional designs across your databases Create presentations and publish reports online Secure your database with passwords and encryption Exchange data with other databases and documents Interact with your data easier using macros 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