Microsoft Excel Training Northern Ireland

Intermediate Level

Our standard course outline for this course is shown below, however, we are able to adapt the contents to suit your specific needs as required. Please contact us for more details

• Viewing Worksheets
  • Customising View Options
  • Displaying And Customising Toolbars
  • Hiding Workbooks And Worksheets
  • Freezing Panes
  • Grouping And Ungrouping Worksheets

• More Formatting Techniques
  • Using Styles
  • Conditional Formatting
  • Using The Format Painter
  • Using Guidelines
  • Hiding And Displaying Cells

• More Formulas and Functions
  • Using The Series Command
  • Using The Insert Function Wizard
  • Using The Excel Function Categories
  • Correcting Formulas
  • Using The Formula Error Checker
  • Using The Formula Auditing Toolbar
  • Using The Watch Window

• Database and List Management
  • Using Databases
  • Creating And Editing A Database
  • Sorting A Database
  • Using Autofilters
  • Advanced Filters
  • Working With Filtered Data
  • Using Data Forms

• Charts
  • Chart Wizard
  • Chart Toolbar
  • Working With Charts
  • Formatting The Chart

• Drawing and Picture Objects
  • Drawing Toolbar
  • Working With Autoshapes
  • Creating Text Boxes
  • Adding Pictures
  • Layering Objects
  • Grouping And Ungrouping Objects

• Excel 2003/2007 and Other Applications
  • Converting Files From Other Applications
  • Copying Data From Another Application
  • Embedding And Linking Objects
  • Hyperlinks
  • Managing Links

<- Back to Courses