1712 Courses in Cardiff delivered Online

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Face to face training customised and bespoke. Online or Face to Face

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

English Mastery Mission (Advanced Level)

3DS MAX AND AFTER EFFECTS ONE DAY face to face training customised and bespoke. Online or Face to Face

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Think about the backbone of any successful organization. It's the administrative team, the secretarial staff, and the PAs who keep things running smoothly. A recent study in the UK found that demand for skilled administrative professionals has grown by 15% in the last two years. Are you ready to step up and take on a leadership role in this essential field? This comprehensive Level 7 Diploma equips you with the advanced skills and knowledge to excel in administrative, secretarial, and personal assistant positions. You'll master essential areas like business communication, time management, project coordination, and legal procedures. Additionally, you'll gain expertise in using the latest Microsoft Office tools and navigate complex areas like GDPR and payroll. This Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 180 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Admin, Secretarial & PA course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Admin, secretarial & PA Bundle Package includes: Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 10 Additional CPDQS Accredited Premium Courses - Course 01: Complete Microsoft Word Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Course 03: Legal Secretary Course 04: GDPR Course 05: Payroll Course 06: Administrative Management Course 07: Leadership & Management Diploma Course 08: HR Assistant Course 09: Decision-Making in High-Stress Situations Course 10: Workplace Health and Safety Empower yourself to become an indispensable asset in today's competitive workplace. Enrol today and take your career to the next level! Learning outcome of this Admin, Secretarial & PA: Apply advanced administrative procedures for optimal efficiency. Demonstrate exceptional communication skills in written and verbal formats. Effectively manage time and prioritize tasks in a fast-paced environment. Utilize advanced Microsoft Office applications to streamline workflows. Navigate complex legal and regulatory requirements with confidence. Develop leadership qualities to motivate and support colleagues. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Admin, secretarial & PA Get a free student ID card with Admin, secretarial & PA Training program (£10 postal charge will be applicable for international delivery) The Admin, secretarial & PA is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Admin, secretarial & PA course materials The Admin, secretarial & PA comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Module 1: Personal Assistant Module 2: Admin Support Module 3: Administrative Management Module 4: Organisational Skills Module 5: Telephone Etiquette Module 6: Business Writing Module 7: Time Management Module 8: Body Language and Effective Communication Module 9: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 01: Complete Microsoft Word Manipulating Images Using Custom Graphic Elements Collaborating On Documents Adding Document References And Links Securing A Document Using Forms To Manage Content Automating Repetitive Tasks With Macros Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Section 01: Getting Started Section 02: Excel Basics Section 03: Excel Essential Functions Section 04: XLookup Only For Excel 2021 And Office 365 Section 05: Get Data And Tools Section 06: Formatting Data And Tables Section 07: Pivot Tables Section 08: Excel Charts Section 09: Advanced Excel Charts Section 10: Pivot Charts Section 11: Maps Chart Above 2019 Section 12: Business-Geo Charts Section 13: Named Ranges Section 14: Import Data Into Excel Section 15: Advanced Excel =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £139) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Seasoned Admin, Secretarial & PA professionals seeking career growth. Aspiring executive and personal assistants. Career changers entering Admin, Secretarial & PA roles. Individuals specialising in Admin, Secretarial & PA. Advanced administrative skills seekers. Requirements No prior background or expertise is required for this Admin, secretarial & PA bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Assistant: £25,000 - £50,000 Office Manager: £30,000 - £45,000 PA to CEO: £35,000 - £60,000 Administrative Director: £45,000 - £80,000 Operations Manager: £35,000 - £70,000 Business Development Manager: £35,000 - £70,000 Certificates Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that the UK exported over £668 billion worth of goods and services in 2022? The import and export industry is a thriving part of the UK economy, and with the rise of e-commerce, it's only going to get bigger. Are you interested in a career in this exciting field? This Import/Export bundle offers a vibrant spectrum of courses, integrating the nuances of Supply Chain Management, Business Law, Tax Accounting, and Transport and Logistics Management, amongst others, to create a thoroughfare for ambitious learners. In a world where 49% of UK businesses are engaged in international trade, being armed with robust, comprehensive knowledge encompassing Purchasing & Procurement, Intermediate Economics and Business Analysis is no less than a strategic investment in your future. This Import/Export at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 120 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Diploma in Import/Export course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for absolutely free! This Import/Export Bundle Package includes: Main Course: Diploma in Import/Export at QLS Level 4 10 Additional CPD Accredited Premium Courses related to Import/Export: Course 01: Diploma in Supply Chain Management at QLS Level 5 Course 02: Business Law Course 03: Lean Process and Six Sigma Course 04: Purchasing & Procurement Course 05: Tax Accounting Diploma Course 06: Essentials of UK VAT Course 07: Intermediate Economics Course 08: Transport and Logistics Management Course 09: Business Analysis Course 10: Compliance Risk and Management Learning Outcomes of Import/Export Apply import and export regulations and procedures. Identify and mitigate risks associated with international trade. Utilize Incoterms to manage responsibilities and costs in transactions. Implement effective logistics and supply chain management practices. Analyze international trade finance options for import and export. Develop strategies to ensure compliance with customs regulations. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Import/Export Get a free student ID card with Import/Export Training program (£10 postal charge will be applicable for international delivery) The Import/Export is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Import/Export course materials The Import/Export comes with 24/7 tutor support Take a step toward a brighter future! Course Curriculum Course 01: Diploma in Import/Export Processing Level 4 Module 01: Introduction to Import/Export Module 02: Organising the Import/Export Operation Module 03: Products for Your Import/Export Business Module 04: Target the Marketing & Find Your Customers Module 05: Searching, Marketing & Distribution Module 06: Documentation & Supply Chain Management Module 07: Pricing, Payment & Shipping Procedure Module 08: Necessary Tools for Trading Course 02: Business Law Module 01: Understanding Business Law Module 02: European Community Law Module 03: The Court System Module 04: Civil and Alternative Dispute Resolution Module 05: Contract & Business Law Module 06: Employment Law Module 07: Agency Law Module 08: Consumer Law and Protection Module 09: Law of Tort Module 10: Business Organisations Module 11: Company Law Module 12: Business Property Module 13: Competition Law Course 03: International Law Module 01: Basics of International Law Module 02: Sources of International Law Module 03: International Law and Municipal Law Module 04: International Organisations Module 05: International Law of Human Rights Module 06: Private International Law Module 07: International Criminal Law Module 08: Law of Treaties Module 09: Territory and Jurisdiction Module 10: Law of the Sea Module 11: International Commercial Law Module 12: International Environmental Law How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £99) CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Business owners Trade professionals Supply chain managers Logistics coordinators Finance officers Career changers Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Import/Export Manager - £30,000 to £45,000 Supply Chain Manager - £35,000 to £55,000 Logistics Coordinator - £25,000 to £35,000 Procurement Officer - £25,000 to £40,000 Compliance Officer - £28,000 to £45,000 Business Analyst - £30,000 to £50,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD. Diploma in Import/Export Processing at QLS Level 4 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Package Details: Number of Courses: 30 Courses Accreditation: CPD Quality Standards Free Certificates:PDF: 30Hardcopy: 30 (Delivery Charge Applicable) Courses Access: Lifetime Instalment Payment Available Structural Engineering Course 01: Read Construction & Structural Drawing Like Expert Course 02: Diploma in Construction Management Course 03: Quantity Surveyor Diploma Course 04: Building Surveyor Course 05: Land Surveying Course 06: Bricklaying Course 07: Construction Cost Estimation Diploma Course 08: Construction Estimation using RSMeans Course 09: Construction Cost Estimation Using Xactimate Course 10: Cost Estimation for Multiplex Building Using Xactimate Course 11: Property Law and Legislation Course 12: Construction Industry Scheme (CIS) Course 13: WELL Building Standard Course 14: LEED V4: Building Design and Construction Course 15: LEED V4 - Building Design and Construction Architecture & AutoCAD Course 01: Architectural Studies Course 02: AutoCAD Programming using C# with Windows Forms Course 03: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 04: Autocad Electrical Design Course 05: Intermediate Solidworks Course Course 06: Solidworks Foundation Training Course 07: Interior Design Professional Diploma Course 08: Professional Interior Design & Construction Constraction Safety Course 01: Construction Safety Course 02: Fire Safety | Online Course Course 03: Emergency First Aid and Incident Management at Work Course 04: RIDDOR Training Course 05: LOLER Training Course 06: COSHH Training and Safety - Level 2 Course 07: DSEAR Training Benefits you'll get from choosing Apex Learning for this training: Pay once and get lifetime access Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills CPD 305 CPD hours / points Accredited by CPD Quality Standards Career path This bundle will help you learn the necessary skills to explore opportunities such as- Structural Engineer £36,000 - £38,000 per annum Engineer £27,000 - £45,000 per annum Construction Engineer £3,000 - £45,000 per annum Engineer Surveyor £28,000 - £32,500 per annum Civil Engineer £29,000 - £38,000 per annum

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers.  Who is this course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The diploma in Microsoft Excel will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel for Beginners Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel - Beginners Level 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel - Intermediate Level 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00