4488 Numeracy courses in Sheffield delivered On Demand

Effectively oversee the planning, design, and execution of a building project with the Construction Management Diploma Level 5 course. This certificate program is designed to teach fundamental methods of construction and management, covering all aspects of construction projects, from planning and scheduling to management theories and cost estimation. You will also explore the project delivery and production process, project control techniques, and how to schedule construction materials. Throughout this construction project management course, you will develop essential management skills and practical, real-world knowledge, to boost your professional development. This course is ideal for those who already work in the construction industry and are seeking a more senior role. Learning Objective: Understand the role and responsibilities of a Construction Manager Identify the different elements of the design and construction process Explore methods of project delivery and current industry trends Develop your problem-solving, communication and decision-making skills Learn the characteristics of a successful construction project Explore estimation strategies for working out the cost of a construction project Demonstrate a solid understanding of modern construction planning Familiarise with construction materials and equipment safety procedures Explore the basic components of a supply chain management system Who is This Course for? This Construction Management Diploma Level 5 is ideal for beginners who want an introduction to this field to develop the essential skills required for project planning, design and construction work. No previous experience is required to enrol and learners from all academic backgrounds will benefit from this specialist beginners training. Train online from the comfort of your own home and study at your own pace, with our distance learning program. On successful completion, learners will receive a certificate of achievement, which will help them to advance their career opportunities in this field. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Career Path: After completing your online studies, you will have the opportunity to explore a wide range of job roles within the field of construction management, including: Construction Manager Assistant Project Manager Development Project Manager Building Inspector Construction Assistant Construction Supervisor Project Assistant Course Curriculum Module 01: Introduction to Construction Management Introduction to Construction Management 01:00:00 Assessment Module 01 Module 01 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 02: Construction Project Stages Construction Project Stages 01:00:00 Assessment Module 02 Module 02 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 03: Estimating Construction Project Costs Estimating Construction Project Costs 00:30:00 Assessment Module 03 Module 03 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 04: Construction Project Planning Construction Project Planning 00:40:00 Assessment Module 04 Module 04 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 05: Site Organisation in the Construction Industry Site Organisation in the Construction Industry 00:40:00 Assessment Module 05 Module 05 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 06: Construction Resource Management Construction Resource Management 00:40:00 Assessment Module 06 Module 06 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 07: Subcontracting in the Construction Industry Subcontracting in the Construction Industry 00:30:00 Assessment Module 07 Module 07 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 08: Construction Cost and Time Control Part 1: Construction Cost Control 00:35:00 Part 2: Time Management in the Construction Industry 00:30:00 Assessment Module 08 Module 08 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 09: Equipment Cost Management Equipment Cost Management 00:20:00 Assessment Module 09 Module 09 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 10: Elements of Contractor Failure Elements of Contractor Failure 00:25:00 Assessment Module 10 Module 10 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 11: Supply Chain Management in the Construction Industry Supply Chain Management in the Construction Industry 00:20:00 Assessment Module 11 Module 11 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 12: Quality Management in the Construction Industry Quality Management in the Construction Industry 00:30:00 Assessment Module 12 Module 12 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 13: Human Resources Management Human Resources Management 00:45:00 Assessment Module 13 Module 13 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 14: Risk Analysis and Management Risk Analysis and Management 00:25:00 Assessment Module 14 Module 14 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 15: Health and Safety in the Construction Industry Part 1: Key Legislation and Regulations for The Construction Industry 00:30:00 Part 2: Managing Safety within the Construction Industry 00:20:00 Assessment Module 15 Module 15 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 16: Sustainability and the Environment Sustainability and the Environment 00:25:00 Assessment Module 16 Module 16 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00

Description: The Office Admin and Legal Secretary Diploma course teaches you the techniques and skills for managing an Office as Office Admin or managing the role of a legal secretary. You will learn administration management skills, organisational skills and essential office management skills. The course also covers the skills required for a legal secretary such as fundamental concepts of the legal office, billing, preparing legal documents, contracts, torts, real estate, family law, business law, telephone etiquette, meeting management and minute management and more Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal people who want to start working as a receptionist, office administrator, office manager, administration assistant or secretary 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 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: Office Admin and Legal Secretary Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Administrator support staff Administrative assistant Office managers Receptionist Office administrator Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Office Management Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:30:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:15:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Minute Taking tips 00:30:00 Other Secretarial Roles and Responsibilities Working with Your Manager 01:00:00 Administrative Soft Skills 01:00:00 Effective Time Management 01:00:00 Tools of the Trade 01:00:00 Being an Effective Gatekeeper 00:15:00 Organizational Skills 00:15:00 Confidentiality Guidelines 00:15:00 Special Tasks 00:15:00 Legal Office Administration Ethical Considerations 00:10:00 The Basics 00:04:00 Client Relations 00:05:00 Dealing With Mail 00:05:00 File Management 00:03:00 Use Of Technology 00:06:00 Skills that Every Legal Secretary Should Have 00:06:00 What is Litigation 00:04:00 Delivery of Documents 00:04:00 Motions Prior to and During Trial 00:07:00 The Basics 00:04:00 The Essential Elements 00:03:00 Remedies for Breach of Contract 00:04:00 Customer Service Role Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Telephone Etiquette Aspects of Phone Etiquette 01:00:00 Using Proper Phone Language 01:00:00 Eliminate Phone Distractions 01:00:00 Inbound Calls 01:00:00 Outbound Calls 01:00:00 Handling Rude or Angry Callers 01:00:00 Handling Interoffice Calls 01:00:00 Methods of Training Employees 01:00:00 Correcting Poor Telephone Etiquette 01:00:00 Organizing Work Using MS Word Opening 01:00:00 Working with the Interface 01:00:00 Your First Document 01:00:00 Basic Editing Tasks 01:00:00 Basic Formatting Tasks 01:00:00 Formatting Paragraphs 00:01:00 Advanced Formatting Tasks 01:00:00 Working with Styles 01:00:00 Formatting the Page 01:00:00 Sharing Your Document 01:00:00 Proof Reading Introduction to Proofreading 00:15:00 What does a Proofreader do? 00:15:00 Proofreading 00:15:00 Proofreading Symbols 00:15:00 Proofreading on Paper & Screen 00:15:00 Strategies to Check for Specific Errors 00:15:00 Editing & Proofreading Strategies 00:15:00 Proofreading an Essay 00:15:00 Mock Exam Mock Exam- Office Admin and Legal Secretary Diploma 00:30:00 Final Exam Final Exam- Office Admin and Legal Secretary Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Web development is everything involved in the creation of a website. Typically it refers to the coding and programming side of web site production as opposed to the web design side. It encompasses everything from a simple page of HTML text to complex, feature-rich applications designed to be accessed from various Internet-connected devices. The Junior Web Developer Course is designed to teach you all about you need to become a web developer! You will learn the basics, designing, and planning for web development. Through the course, you will be able to build websites and web apps, start your own online business, comfortable front-end developer, and more! Who is this Course for? Junior Web Developer Course 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 the 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 Web Development Basics What Are Niche Website? 01:00:00 The Role Of Visualization In Education 00:15:00 Identify Your Best Platform Or Software 01:00:00 Select A Web Host 01:00:00 Collect Your Site 00:15:00 Building A Content Rich Website 00:15:00 Build Backlinks 00:30:00 Use SEO, Multimedia And Social Sites 01:30:00 Use Analytics 01:00:00 Wrapping Up 00:15:00 Design & Planning How to Choose the Best Website Design for Your Business 01:00:00 What's in a Domain Suffix? 00:15:00 Website Design Terminology 01:00:00 CSS Explained 00:30:00 Website Designs with Staying Power 00:15:00 How Can I Build my Website for Free 00:30:00 Six Steps to Website Design for Beginners 01:00:00 Dreamweaver or CoffeeCup for Website Design 01:00:00 Using Dreamweaver to Create your Site Layout 00:30:00 Three Crucial Steps to Creating Your Website 00:15:00 Dos and Don'ts of Website Creation 00:30:00 SEO Basics for Effective Website Design 00:15:00 Ideas for Your Internet Business Website Design 01:00:00 Immediately Applicable Design Tips for a User-Friendly Website 00:30:00 6 Reasons to Create a Website 00:15:00 Common Website Design Mistakes 00:30:00 Too Much or Too Little 00:15:00 Why Successful Website Development Does Not Stop at Design 00:15:00 Ideas for Your Personal Website Design 01:00:00 How to Create a Social Networking Website to Enhance your Business 01:00:00 Tips for Designing an Affiliate Website 00:15:00 How to Use WordPress for your Website 00:15:00 Top 14 Reasons to Create a Blog 00:30:00 More Tips for Designing a Successful Blog 00:30:00 More Tips for Designing a Successful Blog 00:30:00 Basic Coding for Web Development HTML Basics 00:30:00 CSS Basics 01:00:00 Web Design & Development: HTML5, CSS3 and JavaScript 02:00:00 PHP Programming Welcome to the world of programming! 00:05:00 Getting Started 00:05:00 Let's Start Coding! 00:05:00 PHP Strings 00:05:00 PHP Variables 00:05:00 Useful Variables 00:05:00 PHP Includes & Problem Solving 00:05:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:05:00 Multiple Conditions 00:05:00 PHP Arrays 00:05:00 PHP Loops 00:05:00 Note on PHP Math Functions: 00:05:00 Functions 00:05:00 PHP Sessions 00:30:00 Cookies 00:05:00 Introduction to MySQL 00:05:00 Making The Connection 00:10:00 Inserting Data 00:05:00 Deleting / Removing Data 00:15:00 Recommended Reading Recommended Reading : Junior Web Developer Course 00:00:00 Mock Exam Mock Exam- Junior Web Developer Course 00:30:00 Final Exam Final Exam- Junior Web Developer Course 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Some people consider the teaching profession only loaded with never-ending paperwork. However, it's also a profession that's filled with premia that surpass the tribulations. The Level 3 Diploma in Teaching course is meant to introduce you to the theoretical considerations and practical experience that help you become a great teacher. This innovative course will provide you with a multiracial educated program consisting of several informational modules. Additionally, you will understand the skills and experience required to become an efficient teacher, and how to turn your ability and enthusiasm into a rewarding career. Who is this Course for? Level 3 Diploma in Teaching 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 Fundamentals of Teaching Understanding the Development of Children and Young Person 01:00:00 Communication and Professional Relationships with Pupils and Family 01:00:00 Safeguarding the Welfare of Children and Young Person 01:00:00 Teaching in UK Teaching in the UK 00:10:00 Teachers' Standards in UK 00:10:00 Teachers Pay 00:30:00 The English School System 00:10:00 Evaluation of Schools and Teachers 00:30:00 School Governance 00:15:00 Inclusive Teaching 00:15:00 Teaching Methodologies Chapter I 01:00:00 Chapter II 01:00:00 Chapter III 01:00:00 Chapter IV 01:00:00 Chapter V 01:00:00 Chapter VI 01:00:00 Chapter VII 01:00:00 Chapter VIII 01:00:00 Chapter IX 01:00:00 Chapter X 01:00:00 Chapter XI 01:00:00 Chapter XII 00:20:00 Chapter XIII 01:00:00 Chapter XIV 01:00:00 Chapter XV 01:00:00 Psychology of Teaching Why Young People Do Not Learn to Study Properly? 00:20:00 The Nature of Study, and Its Principal Factors 00:30:00 Provision for Specific Purposes, as One Factor of Study 00:40:00 The Supplementing of Thought, as a Second Factor of Study 00:15:00 The Organization of Ideas, as a Third Factor in Study 00:30:00 Judging of the Soundness and General Worth of Statements, as a Fourth Factor in Study 00:25:00 Memorizing, as a Fifth Factor in Study 02:00:00 The Using of Ideas, as a Sixth Factor in Study 00:25:00 Provision for a Tentative Rather Than a Fixed Attitude Toward Knowledge, as a Seventh Factor in Study 00:20:00 Provision for Individuality, as an Eighth Factor in Study 00:15:00 Full Meaning of Study: Relation of Study to Children and to the School 00:15:00 SEN Teaching Introduction to Special Educational Needs (SEN) 00:05:00 Understand Constructivism in the Classroom and know your role as a teacher 00:10:00 SEN Code of Practice 00:15:00 Get an understanding on SENCO 00:10:00 Classroom Management Strategies for Children with Special Needs 00:05:00 Physical Difficulties, Sensory Difficulties, Cognitive Impairments of Pupils 00:10:00 How to Deal with Pupils with Autism 00:10:00 Understanding Learning Difficulties 00:10:00 Anger Management Methods for Pupils With Special Needs 00:10:00 Teaching Children with Down Syndrome 00:10:00 Conclusion SEN 00:05:00 ADHD What is ADHD? 00:05:00 Causes of ADHD 00:05:00 Diagnosing ADHD 00:05:00 Treating ADHD 00:05:00 ADHD and Education 00:05:00 Reasonable Adjustments: ADHD 00:10:00 Adults with ADHD 00:10:00 Mock Exam Mock Exam-Level 3 Diploma in Teaching 00:20:00 Final Exam Final Exam-Level 3 Diploma in Teaching 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The Real Estate Bundle is the most unique Real Estate Brokerage around! Not only are they offering unique bundles to their clients, but working there is an incredible opportunity. The Real Estate Bundle Course is designed to give both lessons on real estate business and property management. Learning these two lessons will not only help you know about real estate, but it would also be helpful in building your professional career in the real estate industry. This course will give you the fundamental information about the real estate industry and how to become a real estate agent. Who is this Course for? Real Estate Bundle Course 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 the 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 Real Estate What Is Real Estate Investing? 00:10:00 Basic Rental Properties 00:10:00 Why invest in property? 00:05:00 Investment After Brexit 00:10:00 Recent Housing Market Developments 00:05:00 Managing Client Expectation 00:05:00 Best Practices of Customer Service 00:05:00 Customer Life Cycle 00:05:00 Tenant Retention 00:05:00 Real Estate Marketing 00:10:00 Introduction to Real Estate Business The Art of Real Estate Investments 00:45:00 Things to Consider Before Investing in Real Estate 00:45:00 Simple Techniques of Investing in Real Estate 01:30:00 Risks Involved in Real Estate Investment 00:45:00 The Main Challenges Facing Real Estate Investors 00:30:00 Qualities of Successful Real Estate Investors 00:45:00 How to Succeed in Real Estate Investments 01:00:00 Wrapping Up 00:15:00 Legal System & Real Estate UK An Introduction to the UK legal system 00:05:00 Different Types of Investment Structures 00:05:00 Commercial Leases 00:05:00 Title & Registration 00:05:00 Finance in Real Estate 00:05:00 Investment Purchase Procedure 00:05:00 Acquisition Costs 00:05:00 Land Usage 00:05:00 Planning & Environment 00:05:00 Investment Structure & Key Legislations 00:05:00 Property Development What is Property Development? 00:05:00 The Players in the Property Market 00:05:00 The Risks of Property Development 00:05:00 The Stages of a Property Development 00:05:00 Site Identification and Acquisition 00:05:00 Property Management 00:05:00 Property Management Selecting The Best Properties 00:05:00 Leasing Instead Of Selling 00:05:00 Buyers Interest 00:05:00 Be Zone Conscious 00:05:00 Home Loans 00:05:00 Knowing When You're Ready To Buy 00:05:00 Is Your Lake Home For Sale? 00:05:00 Living The Waterfront Lifestyle Every Day 00:05:00 How To Locate Waterfront Property Rentals 00:05:00 Real Estate Front 00:05:00 How To Maintain Waterfront Property 00:05:00 All About Real Estate Clients 00:05:00 Real Estate Evaluation 00:05:00 Are You Ready To Buy Your First Property? 00:05:00 Finding The Actual Real Estate For Sale 00:05:00 Home Shopping: The Smart Way 00:05:00 How Much Land Do You Need? 00:05:00 Real Estate Investments 00:05:00 Manufacturing Real Estate Numbers 00:05:00 Waterfront Real Estate 00:05:00 Purchasing A Home Beside A Lake 00:05:00 Additional Supporting Material Fundamentals of Real Estate Development 00:00:00 Mock Exam Mock Exam- Real Estate Bundle Course 00:30:00 Final Exam Final Exam- Real Estate Bundle Course 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Course Overview The demand for iOS apps is increasing every day. If you want to build your career as an app developer or programmer, learning iOS app development will be a smart choice for you. Learn how to create iOS apps using Swift 5 from this Build your first iOS 14 apps using swift 5 course and take your first step to be a pro developer. This course will help you understand Swift coding and solve your problems with app development. In this Build your first iOS 14 apps using swift 5 course, you will learn about the functions of Swift programming, variables and types, operations, collections, flow control, classes and inheritance. You will be able to create your first iOS app using swift 5 and enhance your skill to start your career as an iOS app developer.  This course will help you understand the app development process step by step with easily understandable bite-sized lessons.  Learning Outcomes Get a clear understanding of the fundamentals of iOS and Swift development Learn iOS development programming from scratch Be able to operate Swift 5 Learn the functions of Swift 5 Learn what you should consider before making an iOS app Gain the skills to be an efficient app developer Who is this course for? This course is designed for you to learn how to design iOS applications using swift 5. Anyone interested in app development can learn effective app development skills from this course 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 Build your first iOS 14 apps using swift 5 is a useful qualification to possess and would be beneficial for any related profession or industry such as: Ios Developers Programmers Designers Unit 01: Introduction Module 01: Setup 00:02:00 Module 01: A Quick Reminder 00:01:00 Unit 02: Variables and Types in Swift Programming Module 01: Variables Strings and Constants in Swift 00:08:00 Module 02: Solution - Variables Strings and Constants in Swift 00:01:00 Module 03: Variables and Numbers in Swift 00:07:00 Module 04: Solution - Variables and Numbers in Swift 00:01:00 Module 05: Type conversions in Swift - Danger Will Robinson 00:05:00 Module 06: Solution - Type conversions in Swift - Danger Will Robinson 00:02:00 Module 07: Tuple Types in Swift 00:05:00 Module 08: Solution - Tuple Types in Swift 00:02:00 Unit 03: Optionals in Swift and the Null Problem Module 01: Optionals Nulls and Variables in Swift 00:05:00 Module 02: Solution - Optionals Nulls and Variables in Swift 00:01:00 Unit 04: Operators in Swift Module 01: Operators in Swift - Assignment Arithmetic and Concatenation 00:04:00 Module 02: Solution - Operators in Swift - Assignment Arithmetic and Concatenation 00:01:00 Module 03: Operators in Swift - Unary Compound Logic and Comparison 00:04:00 Unit 05: Collections in Swift Module 01: Collections in Swift - Arrays 00:05:00 Module 02: Solution - Collections in Swift - Arrays 00:02:00 Module 03: Collections in Swift - Sets 00:06:00 Module 04: Collections in Swift - Dictionaries 00:05:00 Module 05: Solution - Collections in Swift - Dictionaries 00:03:00 Unit 06: Flow Control in Swift Module 01: Controlling Flow in Swift - for in loops 00:08:00 Module 02: Solution - Controlling Flow in Swift - for in loops 00:03:00 Module 03: Controlling Flow in Swift - While loops 00:04:00 Module 04: Solution - Controlling Flow in Swift - While loops 00:02:00 Unit 07: Conditional Statements in Swift Module 01: Conditional Statements in Swift - If Else 00:04:00 Module 02: Solution - Conditional Statements in Swift - If Else 00:02:00 Module 03: Conditional Statements in Swift - Switch Case 00:04:00 Module 04: Solution - Conditional Statements in Swift - Switch Case 00:02:00 Unit 08: Control Transfer in Swift Module 01: Control Transfer in Swift - continue break fallthrough return throw 00:06:00 Unit 09: Functions in Swift Module 01: Functions in Swift 00:10:00 Module 02: Solution - Functions in Swift 00:03:00 Module 03: Nested Functions in Swift 00:04:00 Module 04: Solution - Nested Functions in Swift 00:03:00 Unit 10: Enumerations in Swift Module 01: Enumerations in Swift 00:05:00 Module 02: Solution - Enumerations in Swift 00:01:00 Unit 11: Classes and Inheritance in Swift Module 01: Classes in Swift 00:05:00 Module 02: Solution 1 - Classes in Swift 00:02:00 Module 03: Solution 2 - Classes in Swift 00:02:00 Module 04: Inheritance in Swift 00:07:00 Module 05: Solution - Inheritance in Swift 00:04:00 Unit 12: Your First iOS App Module 01: Your First iOS App and Familiarisation 00:05:00 Module 02: The Key iOS Project Files 00:06:00 Module 03: How to Implement a Button in the User Interface 00:05:00 Module 04: How to Connect a Button to Code in Xcode 00:05:00 Module 05: Writing Code to Change a Views Appearance and a TASK 00:02:00 Module 06: Solution to the Task and If Else View Colors 00:07:00 Unit 13: Temperature Conversion App - iOS Layouts Positioning and Buttons Module 01: A Preview of the App We Will Build 00:01:00 Module 02: Create the App and Its User Interface 00:02:00 Module 03: iOS Layouts and Positioning 00:10:00 Module 04: Connecting UI Elements to Code 00:05:00 Module 05: Converting Temperature via Button Click 00:06:00 Module 06: Adding a Bit of Excellence to the UI and a Task for You 00:06:00 Module 07: Task Solution - Adding a Conversions Counter Label 00:07:00 Unit 14: Gods App - Navigation Table Views and Data Passing Module 01: What we are Building 00:02:00 Module 02: Creating the GreekGod Data Model 00:06:00 Module 03: Navigation Controllers in iOS 00:06:00 Module 04: Creating Fake Gods 00:04:00 Module 05: How to Set Up a Table View and Its Controller 00:11:00 Module 06: Task Solution - How to Fix the Table View 00:04:00 Module 07: How to Navigate from Table View to New View in iOS 00:04:00 Module 08: Create a View Controller for the Detail View 00:03:00 Module 09: Passing Data from Table View to View Controller 00:04:00 Module 10: Setting up a Detail View Controller with Passed Data 00:11:00 Module 11: Using Images and ImageViews in Swift - And a Task 00:04:00 Module 12: Solution to the Task 00:04:00 Unit 15: Will I Burn App - Accessing APIs and Device Hardware - GPS Module 01: Preview of the App We Will Make 00:02:00 Module 02: Structures Instead of Classes 00:05:00 Module 03: How to Request Permissions and Capabilities in iOS 00:04:00 Module 04: Requesting User Permissions in iOS - Part 2 00:09:00 Module 05: Requesting User Permissions in iOS - Part 3 00:07:00 Module 06: Creating a SWEET User Interface 00:09:00 Module 07: Task - Connect the UI to Code 00:01:00 Module 08: Connecting User Interface to Code 00:02:00 Module 09: Action Sheet Alerts in iOS 00:05:00 Module 10: Update a Label and Thoughts on Storage 00:03:00 Module 11: User Defaults Storage in iOS 00:05:00 Module 12: Getting and Setting User Defaults in iOS 00:04:00 Module 13: Getting a Location in Latitude and Longitude in iOS Apps 00:04:00 Module 14: Selecting an API Provider for Your Apps 00:07:00 Module 15: Generating an API Key and Exploring the Docs 00:04:00 Module 16: Create an API Access Class in Swift 00:04:00 Module 17: Using Third Party Libraries in iOS - AlamoFire 00:06:00 Module 18: How to Use AlamoFire in iOS 00:08:00 Module 19: How to Extract JSON Data from an API Call 00:06:00 Module 20: Performing Background Calculations in iOS 00:06:00 Module 21: Performing Background Calculations in iOS - Part 2 00:07:00 Module 22: Activity Indicators in iOS and Swift 00:07:00 Module 23: Local Notifications in iOS 00:06:00 Module 24: Solution to the Task - UI Smoothing 00:05:00 Unit 16: Whatsapp Clone Using Google Firebase Module 01: Preview of What We're Building 00:03:00 Module 02: Should you Choose Firebase or Firestore 00:10:00 Module 03: Create a Firebase Application 00:03:00 Module 04: Installing Firebase in your iOS App 00:09:00 Module 05: Firebase Authentication Options 00:05:00 Module 06: Designing the Auth Screen 00:10:00 Module 07: Connecting UI to Code 00:04:00 Module 08: Showing the Auth Screen 00:11:00 Module 09: Validating User Input for Firebase Authentication 00:08:00 Module 10: Register a User in Firebase 00:05:00 Module 11: Logging in via Firebase 00:06:00 Module 12: Set Activity Indicator to Show Network Processing 00:07:00 Module 13: How to Reset a Firebase User Password 00:11:00 Module 14: How to Prevent Dismissal of a View Controller 00:02:00 Module 15: Setting up a Table View and Cell Manually 00:11:00 Module 16: Connecting a TableView and ViewController Manually 00:05:00 Module 17: Implementing TableView Functions in the ViewController 00:06:00 Module 18: Listening to Firebase Data Streams on iOS 00:09:00 Module 19: Demo with Dummy Data 00:03:00 Module 20: Using a TextField Delegate in iOS 00:03:00 Module 21: Sending Data from iOS to Firebase Database 00:05:00 Module 22: Well Done and a Couple HARD TASKS with NO SOLUTION 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn Yoga and start practising yoga with the video course entitled Yoga Training Diploma. Yoga helps you to improve your physical, mental, and spiritual condition. The course covers the powerful Pranashama Yoga techniques, sequences along with the concepts and techniques of Chakra balancing, meditation, nutrition, Acro or partner Yoga and Thai massage healing. The course is helpful for both Yoga trainers and individuals who want to learn Yoga. Apart from the Yoga exercise, the course also presents the recipes of Yoga Detox diet, juicing, and making smoothies. You will also know some of the short yoga practices and specific poses such as Donkey kicks, mermaid pose, vibrator technique, yoga abs and more. Finally, the course includes some training manuals and ebooks that can work as your guide for a long time. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Yoga Training Diploma 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. Career path The Yoga Training Diploma will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Pranashama Philosophy Pranashama Philosophy 00:48:00 Guided Meditations Meditation for Beginners 00:06:00 Chakra Balancing Meditation 00:09:00 Guided Mediation Love and Yoga Nidra 00:12:00 Empowering Relaxation Guided Meditation 00:20:00 The Prasha Method System of Healing Yoga to Get Grounded 00:19:00 Grounding Yoga 00:55:00 Qi Yoga Flow to Balance Emotions 00:13:00 Fire Practice to Transform & Tone 01:21:00 Journey into the Heart - Upper Back & Shoulders 00:53:00 Yoga Inversions Series 00:34:00 Yoga Inversion Series 2 00:09:00 Yoga Inversion Headstands 00:17:00 Mantra Vinyasa Yoga 00:50:00 Mantra Vinyasa Florida 00:50:00 Eyes Closed Vinyasa 6th Chakra Practice 00:13:00 Mantra Vinyasa Workshop Part 1 00:12:00 Mantra Vinyasa Workshop Part 2 00:12:00 Mantra Vinyasa Part 33 00:04:00 Heart Chakra Practice Part 16 00:13:00 Heart Chakra Practice Part 26 00:13:00 Heart Chakra Practice Part 36 00:13:00 Heart Chakra Practice Part 46 00:13:00 Heart Chakra Practice Part 56 00:01:00 Heart Chakra Practice Part 66 00:12:00 Detox Yoga 00:33:00 Yoga Detox Diet, Juicing & Smoothie Recipe Videos Energy Diet Seminar 00:39:00 Red Smoothie Recipe 00:03:00 Detox Green Juice 00:06:00 Chocolate Chai Spice Smoothie Recipe 00:10:00 Cabbage Wraps Recipe 00:18:00 Partner / Acro Yoga Workshops Thai Yoga Massage - Partner Healing & Love 00:32:00 Acro Yoga Double Wheel Pose 00:01:00 Acro Partner Yoga Triple Plank 00:01:00 Pranashama Yoga Full Classes Transform Your Life with Yoga DVD - full length 01:04:00 Pranashama Yoga Flow - All Levels 00:55:00 30 Minute Core Strengthening and Spinal Balancing Sequence 00:31:00 Adjustments, Anatomy and Alignment Workshops Anatomy & Alignment Staff Pose 00:07:00 Yoga for Back Pain Special Needs Yoga Workshop 00:10:00 Anatomy & Alignment Workshop Fish 00:06:00 Anatomy and Alignment Poses for Very Tight Hips 00:20:00 Adjustments Workshop tight or injured shoulders 00:17:00 Adjustments Workshop Sun Salutation Series 00:25:00 Adjustments Workshop Knee Injury or Pain 00:11:00 Adjustments Workshop Back Pain or Injury 00:10:00 Adjustments Workshop Shoulder Pain or Injury 00:10:00 Adjustments Workshop Legs 00:07:00 Adjustments Workshop Lower Back 00:05:00 45 minute Workshop Yoga for Lower Back and Sciatica Pain Relief 00:45:00 Short Yoga Tutorials and Specifics Poses Running Man Yoga Tutorial 00:04:00 Donkey Kicks Yoga Tutorial 00:04:00 Wild Thing - How to 00:04:00 Yoga Abs 00:04:00 Mermaid Pose Yoga Tutorial 00:08:00 Vibrator Technique - How to 00:05:00 Resources Resources - Yoga Training Diploma 00:00:00 Order Your Certificate

This course will provide you with everything you need to take control of Instagram and attract targeted followers. This comprehensive course guides you with a better understanding of using Instagram and generate more earnings. You will learn how to get started with Instagram, build an audience and increase followers on this incredible platform and sell your products or services. With this course, determine what the best hashtags are for your business and how to use them in every post. Moreover, learn to create interesting and encouraging content and optimise your account for leads. Instagram is ideal for the advertisement since a vast amount of people use Instagram to research on different subjects, and this is where your product or service can be found. Your Learning Goals: Discover what it takes to create an impressive Instagram profile and feed. Get plenty of tips and tricks for producing daily content. Grow genuine Instagram followers. Promote your products or services through Instagram and boost revenue. Be able to collect leads from Instagram. Successfully sell your products or services through Instagram. Who is this Course for? Instagram Marketing Masterclass 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 Introduction About the instructor and the course FREE 00:03:00 DO NOT ENROL until you watch this 00:02:00 INSTAGRAM FUNDAMENTALS Introduction to Fundamentals 00:01:00 Basic Features of Instagram 00:05:00 How Instagram Works 00:04:00 Rule no.1 & Rule no.2 of Instagram Marketing 00:04:00 Purpose and Theme 00:09:00 ACCOUNT SETUP Introduction to Account Setup 00:01:00 Username Selection 00:09:00 Personal or Business Account 00:08:00 How to Create an Amazing Bio Description 00:10:00 How to Select the Perfect Display Image (Profile image) 00:06:00 The Instagram solo link 00:05:00 CONTENT STRATEGY Introduction to Content creation on Instagram 00:01:00 Theme of your account 00:04:00 Quality and Quantity of content 00:09:00 Type of content that work on Instagram 00:11:00 How to create compelling content (non designers) 00:05:00 Free stock photo websites 00:04:00 Tools for creating content: IOS devices 00:10:00 Tools for creating content: Android devices 00:04:00 Tools for creating content: Desktop tools 00:10:00 What to do if you don't have time to create content 00:09:00 Tools to schedule your content 00:13:00 Create the ultimate Content Strategy Plan 00:07:00 GROWTH HACKS Introduction to Growth Hacking 00:01:00 Growth Hack no.1 - Consistency 00:03:00 Growth Hack no.2 - Hashtags 00:10:00 Growth Hack no.3 00:05:00 Growth Hack no.4 - Engaging 00:05:00 Growth Hack no.5 00:08:00 Growth Hack no.6 00:06:00 Growth Hack no.7 00:09:00 Tools to track your growth 00:04:00 ADVERTISING AND PROMOTION Introduction to advertising and promotion 00:01:00 Instagram ads- within the app 00:04:00 Instagram ads - Facebook Ads Manager 00:10:00 Paid shoutouts: how much does it cost 00:09:00 How to reach out to influencers 00:04:00 HOW TO GENERATE LEADS Introduction to lead generation 00:01:00 Rule no.1 - Give value first 00:04:00 Rule no.2 - The 80/20 rule 00:05:00 Call-to-action (CTA) 00:05:00 INSTAGRAM STORIES Introduction to Stories 00:01:00 Basics of the feature 00:05:00 What to share in your strories 00:04:00 CASE STUDIES A final advice 00:02:00 @digi_lifestyle Case Study - From 0 to 1000 in 4 weeks 00:09:00 @lfcgadgets Case Study - From 1000 to 10000+ in 4 months 00:09:00 BONUSES February 2018 - How to create awesome videos for Instagram with Quick app 00:12:00 February 2018 Instagram algorithm update 00:07:00 Instagram Hashtag Algorithm Update March 2018 00:08:00 How to Create Instagram Story Ads with Facebook Ads Manager 00:12:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Presently, there are roughly 1.9 million people working in the hospitality industry. And if you prefer to study this Advanced Diploma in Restaurant and Hospitality Management course, then there is a probability for you to be one of them. We all probably know why the hospitality industry is so thriving these days, and why so many people desire to work in it. We have delicately designed this course where you will learn restaurant and hospitality management at the same time. You will learn how to work in a fast-paced environment and perform varied tasks every day. Become a part of the foodservice industry and learn hospitality management with just one single course. Who is the course for? Any professional who works in the hotel or part of a hotel's management People who have an interest in hospitality and management 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 Advanced Diploma in Restaurant and Hospitality Management - Update Version Module 1: Introduction to Hospitality Management Introduction to Hospitality Management 00:21:00 Module 2: An Overview of Hotel Industry An Overview of Hotel Industry 00:15:00 Module 3: The Process of Selection and Recruitment in Hospitality Industry The Process of Selection And Recruitment in Hospitality Industry 00:18:00 Module 4: The Process of Development and Training in Hospitality Industry The Process of Development and Training in the Hospitality Industry 00:21:00 Module 5: Management of Front Office Operations Management of Front Office Operations 00:16:00 Module 6: Management of Housekeeping, Engineering and Security Operations Management of Housekeeping, Engineering and Security Operations 00:24:00 Module 7: Management of Food and Beverage Operations Management of Food and Beverage Operations 00:17:00 Module 8: Management of Service Quality in Hospitality Industry Management of Service Quality in the Hospitality Industry 00:17:00 Module 9: Marketing in Travel and Tourism Business Marketing in Travel and Tourism Business 00:21:00 Module 10: Accounting in Hospitality Industry Accounting in Hospitality 00:23:00 Module 11: Customer Satisfaction Customer Satisfaction 00:20:00 Module 12: E-Hospitality and Technology E-Hospitality and Technology 00:19:00 Advanced Diploma in Restaurant and Hospitality Management - Old Version Starting a Restaurant Are you ready for the challenge? 00:15:00 How to decide on a concept 00:30:00 Designing your restaurant 00:15:00 Friends and family 00:15:00 Writing a Business Plan 00:30:00 Insurance 00:15:00 Restaurant Organizations that you need to check out. 00:15:00 What are the best Catering Industry Trade Shows? 00:15:00 Managing a Restaurant Managing Yourself 00:30:00 Managing Others 00:30:00 Managing Your Money 00:15:00 Managing Your Food and Supplies 00:30:00 Managing Everything Else 00:30:00 Starting Food Catering Where You Work 00:15:00 Health and safety 00:15:00 Staff, Suppliers and Transport 00:00:00 Food Hygiene 01:00:00 Rules about Menus 00:15:00 Paperwork and Finances 00:15:00 Law 00:15:00 Food Business Food Business Basics 00:45:00 Put Together Your Business Concept 00:10:00 Identify Your Target Market 00:10:00 Identify Your Competition 00:10:00 Write A Mission Statement 00:10:00 Downline Basics 00:15:00 Equipment And Supplies 00:10:00 Marketing And Quality Control 00:10:00 Wrapping Up 00:05:00 Hospitality Introduction to Hospitality 00:15:00 Characteristics of the Hospitality Industry 00:15:00 Relationship Between the Hospitality Industry and Tourism 00:15:00 Types of Accommodation 00:15:00 Types of Room 00:30:00 Types of Hotel Guests 00:15:00 Hospitality Management Introduction to Hospitality Management 01:00:00 Influences Which Affect the Industry 00:05:00 The Development of the Hospitality Industry 00:05:00 Hospitality Brands 00:15:00 Accommodation 00:05:00 Food Service 00:05:00 Successful Quality Management 00:05:00 Certificate and Transcript Order Your Certificates or 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