Sign Up Now! Best Value Courses Enrolment opening soon for Summer Courses 2021! Sign Up Now! Get Up To 5 EPV Days DES Approved Sign Up Now! Delivering Online Courses in Ireland for over 16 years Sign Up Now! No Risk Guarantee.... 100% refund within 21 days of signing up

Important Information – Enrolment now open for 2021

To qualify for your EPV days* you can select from any of our practical and beneficial suite of courses. The more courses you select, the more EPV days you receive:

  • 1 online course – 3 EPV days entitlement
  • 2 online courses – 4 EPV days entitlement
  • 3 online courses – 5 EPV days entitlement

All our courses are run in accordance with the Department of Education and Skills criteria. Courses begin on Thursday, 1st July 2021 and must be completed by Friday, 20th August 2021 at 5.00pm.

Each course requires approximately 20 hours of study. The Discussion forums are facilitated by expert moderators. When you have successfully completed your course you will receive your CPD Certificate.

New for Summer 2021. This year we’re delighted to expand our offering to 50 highly practical and unique courses. All courses have been updated with updated and fresh content and an easy-to-navigate interface.

Purchasing courses: Courses may be purchased either online or by phone.

  • Each Individual course costs €69
  • Two courses will cost €89
  • Three courses will cost €99

Technical Support: Our Technical Support team are on hand to answer all your queries, either by phone or e-mail.

Online Forum: Check your Course Homepage

Email: [email protected]

Phone: 066 712 9828

Click here for a list of Frequently Asked Questions. For further queries, contact our team at [email protected] or 066 712 9828

*All courses subject to approval by the Dept of Education

Microsoft Excel 365

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

Learning Objectives

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

  • Get started with Microsoft Excel.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

 

  • Components / Modules

Module 1

1 – GETTING STARTED WITH EXCEL

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Excel Online

Topic E: Enter Cell Data

Topic F: Use Excel Help

2 – PERFORMING CALCULATIONS

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

3 – MODIFYING A WORKSHEET

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic B: Search for and Replace Data

Topic C: Use Proofing and Research Tools

4 – FORMATTING A WORKSHEET

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Colors, Borders, and Styles

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

5 – PRINTING WORKBOOKS

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

6 – MANAGING WORKBOOKS

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

Module 2

1 – WORKING WITH FUNCTIONS

Topic A: Work with Ranges

Topic B: Use Specialized Functions

Topic C: Work with Logical Functions

Topic D: Work with Date and Time Functions

Topic E: Work with Text Functions

2 – WORKING WITH LISTS

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data with Database Functions

Topic D: Outline and Subtotal Data

3 – ANALYZING DATA

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

4 – VISUALIZING DATA WITH CHARTS

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features

5 – USING PIVOTTABLES AND PIVOTCHARTS

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Timelines and Slicers

Module 3

1 – WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

Topic A: Use Links and External References

Topic B: Use 3-D References

Topic C: Consolidate Data

2 – SHARING AND PROTECTING WORKBOOKS

Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks

3 – AUTOMATING WORKBOOK FUNCTIONALITY

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

4 – USING LOOKUP FUNCTIONS AND FORMULA AUDITING

Topic A: Use Lookup Functions

Topic B: Trace Cells

Topic C: Watch and Evaluate Formulas

5 – FORECASTING DATA

Topic A: Determine Potential Outcomes Using Data Tables

Topic B: Determine Potential Outcomes Using Scenarios

Topic C: Use the Goal Seek Feature

Topic D: Forecast Data Trends

6- CREATING SPARKLINES AND MAPPING DATA

Topic A: Create Sparklines

Topic B: Map Data

  • Delivery Format The course consists of … modules which are studied online.