Excel: Working with arrays, macros and VBA

  • Excel 2010 icon course pack | Oxford only | v. 2010

Want to do some frequency distribution? Then learn to use arrays and array formulae.

Want to learn to create dynamic charts that update automatically as you add rows of data? Not easy, but you'll learn how on this course.

Do those repeated tasks bore you? Automate the process with macros. Once you've mastered macros, learn to change the macro with code and VBA.