Microsoft Excel Advanced Training Micro Courses

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

Working with Data using Microsoft Excel

• 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.

Advanced Certificate Formulas using Microsoft Excel

• 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.

Practical Financial Formulas and Case Studies in Advanced Excel Course

• 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