Microsoft Access 2010 Intermediate Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1936220245
Release Date: 2010-10-30
Genre:

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 Tables PivotTables Sorting and Filtering Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcu

Author: Beezix Software Services, Inc
Publisher:
ISBN: 1936220334
Release Date: 2011-02-18
Genre: Business

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 Excel 2010 Advanced and Macros Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1936220369
Release Date: 2011-03-08
Genre:

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 Word 2010 Formatting Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 1936220202
Release Date: 2010-06-15
Genre: Microsoft Word

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: 1936220156
Release Date: 2010-06-15
Genre: Microsoft Word

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 Introduction Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 193622013X
Release Date: 2010-05-01
Genre: Business

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 Functions and Formulas Quick Reference Guide 4 Page Cheat Sheet Focusing on Examples and Context for Interme

Author: Beezix Software Services
Publisher:
ISBN: 1936220253
Release Date: 2011-04-15
Genre: Business

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.

Microsoft Access 2010 In Depth

Author: Roger Jennings
Publisher: Pearson Education
ISBN: 0768695236
Release Date: 2010-12-28
Genre: Computers

Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Access 2010, and get more done in less time. Legendary Access expert Roger Jennings provides specific, tested, proven solutions to the problems Access database users and developers run into every day: challenges other books ignore or oversimplify. Jennings thoroughly covers all facets of working with Access 2010, and adds new chapters on integration and collaboration with Microsoft SharePoint and emulating Table Triggers with Access Data Macros. New coverage also includes: customizable Ribbon and Themes; the revamped Macro Designer; Quick Start Fields; IntelliSense support in Expression Builder; Application Parts and Navigation Forms; conditional formatting and data bars in reports; and new web database publishing techniques. As with all In Depth books, Access 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity. By Roger Jennings, a world-renowned Access expert who has sold more than 1.25 million books! Covers all aspects of working with Access 2010, from the customizable Ribbon and Themes to conditional formatting, advanced web database publishing to SharePoint collaboration For everyone who wants to get the most out of Access 2010, from hobbyists to power users to corporate developers

Windows 8 Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Guide

Author: Beezix
Publisher:
ISBN: 1936220687
Release Date: 2012-11-19
Genre:

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 Word 2010 Collaboration Features Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 193622044X
Release Date: 2012-06-07
Genre:

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 Charts and Sparklines Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1936220423
Release Date: 2011-08-15
Genre:

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use charts/graphs and Sparklines features of Microsoft Office Excel 2010. The following topics are covered: Charts: Inserting a Chart, Creating a Chart Sheet Using the Default Chart Type, Changing Type, Resizing a Chart in the Worksheet, Changing Chart Type, Charting Non-Adjacent Data, Selecting Chart Objects, Adjusting Scale, Creating a Chart with Two Scales, Add, Move or Remove the Legend, Adding a Data Series, Removing a Data Series, Using Tables as a Data Source, Switching Rows and Columns, Adding or Removing Gridlines, Exploding a Piece of a Pie Chart, Adding Explanatory Text, Adding Visuals, Adding Data Labels, Move, Format, Edit Data Labels, Adding/Removing a Chart Title, Adding an Axis Title, Moving a Title, Using Styles and Layouts, Moving the Chart to Another Worksheet, Adding a Projection or Trendline to a Data Series, Removing a Trendline, Handling Hidden and Empty Cells, Setting the Default Chart, Creating a Chart Template, Applying a Custom Chart Type. Sparklines: Creating a Sparkline, Removing Sparklines, Grouping Sparklines, Changing Sparkline Type. Customizing Sparklines: Adding Text, Highlighting Values (Markers). Changing Marker Color, Change Sparklines Color and Weight, Customizing Axis Settings, Handling Hidden and Empty Cells. 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 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: 9780789743145
Release Date: 2010
Genre: Computers

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

OneNote 2013 For Dummies

Author: James H. Russell
Publisher: John Wiley & Sons
ISBN: 9781118550564
Release Date: 2013-05-20
Genre: Computers

OneNote lets you organize, access, and share notes on multiple devices. This guide shows you how to take full advantage of everything it offers-- text recognition, the ability to include data from other Office apps, and more!

Microsoft Project 2007

Author: Bonnie Biafore
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596528362
Release Date: 2007-10-08
Genre: Business & Economics

A guide to the project management tool covers such topics as estimating work time, setting up a project schedule, building a team, setting up a budget, tracking progress, evaluating performance, and reporting on projects.

Access 2016 For Dummies

Author: Laurie Ulrich Fuller
Publisher: John Wiley & Sons
ISBN: 9781119083108
Release Date: 2015-11-02
Genre: Computers

Fuller and Cook help you unlock the magic of databases so you can manage it all and make it useful with the tools in Access 2016. This guide will help you organize your data, produce reports that make you look like a genius, and create forms that enable your staff to enter and manage more data.