Microsoft Excel and Access - QLS Endorsed
2 QLS Endorsed Course with Free Hardcopy Certificates| 80 CPD Points| Free Assessment & Tutor Support | Instant Access
Thames College
Summary
- Certificate of completion - Free
- Certificate of completion - Free
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
Add to basket or enquire
Overview
This Microsoft Excel and Access bundle will provide you with a solid foundation to become a competent worker in the relevant sector and pick up more useful skills. If you want to study more about the relevant fields, this Microsoft Excel and Access bundle is ideal for you. Learn more about the field and enter a world of limitless options.
The Microsoft Excel and Access bundle covers all the most recent areas to keep you updated on employment market developments and improve your knowledge of your preferred profession in the relevant sector. This excellent Microsoft Excel and Access bundle will improve your abilities by covering fundamental and advanced materials. As a result, you'll be more educated and certain in the relevant field after completing our Microsoft Excel and Access bundle.
The Microsoft Excel and Access bundle will help you improve your skills. You will learn all you need to know and have all of your questions answered with this thorough bundle. It offers several benefits to make your learning experience more enjoyable and less stressful and set you up for success. Add this course to your cart to increase your level of proficiency.
Learning Outcomes of the Microsoft Excel and Access bundle
- Learn about how you may contribute to the relevant sectors.
- Detailed examination of the fundamental data.
- Master some effective skills to enhance your performance.
- Maintain a good relationship with your clients and staff.
- Become computer literate and pick up the necessary office skills with the right software.
- Develop your career with a specific grasp of this industry.
- Be mindful of your ethical and legal responsibilities as a professional in the related industry.
The Microsoft Excel and Access bundle was prepared by specialists with the requirements of job seekers to improve their skill sets and increase employment opportunities with established organisations. So don't wait up. Enrol today!
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.
Achievement
CPD
Course media
Description
Course Curriculum
Course 1: Microsoft Excel (Level 7 at QLS)
- Unit 01: Excel from A-Z Course Introduction
- Unit 02: Getting Started With Excel
- Unit 03: Values, Referencing and Formulas
- Unit 04: Intro to Excel Functions
- Unit 05: Adjusting Excel Worksheets
- Unit 06: Visually Pleasing Cell Formatting
- Unit 07: How to Insert Images and Shapes!
- Unit 08: Visualize Data with Charts
- Unit 09: Excel’s Printing Options
- Unit 10: Benefits of Using Excel Templates
- Unit 11: Working with Excel Datasets
- Unit 12: Excel Database Functions
- Unit 13: Excel Data Validation
- Unit 14: Excel PivotTables
- Unit 15: Excel’s PowerPivot Add-In
- Unit 16: Excel’s Conditional Functions
- Unit 17: Excel’s Lookup Function
- Unit 18: Text Based Functions in Excel
- Unit 19: Auditing Formulas and Views in Excel
- Unit 20: Excel’s “what If?” Tools
- Unit 21: Welcome to Excel VBA
- Unit 22: The VBA Language
- Unit 23: Writing VBA Code
- Unit 24: Important VBA Tools and Logic
- Unit 25: Excel VBA Loop
- Unit 26: Triggering Macros
- Unit 27: Excel User Forms
- Unit 28: Starting a Career in Excel
Course 2: Microsoft Access (Level 4 at QLS)
- Autoforms
- Form Wizard
- Changing a form with design view
- Adding controls to your form
- Subforms
- Using Autoreport to create a report
- Using the Report Wizard to create a report
- Changing a report in design view
- Adding Calculations to your report
- Adding Groups, Sorts and Totals to reports
- Making labels with the Label Wizard
- Form and Report Properties
- Exporting a report to Excel
- Creating a menu with the Switchboard Manager
- Finalizing the Application
Certification
Learners will be eligible for 2 QLS Endorsed Certificate + 2 CPD Accredited PDF Certificate of achievement directly at their doorstep after successfully completing the course! Please note that international students must pay an additional £10 as shipping cost.
Who is this course for?
Those who want to strengthen their professional skills while training for the desired job should take advantage of the Microsoft Excel and Access training!
Requirements
This course is accessible to anyone with an eagerness to learn. All you require is —
- A smart device with a stable internet connection
- A keen interest in the Microsoft Excel and Access
- And being over the age of 16.
Career path
You'll unlock a new universe of options after completing this thorough Microsoft Excel and Access bundle. You will be able to differentiate yourself from the competition and operate more effectively in your sector with the help of this package.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
2 Free CPD Accredited PDF Certificate
Certificate of completion
Hard copy certificate - Included
2 Hard Copy QLS Endorsed certificate Completely free of charge.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.