Microsoft Office
Online Help and Contextual Help in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, we will show you where you can access Help in this version of Excel. You will find that Help is not available offline in Excel 2016, but rather online only. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced…
Complex Examples of Formulas in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, and we’re going to concentrate on a more complex example of the use of formulas. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn more. >> Video Transcript In this section we’re going to…
Basics of Formulas and Functions in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, discover the essentials for using formulas and functions. Your instructor will demonstrate the general principles of doing calculations in Excel 2016. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn more. >> Video Transcript…
Using the Tell Me Feature in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, we will discuss one of the new features in this version of Excel – Tell Me. We will demonstrate how you can utilize Tell Me and where to find additional help regarding this particular feature. Like what you see? Get our complete Microsoft Excel 2016 training courses…
How to Use Microsoft Excel 2016 Options
During this Microsoft Excel 2016 training tutorial video, you will learn how to personalize your use of this program through Excel Options. We will show you how to setup your own username, how to customize the office background and theme, how to modify the user interface options, how to set a default file location and…
How to Open a Workbook in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, we will show you how to open a saved workbook, as well as using Autosum, Series Fill, Undo and Redo, and Zooming in and out. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn…
How to Create a Spreadsheet in Microsoft Excel 2016
Watch this Microsoft Excel 2016 video tutorial, we will show you how to create, save and close a workbook. Additional topics include creating a shortcut by pinning Excel to the taskbar, and the importance of signing in to a Microsoft account. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner,…
How to Create Charts and Graphs in Microsoft Excel 2016
Watch about Microsoft Excel 2016 video tutorial by Simon Sez IT. Learn how to create different types of charts and graphs, such as a clustered column. We will also show you how to resize the chart, change its design, and move it to another worksheet or to a new chartsheet. Watch the free video here….
How to Use Microsoft Excel 2016 Formulas and Functions
Synopsis: One of the reasons many people fell in love with Excel is its sophisticated formula features. In this article, learn how to correctly type a formula in the Formula Bar. On top of that, get to know some of the commonly used formulas and functions when dealing with calculations in Excel 2016. FacebookLinkedinTwitter One…
How to Archive Email in Microsoft Outlook 2013
Archiving is an important process in Outlook 2013 and involves deleting or moving old files to a different file location. Outlook 2013 provides two ways to Archive: AutoArchiving and Manual Archiving. AutoArchiving can be done through the AutoArchiving Settings which contains an AutoArchiving Dialog. This dialog contains numerous options that control how often Outlook AutoArchives,…
Inserting, Reordering, Renaming and Deleting Pages in Publisher 2013
In Publisher 2013 there are several particularly important functions pertaining to pages: Insert, Reorder, Rename and Delete. Pages can be Inserted into publications through the Insert Tab as well as the Insert Page dialogue, allowing users to insert single or multiple pages into a publication either as blank documents or duplicates of existing pages. Reordering…
How to Insert Basic Shapes in Microsoft Publisher 2013
Inserting Basic Shapes is one method of editing publications in Publisher 2013, enabling users to add design elements as well as create illustrations and visual interest. In other words, Shapes are useful because they can greatly alter the look of a publication, and are themselves customizable. Shapes are Inserted through a Shape gallery in the…
