Microsoft Excel 2010 - Intermediate/Advanced (Tailored) - On-Site Course

This is an onsite course catering for up to 10 delegates

The course is designed to enhance the skills level of the delegate with a mixture of intermediate and advanced features taken from the 1 day Intermediate and Advanced courses.  

More details

More info

Prerequisites:

Excel Introduction or experience in the work place

Course Outline

  • Absolute & Relative References
  • Custom Cell Formats
  • Sparklines
  • Linking Worksheets & Workbooks with Formulas
  • Working with Excel Functions
  • Finding Excel Functions
  • Logical Functions (IF, AND, OR)
  • Math Functions
  • Statistical Functions
  • Date and Time Functions
  • Text Functions
  • Advanced Functions (LOOKUPS & Nested Functions)
  • Creating Charts
  • Customising Chart Appearance
  • Adding Data to a Chart
  • Macros
  • Using Templates
  • Data Validation
  • Custom Lists
  • Saving a Workspace
  • Formula Auditing
  • Protecting your Spreadsheets
  • Summarising Data
  • Using Analysis Tools
  • Importing & Exporting Data

£ 895.00 ex.vat

Excel 2010 Intermediate Advanced

Excel 2010 Intermediate Advanced (Tailored)_en

Download (90.79k)

Data sheet

Course Duration 1 Day
Location Various