MS Excel Intermediate

Home / MS Excel Intermediate

MS Excel Intermediate

Event Location / Date & Time: Raheen, 8th February 2018 (09:30-16:30)

Seat Rate: 10

MS Excel Intermediate

Duration: 1 Day

Date: Thurs 8th February 2018

Times: 09:30 to 16:30

Venue: Portal House, Raheen Business Park, Limerick

Course Fee: €120 per person (includes 20% skillnet funding)

Course Outline:

This Microsoft Excel Intermediate training course is designed for anyone who wants to improve his or her knowledge of Microsoft Excel. Participants will learn topics like logical, statistical functions, VLookups, creating the templates, charts and an introduction to pivot tables which will improve their efficiency and productivity in the workplace.

Course Content:

Setup & Printing Issues (Worksheet Setup, Headers and Footers, Scaling Your Worksheet to Fit a Page(s), Printing Titles On Every Page, Printing the Row and Column Headings, Spell Checking, Previewing a Worksheet, Viewing Workbooks Side By Side, Printing Options)

Functions and Formulas  (Getting Help With Functions, Nested Functions, Mixed References within Formulas)

Time & Date Functions (TODAY, NOW, DAY, MONTH, YEAR)


Logical Functions (IF, AND, OR)

Lookup Functions (VLOOKUP)

Text to columns
Named Ranges (Naming Cell Ranges, Removing a Named Range, Named Cell Ranges and Functions)

Cell Formatting (Applying Styles to a Range, Conditional Formatting, Custom Number Formats)

Manipulating Worksheets  (Copying or Moving Worksheets, Splitting a Window, Hiding Rows, Columns & Worksheets)

Templates (Creating Excel Templates, Editing Excel Templates)

Paste Special Options (Using Paste Special to Add, Subtract, Multiply & Divide, Using Paste Special ‘Values’, Using Paste Special Transpose Option)

Database & List Management – Sorting and Filtering Data (Sorting Data by Multiple Columns, Custom Sorts, Customized List, AutoFilter)


To book a place, please contact Anne 061 217608 or Kinga 061 217601

Facebook By Weblizar Powered By Weblizar

Can We Help You?

To find out more information or to discuss how Limerick Chamber and Limerick Skillnet can aid you in your business and training needs please contact us.

Contact Us ›