Relative cell references, moving or copying Data: Copying to Adjacent Cells; Cut, Copy, Paste & Drag/Drop. Sheet features: renaming, Copying, Moving, Selecting, Inserting, Deleting. Previewing, scaling the printout, Printing and Page Breaks, Repeating Rows/Columns on Every Page. Also includes a list of Selection and Movement Shortcuts.
Recommended companion title covering office basics: Office 2016 for Mac Essentials ISBN 9781939791634. Written with beezix's trademark focus on clarity, and the user's perspective, accuracy, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016 for Mac. Normal view, entering and editing data, borders and shading, clearing cells, aligning Cell Contents, Entering Data into a Selected Range, Formatting Numbers, Best Fit, Replacing Cells, Inserting and Deleting Rows Columns and Cells, Column Width and Row Height, Clearing Formatting.
Entering dates, Entering a Sequence of Numbers. Entering formulas & functions sum, entering functions Quickly, MAX, TODAY, MIN, AVERAGE, Absolute vs. Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Excel 2016 for Mac.
Word 2016 for Mac Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card
Written with beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Word 2016 for Mac. The following topics are covered:setting up the pagemoving and copying textchanging Line and Paragraph SpacingParagraph AlignmentShowing/Hiding Special CharactersDisplaying RulersCreating Bulleted & Numbered ListsCopying FormattingGoing to a PageMoving Quickly to the Next Page, Heading, Table, Graphic, etc.
Using the sidebar to navigatedocument views: Print Layout View, Web Layout view, Draft View, Outline View, Full Screen View. Using the Highlighter. Creating a text boxinserting a Page Break, Creating and Editing Headers and Footers. No header or footer on the First PageCreating a Cover Page. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.
Using smart lookup & thesauruschecking Spelling, GrammarAutoCorrectAutoTextSetting Default FontUser InformationPrinting Envelopes and Labels. Also includes: lists of Selection, Movement, Editing and Formatting Shortcuts.
Office 2016 for Mac Essentials Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use features of Microsoft Office 2016 for Mac that are common to Word, Excel & PowerPoint. Written with beezix's trademark focus on clarity, and the user's perspective, accuracy, this guide will be a valuable resource to improve your proficiency in using Microsoft Office 2016 for Mac.
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: starting word/excel/PowerPoint; Using the Ribbon; Creating, Opening & Saving Documents; Using the Status Bar: Zoom, Document Views. Changing text font & size; Enhancing Text: Bold, Italic, etc.
Undo, redo, audio, and repeat; inserting/deleting text; selecting text; selecting shapes or excel cells; moving and Copying: Cut Copy Paste, Paste Options, Drag and Drop; Copying Formatting; Using Themes to Format a Document; Adding SmartArt; Inserting and Formatting a Shape; Shape Styles; Insert Pictures, or Video; Using Smart Lookup; Using the Thesaurus.
Also includes a list of Common Keyboard Shortcuts.
PowerPoint 2016 for Mac Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card
Great companion product to word 2016 for mac isbn 9781939791603 and Excel 2016 for Mac ISBN 9781939791597 Introduction guides. Creating an org chart; adding a New Box to the Org Chart; Deleting a Box in the Org Chart. Creating Speaker Notes. Using presentation views: normal View; Working on Your Presentation Structure Outline View; Rearranging Slides Slide Sorter.
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 included:adding a new Slide; Changing a Slide's Layout; Slide Shape, Size, Orientation; Entering Text into a "Click to add. Bulleted list placeholder; starting a new line without a Bullet; Moving from Title to Body with the Keyboard; Changing Indention Level; Text Formatting; Adding Other Text on the Slide.
Inserting clip art or other images; resizing Graphics; Creating a Charts or Graph; Changing Chart Type; Editing a Chart.
Laminated Guide - Excel 2016 for Mac Functions & Formulas Quick Reference Guide 4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas
Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. This guide is suitable as a training handout, or simply an easy to use reference guide. Topics include: Glossary. Conditionally summing/Counting Data SUMIF, COUNTIF. Being Precise Rounding functions.
Improving clarity with range names: name rules, managing Names, Using and Selecting Names, Creating Names, Indirectly Referring to a Named Range INDIRECT. Merging text and numbers concatenate, len, mid, right, text, find, value, left, TRIM, SUBSTITUTE. Changing results: IF, AND, OR. Table lookups vlookup, hlookup, indEX, MATCH.
Error recovery isNA, ISERROR. Common loan functions pmt, ratE, NPER, PV, FV.
Learn Excel 2016 Essential Skills for Mac OS X with The Smart Method: Courseware tutorial for self-instruction to beginner and intermediate level
There's also an excel for windows book available ISBN: 978-1-909253-08-7. This excel 2016 for mac book is very, very different to any other computer book you have ever read. Every lesson is presented on two facing sheets of A4 paper the pages are much bigger than in any other Excel book. You can complete each self-contained lesson in a few minutes.
Each lesson has a sample file that models a real-world business problem. And many, many others. Here are just five of the many ways in which this book is unique: The book will equip you with excellent Excel 2016 for Mac skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace.
Only users who have advanced requirements need progress to the Excel 2016 for Mac Expert Skills book. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses. This has made smart method books a popular choice for schools, colleges and universities all over the world.
Every smart method book is registered in Amazon's Kindle MatchBook program.
Laminated Card - Excel 2016 for Mac Charts, Sparklines, Tables & PivotTables Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts
This card is suitable as an accompaniment for Intermediate level Excel training, or simply an easy to use reference guide, for any type of user. Laminated quick reference card showing step-by-step instructions and shortcuts for Charts graphs, Sparklines, Tables and PivotTables features of Microsoft Excel 2016 for Mac.
. Filtering and advanced filtering: show/hide autofilter; filtering with AutoFilter; Setting Criteria for Advanced Filters; Using Advanced Filters/Copying Filtered Data to Another Range; Selecting/Ordering Columns; Clearing Filtering; Creating Subtotals in a List. Excel tables: creating an excel table; adding a new row or column; deleting a table row or column; Turning On/Off or Changing the Total Row; Removing Duplicates; Structured References in Excel Tables; Convert a Table to a Normal Range; Using a List in a Normal Range; Sorting: Simple and Complex.
Pivottables: creating a pivottable; adding/removing a pivottable field; Show/Hide the PivotTable Builder; Refreshing a PivotTable; Rearranging a PivotTable; Changing the Summary Function; Changing How Values are Shown; Sorting in a PivotTable. This guide is one of multiple titles available for excel 2016 for mac, other excel titles are: Excel 2016 for Mac Introduction ISBN 978-1939791597; Excel 2016 for Mac Functions & Formulas ISBN 978-1939791641.
Written with beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016 for Mac.
macOS High Sierra Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Guide
The following topics are covered: using the touch bar; starting an app a program; accessing Recently Used Files, Apps, or Servers; Organizing Launchpad; Opening Files & Folders; Working with Windows; Finding the Mouse Pointer; Using the Secondary/Right Click; Connecting to a Wi-Fi Network. Four page laminated quick reference guide showing step-by-step instructions and shortcuts for how to use macOS High Sierra.
Includes a list of keyboard Shortcuts, Trackpad Gestures, and links to blog posts for more detailed subjects. Converting a file to a pdf; Searching with Spotlight; Using the Virtual Assistant Siri. Switching between running apps or windows; quitting an app; quitting a frozen app; ejecting drives, Discs, or Servers; Adding an App to the Dock; Moving the Dock; Hiding the Dock; Using Stacks; Customizing the Menu Bar; Finding Keyboard Shortcuts for Menu Items; Showing the Date and Battery Percentage.
This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. Using dictation; using text to speech; using automatic Spelling Correction; Capitalization and Period Shortcuts; Using the Dictionary; Using Special Characters; Setting Text Shortcuts. Ending Your Computer Session.
macOS Mojave Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Guide
Ending Your Computer Session. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. Includes a list of keyboard Shortcuts, Trackpad Gestures, and links to blog posts for more detailed subjects. Four page laminated quick reference guide showing step-by-step instructions and shortcuts for how to use macOS Mojave.
The following topics are covered: using the touch bar; starting an app a program; accessing Recently Used Files, Apps, or Servers; Organizing Launchpad; Opening Files & Folders; Working with Windows; Finding the Mouse Pointer; Using the Secondary/Right Click; Connecting to a Wi-Fi Network. Switching between running apps or windows; quitting an app; quitting a frozen app; ejecting drives, Discs, or Servers; Adding an App to the Dock; Moving the Dock; Hiding the Dock; Using Stacks; Customizing the Menu Bar; Finding Keyboard Shortcuts for Menu Items; Switching Between Light and Dark Mode.
Written with beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using macOS High Sierra.
Laminated Card - Outlook 2016 for Mac Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts
Calendar: displaying the calendar; setting up your work week; creating a simple and detailed appointment; changing entry date or time by Dragging; Editing an Appointment or Meeting; Responding to Meeting Requests; Repeating Appointments or Meetings; Viewing Multiple Calendars; Sharing a Calendar Using an Exchange Server; Using Another Person's Calendar; Showing More/Fewer Hours in The Calendar; Setting How an Event Affects Availability; Using the Weather Forecast.
This guide is suitable as a training handout, or an easy to use reference guide, for any type of user. The following topics are covered:navigating sectionsmail: displaying mail; displaying the inbox; hiding/displaying the Folder Pane; Creating and Sending a Message; Attaching a File to a Message; Showing BCC; Sending a Message with High or Low Importance; Saving a Draft of a Message; Restricting Forwarding, Printing, Copying; Reading Messages and Attachments; Manual Send/Receive.
Using the outbox; replying to a message; forwarding a message; Saving an Attachment; Removing an Attachment; Marking a Message Read/Unread; Using Notifications. This is the latest version of Outlook for the Mac, part of the recently released Office 2016 for Mac. This same content was previously issued with the title Outlook for Mac 15 Introduction.
Filtering Tasks.
Learn Excel 2016 Expert Skills for Mac OS X with The Smart Method: Courseware Tutorial teaching Advanced Techniques
Every lesson is presented on two facing sheets of A4 paper the pages are much bigger than in any other Excel book. You can complete each self-contained lesson in a few minutes. Each lesson has a sample file that models a real-world business problem. The teaching methods used in the book were developed and refined using over ten years of experience teaching real students Excel skills in classroom courses.
Every smart method book is registered in Amazon's Kindle MatchBook program. And many, many others. This enables american book purchasers to also download an electronic copy of the book for 99 cents when purchased with or after the printed book look for the MatchBook logo on this page. Advanced concepts are explained without needless technical jargon.
Everything is concisely described in a simple, no-nonsense way. Here is a small selection from the many advanced excel skills you will learn: visually filter data using slicersmaster dynamic tables and structured table referencesenforce complex business rules using function-driven custom validationsperform what-if analysis to model and compare business scenariosuse advanced functions to solve real-world business problemsCreate intuitive user interfaces using form controls Eliminate errors using Excel's advanced formula auditing toolsUnderstand and use all of Excel's security featuresDesign advanced Pivot TablesCreate and use dynamic and table-based range namesRecord macros and then execute them from button controlsUse Excel's three different sharing methods for efficient teamworkCompanies who have taken Smart Method courses include:AOL Time Warner, Scottish Power, Volvo, Unilever, BAE Systems, Transport For London, Barclays, RBS, Keele University, HBOS, Daimler Chrysler, The United States Army, Motorola, The Performing Rights Society, The Ministry of Defence, The British Museum, Virgin, The Institute of Chartered Accountants, British Petroleum, Imperial Tobacco, Pokerstars, American Express, O2, Deutsche Bank, The BBC, HSBC, The Foreign and Commonwealth Office, The Office of the Parliamentary Ombudsman, Marks & Spencer, The National Gallery, Allied Irish Banks, BMW.