Microsoft Excel
Excel Crash Course – Learn Pivot Tables in 1 Hour
In this Excel crash course, pivot table tutorial, excel aficionado Deb Ashby shows you: How to prepare and clean your Excel data for your pivot table How to use recommended PivotTables and create a pivot table from scratch How to format, edit and display different results in a pivot table How to create a chart…
An Introduction to Excel Functions Using Excel 2016
If you are an office administrator, financial analyst, or salesmen, you probably use Microsoft Office Excel. For these, along with many other professions, working with spreadsheet are not only an essential tool, but also a daily routine. If you are an office administrator, financial analyst, or salesmen, you probably use Microsoft Office Excel. For these,…
Using Dates and Times with Microsoft Excel 2016
Microsoft Office Excel’s date and time functions are one of the most common data types that people work with. Unfortunately, they are also the most frustrating. This is especially true if you are still new to Excel. This is because the creators of Excel decided to use a serial number for date representation, instead of…
How to Use the LOOKUP Function with CHOOSE in Excel 2016
As the name implies, the Microsoft Office Excel LOOKUP function is used to look up a specific value located in an index or list and returned the identified value to a particular cell. This can be useful in a variety of problem-solving applications, that require a representation of a specific value or response. Lookup/Reference Purpose…
How to Use the Vertical Lookup Function in Excel 2016
In the previous section we examined Lookup Functions and their use within a horizontal list of values (HLOOKUP). Today we are going to examine a vertical list of values to lookup (VLOOKUP). Their functions are similar in nature, the only difference being a vertical versus a horizontal lookup direction. However, we are also going to…
How to Use Flash Fill With Microsoft Excel 2013
Microsoft Excel 2013 has reinvented the old formula system of previous versions. It used to be that in order to change the information in one column, one had to write a code or formula to teach Excel what was wanted. With flash fill, Excel is able to extrapolate from one cell to the entire block…
How to Create Invoices Using Microsoft Excel 2013
Creating effective, powerful invoices has long been a primary function of Excel. In Excel 2013, it is even easier to move information across tables and even workbooks, saving time and effort. Instead of having to find the customer information from another worksheet and type it in, you can tell Excel to automatically dig this up…
How to Use Logical Functions in Microsoft Excel 2013
In Excel 2013, some brand new logical features are enabling Excel to accurately predict and modify calculations. By employing variations in the VLOOKUP function, Excel is able to perform such two-step logical functions as determining when to apply a discount to a customer’s invoice and when not to. The new logical features are handy when…
How to Print and Use Printing Features in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, discover printing options when printing from Excel 2016. FacebookLinkedinTwitter 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 take a look at printing and…
Workbook Views and Using the Zoom Feature in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, you will learn about the different workbook views and how you can use them. We will also demontsrate zooming in/out and freezing panes. Facebook LinkedinTwitter Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn…
How to Backup and Recover Your Spreadsheets in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, we will discuss the different ways in which you can backup and recover your Excel spreadsheets. We will show you how you can autosave your work, recover unsaved workbooks, autorecover a file location and create a backup copy of a file. Like what you see? Get our…
How to Delete and Add Rows and Columns in Microsoft Excel 2016
During this Microsoft Excel 2016 training tutorial video, you will learn how to insert and remove rows and columns. FacebookLinkedinTwitte 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 and the next couple of sections…
