Microsoft Lync 2013 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Lync 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 included: Signing In/Out, Show/Hide the Menu Bar, Using Presence Status, Status Indicators, Changing Status Manually, Using Location Status, Adding a Note to Your Status, Viewing Other User's Notes Adding Contacts, Deleting Contacts, Emailing a Contact, Using the Favorites Group, Viewing Contact Cards, Monitoring a Contact's Status, Controlling Presence Privacy Creating and Using Groups Starting a Conversation; Sending an Instant Message; Inviting Additional Participants to Your Conversation; Sending a File; Receiving a File; Working with Multiple Conversations; Conversation Window On Top; Sharing Your Desktop or a Program; Sharing PowerPoint, Whiteboard, or Polls Scheduling an Online Meeting; Joining an Online Meeting; Using Meet Now; Ending an Online Meeting. Viewing Presence Information in Outlook; Responding to an Email with an Instant Message; Responding to an Email with a Call Also includes a list of keyboard shortcuts.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Lync 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 included: Signing In/Out, Using Presence Status, Status Indicators, Changing Status Manually, Using Location Status. Adding Contacts, Deleting Contacts, Using the Frequent Contacts Group, Viewing Contact Cards, Monitoring a Contact's Status, Adding a Note to Your Status, Updating or Clearing a Status Note, Viewing Other Users' Notes, Creating and Using Groups. Starting a Conversation, Sending an Instant Message, Marking Conversation as High Importance, Changing Conversation Subject, Hiding the Instant Message Area, Show/Hide the Conversation Window Menu Bar, Inviting Additional Participants to Your Conversation, Sending a File, Receiving a File, Changing Where your Received Files are Saved. E-Mailing a Contact. Scheduling a Meeting. Sharing Your Desktop or a Program; Sharing PowerPoint, Whiteboard, or Polls; Switching Between Shared Content. Controlling Presence Privacy, Viewing Presence Information in Outlook. Responding to an E-mail with an Instant Message. Responding to an Email with a Call. Also includes a list of keyboard shortcuts.

100% practical guide to understand and use basic to advance level Excel 2019 DESCRIPTION Excel is, by far, the most preferred spreadsheet program on this planet. People love it because of its simplicity and easy user interface. The primary focus of Excel is to perform basic to advanced level numeric calculations. Every industry, department, job role is dependent on Excel to perform day to day duties as well as data analysis and visualization. Microsoft Excel is available in both offline (Excel 2019) and online (Office 365) versions.Ê If you are new to Excel or use this program day in day out, then this book will surely clearÊ your logics and concepts of excel. This book starts with an introduction to Excel program and an overview of its interface and move towards an explanation of new features being introduced in Excel 2019 and Office 365, then an in-depth discussion on entering and transforming data. Understanding different formulas andÊ functions with practical exercises. Afterwards, how to perform data analysis and present it using different data visualization tools. Finally, extracting data and automation of tasks through Macros. After going through this book, you will become conceptually strong in using various features of Excel. You will increase your productivity by understanding and using the right tool for the related data set. KEY FEATURES WhatÕs New in Excel 2019 Office 365 Putting Data into Excel Transforming and Managing the Data Formulas and Functions Data Analysis techniques Data Visualization techniques Multiple ways of Data Extraction Automation in Excel through Macros WHAT WILL YOU LEARN By the end of the book, you will come across many case studies to put your knowledge to practice and understand many tools to solve real-life business problems such as importing data into Excel from different sources, data cleaning through various tools including flash fill, bringing data together into one place using lookup functionality, analysing it to get insights through pivot tables & what if analysis, generating forecast based on past trends, exporting final reports, understanding Power features like Power Pivot/Query/Map and automating manual processes through Macros . Remember to practice along with sample data files provided in the exercise files bundle of the book to master these techniques. WHO THIS BOOK IS FOR This book is for anyone who is either new to Excel or daily Excel user. This book will take you from basic concepts of Excel to Advanced level. Whether you belong to any industry or serving any department, as an Excel user, this book will make you a Pro in Excel. Table of Contents WhatÕs New in Excel 2019/Office 365 Entering Data in Excel Transforming and Managing Data Formulas and Functions Data Analysis Data Visualization Data Extraction Automation in Excel through Macros

Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2013. The following topics are covered: Entering and Editing Data Picking from a Drop-Down List Selecting Cells Resizing Column Width and Row Height Inserting and Deleting Rows, Columns and Cells Clearing Cells, Clearing Formatting Borders, Shading, Text Color Formatting Number Cells Aligning and Merging Cell Contents Entering Dates Entering a Sequence of Numbers Entering Formulas & Functions Entering SUM and Other Functions 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. Previewing, Printing and Page Setup Scaling to Print Printing a Specific Area Using Page Break Preview to Adjust Page Breaks Repeating Rows/Columns on Every Page. Also includes a list of Touch Actions, Selection and Movement Shortcuts.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office PowerPoint 2013. The following topics are covered: Adding a New Slide; Changing a Slide's Layout; Switching Between Standard and Widescreen Format; Custom Slide Size and Orientation; Entering Text; Starting a Line without a Bullet; Moving Between Text Areas with the Keyboard; Adding Other Text on the Slide; Changing Level of Indention; Text Formatting; Using Presentation Views: Normal View, Outline View, Slide Sorter View. Applying Design Themes; Changing Background of a Slide; Adding a Header or Footer; Creating Speaker Notes. Using the Slide Master; Suppressing Slide Master Objects. Adding Clip Art and Online Images; Creating a Chart; Creating an Org Chart; Adding and Deleting Org Chart Boxes; Drawing Shapes; Resizing a Shape or Picture; Rotating Objects; Moving a Shape; Adding Text to Shapes; Selecting Shapes; Changing Color, Fill Pattern, or Line Style of a Shape or Line; Using Eyedropper to Match Colors; Duplicating Shapes; Animating an Object. Running a Slide Show; Assigning Transition Effects and Timings for a Slide Show; Changing Slide Show Settings; Printing. Also includes a list of Touch Actions, Text Selection and Movement and Slide Show Shortcuts.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced features of Microsoft Office Word 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: Using Styles; Character, Paragraph, Linked Styles; Applying Character and Paragraph Styles; Creating a Style; Displaying the Styles Pane; Changing Styles; Deleting a Style; Selecting All Text with Same Style; Adding Styles to the Default Style List; Showing Formatting as Styles to "Clean Up" a Document; Importing Styles; Using Numbered Lists with Styles; Applying Table Styles. Jumping to a Specific Element (Page, Section, Comment, etc.) Creating Multilevel Numbered Lists Expand/Collapse In Print Layout View Viewing & Structuring your Document Using the Navigation Pane Outlining Restricting Formatting Finding and Replacing Formats Finding and Replacing Special Characters (Tabs, Spaces, etc.) Options when Pasting Inserting Entire Documents Creating a Table of Contents; Updating a Table of Contents. Creating an Index; Generating an Index; Updating an Index Creating a Bookmark; Going to/Selecting Bookmarked Text; Using Bookmarks to Refer to Pages. Section Breaks: Inserting a Section Break; Changing Page Numbering Mid-Document; Changing Headers and Footers; Changing Page Setup in a Section. Inserting a Footnote/Endnote.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced features of Microsoft Office PowerPoint 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: Adding Placeholders to a Slide Master Adding Master Level Guides Adding a Customized Layout Creating and Changing Personal Templates Organizing Slides with Sections Inserting an Excel Table WordArt Effects Recoloring a Picture Inserting an Audio Clip Inserting a Video Merging Shapes Ungrouping Clip Art Creating a Button to Jump to Another Slide or File During a Slide Show Hiding Slides Displaying the Animation Pane Reordering Animations Removing or Modifying Animations Previewing Animations Using the Animation Painter Syncing Animation/Text Overlays with Audio/Video Annotations During a Slide Show Saving Different Slide Orders Setting up a Self Running Show Setting Timings by Viewing the Show Recording Narration Compressing Media Files Packaging Presentations on a CD/USB Drive Saving a Presentation as a Video Broadcasting Your Presentation on the Web. This guide is one of two titles available for PowerPoint 2013: PowerPoint 2013 Introduction, PowerPoint 2013 Advanced.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Word 2013. The following topics are covered: Margins, Orientation, and Paper Size Moving and Copying Text Formatting Text with the Mini Toolbar & Touch MiniBar Spacing between Paragraphs Creating Bulleted Lists Changing Bullet Style Creating Numbered Lists Turning off Bullets or Numbering Paragraph Alignment Copying Formatting Searching using the Navigation Pane Finding and Replacing Text Jumping to Other Pages Resuming Reading Read Mode, Print Layout, and Draft View Using the Highlighter Using the Dictionary and Thesaurus Creating and Inserting Quick Part Building Blocks Inserting a Cover Page Creating and Editing Headers and Footers; Suppress/Change Header or Footer on the First Page Inserting a Page Number Inserting a Text Box: Drawing a Text Box, Moving, Resizing, Formatting, and Deleting a Text Box Inserting a Page Break Checking Spelling, Grammar, AutoCorrect Previewing and Printing Documents Printing Envelopes and Labels. Also includes: Lists of Touch Actions, Selection and Movement Shortcuts, Editing and Formatting Shortcuts.