Microsoft Excel Advanced Training Micro Courses

Learn how to use and be proficient at using Microsoft Excel advanced skills including:

Error checking rules, customising the ribbon, quick access toolbar. databases, field and record delimiters, headers, records, fields, flat file vs relational data, Filtering and sorting data, data formats, Comma Separated Values (CSV), TXT, Tab separated values, open data in Office software programs, Naming Ranges, using Named Ranges in formulas & functions, Data validation and drop down lists and mastering find and replace.

Understand 3D formulas between worksheets, Clean up data using advanced filter,
Create a pivot table and change the value field settings, Create a pivot chart for data analysis to show stats and trends, advanced functions, CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, advanced functions within functions (Nested Functions) and How to protect the worksheet and workbooks.

Find out how much you can afford to pay for a house using goal seek and financial functions, Consolidate information from several sheets, grouping data, use Excel solver to explore possible outcomes depending on input variables, forecast future income, IRR (Internal rate of return), NPV (Net present value) and other financial functions