Griffith College Logo

Microsoft Excel - Intermediate

Microsoft Excel - Intermediate

Overview

The intermediate course is designed to introduce new features of Excel that will enable users to be more exploitative of Excel 's features.

If you have attended or understand the concepts covered at introductory level, this course may be your next step. Its main focus is to introduce users to more functions and formulae writing and look at the interaction between Microsoft products. It covers Excel Database utility and looks at some of the easy to use Wizard features in Excel.

The course is designed to introduce new features of Excel that will enable users to be more exploitative of Excel 's features.  It provides participants with some experience of Microsoft Excel the opportunity to learn new Excel features in order to achieve more complex tasks.

 

Intake Dates

We run 2 intakes for this course commencing in Spring and Autumn.

  • January (date to be confirmed)*
  • September (date to be confirmed)*

*subject to sufficient numbers

See timetable for course dates.

Course details
Modules
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 Formulae
  • 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 and Other Applications
  • Converting Files from other Applications
  • Copying Data from Another Application
  • Embedding and Linking Objects
  • Hyperlinks
  • Managing Links

Course Contacts

If you have any questions please get in touch with us at [email protected] or 01 415 0429.

Timetables

Saturday 1 Day Course from 9:30am to 5pm

Year 2019

Jan: 26

This course is also available as customised training please contact [email protected] for further information about this option.

How to Apply

How to apply

Directly to Griffith College Short Courses Department

Fees

Study mode: Part time.

Fee: Available upon request.

CTA1

Ready to take the next step?