Microsoft Excel Level 3 - Advanced Excel

1. Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video 

2. Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again   

3. Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare

Excel 2016 training video on how to create custom views of your worksheet, or for example, be able to show or hide parts of your worksheet and set that as a custom view.

Excel 2016 training video on how to record and copy a Macro from one workbook to another. Macros are a series of recorded actions that can be played back, or ran in a single click; thereby, helping you save time by not having to repeat the same steps over again yourself!

Excel 2016 training video on how to edit a Macro.

Excel 2016 training video on the differences between Absolute and Relative referencing (references) in conjunction with recording a Macro.

Excel training video on how to use formulas, or functions with Conditional Formatting to apply formatting, based upon a condition you specify, to a cell, or range of cells.

Excel training video on how to quickly analyze a range of selected cells by using the Quick Analysis Tool, which includes shortcuts to: Formatting, Charts, Totals, Tables and Sparklines.

Microsoft Excel 2016 training video on Data Validation, which is data that has to be met within a certain condition, or criteria you set, or it cannot be entered into a cell. In other words, you can control a user's input to a degree that will result in more accurate data entry by locking, or blocking certain ranges or types of data into a cell. To validate the entered data.

Microsoft Windows 7 training video on how to password protect your worksheet from anyone editing, or making changes to it. Lock your cells and then password protect, as well as how to unlocking your cells prior to password protecting your worksheet for those cells you'd like to remain editable by others.

Excel 2016 training video on how to password protect cells, preventing other users from editing selected cells without a password.

Excel 2016 training video on the Document Inspector, which will find and remove personal, or hidden information quickly.

Excel 2016 training video on protecting the workbook structure, which will prevent other users from adding, deleting, moving, renaming, coloring, hiding worksheets in Excel by protecting the workbook with a password.

Excel 2016 training video on how to require a password to open, and/or modify your Excel workbook.

Excel 2016 training video on how to have Excel always create a backup of your workbook automatically.

Excel 2016 training video on how to share your workbook with others, and be able to have more than one person work on it at the same time across your network.

Excel 2016 training video on Microsoft's OneDrive, and how to upload, share and set permissions to your Excel workbook using Microsoft's OneDrive.

Excel 2016 training video on how to keep track of any changes made to your workbook, and then be able to accept or reject those changes quickly.

Excel 2016 training video on how to password protect and share your workbook with others, and keeping them from turning off the Track Changes feature; and to always keep track of any changes anyone makes to your workbook.

Excel 2016 training video on how to merge one workbook into another to compare differences between the two and also be able to accept, or reject any changes quickly.

Excel 2016 training video on Digital Signatures, or Digital ID, which is used to confirm the identity of the person who sent you the workbook.

Excel 2016 training video on the Mark as Final feature, and how to let other users know that the workbook is a final draft and prevent any inadvertent changes by making it read-only; however, users can make changes if they go out of their way to remove the Mark as Final feature.

Excel 2016 training video on Trace Dependents, Precedents and Errors. Dependents: Excel traces an arrow from a cell, like one containing a formula, to those cells it's "dependent" upon. Precedents: shows arrows that indicate which cells affect the value of the currently selected cell . Error: shows arrows indicating which cells affect the error value of the currently selected cell.

Excel training video on the Troubleshoot Invalid Data feature, which circles invalid data, or data that doesn't meet the criteria set from the Data Validation feature being applied to a cell, or range of cells.

Excel training video on Watch Windows and Evaluate Formulas. The Watch Windows allows you to watch formulas in any cell, from anywhere in your worksheet in one small window. The Evaluate Formulas allows you to step by step go through each part of a formula or function.

Excel training video on how to Outline and Group a range of cells where you can expand the range for data details, or collapse it for the subtotals and totals.

Excel 2016 training video on Sparklines, which are small line charts you can insert into a cell for a selected row.

Excel training video on the New Excel 2016 3D Map! Which allows you to visually plot your data on a 3D map by geographical regions as well as over time. Even create visual tours!

Excel training video on the Data Table, which starts off with you creating a table of varying values, that you then can use in conjunction with a formula, that will in turn display the results of each changing value in an adjacent range. For example, you create a table of 10 different interest rates, then using the PMT function you find out the monthly payment of the first the interest rate; however, with the Data Table feature you can instantly see the results of all 10 of the interest rates calculated into each monthly payment.

Excel 2016 tutorial on the Scenario Manager that allows you to create different groups of values, or scenarios and switch between them.

Excel 2016 training video on Forecast Sheet, and how to take historical date and, or time based data to create a graphical projection of future trends.

Excel 2016 training video on Goal Seek, which is used to find the right input for the value you want out of a formula or function.

Excel 2016 training video on the Solver Add-in, and how you can set the value(s) you want a function to return.

Excel 2016 training video on the Sampling, and how to pick out a random number from a range of numbers.

Excel training video on the RAND function in conjunction with the Advanced Filter feature, and how to return a random number from a range of cells.

Excel training video on Descriptive Statistics, and how to display a sampling of common statistics for a range of data including: MIN, MAX, SUM, COUNT and more functions!

Excel 2016 training video on Power View, and how to create attractive visualizations and reports of your worksheets with special emphasis on variables that are useful to you in a separate worksheet. Elements that can be added to a Power View worksheet include: charts, maps, KPIs or Key Performance Indicators and Hierarchies.

Excel 2016 training video on Consolidating Data, and how to summarize data from separate ranges, consolidating results in a single output range.

Excel training video on Link Workbooks, and how to link data, or cells from one workbook into another that will automatically update with to changes made.

Excel 2016 training video on Form Data, and how to use it to help data entry into worksheets with many columns in a single window, and not have to scroll horizontally to enter data at the end of long rows.

Excel training video on Export Data, and how to export your data into a text file, either to then reimport into another database that won't import directly from Excel, or because you'd like to view and, or edit it in Microsoft's Word.

Excel 2016 training video on on Import Text File, and how to import those data files exported into a text file from another program, or even from Excel.

Excel training video on Power Pivot, and how to use is as another way to import data into Excel. It's a more robust way to manage external data through the PowerPivot, as you can filter data, and rename columns & tables.

Excel 2016 training video on Publish to Web, and how to publish your Excel worksheet as a web page to be viewed on the web.

Excel training video on XML or Extensible Markup Language, and how to use it to convert Excel data into the XML file format that is a friendly language which most programs can import from; as well as how to import an XML file into Excel.

Excel training video on Advanced Custom Number Format, and how to add: symbols, text and color formats to your numbers.

Excel training video on Camera, and how to copy a range of cells into a picture, which is linked back to the selected range. So, anytime the cell's data change, the picture will update with those changes.