Top

Intermediate Excel

Home / Intermediate Excel

Intermediate Excel

Event Location / Date & Time: 27th September 2017 (09:30-16:30)

Duration: 1 Day

Date: Wed 27th September 2017

Times: 09:30 to 16:30

Venue: Portal House, Raheen Business Park, Limerick

Course Fee: €120 per person

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 introduction to pivot tables which will improve their efficiency and productivity in the work place.

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)

Functions (ROUND, ROUNDDOWN, ROUNDUP, SUMIF)

Logical Functions (IF, AND, OR)

Lookup Functions (VLOOKUP)
Statistical Functions (COUNT, COUNTA, COUNTIF, CONCATENATE)

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)

Subtotalling

To book a place, please contact Anne 061 217608 amorris@limerickchamber.ie or Kinga 061 217601 kdzierzak@limerickchamber.ie 

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 ›