54724 Courses in Cardiff delivered Online

Course Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Online Cupcake and Baking Diploma course is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Online Cupcake and Baking Diploma Course for? This Online Cupcake and Baking Diploma course is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Online Cupcake and Baking Diploma Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to 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 the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for 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. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Section 01: Basic Concepts of Baking Basic Concepts of Baking 00:16:00 Section 02: Basic Ingredients of Baking Basic Ingredients of Baking 00:28:00 Section 03: Glossary and Equipment Used in Baking Glossary and Equipment Used in Baking 00:34:00 Section 04: Types of Cakes Types of Cakes 00:14:00 Section 05: Baking the Cake Baking the Cake 00:20:00 Section 06: Baking Principles Baking Principles 00:25:00 Section 07: Cake Decorating Recipes Cake Decorating Recipes 00:26:00 Section 08: Cake Decorating Ideas Cake Decorating Ideas 00:21:00 Section 09: Frosting and Icing Frosting and Icing 00:24:00 Section 10: Working with Different Pastes Working with Different Pastes 00:20:00 Section 11: Working with Glazes Working with Glazes 00:28:00 Section 12: How to Stack a Cake How to Stack a Cake 00:21:00 Section 13: Piping and Writing Piping and Writing 00:24:00 Section 14: Health, Safety and Food Hygiene Health, Safety and Food Hygiene 00:20:00 Section 15: Troubleshooting Troubleshooting 00:20:00 Section 16: Cake Decorating Business Cake Decorating Business 00:19:00 Assignment Assignment - Online Cupcake and Baking Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Have you tried online banking? Do you find it convenient but you don't have enough knowledge of how it works? Then this training course in Online Banking Essentials will be a great help to you and your business through increasing and finding ways to elevate your online performance. Description: Most banks are presently worldwide or global in nature using modern channels of technology. This course adequately explains online banking and it's in and out. This will include the keeping money framework and the fundamental in managing an account. It will also include how worldwide saving money acts and in addition analyzing subjects, for example, partial hold saving money, save proportions, treasuries, utilizing, the foreign exchanges rates. Managing an account online is noticeably in the mainstream nowadays because of the modern technology and its convenience provided to the consumers. If you want to know how it works and why it matters in this modern day and age, then this course will help you with that. Who is the course for? Professionals, who work in the business or corporate setting, especially people who are part of the management, sales and marketing departments of the banking industry. People who are interested in online retail banking and other online transactions. 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. 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 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 Online Banking Essentials course is a useful qualification to possess, and would be beneficial for the following careers: Banking Manager Business Development Group Account Director Marketing Manager Public Relations Officer Sales Specialist Strategist And Many More! Online Banking Essentials How Online Banks are Set Up 00:30:00 Why People Like Online Banking 00:30:00 Taking Your First Steps With Online Banking 00:30:00 Paying Your Bills using Online Banking 00:30:00 How to Determine if Your Online Bank is Legit 00:15:00 Tips to Prevent Online Banking Fraud 00:30:00 More Online Banking Security Tips 00:30:00 Transferring funds With Online Banks 00:30:00 Online Banking Privacy Policies 00:30:00 Mock Exam Mock Exam- Online Banking Essentials 00:20:00 Final Exam Final Exam- Online Banking Essentials 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Office Admin, Secretarial & PA  course is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Office Admin, Secretarial & PA Course for? This Office Admin, Secretarial & PA Course is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Office Admin, Secretarial & PA Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to 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 the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for 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. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Section 01: Introduction to Admin Support Assistant Introduction to Admin Support Assistant 00:19:00 Section 02: Introduction to Personal Assistant Introduction to Personal Assistant 00:18:00 Section 03: Introduction to Office Administration Introduction to Office Administration 00:14:00 Section 04: Skills of an Effective Administrator Skills of an Effective Administrator 00:15:00 Section 05: Introduction to Reception and Receptionist Introduction to Reception and Receptionist 00:26:00 Section 06: Business Telephone Skills Business Telephone Skills 00:19:00 Section 07: Representing Your Boss and Company Representing Your Boss and Company 00:36:00 Section 08: Business Etiquette Business Etiquette 00:19:00 Section 09: Mail Services and Shipping Mail Services and Shipping 00:27:00 Section 10: Travel Arrangements Travel Arrangements 00:25:00 Section 11: Organising Meeting and Conferences Organising Meeting and Conferences 00:28:00 Section 12: Diary Management and Note taking Diary Management and Note taking 00:25:00 Section 13: Time Management Time Management 00:37:00 Section 14: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:28:00 Section 15: Business Writing Skills Business Writing Skills 00:40:00 Section 16: Organisational Skills Organisational Skills 00:16:00 Section 17: Communication Skills Communication Skills 00:25:00 Section 18: Customer Service Customer Service 00:16:00 Section 19: Effective Planning and Scheduling Effective Planning and Scheduling 00:51:00 Section 20: Invoicing Petty Cash Invoicing Petty Cash 00:27:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you struggling with your present job? Are you feeling unmotivated and uninspired in your life? Do you want to become positive? Then it's time for you to learn how to attract positivity and learn to enjoy what you are doing and this course will surely help you out with that. Description: This course will teach you all the necessary steps and aspects of occupational and career blitzing. Think about your occupation as your principle outlet for expression. Your occupation may appear as an income producing profession you execute or a business you handle, yet it doesn't need to. You want to enjoy your occupation as this is your profession, at a truly fundamental level; it's basically what you do to take up your time. Actually in the case will live intentionally, this decision gets the opportunity to be a sort of critical one. It appears that an essential factor that considers the professional happiness is basically an experience. Individuals who always ask what they truly need will only result to a fixation on regardless of whether an occupation is ideal for them. They turn out to be mindful of all that they detest about their work and their occupation fulfillment and satisfaction plunges. By complexity, the skilled worker's mentality recognizes that regardless of what field you're in, achievement is constantly about quality. Once you're centered around the nature of the work you're doing regardless of whether it's appropriate for you, you won't waiver to do what is important to enhance it. And this course will explain how you should become content with your job and more importantly in your life. Who is the course for? Professionals, businessmen, and employees who are currently working Anyone who is interested in learning more about the perfect occupation that is suited to them and develops extreme focus to enjoy what you are doing 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. 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 recognized 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 course is a useful qualification to possess and would be beneficial for every kind of jobs or to any career path you would like to take. Occupational and Career Blitzing Course About Your Occupation 00:30:00 Occupation Reality and Affection 00:15:00 Career and Might 00:15:00 Career and Bravery 00:30:00 Career and Being Intelligent 00:30:00 Wrapping Up 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office Business Contact Manager 3 will help you to learn everything you need to teach Microsoft Office Business Contact Manager 3. In this course you will learn how to install business contact manager, use express setup and advanced setup, use the business contact manager dashboard, use the business contact manager folder list, menus, and toolbar, create and remove a database, use shared database, manage your database, access the welcome email, use the dashboard links, use 'learn about business contact manager', use the help menu, and more. This course will help you to get skilled and improve your knowledge. Learning Outcomes: Understand and install Business Contact Manager, and use express and advanced setup View folders, use dashboard, menu and toolbar in the Business Contact Manager Create, remove, share and manage database, along with connections to other shared databases Get to know welcome emails, use dashboard links, 'Learn about Business Contact Manager', and help menu Open folders, create, edit and view Accounts, Business Contacts, Opportunities and Business Projects and Project Tasks Discover how to create a history item, business note in and outside an item, view the communication history folder and use link to record and emails to auto-links Learn to open the dashboard, customize it and about the home, sales, marketing and projects tab Setup and use the Product and Service Items List, import and export data, generate reports and utilize the reports window in the information management tools Go through marketing campaigns by creating basic campaigns, campaigns through Word and Publisher, and track campaign results Create custom forms, edit lists in and outside a form Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office Business Contact Manager 3 is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Microsoft Office Business Contact Manager 3 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Configuring Business Contact Manager Getting Started 00:30:00 Using Business Contact Manager 00:15:00 Working with Business Contact Manager Data 00:15:00 Getting Help in Business Contact Manager 00:15:00 Using Business Contact Manager Accounts 00:15:00 Business Contacts 00:15:00 Opportunities 00:15:00 Business Projects and Project Tasks 00:30:00 Communications History and Linking 00:15:00 Business Contact Manager Tools Using the Dashboard 00:15:00 Information Management Tools 00:30:00 Marketing Campaigns 00:15:00 Customizing Forms 00:15:00 Mock Exam Mock Exam- Microsoft Office Business Contact Manager 3 00:20:00 Final Exam Final Exam- Microsoft Office Business Contact Manager 3 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Windows Internet Explorer 8 is a web browser developed by Microsoft in the Internet Explorer browser, released on October 22, 2009. It is the latest version of Microsoft's widely used Windows operating system. By taking this Microsoft Internet Explorer 8 you will get a complete overview of the new start screen, a comprehensive look at touch gesture, an introduction to the default Windows 8 applications (including Mail, Messaging, Photo, Travel, and Sports), and information on using the desktop and its applications. If are thinking to improve your skills and knowledge on Windows system, you are welcome to join this course. Learning Outcomes: Understanding the requirements of internet connection, different types of connections, and opening, setting up and closing Internet Explorer Get an overview of the user interface by using the command area, menu bar, explorer bar, search bar and status bar Discover the application window by learning how to minimize, maximize, restore, and manually resize the window; differences between full screen vs. normal mode; and using zoom feature Enabling, disabling and locking toolbars, along with customizing the command toolbar Get help from help menu, help file, using the table of contents, searching the help file, taking internet explorer tour and online support Learn how to use the navigation buttons, understand parts of web addresses, access your homepage, access websites using address bar and/or hyperlink, and opening page in a new window Opening and closing tabs, switching between tabs, access tabbed help, using tabbed thumbnails and tab list Search the web using search boxes, search engines, within a page, and get some general tips for searching and change the search options Copying text and pictures from the web, saving pictures and web pages, and sending page, link or picture using emails Examine the print preview, page setup, printing page or selection options Understand Favourites; opening, pinning and closing favourites centre; and accessing favourites without Internet Explorer Marking pages or multiple tabs, deleting, maintaining and accessing favourites Organise your favourites by renaming them, adding folders to favourites, and saving and moving them into the folders Understand and manage accelerators, use and get new ones Get to know what are web slices, and how to get, use and find them See the differences between secure and non-secure sites, learn about encryption, digital signatures, cookies, browser cache, and display options Protect your sites using passwords, form filling, learning about the Password Manager, and CAPTCHA Discover more about information bar, pop-up blocker, phishing filter, InPrivate browsing and filtering, and finally managing add-ons Get safety tips and learn about antiviral software, anti-spam software, and firewalls Import and export favourites and cookies Understand and open dialog boxes, set up your homepage, delete temporary internet files, setup parental filtering, automatically disconnect, and set internet explorer as default browser Manage browser history by understanding what it is, access history from address bar, manually delete history items, clear entire history, and set up history options Discover the meaning of RSS Feed, how to view it, subscribing and using feeds, changing feed properties and unsubscribing from feeds Explore HTML, JavaScript, and ActiveX; view and edit HTML source code, more plugins and add-ons, and reset options for internet explorer Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Internet Explorer 8 is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Microsoft Internet Explorer 8 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started Definitions 00:15:00 Internet Explorer Basics 00:30:00 The Internet Explorer Interface 01:00:00 The Internet Explorer Window 00:30:00 More about Toolbars 00:15:00 Getting Help 01:00:00 Browsing the Web Accessing a Web Site 00:30:00 Using Tabs 00:30:00 Searching the Web 01:00:00 Working with Data 01:15:00 Printing from the Web 00:30:00 Favorites, Accelerators, and Web Slices Favorite Basics 00:15:00 Creating and Using Favorites 00:30:00 Organizing Favorites 00:30:00 Accelerators 01:00:00 Web Slices 00:15:00 Security Secure Sites 00:15:00 Accessing Protected Sites 00:15:00 Security Features 01:00:00 Keeping Yourself Safe 00:15:00 Managing Information 00:30:00 Advanced Topics Setting Your Options 01:00:00 Managing your History 00:30:00 RSS Feeds 00:30:00 Additional Components 00:30:00 Mock Exam Mock Exam- Microsoft Internet Explorer 8 00:20:00 Final Exam Final Exam- Microsoft Internet Explorer 8 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Internet Explorer 6 is the sixth major revision of Internet Explorer, a web browser developed by Microsoft for Windows operating system. This Microsoft Internet Explorer 6 will help you make the most of Internet Explorer 6. If you are thinking to take this course you need a Windows-based computer with the Internet access and Internet Explorer 6, including the basic knowledge of Windows functions, and how to use the mouse and keyboard. By this Microsoft Internet Explorer 6 you will be introduced to Internet Explorer basics, the Internet Explorer interface, ways to access a Website, printing from the Web, setting your options, and much more. Learning Outcomes: Learn how to understand secure sites Get knowledge of accessing the protected sites Get to know the Internet Explorer's security features Learn to keep yourself safe Learn to manage the information Know of setting your options Learn of managing history Get additional components Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Internet Explorer 6 is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Microsoft Internet Explorer 6 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. DEFINITIONS 00:30:00 INTERNET EXPLORER BASICS 00:30:00 THE INTERNET EXPLORER INTERFACE 00:30:00 MORE ABOUT TOOLBARS 00:30:00 GETTING HELP 00:30:00 ACCESSING A WEB SITE 00:30:00 SEARCHING THE WEB 00:30:00 WORKING WITH DATA 00:30:00 PRINTING FROM THE WEB 00:30:00 FAVOURITE BASICS 00:30:00 CREATING AND USING FAVOURITES 00:30:00 ORGANIZING FAVOURITES 00:30:00 THE LINKS TOOLBAR 00:30:00 SECURE SITES 00:30:00 ACCESSING PROTECTED SITES 00:30:00 SECURITY FEATURES 00:30:00 KEEPING YOURSELF SAFE 00:30:00 MANAGING INFORMATION 00:30:00 SETTING YOUR OPTIONS, PART ONE 00:30:00 SETTING YOUR OPTIONS, PART TWO 00:30:00 MANAGING YOUR HISTORY 00:30:00 ADDITIONAL COMPONENTS 00:30:00 Mock Exam Mock Exam- Microsoft Internet Explorer 6 00:20:00 Final Exam Final Exam- Microsoft Internet Explorer 6 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 recognized 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 Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview The nervous system is the most complex and sophisticated part of the human body. Therefore, it requires immense knowledge and expertise to work with the neurological system. The Neurology Science Training Course is here to help you out. It is built to equip the learners with an in-depth understanding of the nervous system. This Neurology Science Training Course will introduce you to the core principles of the neuro system. You will be able to deepen your understanding of visual disorders, hearing disorders, and Peripheral Nervous System Disorders. The course will also educate you on the different types of spinal disorders. You will learn a great deal about child neurology from the highly informative modules. The course will assist you in building expertise in neurological assessment and medications. The Neurology Science Training Course will provide you with a detailed understanding of the nervous system. Enroll today and learn the ins and outs of this complicated system. Learning Outcomes Get an introduction to the fundamentals of neurology Enrich your understanding of visual disorders and hearing disorders Understand the basics of spinal cord disorders Learn about the Peripheral Nervous System Disorders Explorer the essentials of child neurology Build your skills in neurological assessment and medications Who is this course for? The Neurology Science Training Course is designed for people interested in working in the field of neurology 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 recognized 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 Neurology Science Training Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Research assistant Health educator Research scientist Clinical psychologist Neurosurgeon Neurologist Module 1: Introduction to Neurology Introduction to Neurology 00:15:00 Module 2: Neurological Disorders Neurological Disorders 00:26:00 Module 3: Visual Disorders Visual Disorders 00:17:00 Module 4: Disorders Of Hearing Disorders Of Hearing 00:16:00 Module 5: Spinal Cord Disorders Spinal Cord Disorders 00:17:00 Module 6: Peripheral Nervous System Disorders Peripheral Nervous System Disorders 00:17:00 Module 7: Child Neurology Child Neurology 00:18:00 Module 8: Neurological Assessments Neurological Assessments 00:17:00 Module 9: Medications Medications 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: NLP (Neuro-Linguistic Programming) is an approach to communication, personal development and psychotherapy. The basic NLP techniques allow you to modify your behaviour for achieving self-improvement, self-management and makes you more creative for effective interpersonal communication. After gaining the basic knowledge, you will be interested to know the advanced NLP tools for real world to apply the NLP knowledge in the real world. The Neuro Linguistic Programming Tools for Life will help you to bring your unconscious thoughts to the surface so that you can take the right decision t the right time. In the course you will learn some of the practical NLP tools and techniques such as anchoring, establishing congruency, developing rapport, creating outcomes, interpreting and presenting information effectively. Learning Outcomes: Improvise a more profound accord with others Apply anchoring to formulate the state of mind you intend to Being identified with your inner entity Decipher as well as implement the radical self-hypnosis methodologies Generate your visionary goals merging a high speed to apply NLP's framework Learn how you can present, explain, as well as information so as to use the 7±2 rule as well as chunking technique Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Neuro Linguistic Programming Tools for Life is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Neuro Linguistic Programming Tools for Life is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Overview 00:15:00 Developing Rapport 00:30:00 Getting in Tune with Yourself 00:15:00 Creating Comprehensive Outcomes 00:15:00 Creating a Desired State 00:30:00 Chunking Information 00:15:00 Mock Exam Mock Exam- Neuro Linguistic Programming Tools for Life 00:20:00 Final Exam Final Exam- Neuro Linguistic Programming Tools for Life 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00