Microsoft Excel 2013 Data Analysis With Tables Quick Reference Guide
Download Microsoft Excel 2013 Data Analysis With Tables Quick Reference Guide PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Microsoft Excel 2013 Data Analysis With Tables Quick Reference Guide book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages.
Microsoft Excel 2013 Data Analysis with Tables Quick Reference Guide
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use tables, PivotTables, sorting and filtering features in Microsoft Office Excel 2013. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: List Range or Table? Excel Tables: Creating an Excel Table, Adding or Deleting a Table Row or Column, Turning On/Off the Total Row, Removing Duplicates, Using Table Specifiers in Formulas, Converting a Table to a List Range, Using a List Range for Sorting, Filtering, Subtotals, and PivotTables. PivotTables: Creating a PivotTable or PivotChart from Worksheet Data, Show/Hide the PivotTable Fields Pane, Adding/Removing a PivotTable Field, Refreshing a PivotTable, Rearranging a PivotTable, Adding a PivotChart to an Existing PivotTable, Changing the Summary Function, Changing How Values are Shown, Sorting and Filtering a PivotTable, Filtering PivotTables with Timelines, Using a PivotTable to Analyze Multiple Data Sources, Adding Excel Workbook Tables to the Data Model, Adding External Data to the Data Model, Defining Relationships Across Multiple Tables, Creating a New PivotTable to Analyze Multiple Data Model Tables, Adding Tables and Fields to an Existing PivotTable, Advanced Data Analysis, Creating a Power View Sheet, Adding a Visualization to Power View. Sorting & Filtering a Table or List Range: Basic Sorting, Complex Sorting, Filtering and Advanced Filtering, Show/Hide AutoFilter, Filtering with AutoFilter. Advanced Filtering: Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting/Ordering Columns, Clearing Filtering and Sorting, Subtotals. This guide is one of several titles available for Excel 2013: Excel 2013 Introduction; Excel 2013 Data Analysis with Tables; Functions & Formulas.
Microsoft® Excel® 2013 QuickSteps
Author: John Cronan
language: en
Publisher: McGraw Hill Professional
Release Date: 2013-03-14
Full-color, step-by-step guide to the new release of the world’s most popular spreadsheet application Get up and running with Excel 2013 right away--the QuickSteps way. Full-color screenshots on every page with clear instructions make it easy to use the latest release of Microsoft's powerful spreadsheet application. Follow along and quickly learn how to create workbooks, enter and edit data, use formulas and functions, create charts and tables, analyze data, extend Excel, and more. This practical, fast-paced guide gets you started in no time! Use these handy guideposts: Shortcuts for accomplishing common tasks Need-to-know facts in concise narrative Helpful reminders or alternate ways of doing things Bonus information related to the topic being covered Errors and pitfalls to avoid The unique, landscape-oriented layout of the QuickSteps series mimics your computer screen, displays graphics and explanations side by side, and lays flat so you can easily refer to the book while working on your computer.
Microsoft Excel 2013 Charts and Sparklines Quick Reference Guide
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use charts/graphs and Sparklines features of Microsoft Office Excel 2013.The following topics are covered:Charts: Inserting a Chart, Inserting a Recommended Chart, Understanding Chart Types, Charting Non-Adjacent Data, Creating a Chart Using the Default Chart Type, Using Chart Buttons, Resizing a Chart in the Worksheet, Selecting Chart Objects, Changing Chart Type, Adding/Removing a Data Series, Adding and Adjusting Axis and Chart TItles, Switching Rows and Columns, Using Tables as a Data Source, Adjusting Scale, Creating a Chart with Two Scales, Adjusting the Legend, Using Gridlines, Adding Explanatory Text, Adding Visuals, Adding and Adjusting Data Labels, Exploding a Piece of a Pie Chart, Using Styles and Layouts, Moving a Chart to Another Worksheet, Adding a Projection or Trendline to a Data Series, Handling Hidden and Empty Cells in a Chart, Changing the Default Chart Type, Creating a Custom Chart Template, Applying a Custom Chart Type.Sparklines: Creating a Sparkline, Grouping Sparklines, Changing Sparkline Type, Removing Sparklines, Customizing Sparklines with Text and Markers, Changing Marker Color, Change Sparklines Color and Weight, Customizing Axis Settings, Handling Hidden and Empty Cells in Sparklines.