Microsoft Word 2010 Formatting Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 9781936220205
Format: PDF, Docs
Download Now
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use formatting features of Microsoft Office Word 2010 at the intermediate level. The following topics are covered: Displaying the Ruler, Changing the Default Font, Settings Tabs, Moving Tab Positions, Removing a Tab Marker, Clearing All Tab Markers from the Ruler, Tab Tips, Setting Tabs with Leaders, Disabling Automatic Formatting, The Indent Markers, Changing Indents, Applying Indents Quickly, Creating Bulleted Lists, Changing Bullet Style, Creating Numbered Lists, Turning off Bullets or Numbering, Creating Multilevel Numbered List. Paragraph Breaks vs. Line Breaks, Changing Paragraph Spacing, Changing Line Spacing, Clearing Formatting, Using Quick Styles, Using Themes to Format the Document. Inserting a Table, Moving a Table, Inserting Rows within a Table, Adding a Row at the End of a Table, Inserting Columns within a Table, Changing Column Widths, Merging Table Cells, Splitting Cells of a Table, Centering a Table within the Margins, Changing Text Direction, Wrapping Text around Tables, Adding Space to Table Rows, Adding Paragraph/ Cell Borders and Shading, Inserting a Pre-Formatted Text Box, Drawing a Text Box, Formatting a Text Box. Finding and Replacing Text, Finding and Replacing Formats, Finding and Replacing Special Characters (Tabs, Spaces, etc.). Also includes: Lists of Table Selection Shortcuts and Formatting Shortcuts. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Microsoft Word 2010 Introduction Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 9781936220151
Format: PDF, ePub, Mobi
Download Now
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Word 2010. 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: Creating, Opening & Saving Documents; Working with Previous File Versions; Setting up the Page; Inserting/Deleting Text; Spacing between Paragraphs; Undo, Redo, and Repeat; Moving and Copying Text. Formatting: Changing Font, Size, Enhancements, Paragraph Alignment; Copying Formatting; Using the Mini Toolbar; Highlighter. Draft, Print Layout, Reading Views; Going to a Page; Searching Using the Navigation Pane; Creating and Editing Headers and Footers; No Header or Footer on the First Page, Inserting a Page Break. Checking Spelling, Grammar; AutoCorrect; Creating and Inserting Quick Part Building Blocks; Sending the Document as an E-mail Attachment; Saving as PDF; E-mailing a PDF; Printing Envelopes and Labels; Previewing and Printing. Also includes: Lists of Selection and Movement Shortcuts. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Microsoft Excel 2010 Tables PivotTables Sorting and Filtering Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcu

Author: Beezix Software Services, Inc
Publisher:
ISBN: 9781936220335
Format: PDF, ePub, Mobi
Download Now
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 2010. 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: Excel Tables: Creating an Excel Table, Changing the Table Area, Adding a New Row or Column to the Table, Deleting a Table Row or Column, Turning On/Off the Total Row, Changing the Total Row, Convert a Table to a Normal Range, Using a Normal Range for Sorting, Filtering, Subtotals, and PivotTables, Removing Duplicates, Structured References in Excel Tables. PivotTables: Creating a PivotTable or PivotChart Report, Show/Hide the PivotTable Field List, 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 in a PivotTable, Grouping by Dates or Time, Filtering PivotTables and Charts with Slicers. Sorting & Filtering: Basic Sorting, Complex Sorting, Re-applying a Sort, Creating a Custom List, Creating a Custom List from Cell Data, Sorting Using a Custom List, Filtering and Advanced Filtering, Show/Hide AutoFilter, Searching for Filter Criteria in AutoFilter, Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting /Ordering Columns, Filter/Copy Unique Rows, Clearing Filtering and Sorting, Subtotals. This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

Microsoft Word 2010 Collaboration Features Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 9781936220441
Format: PDF, ePub
Download Now
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use collaboration features of Microsoft Office Word 2010. 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: Turning On/Off Track Changes, Tracking Table Changes, Show/Hide the Reviewing Pane, Accepting/Rejecting Changes. Inserting Comments, Reviewing Comments, Show/Hide Comments, Deleting Comments, Changing What is Shown, Showing Deletions and Moves in Balloons, Hiding Formatting Changes, Turning Off/On Tracking Formatting. Hide/Show Specific Authors, Changing Author, Forcing Landscape Printing, Comparing Two Documents: Combining Multiple Documents, Comparing with Previous Versions, Comparing Documents Side by Side. Protecting your Document, Removing Personal or Hidden Information from a Document, Restricting Editing, Blocking Others from Editing Part of a Document Stored on SharePoint, Unblocking. Sharing a Document on SkyDrive, Sending a Link to a SkyDrive Folder, Sharing a Document on a SharePoint, Co-Authoring, Using the Navigation Pane While Co-Authoring, Resolving Conflicts. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Microsoft Excel 2010 Functions and Formulas Quick Reference Guide 4 Page Cheat Sheet Focusing on Examples and Context for Interme

Author: Beezix Software Services
Publisher:
ISBN: 9781936220250
Format: PDF, Kindle
Download Now
Geared toward the intermediate to advanced user, this example-rich 4-page laminated quick reference guide provides explanations and context for many powerful functions and formulas. Step-by-step instructions for many function/formula-related features. This guide is suitable as a training handout, or simply an easy to use reference guide. The following topics include: Conditionally Summing Data (SUMIF, COUNTIF) Being Precise (Rounding functions) Improving Clarity with Range Names Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) Changing Results: IF, AND, OR Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) Error Recovery (ISNA, ISERROR) Array Formulas (Single Cell & Multi-Cell Arrays) Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAY) Using a Formula for Data Validation Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Show/Hide Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows. This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

VBA and Macros

Author: Bill Jelen
Publisher: Pearson Education
ISBN: 0789743140
Format: PDF, Kindle
Download Now
Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features Learning advanced Excel scripting has never been easier You'll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

Fixing PowerPoint Annoyances

Author: Echo Swinford
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596100049
Format: PDF, ePub, Mobi
Download Now
Provides a variety of tips and tricks when using Microsoft PowerPoint, covering such topics as avoiding setup mistakes, adding multimedia effects, and printing and distribution.

Microsoft Excel 2013 Functions and Formulas Quick Reference Card 4 Page Cheat Sheet Focusing on Examples and Context for Intermed

Author: Beezix
Publisher:
ISBN: 9781936220779
Format: PDF
Download Now
Geared toward the intermediate to advanced Excel 2013 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2013 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. Topics include: Controlling Order of Precedence Conditionally Summing/Counting Data (SUMIF, COUNTIF) Being Precise (Rounding functions) Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT) Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) Changing Results: IF, AND, OR, NOT Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) Error Recovery (ISNA, ISERROR) Array Formulas (Single Cell & Multi-Cell Arrays) Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS) Using a Formula for Data Validation Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.

Adobe Acrobat DC Introduction Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services
Publisher:
ISBN: 9781939791535
Format: PDF, ePub
Download Now
Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Adobe Acrobat DC. Covers BOTH Windows & Mac versions of Acrobat DC. The following topics are covered:Home, Tools, & Document Views; Customizing the Tools Pane; Creating a PDF: from within Acrobat; from Internet Web Pages; from Other Programs. Combining Files into a PDF: Creating a PDF Portfolio; Creating PDFs from Multiple Files. Adding Comments and Markup; Adding a Sticky Note; Reviewing Comments.Changing Description and MetadataFinding and SearchingZooming and Reordering PagesDeleting PagesCreating WatermarksUsing a StampOptical Character RecognitionAdding or Touching up ContentCreating Headers and FootersWorking with LinksCreating BookmarksAttaching a FileSigning a DocumentSecurityApplying Password EncryptionReviewing Documents with OthersUsing Comment and ReviewTracking ReviewsAlso includes a list of Windows and Mac keyboard shortcuts