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.

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.

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 NamesMerging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)Changing Results: IF, AND, ORTable 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 ValidationTroubleshooting: 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.

Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:An introduction to the VBA languageA hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing itThe essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorderThe essential VBA language elements, including comments, variables and constants, and labelsWorking with Range objects and discovering useful Range objective properties and methodsUsing VBA and worksheet functions, including a list and examplesProgramming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loopAutomatic procedures and Workbook events, including a table and event-handler proceduresError-handling and bug extermination techniques, and using the Excel debugging toolsCreating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricksCustomizing the Excel toolbarsUsing VBA code to modify the Excel menu systemCreating worksheet functions and working with various types of argumentsCreating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilitiesAuthor John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with:A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changesInformation to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to knowWhat are you waiting for? Sure, learning to do VBA programming takes a little effort, but it’s a Very Big Accomplishment.

Experience learning made easy-and quickly teach yourself how to manage your projects with Project 2010. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Topics include building a project plan and fine-tuning the details; scheduling tasks, assigning resources, and managing dependencies; monitoring progress and costs; keeping projects on track; communicating project data through Gantt charts and other views.

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.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use calendar, contacts, and tasks features of Microsoft Office Outlook 2007. Topics include: Calendar: Setting up Your Work Week, Viewing the Calendar, Creating Appointments, Repeating Appointments or Meetings, Creating and Scheduling a Meeting, Responding to Meeting Requests, Changing Time or Date of Meeting/Appointment, Viewing Multiple Calendars, Creating and Using Group Schedules, Printing the Calendar, Hiding/Displaying Tasks Contacts: Creating&Editing Contacts, Sending a Mail Message to a Contact, Searching for Contacts, Merging Contacts with Word, Viewing Mail Related to a Contact Tasks: Displaying To-Do and Task List Folders, Creating Tasks, Marking Complete, Adding Messages or Contacts to the To-Do List, Sorting Tasks, Changing Task Order, Assigning Tasks, Viewing Tasks in the Calendar, Hiding /Displaying Tasks in the To-Do Bar, Printing Tasks For Any Outlook Item: Deleting, Assigning an Item to a Category, Sorting on Categories, Sharing Calendar Contacts Tasks or Notes, Using Another Person's Calendar Contacts Tasks or Notes Folder, and The Reading Pane. Also includes a list of Keyboard and Selection 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 available for Outlook 2007: What s New in Outlook 2007, Outlook 2007 Mail, Outlook 2007 Calendar, Contacts,&Tasks.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced 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:Using Styles, Character, Paragraph, Linked Styles, Applying Character and Paragraph Styles, Creating a Style, Displaying the Styles Pane, Disabling Linked Styles, Changing Styles, Deleting a Style, Selecting All Text with the Same Style, Showing Formatting as Styles to Clean Up a Document, Importing Styles from Another Document, Using Numbered Lists with Styles, Adding Styles to the Default List, Applying Table Styles, Restricting Formatting, Creating a Table of Contents, Updating a Table of Contents, Preparing an Index, Generating an Index, Updating an Index, Section Breaks, Inserting a Section Break, Changing Page Numbering Mid-Document, Changing Headers and Footers, Changing Page Setup in a Section, Displaying the Section Number in the Status Bar, Inserting a Footnote/Endnote, Editing a Footnote/Endnote, Deleting a Footnote/Endnote, Creating a Bookmark, Going to/Selecting Bookmarked Text, Using Bookmarks to Refer to Pages, Outlining, Adding a Watermark, Inserting an Excel Spreadsheet, Comparing Documents Side by Side, Creating a Template Library in Windows 7, Creating a Template.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.

In this new third edition, Linenberger updates his longtime #1 bestselling Outlook book to include Microsoft's new version 2010 release and the new Outlook for Mac 2011. Outlook 2007 and 2003 are also covered. This seminal guide presents the author's best practices of time, task, and e-mail management, drawing from time management theories and applying these best practices in Microsoft Outlook. Anyone who finds they are overburdened by e-mail or working too late each day will benefit from this book. 

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.