An organisation development specialistLinked In

Excel Intermediate 2007

Duration 1 day


Designed for

Users wishing to extend their knowledge of the features and functions available within this program.

Pre-requisites

Delegates should have attended the introductory course or have gained similar knowledge and experience in the workplace. Delegates must be able to create their own formulas without the aid of the wizard and be familiar with Absolute and Relative referencing.

Course Aims

By the end of this course delegates will be able to build complex spreadsheets which link via formulae, together with being able to construct functions which incorporate logic into the statement. An element of automation is also examined so that repetitive sheets can be recreated with minimal effort. Delegates will also be shown the ‘database’ capabilities and be able to manipulate data to give various outputs.

Course Contents

  • Customising toolbars
  • Freezing panes, Splitting Panes, Comparing Workbooks and Saving Workspace
  • Comments
  • Styles, Backgrounds and Printing Titles
  • Visual Interpretation with Smart Art and Shared Charting
  • Templates (including Chart Templates)
  • Structured References
  • Multiple Worksheets -v- Multiple Workbooks
  • Group editing
  • 3D Formulas
  • Linking Worksheets/Workbooks
  • IF and Nested IF Functions (including Rich Conditional Formatting)
  • Date/Time Functions
  • Lookup Functions
  • Outlining
  • Managing lists (Database)
  • Using Data Forms
  • Sorting Records
  • Automatic filtering
  • Advanced Filtering
  • Extracting Records
  • Subtotaling and Total Rows
  • Saving to PDF & XPS
More