Excel 365

Excel 365

Course

Course Description

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

The purpose of this award is to equip the learner with the knowledge, skill and competence to create and modify spreadsheets under supervision, using common spreadsheet features.

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.

COURSE OUTLINE

This course is divided into modules and lessons, each focusing on key topics, which are broken down into easy-to-follow concepts.

Throughout the course, you will be given activities to complete to help you summarise what you have learnt and appraise your understanding.

There are thirteen modules within the course and information on what is covered is as follows:

  • Getting to Know Excel
  • Creating Workbooks
  • Getting Help in Excel 365
  • A Closer Look at Formulas
  • Using Formulas and Functions
  • Working with Data
  • Working with Rows and Columns
  • Sorting and Filtering Data
  • Formatting Text
  • Formatting Cells
  • Aligning Cell Content
  • Search for and Replace Data
  • Spell Check a Worksheet
  • Define Basic Page Layout for a Workbook
  • Refine Page Layout and Apply Print Options
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
  • General and Language Options
  • Formula Options
  • Proofing and Save Options
  • Ribbon and Quick Access Toolbar
  • Understanding and Enabling Add-Ins
  • Advanced and Trust Center Options
  • Apply Range Names
  • Use Specialized Functions
  • Text Functions
  • Logical Functions
  • Lookup Functions
  • Date Functions
  • Financial Functions
  • Create and Format Tables
  • Modifying Tables
  • Table References
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts
  • Create a PivotTable
  • Filter Data Using Slicers
  • Analyse Data with PivotCharts
  • Insert and Modify Graphic Objects
  • Layer and Group Graphical Objects
  • Incorporate SmartArt
  • Managing Workbook Properties
  • Working with Macros
  • Create and Use a Template
  • Use Data Validation in a Workbook

Course Details

TARGET AUDIENCEThis course is suitable for beginners and is ideal for anyone who wants to propel their data processing skills to an advanced level.
CAREER PATHExcel is used in a wide range of careers such as Office Administration, PA roles as well as finances roles such as Bookkeeping or Finance Assistant.
COURSE DURATION35 Hours

(Actual course duration may vary based on prior skills and application)

CPD POINTS35

(Awarded CPD points upon successful completion)

PREREQUISITESThis course assumes the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu.

No previous experience with other versions of Microsoft Excel is necessary.

Talk to a Course Advisor

Our promise is for honest and helpful advice at all times, even if that means recommending another training provider or perhaps recommending alternatives to training. We’re here to help you reach your career and training goals.

Enrolment Procedure

  • 1. Contact our Training Team

    Talk to one of our expert training administrators today and let them guide you on the first steps needed for you to achieve the career of your dreams. Contact us on any of the following:

  • 2. Book an Appointment

    Arrange a call with our Course Advisors all of whom have years of experience helping and guiding students achieve their dream jobs!

  • 3. Enrol and Start Your Course

    Sign up, complete the induction training with your tutor and you’re ready to go! You will complete one career focused module at a time until you’ve gained all the skills you need and are ready to graduate and get that job!

  • 4. Graduate & Avail of Career Services

    As part of the training, Fluirse Career College will provide you not only with the skills for your new career but also the skills to get that new career. During the course we will teach you interview skills, job hunting skills and CV hints and tips!

  • 5. Get that Job and Achieve your Goal

    Take that first step and get in touch with us today!

Book an Appointment

Book a free 45 minute online meeting with one of the professional Career & Course Advisors. At this meeting we can help advise and guide you on a large range of flexible training programmes, as well as advise on your career and training objectives.

Training Information

Courses: Diplomas consists of several in-depth courses, each allowing you to gain valuable knowledge and skills.

Format: Courses are divided into modules and lessons, each focusing on key topics, which are broken down into easy-to-follow concepts. Throughout each course, complete interactive activities to help you summarise what you have learnt and appraise your understanding.

Pre-Requisites: There are no specific experience or qualifications requirements before starting your training.

Training Period: Once enrolled on the course, you have 12 months to complete all courses within this training programme.

Course Length: On average each course requires approximately 15-20 hours of study.

Assessment Criteria:  Assessments are scheduled only when you are ready. There are no final exams, continual assessments are included through each course with a test at the end of each course.

Course Fees: Fees can be paid in advance or you can select a range of flexible instalment plans. Fees vary depending on what options are selected. You can speak to any of our  Course Advisors to get a detailed breakdown of course fees and instalment plan options.

Support: Our Support teams are on hand to answer all your queries, either by phone, e-mail or video (shared screen) support.

Support Centres: You can always visit any of our training centres located throughout Ireland.

Career Path: After graduating from this programme, students can expect to compete and secure roles in key Leadership and Management positions across many industries. Ask one of our Course Advisors for a list of roles where our graduates are employed.

Certification: Upon successful completion of each course you will receive a certificate. Once you complete all courses within your training programme, you will receive an internationally recognised accredited Certificate or Diploma to verify your achievement.

Why Train With Us?

  • Providing Career Focused Training Since 2007

    Train when and where it suits you: from your Laptop, Phone or Tablet

  • A Wide range of Diplomas Now Enrolling

    We offer over a wide range of diplomas and courses designed specifically for career development

  • Internationally Accredited Training

    Internationally accredited professional training that will help you get the career of your dreams

  • 14 Day No Quibble Refund Option On All Courses

    Full course fees refund if you’re not happy for any reason within 14 days of enrolment

  • All Online Training Supported By Real People!

    All our training is fully supported by 100% native English speaking tutors so you are never training alone

  • Award Winning International Organisation

    Winner of “Best Online Education Experience” at the Education Awards 2022

  • 5 Star Reviews

    People love training with us! Our average review score is 5/5

Frequently Asked Questions

Flúirse Career College is a multi-award-winning company based in Ireland specializing in the delivery of career focused training. Founded in July 2005 by Kristian O’Donovan and Tomás Finneran.

Yes

We are proud to be based in Ireland, with training centres in Kerry, Cork, Waterford, Wexford, Laois, Carlow, Wicklow and most recently in Ennis, Clare.

Although the courses are delivered online they are different to traditional “online” courses that offer no real support. Our Course Advisors and Tutors are always on-hand to guide you through your courses and help you at each step of your career path.

  • Fluirse Career College
  • CPD Standards

Students with Fluirse Career College have access to a full range of Career Services including: CV Clinics, Job Application support and Interview Skills

More questions? Check our FAQ Section.

What Our Students Say