Microsoft Access 2010 Intermediate Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Author: Beezix, Inc Staff
Editor:
ISBN: 9781936220243
Size: 13,71 MB
Format: PDF, ePub, Docs
Read: 863
Download

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Access 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: Table Design: Preventing Data Entry Errors, Find and Sort More Quickly With Indexing, Joining Tables to Create Relationships, Deleting a Table Join, Preventing Orphaned Data with Referential Integrity. Query Design: Performing Calculations, Summarizing Selected Data. Form Design: Adding Form Controls, Sorting, Removing Automatic Labels, Modifying Automatic Labels, Modifying Form Controls. Report Design: Summarizing by Group, Printing Options. Table Relationships. Complex Expressions Examples. Form Control. This guide is one of two available titles for Access 2010: Access 2010 Introduction and Access 2010 Intermediate.

Microsoft Excel 2010 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Editor:
ISBN: 9781936220137
Size: 15,24 MB
Format: PDF, ePub, Docs
Read: 226
Download

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use 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: Creating Workbooks, Entering and Editing Data, Undo and Redo, Resizing Column Width and Row Height, Inserting and Deleting Rows Columns and Cells, Clearing Cells, Clearing Formatting, Formatting Numbers and Cells, Aligning and Merging Cell Contents, Borders and Grids, Viewing the Worksheet as it will Print, Entering Dates, Entering Sequences. Entering Formulas & Functions, Entering a SUM Function 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, Copying Data and Formatting to Multiple Worksheets. Previewing, Printing and Page Setup, Printing a Specific Area, Using Page Break Preview to Adjust Page Breaks, Repeating Rows/Columns on Every Page. Working with Previous Versions (Compatibility Mode). Also includes: Lists of Selection and Movement Shortcuts. 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 Excel 2010 Tables Pivottables Sorting And Filtering Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcu

Author: Beezix Software Services, Inc
Editor:
ISBN: 9781936220335
Size: 20,52 MB
Format: PDF
Read: 527
Download

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 Formatting Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Editor:
ISBN: 9781936220205
Size: 15,24 MB
Format: PDF, ePub, Docs
Read: 920
Download

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
Editor:
ISBN: 9781936220151
Size: 13,48 MB
Format: PDF, Kindle
Read: 126
Download

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.

Onenote 2010 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Author: Beezix, Inc Staff
Editor:
ISBN: 9781936220267
Size: 11,84 MB
Format: PDF, ePub, Docs
Read: 715
Download

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office OneNote 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: Navigating Notebooks, Opening and Existing Notebook, Creating a Notebook, Saving in OneNote, Sections and Pages, Adding a Section, Adding a Page, Deleting a Section or Page, Moving or Copying a Section, Moving a Page, Renaming a Section, Renaming a Page, Creating Text Notes, Moving Text Notes, Merging Text Notes, Creating Tables, Working With Image-Based Notes, Screen Clips, Creating an Audio or Video Note, Unfiled Notes, Sending to OneNote, Adding Tags, Add Tasks to OneNote, Searching in OneNote, Searching for Text, Searching for Tags, Searching for Audio and Video Notes, The Search Results Pane, Creating a Shared Notebook, Turning Synchronization Off, Turning Synchronization On/Manual Synchronization, Editing and Reading Shared Notebooks, Password Protecting a Section, Docking OneNote (Taking Linked Notes).

Microsoft Excel 2010 Advanced And Macros Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Author: Beezix, Inc Staff
Editor:
ISBN: 9781936220366
Size: 16,58 MB
Format: PDF
Read: 210
Download

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros 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: Goal Seek, Saving Views, Defining Scenarios, Hiding Columns, Rows or Sheets, Restricting Cell Entry with Data Validation, Highlighting Invalid Data, Clearing Data Validation Circles, Data Consolidation, Conditional Formatting, Clearing Conditional Formatting, Conditional Formatting Rules Manager, Creating a Workspace With Multiple Workbooks, Protecting/Unprotecting Worksheets, Password Protecting Specific Cells, Keeping Part of a Worksheet Visible: Freeze Panes, Split Panes. Macros: Showing the Developer Tab, Macro Names, Recording a Macro, Running a Macro, Renaming a Macro, Automatic Macro Execution, Relative vs. Absolute Recording, Assigning to the Quick Access Toolbar, Creating a Macro Without Recording, Documenting a Macro, Calling Another Macro, Setting Macro Security, Getting Help on Visual Basic, Saving a Macro Enabled Worksheet, Creating a Custom Ribbon Group, Adding a Macro to the Ribbon, Creating a Function Procedure, Using a Function Procedure. 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 Office Sharepoint 2013 Quick Reference Guide

Author: Beezix
Editor:
ISBN: 9781936220953
Size: 16,92 MB
Format: PDF, ePub, Mobi
Read: 472
Download

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office SharePoint 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: Accessing a SharePoint site Signing Out Navigating SharePoint Expanding the Main Content Area Creating a New List Item Editing a List Item Assigning a Task Viewing Your Update Stream Following a Site Following a Document/File Following a Person Engaging in Newsfeed Conversations Using @ Mentions Using # Tags Liking a Newsfeed Update Tagging and Adding Notes to Documents and Pages Sharing Files with People Viewing Tags and Notes Searching for Documents Searching for People Creating a Subsite Community Sites Using Document Libraries Adding Existing Files List and Library Functions: Sorting, Filtering, Changing View, Using Email Alerts, Creating a List or Library, Deleting a List or Library. Checking Files Out/In Using the Recycle Bin Creating a Survey

Windows 8 Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Guide

Author: Beezix
Editor:
ISBN: 9781936220687
Size: 14,16 MB
Format: PDF, ePub, Mobi
Read: 989
Download

4-page laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Windows 8. Includes touch interface. The following topics are covered: Getting Started: Starting Windows/Login; The Start Screen; Windows Store Apps and Desktop Apps; Accessing the Desktop; Starting a Desktop or Windows Store App; Accessories (Calculator, Notepad, etc.); Switching Between Apps and Desktop Windows - Using the Switch List; Closing a Windows Store App; Closing a Desktop Window or App; Windows Charms, Using the Share Charm; Searching; Working with Multiple Monitors; Opening Files, Folders and Libraries; Saving a Document; Using the Shortcut Menu; Showing Windows Store App Commands and Navigation. Organizing Tiles & Apps: Creating a Tile Group; Naming a Tile Group; Rearranging Start Screen Tiles; Adding an App Tile to the Start Screen; Creating Secondary Tiles; Always Show a Windows Store App (Snapping). Working on the Desktop: Pinning a Desktop App to the Taskbar; Using Taskbar Jump Lists (Recently Used Files, Pinned Files, Common Tasks);Pinning Files to Taskbar Jump Lists; Switching Between Windows Using the Taskbar; Resizing a Desktop Window; Moving a Desktop Window; Making a Desktop Window Large (Maximize); Hiding a Desktop Window (Minimize); Using the Notification Area (Printing, Security, Sound, etc.). File Management: Folders, Libraries & Favorites: Starting File Explorer; Working with the Ribbon; Navigation Pane, Preview Pane & Details Pane; Changing How Items are Displayed, Changing Views, Grouping & Sorting; Navigating Folders in File Explorer; Opening a Second Explorer Window; Creating a Folder; Renaming Files or Folders; Working with Libraries; Selecting Multiple Items, Selecting with Checkboxes; Moving and Copying Files and Folders, Moving and Copying with Cut, Copy & Paste; Creating a Shortcut to a Document, Folder, or Other Item; Zipping Files or Folders; Deleting Files or Folders; Pinning to Start; Adding a Folder or Library to Favorites; Searching in File Explorer; Burning to a CD/DVD. Settings & Troubleshooting: Using the Settings Charm; Using the Control Panel; Setting up WiFi; Using Airplane Mode; What to Try if an App Freezes. Users & Security: Viewing a Password While Typing; Changing Users; Ending your Windows Session; Changing Login Password; Creating a Picture Password; Getting Help.

Microsoft Office 2010 Plain Simple

Author: Katherine Murray
Editor: Pearson Education
ISBN: 0735649197
Size: 18,62 MB
Format: PDF, ePub, Mobi
Read: 428
Download

Get the fast facts that make learning Office 2010 plain and simple! This colorful, no-nonsense guide uses easy-to-follow steps and screenshots, and clear, concise language to show the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote. Here's WHAT You'll Learn Create documents, Web pages, and other publications Organize your e-mail, calendar, contacts and tasks Build spreadsheets to analyze and visualize data Set up a simple database Capture notes with ink, voice or text Here's HOW You'll Learn It Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! Exercises help you apply what you learn right away