Microsoft Excel 2013 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card
Download Microsoft Excel 2013 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Microsoft Excel 2013 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card 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 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips and Shortcuts - Laminated Card)
Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2013. The following topics are covered: Entering and Editing Data Picking from a Drop-Down List Selecting Cells Resizing Column Width and Row Height Inserting and Deleting Rows, Columns and Cells Clearing Cells, Clearing Formatting Borders, Shading, Text Color Formatting Number Cells Aligning and Merging Cell Contents Entering Dates Entering a Sequence of Numbers Entering Formulas & Functions Entering SUM and Other Functions Quickly Absolute vs. Relative Cell References. Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop. Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets. Editing Multiple Worksheets Simultaneously. Previewing, Printing and Page Setup Scaling to Print Printing a Specific Area Using Page Break Preview to Adjust Page Breaks Repeating Rows/Columns on Every Page. Also includes a list of Touch Actions, Selection and Movement Shortcuts.
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 Word 2013 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips and Shortcuts - Laminated Card)
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Word 2013. The following topics are covered: Margins, Orientation, and Paper Size Moving and Copying Text Formatting Text with the Mini Toolbar & Touch MiniBar Spacing between Paragraphs Creating Bulleted Lists Changing Bullet Style Creating Numbered Lists Turning off Bullets or Numbering Paragraph Alignment Copying Formatting Searching using the Navigation Pane Finding and Replacing Text Jumping to Other Pages Resuming Reading Read Mode, Print Layout, and Draft View Using the Highlighter Using the Dictionary and Thesaurus Creating and Inserting Quick Part Building Blocks Inserting a Cover Page Creating and Editing Headers and Footers; Suppress/Change Header or Footer on the First Page Inserting a Page Number Inserting a Text Box: Drawing a Text Box, Moving, Resizing, Formatting, and Deleting a Text Box Inserting a Page Break Checking Spelling, Grammar, AutoCorrect Previewing and Printing Documents Printing Envelopes and Labels. Also includes: Lists of Touch Actions, Selection and Movement Shortcuts, Editing and Formatting Shortcuts.