25880 Courses in Cardiff delivered Online

Microsoft Office 2016 Complete Course Course Overview: The "Microsoft Office 2016 Complete Course" is designed to provide learners with comprehensive knowledge and essential skills in the core Microsoft Office applications. This course offers in-depth coverage of Microsoft Word, Excel, PowerPoint, Outlook, and Access, enabling participants to confidently use these programs in professional environments. By the end of the course, learners will be equipped to create, manage, and analyse documents, spreadsheets, presentations, emails, and databases with proficiency. This course is an invaluable resource for those looking to enhance their productivity and improve their digital skills, making them more competitive in the job market. Course Description: The "Microsoft Office 2016 Complete Course" delves into the key functionalities of Microsoft Office, with modules dedicated to each major application. Learners will explore the features of Word for document creation and editing, Excel for data analysis and management, PowerPoint for effective presentations, Outlook for email and calendar management, and Access for database handling. Each module is structured to help learners understand the software’s core functions and how to apply them in real-world scenarios. Upon completion, learners will have developed a strong foundation in using Office 2016, boosting their ability to operate efficiently and effectively in modern workplaces. This course is suitable for individuals seeking to increase their office productivity and streamline their daily tasks. Microsoft Office 2016 Complete Course Curriculum: Module 01: Microsoft Word 2016 Module 02: Microsoft Excel 2016 Module 03: Microsoft PowerPoint 2016 Module 04: Microsoft Outlook 2016 Module 05: Microsoft Access 2016 (See full curriculum) Who is this course for? Individuals seeking to improve their office productivity skills. Professionals aiming to advance in roles requiring Microsoft Office proficiency. Beginners with an interest in data management, communication, and office software. Those wishing to enhance their CV and increase career opportunities in administrative and support roles. Career Path: Office Administrator Executive Assistant Data Analyst Personal Assistant Administrative Support Specialist Project Coordinator

Hospitality - Concierge Course Overview: This comprehensive course on Concierge Services equips learners with the essential skills and knowledge required to excel in the hospitality industry. Covering a range of concierge services, from customer care to handling emergency situations, it offers valuable insights into the role of a concierge within various service sectors. Learners will gain a thorough understanding of the necessary skills and principles to provide high-quality service, helping them build a solid foundation for a career in hospitality. By the end of the course, learners will have developed the competencies needed to operate efficiently and professionally within the dynamic environment of hotel and hospitality services. Course Description: The "Hospitality - Concierge" course provides a thorough exploration of the concierge service industry. It covers essential topics, including the various types of services offered by concierges, the required skills for success, and key principles for running a concierge service business. Learners will gain a deep understanding of customer service and the etiquettes required in a professional concierge environment. The course also prepares learners for managing emergency situations in the hospitality industry, ensuring they are well-equipped to handle any challenges that may arise. By completing this course, learners will be prepared for roles in customer service, hotel management, and other areas within hospitality, ensuring a high standard of service in their future careers. Hospitality - Concierge Curriculum: Module 01: Understanding the Service Module 02: Types of Concierge Services Module 03: Necessary Skills for Any Concierge Module 04: Principles for a Concierge Service Business Module 05: Delivering Customer Service Module 06: Concierge Work Environment and Etiquettes Module 07: Emergency Measures for a Hotel Concierge (See full curriculum) Who is this course for? Individuals seeking to start a career in hospitality. Professionals aiming to develop customer service and management skills. Beginners with an interest in concierge services or hotel management. Anyone looking to enhance their understanding of the hospitality sector. Career Path: Hotel Concierge Hospitality Customer Service Representative Front Desk Supervisor Concierge Manager Event Coordinator Travel and Tourism Industry Professional

Nanny Care Worker Course Overview The "Nanny Care Worker" course provides learners with essential knowledge and skills to thrive in a career as a nanny. It covers a range of key areas, including child development, child safety, healthy living, and effective time management. By focusing on practical, professional caregiving skills, the course ensures that learners are prepared to provide exceptional care for children. On completion, learners will be equipped to manage daily routines, foster relationships with children, and create a safe and nurturing environment. The course also offers valuable insights into career progression within the nanny industry. Course Description This course is designed to give learners a comprehensive understanding of the core responsibilities of a nanny care worker. Topics include child development, ensuring children’s safety and health, creating structured routines, and understanding early years provision. The course explores the critical role of nutrition and healthy living in a child's upbringing, alongside essential time management skills for nannies. Learners will gain insight into the role and profile of a nanny and how to establish a successful career in this field. By the end of the course, learners will possess the skills necessary to provide high-quality care and support in a professional childcare environment. Nanny Care Worker Curriculum Module 1: Introduction to Nanny Care Workers Module 2: Understanding Child Development Module 3: Care for Children Module 4: Healthy Food, Healthy Living Module 5: Keeping Children Healthy & Safe Module 6: Early Years Provision Module 7: Establishing Relationships and Routines Module 8: Time Management for Nannies Module 9: Nanny’s Job Profile Module 10: Establishing a Nanny’s Career (See full curriculum) Who is this course for? Individuals seeking to become professional nanny care workers. Professionals aiming to expand their childcare expertise. Beginners with an interest in working with children. Those looking to enter the nanny or childcare industry. Career Path Nanny Childcare Assistant Early Years Practitioner Family Support Worker Child Development Specialist Child Protection Officer

Learn to Level Up Your Leadership Course Overview "Learn to Level Up Your Leadership" is designed for individuals who want to enhance their leadership capabilities and navigate the challenges of leading teams. This course delves into essential leadership concepts such as decision-making, communication, and team management. Learners will gain a solid understanding of leadership styles, conflict resolution, and how to motivate and inspire their teams. By the end of the course, learners will be equipped to lead more effectively, build trust, and foster a positive team environment, which are essential skills in today's dynamic business world. Course Description This course covers a comprehensive range of leadership topics, offering insights into modern leadership techniques and strategies. Learners will explore various leadership styles, learn the importance of emotional intelligence in leadership, and understand the core principles of team dynamics. They will also be introduced to conflict management strategies, decision-making processes, and the significance of leading with integrity. The course is designed to provide a robust foundation for individuals who wish to improve their leadership skills and grow in their professional careers. Learners will develop the skills to manage diverse teams, handle challenges, and drive organisational success. Learn to Level Up Your Leadership Curriculum Module 01: Introduction to Leadership Module 02: Leadership Styles and Approaches Module 03: Emotional Intelligence in Leadership Module 04: Effective Communication for Leaders Module 05: Decision-Making and Problem Solving Module 06: Managing and Motivating Teams Module 07: Conflict Resolution and Negotiation Module 08: Leading with Integrity and Vision (See full curriculum) Who is this course for? Individuals seeking to develop their leadership skills. Professionals aiming to advance their careers through enhanced leadership capabilities. Beginners with an interest in management or leadership roles. Aspiring managers looking to transition into leadership positions. Career Path Team Leader Project Manager Department Manager Operations Manager Leadership Consultant HR Manager Executive Role in various industries

Hotel Cleaner Course Overview: This Hotel Cleaner course is designed to equip learners with the knowledge and skills needed to excel in the hospitality cleaning industry. Covering a broad range of topics, it includes essential cleaning techniques, health and safety practices, and customer service skills tailored for hotel environments. Learners will gain an understanding of the importance of cleanliness and organisation in guest satisfaction. Upon completing the course, learners will be able to confidently perform cleaning duties in various hotel areas, ensuring a safe and welcoming environment for guests. Course Description: The Hotel Cleaner course delves into a variety of topics crucial to maintaining cleanliness and hygiene in hotels. Learners will explore techniques for cleaning guest rooms, public spaces, and facilities while adhering to industry standards. Topics include understanding cleaning equipment, handling chemicals safely, time management, and effective communication with hotel staff and guests. Learners will gain knowledge of the importance of attention to detail, a strong work ethic, and maintaining high cleanliness standards to enhance the guest experience. The course offers a comprehensive overview of the expectations and requirements within the hotel cleaning industry, preparing learners for roles in this sector. Hotel Cleaner Curriculum: Module 01: Introduction to Hotel Cleaning Module 02: Cleaning Techniques for Guest Rooms Module 03: Cleaning Public Spaces and Facilities Module 04: Health and Safety in Hotel Cleaning Module 05: Chemical Handling and Equipment Use Module 06: Time Management and Efficiency Module 07: Customer Service and Communication in Hotel Cleaning Module 08: Maintaining Cleanliness Standards and Best Practices (See full curriculum) Who is this course for? Individuals seeking to work in the hotel cleaning industry. Professionals aiming to improve cleaning and organisational skills. Beginners with an interest in hospitality services. Those looking to develop a career in hotel management or facilities maintenance. Career Path: Hotel Cleaner Housekeeping Assistant Facilities Maintenance Worker Hotel Housekeeping Supervisor Hospitality Industry Cleaner

Functional Skills - IT Course Overview: The "Functional Skills - IT" course is designed to provide learners with a comprehensive understanding of essential IT concepts and skills. It covers a wide range of topics, from the basic components of information technology to more advanced areas such as networking, security, and cloud computing. This course is ideal for individuals seeking to enhance their IT skills for personal or professional development. Learners will gain a strong foundation in IT principles, which will support them in various workplace environments and allow them to apply their knowledge to real-world scenarios. Course Description: This course covers fundamental IT concepts, including the core components of information technology, hardware, software applications, and operating systems. Learners will explore topics such as networking, security, database management, and virtualisation. The course also includes an in-depth look at enterprise-level IT systems, traffic flow, and storage solutions. By the end of the course, learners will have a solid understanding of how IT systems are designed, implemented, and managed. They will gain the skills necessary to work effectively in diverse IT roles, enabling them to confidently support organisational IT needs. Functional Skills - IT Curriculum: Module 01: Introduction Module 02: Information Technology Module 03: Components of IT Module 04: Hardware Module 05: Operating System Module 06: Application/Software Module 07: Networking Module 08: Security Module 09: Traffic Flow & Enterprise Level IT Components Module 10: Storage Module 11: Database Module 12: Virtualisation & Cloud Module 13: Management & Other IT Jobs (See full curriculum) Who is this course for? Individuals seeking to develop a strong understanding of IT principles. Professionals aiming to enhance their technical skills for career progression. Beginners with an interest in information technology and related fields. Those looking to pursue a career in IT management, networking, or support roles. Career Path IT Support Technician Network Administrator Systems Analyst IT Manager Cloud Solutions Specialist Database Administrator IT Consultant Cybersecurity Specialist

Duration 5 Days 30 CPD hours This course is intended for Built for IT Professionals with extensive networking and Citrix ADC experience. This course is built for IT Professionals who are responsible for defining the overall structure or architecture of a Citrix networking environment. This course encompasses advanced Citrix networking configurations and leading Citrix design principles. Overview How to identify and prioritize business drivers, constraints, and requirements using the Citrix Consulting methodology Assess environment requirements and learn to apply leading design principles to address them in a multi-site Citrix ADC deployment Apply advanced authentication and load balancing principles In this expert level 5-day training course you will be exposed to advanced networking and Citrix ADC concepts and configurations. Through lecture, lab exercises, and real-world case studies, you will learn to look critically at environment requirements, constraints, and business drivers to create a complex Citrix networking solution. Topics to be covered in this course include multi-site and multitenant deployments, advanced authentication and load balancing, and automation and orchestration and advanced troubleshooting. This training will also prepare you for the Citrix Certified Expert in Networking (CCE-N) exam. Module 1: Networking Methodology and Assessment Understanding the Citrix methodology Business Drivers and Requirementrs User Segmentation Application Assessment Capabilities Assessment Module 2: Citrix Networking Deployment Architecture and Topology Multi-Site Deployments Multi Tennant Infrastructure Cloud Deployments High Availability Citrix ADC Double-Hop Scenarios Secure Web Gateway Module 3: Advanced Authentication and Authorization Authorization Policies Access Policies Advanced Authentication Options Multi-Factor Authentication nFactor Authentication AAA Session Management Module 4: Citrix ADC Security Authorization Pre-authentication and Endpoint Analysis Scans Protection against Layer 4-7 Attacks Web App Firewall Module 5: Citrix Gateway Configuration Considerations ICA Proxy Configuration VPN Access Clientless Access Split Tunneling RDP Proxy Deployment and Configuration Module 6: Advanced Load Distribution and Link Load balancing Advanced Load Balancing Advanced Load Balancing Link Load Balancing Firewall Load Balancing Microsoft Exchange Load Balancing Advanced Global Server Load Balancing Global Server Load Balancing Persistence DNS, Policies, Expressions, Actions, and Views GSLB Monitoring and Considerations Module 7: Application Delivery Management Automation and Orchestration Application Delivery Management Outbound Traffic Dashboard Automation Orchestration Configuration Jobs Configuration Audit NITRO API StyleBooks (Net-new)

Highlights of the Course Course Type: Online Learning Duration: 8 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about forensic investigation Understand the core competencies and principles of forensic investigation Explore the various areas of forensic investigation Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert pentester Cyber Security and Digital Forensics for Pentesters - Hands-on Course Master the skills you need to propel your career forward in digital forensic investigation. This course will equip you with the essential knowledge and skillset that will make you a confident pentester and take your career to the next level. This comprehensive cyber security and digital forensics course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this cyber security and digital forensics course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This cyber security and digital forensics course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.  This comprehensive course will teach you the theory of effective digital forensic investigation practice and equip you with the essential skills, confidence and competence to assist you in the digital forensic investigation industry. You'll gain a solid understanding of the core competencies required to drive a successful career in digital forensic investigation. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for pentester or for people who are aspiring to specialise in digital forensic investigation. This cyber security and digital forensics course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this cyber security and digital forensics course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive cyber security and digital forensics course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this digital forensic investigation can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This cyber security and digital forensics course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This cyber security and digital forensics course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This cyber security and digital forensics course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Course Overview 00:06:00 Building Your Forensics Lab Environment Using VirtualBox Video - Downloading ISO and OVA Files for VirtualBox 00:08:00 Video and lab - Create a Virtual Install of CSI Linux 2021.2 00:12:00 Video and Lab - Create a Kali Live (Forensic Mode) VM Using VirtualBox 00:06:00 Video and lab - Create a Virtual Install Kali Image Using VirtualBox 00:11:00 Video and Lab - Create Virtual Install of Windows 10 Using VirtualBox 00:08:00 Video and Lab - Create a Virtual Install of Metasploitable2 Using VirtualBox 00:10:00 Using Kali Forensic Mode and Autopsy Video and Lab -Getting Started with Autopsy 00:10:00 Video and Lab - Simulate Creating a Disk Image for a Forensic Analysis 00:11:00 Video and Lab - Examining a forensic Disk Image Using Autopsy 00:12:00 Digital Forensics Case Management Video and Lab - Installing the WebMap-Nmap Dashboard 00:12:00 Open-source Intelligence (OSINT) Video and Lab - Conducting OSINT Using CSI Linux Investigator 00:08:00 Video and Lab - Find Social Media Accounts Using Sherlock 00:07:00 Video - OSINT Framework - Overview 00:16:00 Using Shodan to Search for Vulnerable Devices Video and Lab - Preparing CSI Investigator to Use Shodan 00:05:00 Video and Lab - Using Shodan to Find Vulnerable Devices 00:16:00 Video and lab - Using Shodan to Search for Vulnerable Databases 00:08:00 Computer Forensics Video - Attaching an External USB Device in Kali 00:07:00 Video and Lab - Acquiring a Forensic Copy of the Windows Registry 00:15:00 Video and Lab - Analyzing the Windows Registry for Evidence 00:14:00 Video and Lab - Dumping Wi-Fi Credentials Using netsh 00:04:00 Video and Lab - Email Header Analysis 00:17:00 Video and Lab - Using Shellbags to View Hidden or Deleted Folders 00:06:00 Video and Lab - Extracting Thumbnail Images From a Suspects Machine 00:05:00 Video and lab - Memory Forensics Using the Volatility Framework 00:19:00 Reverse Engineering and Malware Analysis Video and Lab - Install Ghidra on CSI Linux 00:07:00 Video and Lab - Introduction to Using Ghidra 00:14:00 Video and Lab - Reverse Engineering crackme0x00 Using Ghidra 00:06:00 Video and Lab - Reverse Engineering crackme0x05 Using Ghidra 00:12:00 Video and Lab - Analyzing the WannaCry KillSwitch Using Ghidra 00:17:00 Malware Hunting with Sysinternal Tools Video - Overview of Sysinternal Tools 00:08:00 Video - Overview of Sysinternal's Process Explorer 00:00:00 Video and Lab - Finding Malware with Sysinternals Process Explorer 00:09:00 Stenography Video and Lab - Using Steghide for Hiding and Extracting Data 00:11:00 Video and Lab - Using the EXIFtool to Read and Write EXIF Tags 00:10:00 Network Forensics Using Wireshark Video - Overview of Wireshark 3.2 00:11:00 Video - Wireshark Capture Options 00:07:00 Video - Wireshark Toolbar Icons 00:03:00 Video and Lab - Installing a Wireless Adapter in Kali 00:09:00 Video and Lab - Hacking a Wireless Network Using Kali Linux 00:14:00 Video - Capturing Wireless Traffic Using Wireshark 00:05:00 Practice What You Learned Video and Lab - CTF Lab Build for HA: Forensics 00:11:00 Video and lab - Capture flag #1 00:12:00 Video and lab - Capture flag #2 00:10:00 Video and lab - Capture flag #3 00:20:00 Video and lab - Capture flag #4 00:09:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Register on the Microsoft Excel Training: Depreciation Accounting today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel Training: Depreciation Accounting is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel Training: Depreciation Accounting Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel Training: Depreciation Accounting, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:03:00 Minimum requirements before taking the course 00:01:00 Download master depreciation template 00:00:00 Depreciation Amortization and Related Terms Definition of Depreciation 00:02:00 Amortization: Depreciation vs Amortization 00:02:00 Related Terms to Depreciation 00:02:00 Various Methods of Depreciation and Depreciation Accounting Most Common Methods of Depreciation 00:09:00 Accounting for Depreciation 00:05:00 Depreciation and Taxation Depreciation Tax Shield 00:04:00 Depreciation Tax Shield Under Various Depreciation Methods 00:03:00 Master Depreciation Model Introduction and basics of Depreciation Model in Excel 00:01:00 Deep Dive into Depreciation Model 00:07:00 How to use the model with Example 00:10:00 Advanced functionalities of the Model 00:11:00 Conclusion Thank you for Enrolling 00:01:00 Resources Resources - Microsoft Excel Training: Depriciation Accounting 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.