› › Using Microsoft Excel 2010 Enhanced Edition

Using Microsoft Excel 2010, Enhanced Edition

Author : Tracy Syrstad

Publisher : Pearson Education

Page : 348 pages

File Size : 19,22 MB

Release : 2011-08-29

Category :

ISBN : 0132918676

Get eBook

Book Description

*** This USING Microsoft Excel 2010 book is enhanced with nearly 2 hours of FREE step-by-step VIDEO TUTORIALS and AUDIO SIDEBARS! *** Microsoft Excel is a requirement for most jobs today. Workers in every office use Excel to track and report information. Excel is an amazingly flexible program with seemingly endless blank canvas of rows and columns, charts, and pivot tables. If you’ve never opened Excel, or if you’ve used Excel only to neatly arrange lists in columns, this book will get you up to speed with the real-life skills needed to survive in a job that requires familiarity with Excel. USING Microsoft Excel 2010 is a media-rich learning experience designed to help new users master Microsoft Excel 2010 quickly, and get the most out of it, fast! EVERY chapter has multiple video and audio files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft Excel 2010 users need to know. You’ll Learn How to: - Understand the Excel Interface - Use the Excel Web App - Format, Sort, Filter and Consolidate Data - Use Formulas and Functions Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Using the Fill handle to Fill in a Series - Creating Sparklines - Recording a Macro Using Relative Referencing Examples of Topics Covered in AUDIO SIDEBARS, which Deliver Insights Straight From the Experts! - Pasting and Delimited Text - Creating Custom Lists - The Importance of Choosing the Right Chart Type Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.



Statistical Analysis

Author : Conrad Carlberg

Publisher : Que Publishing

Page : 714 pages

File Size : 18,4 MB

Release : 2014-04-04

Category : Business & Economics

ISBN : 0133823997

Get eBook

Book Description

Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts



Microsoft Excel 2010 Plain & Simple

Author : Curtis Frye

Publisher : Microsoft Press

Page : 0 pages

File Size : 34,98 MB

Release : 2010

Category : Computers

ISBN : 9780735627277

Get eBook

Book Description

"With this full color, no-nonsense guide, you'll learn the quickest ways to solve a problem or learn a skill with Microsoft Excel 2010. Easy-to-follow steps and concise, straightforward language make learning plain and simple!"--Resource description page.



Microsoft Excel 2010 Inside Out

Author : Craig Stinson

Publisher : Pearson Education

Page : 1711 pages

File Size : 10,61 MB

Release : 2010-08-31

Category : Computers

ISBN : 0735652376

Get eBook

Book Description

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



Using Microsoft Visio 2010, Enhanced Edition

Author : Chris Roth

Publisher : Pearson Education

Page : 476 pages

File Size : 50,55 MB

Release : 2011-10-07

Category : Computers

ISBN : 0132966042

Get eBook

Book Description

*** This USING Microsoft Visio 2010 book is enhanced with over 5 hours of FREE step-by-step VIDEO TUTORIALS and AUDIO SIDEBARS! *** Microsoft Visio 2010 is a versatile application for creating rich and diverse diagrams. With Visio, you can create an astonishing variety of visualizations that span a vast number of subjects, disciplines, and professions. USING Microsoft Visio 2010 is a media-rich learning experience designed to help new users master Microsoft Visio 2010 quickly, and get the most out of it, fast! EVERY chapter has multiple video and audio files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft Visio 2010 users need to know. You’ll Learn How to: - Create a Simple Flowchart and Understand Visio 2010 Editions - Work in the Visio Drawing Window - Navigate the Template Gallery and Work Around the Visio Diagram - Create Specific Types of Diagrams - Organize and Annotate Diagrams - Connect, Align, Arrange, and Lay Out Shapes - Work with Individual Shapes and Data - Print Various Documents, Drawings, and Materials - Share, Publish, and Export Visio Diagrams Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Creating a Simple Visio Flowchart - Quickly Copying Shapes to Create a Matrix - Sharing, Publishing, and Exporting Visio Diagrams Examples of Topics Covered in AUDIO SIDEBARS, which Deliver Insights Straight From the Experts! - When to Use Groups - Unremoved Personal Information Horror Stories - Turning Many Symbols into One Shape Using Shape Data Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.



Excel 2003 Bible

Author : John Walkenbach

Publisher : John Wiley & Sons

Page : 972 pages

File Size : 32,89 MB

Release : 2013-05-06

Category : Computers

ISBN : 0764549790

Get eBook

Book Description

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.



Using Microsoft Access 2010, Enhanced Edition

Author : Alison Balter

Publisher : Pearson Education

Page : 421 pages

File Size : 19,1 MB

Release : 2011-10-07

Category : Computers

ISBN : 0132966018

Get eBook

Book Description

*** This USING Microsoft Access 2010 book is enhanced with 4.5 hours of FREE step-by-step VIDEO TUTORIALS and AUDIO SIDEBARS! *** Microsoft Access 2010 is a relational database perfect for any collection of information that allows you to create tables, queries, forms, reports, macros, and modules for that data. USING Microsoft Access 2010 is a media-rich learning experience designed to help new users master Microsoft Access 2010 quickly, and get the most out of it, fast! EVERY chapter has multiple video and audio files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft Access 2010 users need to know. You’ll Learn How to: - Manipulate Data with Databases and Tables - Use Queries to Retrieve the Data You Need - Use Forms to Enter and Edit Table Data - Use Reports to Print Information - Create Your own Tables and Databases - Relate the Information in Your Database - Enhance the Databases you Build - Build Powerful Forms or Reports - Automate Your Database with Macros - Share Data with other Applications - Work with Web Databases Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Filtering Form Data - Adding Fields to Queries - The Basics of Creating and Running a Macro Examples of Topics Covered in AUDIO SIDEBARS, which Deliver Insights Straight From the Experts! - Updatability of Query Results - Uses for Forms - Building Queries Based on Multiple Tables Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.



PowerPivot for the Data Analyst

Author : Bill Jelen

Publisher : Pearson Education

Page : 329 pages

File Size : 22,55 MB

Release : 2010

Category : Computers

ISBN : 0789743159

Get eBook

Book Description

Discusses the use of Microsoft's free PowerPivot add-in to analyse data in Excel 2010. Describes how to import and integrate data; analyse multiple tables together; format, sort and filter data; add calculated columns using Data Analysis Expression (DAX) functions; and create and format PowerPivot reports.



Pivot Table Data Crunching

Author : Bill Jelen

Publisher : Pearson Education

Page : 581 pages

File Size : 39,76 MB

Release : 2010-10-20

Category : Computers

ISBN : 0789746689

Get eBook

Book Description

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen



Excel Charts

Author : John Walkenbach

Publisher : Wiley

Page : 556 pages

File Size : 50,38 MB

Release : 2002-11-29

Category : Computers

ISBN : 9780764517648

Get eBook

Book Description

* One of the world's best-known Excel experts shows how to master the charting features in Excel 2000 and 2002 to create compelling graphic representations of data * Covers basic and advanced features, focusing on the new charting featuresprovided in version 2002 * Explains how to select charts for different categories of data, modify data in a chart, deal with missing data, format charts, customize shapes, and give charts a professional look