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.
Author: John Walkenbach
Publisher: John Wiley & Sons
Release Date: 2011-06-24
Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these charting features and shows you how to choose the right chart for your needs. You’ll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, construct “impossible” charts, create charts from pivot tables, dress them up with graphics, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks. What you’ll learn The secrets of the Excel for Mac interface! How to create effective workbooks and templates How to quickly format worksheets How to perform custom calculations and formulas What kind of creative and persuasive charts How to illustrate your worksheets with SmartArt, pictures, and more What business problem solving can be done with Excel How to analyze data with pivot tables How to automate tasks with Visual Basic for Applications (VBA) Who this book is for Beginning and intermediate users looking to get up to speed quickly with the Excel 2011 application and use it productively, both online and offline. Table of Contents Learning the Secrets of the Excel:Mac Interface Configuring Excel:Mac to Suit the Way You Work Creating Effective Workbooks and Templates Formatting Your Worksheets Quickly and Efficiently Performing Custom Calculations with Formulas Using Excel’s Built-In Functions Creating Clear and Persuasive Charts Using Data Bars, Color Scales, Icon Sets, and Sparklines Illustrating Your Worksheets with SmartArt, Pictures, and More Creating Databases Using Tables Solving Business Questions with What-If Analysis, Goal Seek, and Solver Analyzing Data with PivotTables Collaborating and Sharing with Macs and Windows Automating Tasks with Macros and VBA
This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master Office 2013's new features. If you're one of them, Easy Office 2013 will give you exactly what you're looking for. This full-color, utterly simple, step-by-step tutorial is carefully crafted to provide instant access to the 100+ tasks you'll find most useful and valuable. Like all Easy series books, it teaches visually: you're never forced to work through lengthy text explanations. Its large typeface makes it even more accessible to all readers - especially senior readers whose needs are disregarded by most computer books. Written by two of the world's most experienced authors of Microsoft Office books for beginners, Easy Office 2013 presents the easiest, fastest, most direct procedures for getting the results you're looking for. Learn how to… * Get super productive with Office 2013’s powerful new tools * Create, edit, and read Office files on the Web and mobile devices * Craft high-impact documents with powerful visuals * Prepare and analyze data visually with Excel charts and PivotTables * Make winning presentations with PowerPoint’s new tools; even add audio and video * Work with others to review and refine your documents * Use Outlook to take control of your messages, schedules, and tasks * Take notes anywhere with OneNote: never forget a great idea again! * Publish Office content straight to Facebook, Twitter, or LinkedIn * And more
Author: Elaine Marmel
Publisher: John Wiley & Sons
Release Date: 2013-04-05
A basic introduction to learn Office 2013 quickly, easily, and in full color Office 2013 has new features and tools to master, and whether you're upgrading from an earlier version or using the Office applications for the first time, you'll appreciate this simplified approach. Offering a clear, visual style of learning, this book provides you with concise, step-by-step instructions and full-color screen shots that walk you through the applications in the Microsoft Office 2013 suite: Word, Excel, PowerPoint, Outlook, and Publisher. Shows you how to tackle dozens of Office 2013 tasks Shares practical examples and beneficial advice to guide you through each application Focuses on visual learners, with step-by-step instructions illustrated with full-color screen shots throughout Office 2013 Simplified makes the new Office suite easy to understand, even if you are new to the software.
Author: Greg Harvey
Publisher: John Wiley & Sons
Release Date: 2016-05-31
Let your Excel skills sore to new heights with this bestselling guide Updated to reflect the latest changes to the Microsoft Office suite, this new edition of Excel For Dummies quickly and painlessly gets you up to speed on mastering the world's most widely used spreadsheet tool. Written by bestselling author Greg Harvey, it has been completely revised and updated to offer you the freshest and most current information to make using the latest version of Excel easy and stress-free. If the thought of looking at spreadsheet makes your head swell, you've come to the right place. Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest installment of the software, Microsoft Excel 2016. In no time, you'll begin creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, and more. Plus, you'll get easy-to-follow guidance on mastering more advanced skills, like adding hyperlinks to worksheets, saving worksheets as web pages, adding worksheet data to an existing web page, and so much more. Save spreadsheets in the Cloud to work on them anywhere Use Excel 2016 on a desktop, laptop, or tablet Share spreadsheets via email, online meetings, and social media sites Analyze data with PivotTables If you're new to Excel and want to spend more time on your actual work than figuring out how to make it work for you, this new edition of Excel 2016 For Dummies sets you up for success.
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.
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
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.
A practical, hands-on approach to using Office 2016 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user. Office for Mac remains the leading productivity suite for Mac, with Apple’s iWork and the free OpenOffice.org trailing far behind. Now, it's been updated with a cleaner interface and more compatibility with Exchange and SharePoint. This book provides the best combination of accessible and focused coverage of the Office 2016 applications. Rather than cover every seldom-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office. What You Will Learn Create professional documents for home and business using Word Edit documents collaboratively in real time with your colleagues Record and manipulate data using spreadsheets Use your data to create powerful and convincing charts Build persuasive multimedia presentations in PowerPoint Deliver presentations like an expert Keep your e-mail under control with Outlook Stay on top of your schedule and your tasks Who This Book Is For Any Mac user who needs to work with Word, Excel, PowerPoint, or Outlook either for business or for pleasure. Professionals, students, and home user alike will benefit from straightforward explanations, step-by-step instructions, and effective workarounds for everyday problems.
Author: Joan Lambert
Publisher: Microsoft Press
Release Date: 2010-07-15
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.
Author: Joan Lambert
Publisher: Microsoft Press
Release Date: 2016-01-13
The quick way to learn Microsoft Outlook 2016! This is learning made easy. Get more done quickly with Outlook 2016. Jump in wherever you need answers--brisk lessons and colorful screenshots show you exactly what to do, step by step. Get easy-to-follow guidance from a certified Microsoft Office Specialist Master Learn and practice new skills while working with sample content, or look up specific procedures Manage your email more efficiently than ever Organize your Inbox to stay in control of everything that matters Schedule appointments, events, and meetings Organize contact records and link to information from social media sites Track tasks for yourself and assign tasks to other people Enhance message content and manage email security