16726 Courses in Cardiff delivered Online

Level 5 QLS Endorsed Course | CPD Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

Enhance your social media marketing skills with our Ultimate Social Media Marketing Course. Gain essential knowledge, update your skills, and boost your career prospects. Enroll now for CPD accredited certification.

Dive deep into the vast realm of Python data science with our meticulously crafted course: 'Python Data Science with Numpy, Pandas and Matplotlib'. Explore the intricate details of Python, setting the stage with Pandas and Numpy, before delving into the power of Python data structures. With topics ranging from Python Strings to Matplotlib Histograms, you'll gain a holistic insight, ensuring that every dataset you touch unveils its story compellingly. So, if you're keen on transmuting raw data into visual masterpieces or insights, this journey is tailor-made for you. Learning Outcomes Grasp foundational knowledge of Python and its data structures like strings, lists, and dictionaries. Understand the potential of NumPy, from basic array operations to handling multi-dimensional arrays. Master the versatility of Pandas, encompassing everything from dataframe conversions to intricate operations like aggregation and binning. Efficiently manage, manipulate, and transform data using Pandas' diverse functionalities. Create visually striking and informative graphs using the power of Matplotlib. Why buy this Python Data Science with Numpy, Pandas and Matplotlib course? Unlimited access to the course for forever Digital 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 Python Data Science with Numpy, Pandas and Matplotlib there will be a written assignment test which you can take either during or at the end of the course. 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 Python Data Science with Numpy, Pandas and Matplotlib course for? Beginners eager to jumpstart their journey in Python data science. Analysts looking to enhance their data manipulation skills using Python. Statisticians keen on expanding their toolset with Python-based libraries. Data enthusiasts desiring a deep dive into Python's data libraries and structures. Professionals aiming to upgrade their data visualisation techniques. Prerequisites This Python Data Science with Numpy, Pandas and Matplotlib does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Data Science with Numpy, Pandas and Matplotlib 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 Data Scientist: £40,000 - £80,000 Python Developer: £35,000 - £70,000 Data Analyst: £30,000 - £55,000 Business Intelligence Analyst: £32,000 - £60,000 Research Analyst: £28,000 - £52,000 Data Visualization Engineer: £33,000 - £65,000 Course Curriculum Course Introduction and Table of Contents Course Introduction and Table of Contents 00:09:00 Introduction to Python, Pandas and Numpy Introduction to Python, Pandas and Numpy 00:07:00 System and Environment Setup System and Environment Setup 00:08:00 Python Strings Python Strings - Part 1 00:11:00 Python Strings - Part 2 00:09:00 Python Numbers and Operators Python Numbers and Operators - Part 1 00:06:00 Python Numbers and Operators - Part 2 00:07:00 Python Lists Python Lists - Part 1 00:05:00 Python Lists - Part 2 00:06:00 Python Lists - Part 3 00:05:00 Python Lists - Part 4 00:07:00 Python Lists - Part 5 00:07:00 Tuples in Python Tuples in Python 00:06:00 Sets in Python Sets in Python - Part 1 00:05:00 Sets in Python - Part 2 00:04:00 Python Dictionary Python Dictionary - Part 1 00:07:00 Python Dictionary - Part 2 00:07:00 NumPy Library - Introduction NumPy Library Intro - Part 1 00:05:00 NumPy Library Intro - Part 2 00:05:00 NumPy Library Intro - Part 3 00:06:00 NumPy Array Operations and Indexing NumPy Array Operations and Indexing - Part 1 00:04:00 NumPy Array Operations and Indexing - Part 2 00:06:00 NumPy Multi-Dimensional Arrays NumPy Multi-Dimensional Arrays - Part 1 00:07:00 NumPy Multi-Dimensional Arrays - Part 2 00:06:00 NumPy Multi-Dimensional Arrays - Part 3 00:05:00 Introduction to Pandas Series Introduction to Pandas Series 00:08:00 Introduction to Pandas Dataframes Introduction to Pandas Dataframes 00:07:00 Pandas Dataframe conversion and drop Pandas Dataframe conversion and drop - Part 1 00:06:00 Pandas Dataframe conversion and drop - Part 2 00:06:00 Pandas Dataframe conversion and drop - Part 3 00:07:00 Pandas Dataframe summary and selection Pandas Dataframe summary and selection - Part 1 00:06:00 Pandas Dataframe summary and selection - Part 2 00:06:00 Pandas Dataframe summary and selection - Part 3 00:07:00 Pandas Missing Data Management and Sorting Pandas Missing Data Management and Sorting - Part 1 00:07:00 Pandas Missing Data Management and Sorting - Part 2 00:07:00 Pandas Hierarchical-Multi Indexing Pandas Hierarchical-Multi Indexing 00:06:00 Pandas CSV File Read Write Pandas CSV File Read Write - Part 1 00:05:00 Pandas CSV File Read Write - Part 2 00:07:00 Pandas JSON File Read Write Pandas JSON File Read Write Operations 00:07:00 Pandas Concatenation Merging and Joining Pandas Concatenation Merging and Joining - Part 1 00:05:00 Pandas Concatenation Merging and Joining - Part 2 00:04:00 Pandas Concatenation Merging and Joining - Part 3 00:04:00 Pandas Stacking and Pivoting Pandas Stacking and Pivoting - Part 1 00:06:00 Pandas Stacking and Pivoting - Part 2 00:05:00 Pandas Duplicate Data Management Pandas Duplicate Data Management 00:07:00 Pandas Mapping Pandas Mapping 00:04:00 Pandas Grouping Pandas Groupby 00:06:00 Pandas Aggregation Pandas Aggregation 00:09:00 Pandas Binning or Bucketing Pandas Binning or Bucketing 00:08:00 Pandas Re-index and Rename Pandas Re-index and Rename - Part 1 00:04:00 Pandas Re-index and Rename - Part 2 00:05:00 Pandas Replace Values Pandas Replace Values 00:05:00 Pandas Dataframe Metrics Pandas Dataframe Metrics 00:07:00 Pandas Random Permutation Pandas Random Permutation 00:08:00 Pandas Excel sheet Import Pandas Excel sheet Import 00:07:00 Pandas Condition Selection and Lambda Function Pandas Condition Selection and Lambda Function - Part 1 00:05:00 Pandas Condition Selection and Lambda Function - Part 2 00:05:00 Pandas Ranks Min Max Pandas Ranks Min Max 00:06:00 Pandas Cross Tabulation Pandas Cross Tabulation 00:07:00 Matplotlib Graphs and plots Graphs and plots using Matplotlib - Part 1 00:06:00 Graphs and plots using Matplotlib - Part 2 00:02:00 Matplotlib Histograms Matplotlib Histograms 00:03:00 Resource File Resource File - Python Data Science with Numpy, Pandas and Matplotlib 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Ultimate Job Interview in English Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Ultimate Job Interview in English Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Ultimate Job Interview in English Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Ultimate Job Interview in English Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Ultimate Job Interview in English? Unlimited access to the course for forever Digital 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 Ultimate Job Interview in English there will be a written assignment test which you can take either during or at the end of the course. 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 Ultimate Job Interview in English course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Ultimate Job Interview in English does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Ultimate Job Interview in English 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 Ultimate Job Interview in English is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: English for Job Interview: Introduction How to Use this Course? 00:06:00 Better Fluency Habits - Best Learning Habits for a Better Performance 00:09:00 Strategies to Research Companies for Your Field 00:13:00 Starting Your Vocabulary and Pronunciation List 00:09:00 Question 1: Tell Me about Yourself 00:06:00 Job Interview Audio Samples Question 1: Tell Me about Yourself 00:01:00 Question 2: What are Your Key Strength? 00:04:00 Job Interview Audio Samples Question 2: What are Your Key Strengths? 00:01:00 Question 3: Why Should We Hire You? 00:03:00 Job Interview Audio Samples Question 3: Why Should We Hire You? 00:01:00 Question 4: What are Your Weaknesses or Weak Points? 00:03:00 Job Interview Audio Samples Question 4: What is Your Weak Point? 00:01:00 Question 5: Where Do You See Yourself in 5 Years? 00:04:00 Job Interview Audio Samples Question 5: Where Do You See Yourself in 5 Years? 00:01:00 Question 6: Why Do You Want this Job? 00:05:00 Job Interview Audio Samples Question 6: Why Do You Want this Job? 00:01:00 Question 7: Why Did You (or Why Do You Want to) Leave your Current Employer? 00:04:00 Job Interview Audio Samples Question 7: Why Did You (or Why Do You Want to) Leave Your Current Employer? 00:01:00 Question 8: When are You Available to Start? 00:04:00 Job Interview Audio Samples Question 8: When are You Available to Start? 00:01:00 Question 9: How Do You Deal with Pressure or Stress? 00:04:00 Job Interview Audio Samples Question 9: How Do You Deal with Pressure or Stress? 00:01:00 Question 10: How Did You Hear about the Position? 00:02:00 Job Interview Audio Samples Question 10: How Did You hear about the Position? 00:01:00 Question 11: What Do You Know about our Company? 00:03:00 Job Interview Audio Samples Question 11: What Do You Know about our Company? 00:01:00 Question 12: Do You Have Any Questions? 00:03:00 Job Interview Audio Samples Question 12: Do You Have Any Questions? 00:01:00 Question 13: What are Your Salary Expectations? 00:04:00 Job Interview Audio Samples Question 13: What are Your Salary Expectations? 00:01:00 Question 14: Describe Yourself in Three Words/ Describe Your Personality 00:04:00 Job Interview Audio Samples Question 14 : Describe Yourself in Three Words/ Describe Your Personality 00:12:00 Question 15: What Do You Like to Do in Your Free Time? 00:03:00 Job Interview Audio Samples Question 15: What Do You Like to Do in Your Free Time? 00:01:00 Section 02: How to Answer Difficult Interview Question? 5 Kinds of STAR Question 00:09:00 How to Find STAR Interview Stories 00:04:00 How to Write Your STAR Answers 00:05:00 How to Combine Your Stories with the 5 Categories of Question 00:03:00 How to Answer Difficult Interview Questions and the STAR Interview Technique 00:03:00 Tell me about a time when you worked successfully as a Member of a Team? 00:07:00 Describe a Difficult Situation or Task that you had to Deal with? 00:06:00 Tell me about Your Biggest Achievement to Date 00:06:00 Tell me about a Time When you worked with a Difficult Team Member 00:04:00 Tell me about a Time When you had to make a Difficult Decision 00:03:00 STAR Sample Answers Video 1 00:04:00 STAR Sample Answers Video 2 00:04:00 Assignment Assignment - Ultimate Job Interview in English 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Healthy Nutrition Masterclass: Diet & Meal Plan For Health Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Healthy Nutrition Masterclass: Diet & Meal Plan For Health Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Healthy Nutrition Masterclass: Diet & Meal Plan For Health Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Healthy Nutrition Masterclass: Diet & Meal Plan For Health Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Healthy Nutrition Masterclass: Diet & Meal Plan For Health? Unlimited access to the course for forever Digital 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health there will be a written assignment test which you can take either during or at the end of the course. 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Healthy Nutrition Masterclass: Diet & Meal Plan For Health does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Healthy Nutrition Masterclass: Diet & Meal Plan For Health 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 Healthy Nutrition Masterclass: Diet & Meal Plan For Health is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Course Promo 00:02:00 Introduction & What you will learn in the course 00:04:00 who this course is for 00:02:00 what is nutrition 00:01:00 The principles of healthy dieting 00:04:00 the true dieting pyramid 00:04:00 Calorie Balance Calories Explained 00:04:00 bodyweight and health 00:05:00 Calories & bodyweight in a healthy diet 00:02:00 the twinkie diet 00:02:00 weight loss and health 00:03:00 How many calories do you need daily 00:02:00 How To Determine Your Optimal Calorie Intake 00:03:00 healthy weight ranges 00:02:00 How to lose weight if you are close to the optimal range 00:03:00 How to lose weight when you start from a higher weight 00:02:00 Diet breaks 00:05:00 How to track calories 00:05:00 How to lose weight without tracking calories 00:04:00 Food Composition food composition intro 00:03:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Overview food composition 00:03:00 Macronutrients Macros intro 00:01:00 Protein Explained 00:02:00 protein needs for overall health 00:02:00 How Much Carbs should you eat per day 00:01:00 How Much Fat Should You Eat Per Day 00:04:00 Overview Macronutrients 00:03:00 Nutrient Timing Nutrient Timing Intro 00:02:00 Nutrient Timing Facts 00:04:00 Nutrient Timing Recommendations 00:02:00 Supplements Supplements intro 00:04:00 Why Mulitvitamins arent a good idea 00:02:00 supplements for vegans and vegetarians 00:02:00 supplements for joint health 00:02:00 supplements for improved sleep 00:02:00 supplements for better memory and focus 00:02:00 Supplements Overview 00:01:00 How to naturally increase testosterone 00:07:00 Healthy Eating Fundamentals basics of healthy dieting 00:02:00 making changs towards a healthier diet 00:04:00 How to read a nutrition label 00:03:00 Health Myths, Diet Fads & More diet myths into 00:01:00 Dieting myth #1 Carbs are bad for you 00:02:00 Dieting Myth #2 Fat is bad for you 00:02:00 Dieting Myth #3 Protein is bad for you 00:04:00 Dieting Myth #4 Eating Eggs Raises Cholesterol 00:01:00 Dieting Myth #5 Avoid Salt At All Cost 00:01:00 Dieting Myth #6 Eat several small meals throughout the day to lose weight 00:01:00 Dieting Myth #7 Diet Foods Will Lead To Weight Loss 00:01:00 Red meat always causes cancer 00:03:00 Common Diet Trends Explained Common Diets Intro 2 00:01:00 Gluten Free Diet Explained 00:03:00 Paleo Diet Explained 00:04:00 Low Carb Diet Explained 00:03:00 Intermittent Fasting Explained 00:03:00 Vegan Diet Explained 00:05:00 Micronutrients (Vitamins & Minerals) Micronutrients Introduction 00:01:00 Vitamin A 00:02:00 Vitamin B 00:01:00 Vitamin C 00:01:00 Vitamin D 00:02:00 Vitmain E 00:01:00 Vitamin K 00:01:00 Calcium 00:02:00 Magnesium 00:01:00 Phosphorus 00:01:00 Potassium 00:01:00 Sodium 00:01:00 Copper 00:01:00 Iron 00:01:00 Zinc copy 00:02:00 water 00:04:00 Assignment Assignment - Healthy Nutrition Masterclass: Diet & Meal Plan For Health 00:00:00

The 'Management: LEED Operations Management' course provides comprehensive knowledge of LEED (Leadership in Energy and Environmental Design) operations management, focusing on sustainable practices and green building standards. Participants will learn about various LEED credit categories, including location and transportation, sustainable sites, water efficiency, energy and atmosphere, materials and resources, indoor environmental quality, innovation, regional priority, and LEED Accredited Professional certification. Learning Outcomes: Understand the fundamentals of LEED operations management and its significance in promoting sustainability. Identify the minimum program requirements and rating system selection for LEED certification. Evaluate alternative transportation options and their impact on sustainable sites. Implement water efficiency strategies and practices in buildings. Analyze energy and atmosphere aspects to optimize energy performance and use renewable energy sources. Establish sustainable materials and resource management policies to reduce waste and promote responsible procurement. Implement indoor environmental quality management programs for improved air quality, thermal comfort, lighting, and green cleaning. Explore innovation credits and LEED Accredited Professional certification opportunities. Recognize regional priorities and their impact on LEED certification. Successfully complete the LEED Operations Management course with a comprehensive understanding of sustainable building practices. Why buy this Management: LEED Operations Management? Unlimited access to the course for forever Digital 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 Management: LEED Operations Management there will be a written assignment test which you can take either during or at the end of the course. 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 Management: LEED Operations Management course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Management: LEED Operations Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Management: LEED Operations Management 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 Management: LEED Operations Management is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Introduction Module 01: Introduction - About this course 00:03:00 Module 02: Getting Started 00:04:00 Module 03: Minimum Program Requirements 00:07:00 Module 04: Rating System Selection 00:07:00 Unit 02: Location & Transportation Module 01: Overview 00:01:00 Module 02: Alternative Transportation Credit - Requirements 00:06:00 Module 03: Alternative Transportation Credit - Survey 00:06:00 Module 04: Alternative Transportation Credit - Calculations 00:08:00 Unit 03: Sustainable Sites Module 01: Overview 00:02:00 Module 02: Site Management Policy 00:06:00 Module 03: Site Development-Protect or Restore Habitat 00:03:00 Module 04: Rainwater Management 00:03:00 Module 05: Heat Island Reduction 00:06:00 Module 06: Light Pollution Reduction 00:03:00 Module 07: Site Management 00:04:00 Module 08: Site Improvement Plan 00:02:00 Module 09: Joint Use of Facilities 00:03:00 Unit 04: Water Efficiency Module 01: Overview 00:01:00 Module 02: Prerequisite Indoor Water Use Reduction 00:07:00 Module 03: Building-Level Water Metering 00:02:00 Module 04: Outdoor Water Use Reduction 00:04:00 Module 05: Indoor Water Use Reduction 00:03:00 Module 06: Cooling Tower Water Use 00:04:00 Module 07: Water Metering 00:03:00 Unit 05: Energy and Atmosphere Module 01: Overview 00:02:00 Module 02: Prerequisite Energy Efficiency Best Management Practices 00:05:00 Module 03: Minimum Energy Performance 00:04:00 Module 04: Building-Level Energy Metering 00:02:00 Module 05: Fundamental Refrigerant Management. 00:04:00 Module 06: Existing Building Commissioning-Analysis 00:05:00 Module 07: Existing Building Commissioning-Implementation 00:02:00 Module 08: Ongoing Commissioning 00:04:00 Module 09: Optimize Energy Performance 00:04:00 Module 10: Advanced Energy Metering 00:03:00 Module 11: Demand Response 00:05:00 Module 12: Renewable Energy and Carbon Offsets 00:03:00 Module 13: Enhanced Refrigerant Management 00:05:00 Unit 06: Materials and Resources Module 01: Overview 00:02:00 Module 02: Facility Maintenance and Renovation Policy 00:04:00 Module 03: Ongoing Purchasing and Waste Policy 00:06:00 Module 04: Purchasing-Ongoing 00:04:00 Module 05: Purchasing-Lamps 00:02:00 Module 06: Purchasing-Facility Maintenance and Renovation 00:04:00 Module 07: Solid Waste Management-Ongoing 00:03:00 Module 08: Solid Waste Management-Facility Maintenance and Renovation 00:02:00 Unit 07: Indoor Environmental Quality Module 01: Overview 00:01:00 Module 02: Minimum Indoor Air Quality Performance 00:05:00 Module 03: Environmental Tobacco Smoke Control 00:04:00 Module 04: Green Cleaning Policy 00:04:00 Module 05: Indoor Air Quality Management Program 00:03:00 Module 06: Enhanced Indoor Air Quality Strategies 00:06:00 Module 07: Thermal Comfort 00:04:00 Module 08: Interior Lighting 00:06:00 Module 09: Daylight and Quality Views 00:05:00 Module 10: Green Cleaning-Custodial Effectiveness Assessment 00:02:00 Module 11: Green Cleaning-Products and Materials 00:05:00 Module 12: Green Cleaning-Equipment 00:04:00 Module 13: Integrated Pest Management 00:03:00 Module 14: Occupant Comfort Survey 00:04:00 Unit 08: INNOVATION Module 01: Innovation Credit 00:03:00 Module 02: LEED Accredited Professional 00:01:00 Unit 09: REGIONAL PRIORITY Module 01: Regional Priority Overview 00:01:00 Module 02: Credit Regional Priority 00:02:00 Unit 10: Completion Module 01: Completion 00:01:00 Assignment Assignment - Management: LEED Operations Management 00:00:00

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital 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 SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. 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 SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Web Design for Beginners: Build Websites in HTML & CSS Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Web Design for Beginners: Build Websites in HTML & CSS Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Web Design for Beginners: Build Websites in HTML & CSS Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Web Design for Beginners: Build Websites in HTML & CSS Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Web Design for Beginners: Build Websites in HTML & CSS? Unlimited access to the course for forever Digital 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 Web Design for Beginners: Build Websites in HTML & CSS there will be a written assignment test which you can take either during or at the end of the course. 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 Web Design for Beginners: Build Websites in HTML & CSS course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Web Design for Beginners: Build Websites in HTML & CSS does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Web Design for Beginners: Build Websites in HTML & CSS 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 Web Design for Beginners: Build Websites in HTML & CSS is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:07:00 Section 02: Basic and General Info and Installation Alert!!! Important: A Must-Watch Video 00:01:00 How the Web Works 00:07:00 What Are Text Editors and Installation 00:05:00 How the Browser Works 00:11:00 Section 03: Basics Syntax and First Steps HTML Basic Syntax 00:14:00 HTML Elements 00:06:00 HTML Attributes 00:09:00 HTML Headings 00:04:00 HTML Paragraphs 00:06:00 Section 04: Diving Deeper with HTML and CSS Basics HTML Style Attribute 00:09:00 HTML Formatting 00:04:00 HTML Comments 00:05:00 Simple Intro to CSS 00:16:00 HTML Links 00:06:00 HTML Images 00:08:00 Section 05: Diving Deeper: Tables, Lists and Forms HTML Tables 00:11:00 HTML Lists 00:07:00 First Training (Creating a Simple Menu) 00:10:00 HTML Forms pt.1 00:11:00 HTML Forms pt.2 00:11:00 HTML Forms pt.3 00:08:00 HTML Forms pt.4 00:06:00 Section 06: Getting Advanced and Finishing Up HTML Inline and Block Tags 00:16:00 Classes 00:10:00 Ids 00:08:00 More about the Head 00:09:00 HTML Entities 00:05:00 Section 07: Getting Started with CSS Intro and Revision to CSS 00:05:00 Syntax 00:08:00 Comments 00:04:00 Section 08: Colours Colours pt.1 00:19:00 Colours pt.2 00:08:00 Section 09: Backgrounds Backgrounds pt.1 00:13:00 Backgrounds pt.2 00:05:00 Backgrounds pt.3 00:09:00 Section 10: Borders Borders pt.1 00:06:00 Borders pt.2 00:06:00 Section 11: Margin, Padding and More Margin 00:14:00 Padding 00:08:00 More about height and width 00:05:00 Width and Height 00:07:00 Box Model 00:05:00 Training 2 (Building a Simple Form) 00:22:00 Section 12: Outline Outline pt.1 00:06:00 Outline pt.2 00:05:00 Section 13: Text Text pt.1 00:05:00 Text pt.2 00:07:00 Text pt.3 00:05:00 Section 14: Fonts Fonts pt.1 00:07:00 Fonts pt.2 00:04:00 Fonts pt.3 00:03:00 Section 15: Display Display pt.1 00:10:00 Display pt.2 00:04:00 Display pt.3 00:10:00 Section 16: Position Position pt.1 00:05:00 Position pt.2 00:10:00 Section 17: Z-index Z-index pt.1 00:07:00 Z-index pt.2 00:05:00 Section 18: Overflow Overflow pt.1 00:08:00 Overflow pt.2 00:03:00 Section 19: Pseudo Classes, Elements and other Stuff Pseudo Classes 00:12:00 Pseudo Elements 00:09:00 Opacity 00:06:00 Cursor 00:04:00 Section 20: Float Float pt.1 00:04:00 Float pt.2 00:05:00 Section 21: Outro Outro and Where to Go From Here 00:03:00 Section 22: More Lectures: Update 2022 Videos 00:04:00 Sound 00:02:00 Youtube Videos 00:03:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special English Literature Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The English Literature Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This English Literature Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This English Literature Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this English Literature? Unlimited access to the course for forever Digital 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 English Literature there will be a written assignment test which you can take either during or at the end of the course. 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 English Literature course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This English Literature does not require you to have any prior qualifications or experience. You can just enrol and start learning.This English Literature 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 English Literature is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Elizabethan Drama and Shakespeare's Hamlet The History of Drama 00:10:00 Elizabethan Drama 00:12:00 William Shakespeare 00:06:00 Hamlet: A Synopsis of the Play 00:04:00 Hamlet: An Anlaysis of the Play 00:19:00 Hamlet's Soliloquies 00:05:00 Jacobean Literature and the Metaphysical Poets Jacobean Literature Poetry and Prose 00:12:00 Puritanism & The English Civil War 00:11:00 Metaphysical Poetry 00:08:00 George Herbert 00:05:00 Andrew Marvell 00:07:00 John Milton 00:08:00 The Rise of the Novel and Satire The Restoration & Glorious Revolution 00:06:00 The Novel 00:08:00 Early Novelists: Defoe, Richardson, and Fielding 00:11:00 English Satire: John Dryden & Alexander Pope 00:06:00 Jonathan Swift & Gulliver's Travels 00:10:00 Swift's A Modest Proposal 00:08:00 The Emergence of American Literature Colonialism & John Smith 00:07:00 Pilgrim Writers 00:10:00 The Revolutionary Period Writers 00:07:00 The Knickerbocker Era: Washington Irving 00:14:00 Frontier Fiction: James Fenimore Cooper 00:10:00 The New England Renaissance The Westward Expansion 00:04:00 Transcendentalism: Ralph Waldo Emerson 00:10:00 Transcendentalism: Henry David Thoreau 00:08:00 Anti-Transcendentalism: Nathaniel Hawthorne 00:05:00 Nathaniel Hawthorne and The Scarlet Letter 00:08:00 Herman Melville 00:05:00 Edgar Allan Poe 00:06:00 Poe's 'The Cask of Amontillado' 00:05:00 Poe's 'The Raven' 00:07:00 The American Civil War Era and the Gilded Age The American Civil War Era & Harriet Beecher Stowe 00:07:00 Walt Whitman 00:09:00 Whitman's 'Drum Taps' 00:06:00 Emily Dickinson 00:09:00 The Gilded Age 00:07:00 Local Color Writing: Mark Twain 00:08:00 Tom Sawyer & Huck Finn 00:11:00 A Connecticut Yankee in King Arthur's Court 00:07:00 Women Writers of the 19th Century Female Writers & The French Revolution 00:12:00 Mary Wollstonecraft 00:09:00 Helen Maria Williams 00:08:00 Unitarianism 00:04:00 Harriet Martineau 00:12:00 Anna Laetitia Barbauld 00:06:00 Lucy Aikin 00:05:00 British Romantic Poets and the Poetic Imagination The Napoleonic Wars 00:08:00 The Romantic Period 00:05:00 William Blake 00:08:00 William Wordsworth 00:08:00 Samuel Taylor Coleridge 00:08:00 Percy Bysshe Shelley 00:08:00 John Keats 00:09:00 Lord George Gordon Byron 00:07:00 Victorian Novels Gothic Novels 00:10:00 Jane Austin's Pride and Prejudice 00:14:00 Victorian Novels 00:09:00 Emily Brontë and Wuthering Heights 00:11:00 Charles Dickens and Great Expectations 00:15:00 The Imagist Movements after World War I Anti-Victorianism & Edwardian England 00:05:00 Imagism & Gertruid Stein 00:05:00 Post War Literature & Ezra Pound 00:10:00 T.S. Eliot 00:13:00 William Carlos Williams 00:05:00 Archibald MacLeish 00:05:00 Modernist Fiction Modernist Fiction 00:07:00 Henry James 00:07:00 James Joyce 00:07:00 Joyce's 'Araby' 00:19:00 Joyce's Ulysses 00:07:00 Virginia Woolf 00:06:00 Virgina Woolf's To the Lighthouse 00:12:00 The Lost Generation Ernest Hemingway and the Lost Generation 00:05:00 Hemingway's The Sun Also Rises 00:10:00 F. Scott Fitzgerald 00:04:00 Fitzgerald's The Great Gatsby 00:08:00 ee cummings 00:06:00 Robert Lowell 00:05:00 The Beat Generation & Allen Ginsberg 00:11:00 Resources Resources - English Literature 00:00:00 Assignment Assignment - English Literature 00:00:00

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