Cahir Training Centre are able to offer a rull range of IT and Non IT Courses.
Intermediate Excel
Our Intermediate Excel course will further develop your skills using excel to assist you in your work environment.
 

Charting

  • Creating & Modifying Charts
  • Formatting Charts
  • Creating Line & Pie Charts
  • Editing the Legend

Cell Comments

  • Inserting Comments
  • Displaying all Comments on sheet
  • Modifying & Moving Comments boxes
  • Printing Comment boxes on sheet.

Formatting

  • Merge Cells
  • Wrap Text in a Cell
  • Place text at an angle in a cell
  • Cell Backgrounds

Conditional Formatting

  • Applying Conditional Formatting
  • Deleting Conditional Formats

 

 

Hyperlinks

  • Creating hyperlinks to an Excel file
  • Creating links to specific sheet in file
  • Creating links to specific cells in a particular sheet with a file
  • Linking to named ranges
  • Linking to applications outside Excel
  • Removing hyperlinks

Sorting & Subtotaling

  • Sorting data on a spreadsheet
  • Creating subtotals on a spreadsheet
  • Removing subtotals

Auto Filter

  • Turning on the AutoFilter
  • Doing a Custom Filter

Graphic Objects

  • Using Graphic Objects in a spreadsheet

 

 
       
  Further course recommended ADVANCED Excel    
  back to courses    
 
ABOUT US | COURSES | SERVICES | NEWS & EVENTS | Booking Form | NEWSLETTER | Sitemap | HOME
ADDRESS: ENTERPRISE CENTRE, CAHIR, CO. TIPPERARY PHONE: 052 42616 Fax: 052 42772 E-MAIL: INFO@CAHIRDA.COM