Excel Expert

Excel Expert

£379.00

This course will help you learn the more advanced workings and features of Microsoft Excel. You will look at functions such as macros, pivot tables, functions in formulas and more.

There are 17 modules in this course, below is a breakdown of what
each one covers:
  • Data calculations, watermarks, converting text to columns and flash fill.
  • Consolidating data, paste special, custom formats and working with ranges.
  • Hyperlinks and formatting charts.
  • Applying functions in formulas.
  • Conditional formatting.
  • Sort and filter data, subtotals and database functions.
  • Macros.
  • Data validation, precedent/dependent cells, tracing errors, evaluating formulas and the watch window.
  • Protecting worksheets and workbooks, passwords and file properties.
  • Sharing and merging workbooks and grouping and ungrouping data.
  • Pivot tables.
  • Pivot charts.
  • VLOOKUP, HLOOKUP, embedding and linking objects.
  • Scenario manager and data tables.
  • MATCH and INDEX, NOW and TODAY and COUNTA, COUNTBLANK and COUNTIF functions.
  • Using financial, nested and the CONCATENATE functions.
  • Create and modify custom workbook elements.
Product Options

Category Accounting