EXcel Logo> Microsoft Excel Courses and Training


Many people receive Excel spreadsheets with their sales figures and often don't know how it has been put together. Learn what a day's Excel training can do - how to present your work in the best way, centre headings, write formulae, create running totals, insert rows and columns, merge cells, insert charts and graphs, and use its data processing features. Or alternatively, increase your knowledge of how to write formulae, functions, pivot tables and more.

Beginners

  • Introduction to Excel 2000, 2003, 2007, 2010, 2013, 2016
  • Crossover to Microsoft Excel 2013 or 2016
  • Creating, editing and saving an Excel spreadsheet
  • Page layout - margins, landscape, portrait, fit to size, gridlines
  • Autofill and Autolists
  • Column and Row inserting, deleting, moving
  • Print features
  • Header/footer
  • Basic Formula writing - relative and absolute
  • Sum, count, max, min functions
  • Linking worksheets
  • AutoSum and other functions
  • Date and Currency formats
  • Useful shortcut codes for quick navigation of your text and for editing purposes
  • Create charts and graphs
  • Autofilter and sorting
  • Conditional Formatting

Intermediate

  • Excel Spreadsheet Layout enhancements and customisation - formatting cells, spacing, alignment, borders
  • Advanced chart and graph presentation - manipulating data, formatting text, enhancing layout
  • Custom Number formats
  • Using comments
  • The MDAS rule
  • Use of Function Wizard - writing formulas
  • If and lookup functions
  • Customised filters and autofilters
  • Managing large Excel spreadsheets effectively - linking, naming cells, using names in formulas
  • Paste Special
  • Freeze panes
  • More Printing options
  • Validation, lists and input messages
  • Custom lists

Advanced

  • Creating, editing and running Macros
  • Tracking and auditing
  • Forms
  • Error messages in formulas
  • Conditional formatting
  • Nested functions
  • Match, FV, PMT functions
  • Nested if statements
  • V and hlookups
  • Input Data Tables
  • Pivot tables
  • Subtotals
  • Advanced filters
  • Importing external data
  • Exporting data
  • Inserting pictures and hyperlinks
  • Default customisation of Excel spreadsheet layout
  • Using styles

Ask for an Excel Spreadsheets Course Content Sheet and I will design a course specifically for you.

Top of Page