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 more. Video Transcript In this section I’m going starting off exactly from where I left off in the previous section. I closed the workbook that I just created

read more

How to Create a Spreadsheet in Microsoft Excel 2016

During this Microsoft Excel 2016 training tutorial video, 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, intermediate and advanced learners. Click here to learn more. Video Transcript As I mentioned before I’m actually using Windows 10 here. And

read more

How to Create Charts and Graphs in Microsoft Excel 2016 Tutorial

During this Microsoft Excel 2016 training tutorial video by Simon Sez IT, we will demonstrate 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. Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn more. Video transcripts: In this section we’re going to start to

read more

How to Add Tasks in Microsoft Project 2016

Synopsis: Creating tasks in your Microsoft Project is as easy as 1, 2, 3. In this Microsoft Project 2016 tutorial, you will learn how to add task names using the Entry Bar, how to adjust column widths to suit your specific requirements, and what task IDs are for. Microsoft Project (or what others call “project pro”) makes event planning a lot easier and less burdensome. Its features for monitoring each task’s progress and the manner of laying out the big picture makes MS Project 2016 a

read more

How to Navigate the Microsoft Project 2016 Workspace

Synopsis: In this how-to article, we'll share insight into using workspace options in Microsoft Project 2016. Among the options we'll cover, you'll find these features to be some of the most common and easy to navigate: Project Templates, Quick Access Toolbar, standard Windows options, Entry Bar, Timeline, Main Project Window, Status Bar, View Controls and Backstage View. Workspace Options As a user of Microsoft Office 2016, you'll benefit from a solid grasp of all the options available in

read more

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. One of the greatest strengths of Excel is its ability to provide formulas and functions that always come in handy in situations that call for calculation. In fact, one of the reasons many people

read more

How to Add Resources to Microsoft Project 2016

Synopsis: In Microsoft Project 2016, the term “resources” refers to the people involved in the project, the equipment and material used, cost associated with the project, and other types of resources. In this tutorial, you will learn how to add resources to Microsoft Project 2016. In Microsoft Project 2016, the term “resources” refers to the people involved in the project, the equipment and material used, cost associated with the project, and other types of resources. Under the View tab of

read more

How to Link and Unlink Tasks in Microsoft Project 2016

Synopsis: In Microsoft Project 2016, a dependency reflects the fact that some things happening depend on other things happening. The simplest type is where one task cannot start until another task finishes. However, there can be complex dependencies too. In this Microsoft Project 2016 tutorial, you will learn the process of linking and unlinking tasks Whatever type of Microsoft Project you are working on, there will be instances when a task would largely depend on another task, or a

read more

Using Burndown Reports with Microsoft Project 2013

Synopsis: A Burndown Report includes graphical comparisons of planned, completed and remaining work and tasks. In this article we look at how to use this newly-introduced feature of Project 2013. Burndown Reports have become popular amongst users of lighter project management methodologies, but they can provide useful information in an easily-understood form whatever your approach to your projects. Here is a sample building project that is well behind schedule. Bad weather has delayed work on

read more

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, whether Outlook prompts the user before Archiving, and selecting Age Limits for Archiving. Manual Archiving

read more

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 pages can be done through the Pages pane as well as through the Move command. Similarly, pages can be Renamed or Deleted through the

read more

"30-Day Money Back
Guarantee"

Notify us within 30 days of subscribing and you will receive a full refund with no questions asked

Subscribe for 1 Year and Get VIP Access

Subscribe to our free newsletter for free videos and other tips: