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

Showing all 4 results

Showing all 4 results