Simply select your course first course and click “Add to cart”. You can choose a Foundation Award (3 courses), Standard Award (7 courses) or Diploma programme (10 courses + 1 elective course) simply by going to the relevant Training Programme page and clicking on “Add to Cart”.
This Microsoft Excel Advanced course will add to the skillsets obtained during the Microsoft Excel Fundamentals and Intermediate courses, which you can build upon to eventually become an expert in data manipulation.
This course incorporates some new features and connectivity to make collaboration and production as easy as possible. It will cover how to use Excel online, worksheet automation, auditing and error checking, data analysis and presentation, working with multiple workbooks, and exporting or sorting data.
|TARGET AUDIENCE:||This course is intended to help all users get up to speed quickly on the advanced features of Excel.|
|CAREER PATH||By the end of this course, participants will be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking their work, working in multiple workbooks, and accessing and distributing data.|
|COURSE DURATION:||10 Hours (Actual course duration may vary based on prior skills and application)|
|PROGRESSION OPTIONS:||Build on this certificate by upgrading to a foundation award, standard award or diploma|
For more information or request a prospectus by clicking below:
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 six modules within the course and information on what is covered is as follows:
Module 1: Excel Online
- Accessing and Using Excel Online
- Features that Differ Between Excel Online and the Excel Desktop Application
Module 2: Worksheet Automation
- Managing Workbook Properties
- Working with Macros
- Create and Use a Template
- Use Data Validation in a Workbook
Module 3: Auditing and Error Checking
- Tracing Cells
- Error Checking
- Evaluating Formulas and Using the Watch Window
- Data List Outlines
Module 4: Data Analysis and Presentation
- Quick Analysis Tool
- Adding Sparklines
- What-If Analysis
- The Analysis ToolPak
Module 5: Working with Multiple Workbooks
- Arrange Workbooks
- Linking to Data in Multiple Workbooks
- Consolidating Data
Module 6: Exporting and Sourcing Data
- Exporting Data
- Using Data Sources
- Use a Microsoft Form for Data Collection
Courses: Each course is approximately 7-10 hours in guideline training time including time for offline reading and assessments. By completing additional courses within the required training period, you can easily progress to achieve additional qualifications including a Flúirse Foundation Award, Flúirse Standard Award or a Flúirse Diploma.
Qualification Paths: By successfully completing any course, you will qualify for a Flúirse Certificate in that course topic. Completing 3 courses within a 12 month period in the same category will qualify for a Flúirse Foundation Award. Completing 7 courses in the same category within 18 months qualifies for a Flúirse Standard Award and ultimately completing 10 courses in the same sector with 1 elective course (any course from any category) within 24 months qualifies for a Flúirse Diploma.
Format: Courses are delivered 100% online so you can train in your own time and at your own pace. Each is 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. For those with experience in any of the course topics, you are encouraged to move quickly though any aspects of the course content that are familiar and to focus instead on areas where the content is new or less familiar.
Training Period: Once enrolled on any single course, you have 6 months to complete all courses within this training programme. For Foundation Awards (3 course) you have 12 months and for Standard Awards (7 course) you have 18 months. Diploma programmes (11 courses) have 24 months. We recommend spending at least 1 hour each week training meaning you can always complete your training well before the deadline.
Course Length: On average each course requires approximately 7-10 hours of study. This certificate training programme consists of 10 guideline hours which on average takes no more than 10 weeks to complete with just 1 hour per week training part-time. Training is fully flexible and the entire course can be even completed in one session if preferred.
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 are paid online in advance or for schools or groups you can select a range of flexible instalment plans and a quote or invoice can be issued. Fees vary depending on the number of courses or training qualification 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 Monday – Friday, 9:30am – 5pm (excluding public holidays).
Career Support: After graduating from any Flúirse Diploma programmes, you can avail of free career support where our team will assist you in updating your CV and Linkedin profiles.
Certification: Upon successful completion of each course you have the opportunity to download you certificate. Once you complete all courses within your training programme you can request your Flúirse Award or Diploma certificate. Diploma certificates are posted to your home or school address.
Why Train With Us?
Frequently Asked Questions
All/CAREER SUPPORT/LOCATION & TRAINING CENTRES/QUALIFICATIONS & ACCREDITATION/TRAINING DELIVERY & FORMAT/
Are these online courses?
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 training journey. Once you are a student with Flúirse you are a student for life and will have access to all our career services at every stage of your career.
Where are you located / based?
Flúirse operates eight training centres in Ireland: Tralee, Co. Kerry , Airport East Business & Technology Park, Co. Cork, IDA Industrial Park, Waterford, Westpoint Business Park in Wexford, Kea Lew Business Park in Portlaoise, Wexford Road Business Park, Carlow and Tracklands Business Park, Ennis, Co. Clare
What qualifications will I get if I complete my training programme?
- Fluirse Teacher CPD
- CPD Standards
What Career Supports are available with my training?
Students with Flúirse have access to a full range of Career Services including: CV Clinics, Job Application support and Interview Skills
How are courses structured?
The courses contain several modules each of which is made up of individual lessons.
What are you expected to do to complete the course?
The course completion requirements are as follows:
Each lesson will contain self-assessment exercises to guide your progress and ensure your comprehension.
At the end of each module you will complete revision questions intended to prepare you for the final exam.
Before undertaking the final exam, you will be allowed to take a mock exam to practice until you are confident enough to complete the final exam.
When you are ready you may attempt the final exam to complete the course.
How much time will I have to complete each course?
Each individual course should take approximately 10 hours of online study.
You will be allowed up to 6 months to complete each individual course, with up to 24 month for a full diploma programme.
More questions? Check our FAQ Section.