14225 Courses

Business Law, Commercial Law & UK Employment Law - CPD Certified Do you want to strengthen your knowledge of Business Law, Commercial Law & UK Employment Law? Our Business Law, Commercial Law & UK Employment Law course will provide you with the skills you need to work more effectively and efficiently. The main focus of this Business Law, Commercial Law & UK Employment Law course is on Business Law, Commercial Law & UK Employment Law legal ideas, best practices, and underlying knowledge. The goal of the Business Law, Commercial Law & UK Employment Law course was to provide students with a thorough grasp of Business Law, Commercial Law & UK Employment Law. Additionally, this Business Law, Commercial Law & UK Employment Law course covers secured intersections in commercial transactions and sales legislation. A specific module for this Business Law, Commercial Law & UK Employment Law course is company law. You will understand intellectual property law at the end of this Business Law, Commercial Law & UK Employment Law course. Enrol this Business Law, Commercial Law & UK Employment Law course to gain the knowledge and skills to secure a job in the Business Law sector! Business Law, Commercial Law & UK Employment Law Course This Business Law, Commercial Law & UK Employment Law Course includes a FREE PDF Certificate. Lifetime access to this Business Law, Commercial Law & UK Employment Law Course Instant access to this Business Law, Commercial Law & UK Employment Law Course Get FREE Tutor Support to this Business Law, Commercial Law & UK Employment Law Course Business Law, Commercial Law & UK Employment Law - CPD Certified Advance your career with our Business Law, Commercial Law & UK Employment Law - CPD Certified course! Strengthen your understanding of Business Law, Commercial Law & UK Employment Law - CPD Certified principles and gain essential skills to work effectively in the field. This course covers legal concepts, best practices, and essential knowledge in Business Law, Commercial Law & UK Employment Law - CPD Certified to give you a comprehensive understanding of business law. Dive into commercial transactions, sales legislation, company law, and intellectual property. Enrol in our Business Law, Commercial Law & UK Employment Law - CPD Certified course today to secure your future in this dynamic sector! Who is this course for? Business Law, Commercial Law & UK Employment Law - CPD Certified The Business Law, Commercial Law & UK Employment Law course is for anyone who wants to develop their professional skills and train for a new job or upskill ready for a promotion. Requirements Business Law, Commercial Law & UK Employment Law - CPD Certified To enrol in this CBusiness Law, Commercial Law & UK Employment Law Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Law, Commercial Law & UK Employment Law Course. Be energetic to complete our Business Law, Commercial Law & UK Employment Law Course. Basic computer Skill is required to complete our Business Law, Commercial Law & UK Employment Law Course. If you want to enrol in our Business Law, Commercial Law & UK Employment Law Course, you must be at least 15 years old. Career path Business Law, Commercial Law & UK Employment Law - CPD Certified The Business Law, Commercial Law & UK Employment Law course is made to provide you with the abilities and information you need to gain the career of your dreams, get promoted at work, go self-employed, or establish your own business.

Healthcare Assistant: Healthcare Assistant Course Online Do you want to be a successful healthcare assistant? This healthcare assistant course will assist you in comprehending the intricate details necessary to work as a professional healthcare assistant and assist others. Maintaining medical records and legal instructions are lessons you can get in this Healthcare Assistant course. A number of ethical, professional, and legal elements of healthcare are also covered in this Healthcare Assistant: Healthcare Assistant Course. Moreover, patient mobility, immobility difficulties, health and safety obligations, and other related topics are explained in this Healthcare Assistant course. This Healthcare Assistant course also demonstrates infection control and nursing cleanliness. Enrol in this Healthcare Assistant: Healthcare Assistant Course to learn how to maintain patient confidentiality and operate as a healthcare assistant in a variety of healthcare settings. Learning Outcomes of Healthcare Assistant: Healthcare Assistant Course: By the end of this Healthcare Assistant course, learners will be able to: Learn about the duties and roles that a healthcare assistant performs. Identify the challenges of working as a healthcare assistant in various healthcare environments. The Healthcare Assistant course exhibits an understanding of the duties related to health and safety as well as the value of hygiene in nursing. Healthcare assistants become knowledgeable about patient mobility and immobility difficulties as well as infection prevention. Find out what a healthcare assistant, caregiver, healthcare professional, and health and social care worker's rights, duties, and obligations are. Main Course: Healthcare Assistant Course Free Courses are including with this Healthcare Assistant: Healthcare Assistant Course. Along with The Healthcare Assistant Course, We Offer a free Care Certificate Course Along with Healthcare Assistant Course, We Offer a free Level 2 health & social care Course Special Offers of this Healthcare Assistant: Healthcare Assistant Course This Healthcare Assistant: Healthcare Assistant Course includes a FREE PDF Certificate. Lifetime access to this Healthcare Assistant: Healthcare Assistant Course Instant access to this Healthcare Assistant: Healthcare Assistant Course Get FREE Tutor Support to this Healthcare Assistant: Healthcare Assistant Course Healthcare Assistant: Healthcare Assistant Course Online This course on healthcare assistants addresses infection control, maintaining hygiene in nursing, patient mobility and immobility issues, and health and safety responsibilities. You will gain knowledge about various legal, professional, and ethical aspects of healthcare as well as how to adjust to working as a Healthcare Assistant: Healthcare Assistant in various healthcare settings and maintaining medical records through this course. Who is this course for? Healthcare Assistant: Healthcare Assistant Course Online Anyone with a knack for learning new skills can take this Healthcare Assistant course. Such as: Allied Health RQF Health and Social Care Palliative care Skills for Care Requirements Healthcare Assistant: Healthcare Assistant Course Online To enrol in this Healthcare Assistant: Healthcare Assistant Course, students must fulfil the following requirements. To join in our Healthcare Assistant: Healthcare Assistant Course, you must have a strong command of the English language. To successfully complete our Healthcare Assistant: Healthcare Assistant Course, you must be vivacious and self driven. To complete our Healthcare Assistant: Healthcare Assistant Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Healthcare Assistant: Healthcare Assistant Course. Career path Healthcare Assistant: Healthcare Assistant Course Online This Healthcare Assistant course will lead you to many different career opportunities, here are a few prospects: Healthcare Assistant: £9.05 - £13.00 per hour Healthcare Solicitor: £70,000 - £90,000 per annum Nursing Assistant: £11.22 per hour Support Worker: £10.50 - £20.00 per hour

Anaphylaxis Online Training Unlock your creativity with our Level 2 Anaphylaxis Training for Nurseries course! Do you want to assist those who have ABC (airway, breathing, and circulation) symptoms? Do you want to improve your understanding of and abilities to manage potentially fatal allergic reactions? The Level 2 Anaphylaxis Training for Nurseries course is now available, empowering educators to ensure students' health and safety. Look nowhere else! Our in-depth Level 2 Anaphylaxis Training for Nurseries is intended to give you the skills and knowledge you need to effectively handle an anaphylactic emergency. Our Level 2 Anaphylaxis Training for Nurseries course is ready to manage anaphylaxis in nurseries presents particular difficulties and demands. You will receive pertinent, useful training that you can put into practice right away with the help of our Level 2 Anaphylaxis Training for Nurseries course, which explicitly tackles these worries and adapts the content to the nursery environment. Recent studies show that in the UK, more than 40% of children and nearly 50% of adults have received an allergy diagnosis. Hence, the Level 2 Anaphylaxis Training for Nurseries course will prepare you so that you may properly guide others in this area. The Level 2 Anaphylaxis Training for Nurseries course is set up with a clear flow from Anaphylaxis Medication to Understanding Anaphylaxis. You will learn about Emergency Protocol, Avoidance Techniques, General Guidelines, Training, and Communication with Individuals through this Level 2 Anaphylaxis Training for Nurseries course. Don't delay further! Enrol our Level 2 Anaphylaxis Training for Nurseries course to advance your career. Main Course: Level 2 Anaphylaxis Training for Nurseries Free Courses are including with this Anaphylaxis Course Along with The Anaphylaxis Course, We Offer a free Dyslexia course Along with The Anaphylaxis Course, We Offer a free Autism Diploma Course Special Offers of this Anaphylaxis Course This Anaphylaxis Course includes a FREE PDF Certificate. Lifetime access to this Anaphylaxis Course Instant access to this Anaphylaxis Course Get FREE Tutor Support to this Anaphylaxis Course Anaphylaxis Online Training Understanding anaphylaxis, allergies, and emergency procedures is aided by taking our Level 2 Anaphylaxis Training for Nurseries course. Avoidance techniques are also covered in this Level 2 Anaphylaxis Training for Nurseries course. Following completion of the Level 2 Anaphylaxis Training for Nurseries course, you are qualified to offer both anaphylaxis medication and general advice. Due to the fact that the Level 2 Anaphylaxis Training for Nurseries course offers comprehensive instruction and a manual for appropriate nurse communication. Who is this course for? Anaphylaxis Online Training All instructors, nursery staff, healthcare professionals, and social workers should complete our Level 2 Anaphylaxis Training for Nurseries course. This Level 2 Anaphylaxis Training for Nurseries course includes: Voluntary staff Unpaid working in schools, nurseries, community and sports clubs, NHS and private hospitals Locul doctors local allied health professionals Agency nurses Healthcare assistants who work with children Requirements Anaphylaxis Online Training To enrol in this Anaphylaxis Training Course Students Need, To join in our Anaphylaxis Training Course, you must have a strong command of the English language. To successfully complete our Anaphylaxis Training Course, you must be vivacious and self driven. To complete our Anaphylaxis Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Anaphylaxis Training Course. Career path Anaphylaxis Online Training Level 2 Anaphylaxis Training for Nurseries: Anaphylaxis Training for Nurseries Online

Adult Nursing Training Do you want to improve the lives of the elderly or those who are afflicted with health problems? If so, our adult nursing training course is a great choice for you to advance your skills and knowledge in nursing. Our extensive curriculum for adult nursing training covers an overview of nursing. Also, adult nursing training explains how to work in different healthcare settings. Furthermore, this adult nursing training course teaches the ethical, legal, and professional standards of practice components of healthcare. Adult Nursing Training also discusses health, safety, and efficient communication. Another lesson in this adult nursing training is about hygiene and infection control in nursing. Enrol right away in our adult nursing training program to start your path to a rewarding and lucrative career in healthcare! Learning Outcome Of This Adult Nursing: Adult Nursing Training Course With our Adult Nursing Training Course, you will gain: Understanding of the unique needs of adult patients from this Adult Nursing Training. Adult Nursing Training provides knowledge about how to communicate effectively with patients and their families. Adult Nursing Training describes how to provide emotional support and work collaboratively with other healthcare professionals. Main Course: Adult Nursing Training Free Courses are including with this Adult Nursing: Adult Nursing Training Course Along with The Adult Nursing Training Course, We Offer a free Care Certificate Course Along with Adult Nursing Training Course, We Offer a free Healthcare Assistant Course Along with Adult Nursing Training Course, We Offer a free Nursing Assistant Diploma Course Special Offers of this Adult Nursing: Adult Nursing Training Course This Adult Nursing Training Course includes a FREE PDF Certificate. Lifetime access to this Adult Nursing: Adult Nursing Training Course Instant access to this Adult Nursing: Adult Nursing Training Course Get FREE Tutor Support to this Adult Nursing: Adult Nursing Training Course Adult Nursing Training An introduction to nursing is given by this specialized program for adult learners. The Adult Nursing program teaches students how to function in a range of healthcare environments. The ethical, legal, and professional standards of practice in healthcare are also emphasized in this adult nursing training course. Effective communication and other topics related to health and safety are covered in adult nursing training. The topic of hygiene and infection control in the workplace is also included in this adult nursing training. Who is this course for? Adult Nursing Training Anyone interested in working in this sector who wants to advance their knowledge and abilities should take this Adult Nursing: Adult Nursing training. Requirements Adult Nursing Training To enrol in this Adult Nursing: Adult Nursing Training Course, students must fulfil the following requirements. To join in our Adult Nursing: Adult Nursing Training Course, you must have a strong command of the English language. To successfully complete our Adult Nursing: Adult Nursing Training Course, you must be vivacious and self driven. To complete our Adult Nursing: Adult Nursing Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Adult Nursing: Adult Nursing Training Course. Career path Adult Nursing Training This Adult Nursing: Adult Nursing Training course will prepare you for a career in the following positions: General Nurse Health and Social Care Workers Carers Midwives Other Health Care Professionals

Accounting and Finance: Accounting and Finance Course Online Would you like to know exactly how businesses track, analyse, and schedule their operations? The goal of this Accounting and Finance: Accounting and Finance Course is to provide students with a thorough introduction to company finance as a concept and a career. This Accounting and Finance: Accounting and Finance Course will give you a solid understanding of accounting and financial processes. Also, this Level 5 Accounting and Finance course teaches all the concepts, and responsibilities of an employee. Through the help of this Level 5 Accounting and Finance course, you can prepare yourself for a career in the accounting and finance industry. This Level 5 Accounting and Finance course is helpful in understanding money value, inventory management and other related issues. Join our Accounting and Finance: Accounting and Finance Course now. This Level 5 Accounting and Finance course is ideal for you if you have a strong desire to work as an account assistant or financial manager; otherwise, there are alternative options. Main Course: Level 5 Accounting and Finance Course Free Courses are including with this Accounting and Finance: Accounting and Finance Course Along with The Accounting and Finance Course, We Offer a free Level 5 Diploma in Business Analysis Course Along with The Accounting and Finance Course, We Offer a free HR and Payroll Management Course Special Offers of this Accounting and Finance: Accounting and Finance Course This Accounting and Finance: Accounting and Finance Course includes a FREE PDF Certificate. Lifetime access to this Accounting and Finance: Accounting and Finance Course Instant access to this Accounting and Finance: Accounting and Finance Course Get FREE Tutor Support to this Accounting and Finance: Accounting and Finance Course Accounting and Finance: Accounting and Finance Course Online The daily inflow and outflow of funds from a company or organization is the focus of accounting. The management of assets and liabilities as well as the planning of future expansion are referred to as finance. Accounting and finance support businesses in measuring, tracking, and organizing their activities. Accounting and finance support businesses in measuring, tracking, and organizing their activities. The goal of this accounting and finance course is to give students a thorough introduction to business accounting and finance as a concept and a career. Who is this course for? Accounting and Finance: Accounting and Finance Course Online This Accounting and Finance: Accounting and Finance Course is for anyone who wants to advance their professional life. Requirements Accounting and Finance: Accounting and Finance Course Online To enrol in this Accounting and Finance: Accounting and Finance Course, students must fulfil the following requirements. To join in our Accounting and Finance: Accounting and Finance Course, you must have a strong command of the English language. To successfully complete our Accounting and Finance: Accounting and Finance Course, you must be vivacious and self driven. To complete our Accounting and Finance: Accounting and Finance Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Accounting and Finance Course. Career path Accounting and Finance: Accounting and Finance Course Online After completing this Accounting and Finance: Accounting and Finance Course, you may be able to pursue a variety of promising career opportunities, such as: Account manager Finance manager Administrative Specialist and many more.

Business Management: Level 7 Business Management Overseeing all aspects of a business! - enrol our Level 7 Business Management course to be an expert in this field. Do you want to join the business management team? Do you want to launch your own company? If so, then this Level 7 Business Management course is right for you!The goal of this Level 7 Business Management course is to equip students with fundamental business and management knowledge. This Level 7 Business Management course is divided into a variety of in-depth courses to give you the most convenient and thorough learning experience possible. You can learn about the functions, rules, and policies of contemporary organisations through this Level 7 Business Management course. You will have a thorough understanding of project management, planning and forecasting operations, performance management, negotiation strategies, and human resource management by the end of this Level 7 Business Management course. To get into the business field, enrol our Level 7 Business Management course as soon as possible to make a career as a business expert! Main Course: Level 7 Business Management Free Courses are including with this Business Management: Business Management Course Along with The Business Management: Business Management Course, We Offer a free Level 5 Diploma in Business Analysis Course Along with The Business Management: Business Management Course, We Offer a free Business Law Course Along with The Business Management: Business Management Course, We Offer a free Level 3 Business Administration Special Offers of this Business Management: Business Management Course This Business Management: Business Management Course includes a FREE PDF Certificate. Lifetime access to this Business Management: Business Management Course Instant access to this Business Management: Business Management Course Get FREE Tutor Support to this Business Management: Business Management Course Business Management: Level 7 Business Management By enrolling in a business management course, you can advance both your technical proficiency and your comprehension of business management. In the business management course, you will study risk and operational management. In addition, project management, succession planning, and other subjects are included in business management. You can learn about a range of strategic approaches and business management planning with this business management course. In order to help you make informed management decisions, this comprehensive business management course also explains numerous issues and their solutions. Who is this course for? Business Management: Level 7 Business Management For those who are considering entering or are already working in this field, the Business Management: Level 7 Business Management course is recommended. Requirements Business Management: Level 7 Business Management To enrol in this Business Management: Business Management Course, students must fulfil the following requirements. To join in our Business Management: Business Management Course, you must have a strong command of the English language. To successfully complete our Business Management: Business Management Course, you must be vivacious and self driven. To complete our Business Management: Business Management Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Business Management: Business Management Course. Career path Business Management: Level 7 Business Management After finishing this Business Management: Level 7 Business Management course, you can investigate well-liked and in-demand occupations in the area of Business Management.

Housing Practice: Level 3 Award in Housing Practice Are you seeking to advance your career in this field? Look no further! We have designed a Level 3 Award in Housing Practice course which will provide you with the necessary skills and knowledge. The Level 3 Award in Housing Practice course will teach you how to deliver affordable housing services. This Level 3 Award in Housing Practice course is helpful for learning about equality and diversity in housing. Also, the Level 3 Award in Housing Practice course provides an opportunity for professional practice skills for housing. Enrol in the Level 3 Award in Housing Practice course to open up the opportunity to a rewarding profession. Learning Outcome of Level 3 Award in Housing Practice After completing the Level 3 Award in Housing Practice course, learners will know about: Delivery of affordable housing services from the Level 3 Award in Housing Practice. The Level 3 Award in Housing Practice teaches equality and diversity in housing. Learners will get the opportunity for professional practice skills for housing from this Level 3 Award in Housing Practice course. Special Offers of this Housing Practice: Level 3 Award in Housing Practice Course This Housing Practice: Level 3 Award in Housing Practice Course includes a FREE PDF Certificate Lifetime access to this Housing Practice: Level 3 Award in Housing Practice Course Instant access to this Housing Practice: Level 3 Award in Housing Practice Course Get FREE Tutor Support to this Housing Practice: Level 3 Award in Housing Practice Course Housing Practice: Level 3 Award in Housing Practice Unlock your potential in the housing sector with our Housing Practice: Level 3 Award in Housing Practice course. This program will equip you with the essential skills to deliver affordable housing services efficiently. The Housing Practice: Level 3 Award in Housing Practice also focuses on equality and diversity, ensuring that you can meet the needs of all communities. Additionally, this Housing Practice: Level 3 Award in Housing Practice offers valuable professional practice skills to advance your career in housing management. Enroll in the Housing Practice: Level 3 Award in Housing Practice today and take a step toward a rewarding career in housing! Who is this course for? Housing Practice: Level 3 Award in Housing Practice This Level 3 Award in Housing Practice course is perfect for aspiring housing professionals, current housing practitioners or any career changers. Requirements Housing Practice: Level 3 Award in Housing Practice To enrol in this Housing Practice: Level 3 Award in Housing Practice Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Housing Practice: Level 3 Award in Housing Practice Course. Be energetic and self-motivated to complete our Housing Practice: Level 3 Award in Housing Practice Course. Basic computer Skill is required to complete our Housing Practice: Level 3 Award in Housing Practice Course. If you want to enrol in our Level 3 Award in Housing Practice Course, you must be at least 15 years old. Career path Housing Practice: Level 3 Award in Housing Practice With the help of our Housing Practice: Level 3 Award in Housing Practice course, you may get highly sought-after abilities that can propel your career forward and open up new opportunities.

Planting course is one of our best selling and most popular course. The Planting course is organised into 25 units and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 20hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99.

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course. This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things. Overall the course teaches you all the efficient use of Microsoft Office to be expert in it. Who is this Course for? Microsoft Office 2016 Advanced is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Mock Exam Mock Exam - Microsoft Office 2016 Advanced 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code