- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00
Diploma in Baking & Cake Decorating
By iStudy UK
Most common baked foods are bread, cookies, cake, pies, tarts, and cupcakes. Learning about baking can take you a lot of time, but it would be advantageous if you learn a specific type of baking. If you want to specialise in cake baking, then this course can help you learn it. This diploma course will provide you lessons on caking baking, decoration, and pastry arts. Course Highlights Diploma in Baking & Cake Decorating is an award-winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Diploma in Baking & Cake Decorating into 38 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 2 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Diploma in Baking & Cake Decorating Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Diploma in Baking & Cake Decorating is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Diploma in Baking & Cake Decorating 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Diploma in Baking & Cake Decorating - Updated Version Basic Concepts of Baking 00:16:00 Basic Ingredients of Baking 00:28:00 Glossary and Equipment Used in Baking 00:34:00 Types of Cakes 00:14:00 Baking Principles 00:25:00 Cake Decorating Recipes 00:19:00 Cake Decorating Ideas 00:21:00 Frosting and Icing 00:24:00 Working with Different Pastes 00:20:00 Working with Glazes 00:28:00 How to Stack a Cake 00:21:00 Piping and Writing 00:24:00 Health, Safety and Food Hygiene 00:20:00 Troubleshooting 00:20:00 Cake Decorating Business 00:19:00 Diploma in Baking & Cake Decorating - Old Version Baking and Cake Decorating Introduction and History 00:30:00 Popular Methods of Cake Decorating 01:00:00 Baking a Cake 01:00:00 Making Alternative Cakes 01:00:00 Cake Decorating 01:00:00 Birthday Cake Decorating 01:00:00 Different Cake Decorating 01:00:00 Wedding Cake Decorating 01:00:00 Occasional Cake Decorating 01:00:00 Wedding and Baby Showers Cake 01:00:00 Common Cake Decorating Supplies 01:00:00 Learning to Decorate Cakes 00:30:00 Icing the Cake 01:00:00 Starting a Cake Decorating Business 00:30:00 Creating a Cake Decorating Blog 00:15:00 Conclusion 00:30:00 Decorating the Cake The Cake 01:00:00 Frosting The Cake 01:00:00 Equipment 01:00:00 Borders & Decorations 01:00:00 Leaves And Flowers 01:00:00 Lettering 01:00:00 Special Effects 01:00:00 Mock Exam Mock Exam- Diploma in Baking & Cake Decorating 00:20:00 Final Exam Final Exam- Diploma in Baking & Cake Decorating 00:20:00
Tired of browsing and searching for a Web Development course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Web Development bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Web Development course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Web Development and help you along your learning journey. Advanced audio-visual learning modules of these Web Development courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Web Development, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Web Development Bundle Consists of the following Premium courses: Course 01: Diploma in PHP Web Development Course 02: HTML Web Development for Beginners Course 03: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 04: WordPress Website Creation and Hosting System with Affiliate Marketing! Course 05: Computer Science With Python Course 06: Python Programming for Everybody Course 07: Complete Web Application Penetration Testing & Security Course 08: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 09: Web Design in Affinity Designer Course 10: Advanced Diploma in User Experience UI/UX Design Course 11: Level 2 Adobe Graphics Design Course Course 12: Diploma in Animation Design Course 13: Cyber Security Incident Handling and Incident Response Course 14: Decision Making and Critical Thinking Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum: Course 01: Diploma in PHP Web Development Introduction Environment Configuration PHP Basics and Syntax PHP Forms and MySQL and User Authentication Course 02: HTML Web Development for Beginners Setup and Overview Basic Tags Headings Lists Links Images Tables Advanced Tables Meta Tags Description Lists Presentation Iframe Video Audio Forms CSS JavaScript Course 03: Create Your First Responsive Website Introduction Project Files Project Setup Website Structure Part-1 Website Structure Part-2 Chrome Dev Tools Top Menu Image Area Service Responsive Page Conclusion Course 04: WordPress Website Creation and Hosting System with Affiliate Marketing! Section 01: I Wish this Class Was Available for me When I Started My Business Online! Executive Summary of My Website with WordPress Section 02: Introduction Part 1: Best WordPress Website Creation and Hosting System with Affiliate Marketing! How to Build the Website, Hire Help, and Earn Money Making Websites on Upwork Affiliate Marketing Setup with Footer Links Plus a Bitly Custom Short Domain What Email Marketing Provider Do I Use? The System I Used to Get 400 Blog Posts on My Website Fast in My Voice WordPress Plugins, Collecting Emails, Consistency, and More Questions Section 03: Introduction Part 2: Why I Switched to the Google Cloud Platform Managed by Kinsta With My Faster Website Hosting, I have Improved my Website Rapidly! Why I Deleted My Email List! Section 04: Thank You for Watching! Course 05: Computer Science With Python Module 01: Introduction Module 02: Getting Started Module 03: Procedures and Loops Module 04: How to Manage Data Course 06: Python Programming for Everybody Course 07: Complete Web Application Penetration Testing & Security Course 08: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 09: Web Design in Affinity Designer Course 10: Advanced Diploma in User Experience UI/UX Design Course 11: Level 2 Adobe Graphics Design Course Course 12: Diploma in Animation Design Course 13: Cyber Security Incident Handling and Incident Response Course 14: CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Web Development bundle. Requirements Our Web Development course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Web Development expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included
Course Overview: The plumbing and heating industry is a pillar in modern infrastructure, with an ever-growing demand worldwide. The UK Standard Domestic Plumbing and Heating Installer Training course is crucial in meeting this demand.Throughout this course, we will dive into the intricacies of plumbing and heating systems, covering essential modules such as Basic Components of Plumbing, Principles of Effective Plumbing Systems, The Plumbing Tools, The Plumbing Process, Central Heating Systems, Domestic Cold Water Systems, Domestic Hot Water System, The Sanitation System and Repairs, Domestic Rainwater System Installation, Plumbing Projects: Case Study, and UK Standards for Plumbing. Enrol in the UK Standard Domestic Plumbing and Heating Installer Training course today and unlock the door to many opportunities in this thriving industry. Key Features of the Course: 12 modules covering all aspects of plumbing and heating High-quality lectures CPD certificate upon successful completion 24/7 learning assistance and support Who is This Course For? This course is for anyone who wants to improve their plumbing and heating skills and knowledge. This course is also suitable for anyone pursuing a plumbing and heating career. What You Will Learn: In this course, you will learn the following: The essential components of plumbing include pipes, fittings, valves, taps, and fixtures. You will learn how they work together to form a plumbing system. The principles of adequate plumbing systems include water pressure, flow rate, drainage, and ventilation. You will learn how they affect the performance and efficiency of the plumbing system. The plumbing tools that you need to use for different tasks, such as cutting, bending, joining, and sealing pipes. You will learn how to use them safely and correctly. The plumbing process that you need to follow for different projects, such as planning, measuring, marking, installing, testing, and troubleshooting. You will learn how to apply your skills in various scenarios. The central heating systems include boilers, radiators, pumps, and controls. You will learn how they work together to provide heating for the building. The domestic cold and hot water systems use different methods and materials. You will learn how to install them according to the UK standards and regulations. The sanitation system and repairs using different types of toilets, sinks, baths, showers, and waste pipes. You will learn how to install them according to the UK standards and regulations. The domestic rainwater system installation using gutters, downpipes, tanks, and filters. You will learn how to install them according to the UK standards and regulations. Requirements: There are no specific requirements for taking this course. All you need is a computer or a mobile device with an internet connection and a willingness to learn and improve your plumbing and heating skills. Career Path: Plumbing and heating skills are essential for any career path. Whether you work in a domestic or commercial building, you must ensure high-quality service for yourself and your customers. Plumber - average salary of £31,000 Heating engineer - average salary of £34,000 Gas engineer - average salary of £33,000 Maintenance technician - average salary of £26,000 Plumbing inspector - average salary of £29,000 Plumbing instructor - average salary of £30,000 Plumbing manager - average salary of £37,000 Certification: Upon completing the course, you will receive a CPD certificate that you can download and print. You can also share your certificate online with friends, family, and employers. Course Curriculum 1 sections • 12 lectures • 03:00:00 total length •Module 01: Basic Components of Plumbing: 00:15:00 •Module 02: Principles of Effective Plumbing Systems: 00:15:00 •Module 03: The Plumbing Tools: 00:15:00 •Module 04: The Plumbing Process: 00:15:00 •Module 05: Central Heating Systems: 00:15:00 •Module 06: Domestic Cold Water System: 00:15:00 •Module 07: Domestic Hot Water System - Part 1: 00:15:00 •Module 08: Domestic Hot Water System - Part 2: 00:15:00 •Module 09: The Sanitation System and Repairs: 00:15:00 •Module 10: Domestic Rainwater System Installation: 00:15:00 •Module 11: Plumbing Projects: Case Study: 00:15:00 •Module 12: UK Standards for Plumbing: 00:15:00
Complete Microsoft Office: 8 Course Bundle + Practice Templates
By SkillWise
Overview Become a master of workplace efficiency with the tools available in Microsoft Office Suite. Whether you want to advance your career or develop your knowledge, skills and productivity in the modern office environment, taking this Complete Microsoft Office: 8 Course Bundle + Practice Templates course is an ideal choice to gain the expertise you need to succeed. This bundle course is designed to help professionals advance their career in IT and guide them through every stage of their IT career, from choosing the right career path to earning qualifications and career advancement strategies. This comprehensive course provides expert-crafted content and interactive resources that will help you to gain professional-level skills and proficiency in Microsoft Office's suite of software. You will also discover a wide range of topics enabling you to master the capabilities of Microsoft Office Suite. Successful completion of the course can lead to a career as a computer support specialist, computer systems analyst, network systems administrator and many more. Highlights of Complete Microsoft Office: 8 Course Bundle + Practice Templates : Be able to create basic spreadsheets and use formulas for tracking expenses. Learn how to use complex formulas and perform data analysis on your organisation's revenue and expense patterns. Successfully take your Excel skills to the ultimate level with advanced charts, graphs, formulas and data analysis. Make impressive presentations for your next business conference or meeting, assignment or project work using animation, audio or video and collaborative tools. Master the art of data management, customer tracking, and buying patterns. Learn how to automate repetitive and time-consuming Excel procedures and operations for highest efficiency. Create eye-catching documents starting from scratch and take advantage of Word's spelling, grammar and translation capabilities. 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 Online study materials Mock exams Multiple-choice assessment How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Whether you're an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge. The Complete Microsoft Office: 8 Course Bundle + Practice Templates is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
