Course details

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.

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
Updated on 08 November, 2015

About Griffith College Dublin

Griffith Halls of Residence is purpose-built student accommodation located on the grounds of Griffith College Dublin.

About Griffith Halls of Residence

Griffith Halls of Residence is purpose-built student accommodation located on the grounds of Griffith College Dublin. Just 15 minutes' walk from Dublin city centre, Griffith Halls of Residence boasts an enviable central location that makes us ideal not just for Griffith students, but also students attending any of Dublin's universities or other third level institutions.

A message from the President of Griffith College.

I am delighted to welcome you to the Griffith College website.  Founded in 1974, Griffith College is Ireland’s largest independent college with 7,000 students from Ireland and across the world and their mission is to be a core of the community and a highly reputed center of education.  

At Griffith College their purpose is to set students on a course of change in their lives, leading them towards achieving their optimum potential.  Education should lead to a deep understanding of the subjects being studied as well as excellent exam results; the courses in Griffith College are taught with this in mind.  The College delivers internationally recognized undergraduate and postgraduate degree courses in a vibrant setting. Their record of prize winning students across a wide range of disciplines is testament to the dedication and professionalism of their lecturing and administrative teams.  I would encourage you to explore their website to discover the wide choice of opportunities they have to offer.

See all Griffith College Dublin courses
Are you from Griffith College Dublin ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or