Search Engine Optimisation Course

Search Engine Optimization Claim 100% Fees with SkillConnect Grant

Other Microsoft Excel Courses

  • Get Advanced Excel
Click Here to Register

Advanced Excel 2013 Course Outlines

Advanced Excel functions and formulas

  • Logical functions
  • Conditional functions
  • Financial functions
  • Text functions
  • Date functions
  • Array formulas

PivotTables and PivotCharts

  • Working with Pivot Tables
  • Rearranging Pivot Tables
  • Formatting Pivot Tables
  • PivotCharts

Lookups and data tables

  • Using lookup functions
  • Using MATCH and INDEX
  • Creating data tables

Exporting and importing data

  • Exporting and importing text files
  • Getting external data

Advanced data management

  • Validating cell entries
  • Advanced filtering

Analytical tools

  • Goal Seek
  • Scenarios

Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphical objects

Macros and Visual Basic

  • Running and recording a macro
  • Working with VBA code

Accessibility and language features

  • Accessibility consideration
  • Internationalization

Our Clients