Microsoft Excel
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 Create Pivot Charts in Excel 2013
The Pivot Chart in Excel 2013 is very similar to the Pivot Table, presenting comparable information in a more visually oriented manner; thus, Pivot Charts are useful for live presentations and meetings. Pivot Charts should be created from existing Pivot Tables through the Pivot Chart button, and necessarily Filters and other restrictions on the Pivot…
How to Create Charts and Graphs in Excel 2010 Using Design Tab
Excel 2010 possesses numerous options and tools which augment a user’s ability to create and edit charts and graphs. The Context Menu enables various chart options, and the Switch Row and Column command allows users to manually switch rows and columns in an Excel chart. Additionally, the Select Data button enables switching of the rows…
How to Create Charts and Graphs Using Excel 2010
Excel 2010 allows users to create charts and graphs through various commands and tools, specifically through multiple keyboard shortcuts available in Excel as well as the Insert Charts Dialogue. The dialogue is available in the Insert Tab’s Charts Group, which also contains various charts arranged categorically. The multiple chart types and presentations available in the…
Using Financial Functions in Microsoft Excel 2013
Microsoft Excel 2013 contains Functions that are useful in personal financial contexts pertaining to savings and loans, such as the PMT Function. This PMT Function calculates the periodic payments required to amortize a loan with a particular interest rate and a set number of payment periods. There are five Arguments associated with the PMT Function,…
How to Create Pivot Tables in Microsoft Excel 2013 – Part 2
Excel 2013 contains numerous options and new features for the Pivot Table functionality. Pivot Tables can be created through the Create Pivot Table Dialogue, and the existing tables from which a Pivot Table emerges are created, likewise, through the Create Table Dialogue. Users build up Pivot Tables by selecting data fields and dropping them into…
