Items related to Microsoft Excel 2013 Data Analysis with Tables Quick...
Microsoft Excel 2013 Data Analysis with Tables Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
Synopsis
Laminated quick reference guide 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 multiple titles available for Excel 2013: Excel 2013 Introduction (ISBN 978-1936220762); Excel 2013 Functions & Formulas (ISBN 978-1936220779); Excel 2013 Data Analysis with Tables.
"synopsis" may belong to another edition of this title.
About the Author
Beezix Inc. - Publishers of quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for over 15 years. Through working with top trainers and product specialists, we've distilled years' worth of experience into these sleek, durable cheat sheets. Our cards have all the shortcuts, quick tips, and step-by-step instructions for Microsoft® Office products such as Outlook, Excel, PowerPoint, as well as Lotus Notes and many others at your fingertips. Beezix was founded by trainers, and has always had a strong focus on the learner. Extensive industry experience made us aware of the need for a line of high-quality, trainer-produced courseware, and led to the creation of Beezix Quick Reference guides in 1994. Our cards are designed for casual computer users right through to trainers and trouble-shooters.
"About this title" may belong to another edition of this title.
- PublisherBeezix Inc.
- Publication date2013
- ISBN 10 1936220784
- ISBN 13 9781936220786
- BindingPamphlet
- LanguageEnglish
- Number of pages2
- IllustratorBeezix Inc.
- Rating
(No Available Copies)
Search Books: Create a WantCan't find the book you're looking for? We'll keep searching for you. If one of our booksellers adds it to AbeBooks, we'll let you know!
Create a Want