• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2572 Mentor courses

Functional Skills Maths - Level 2

4.9(27)

By Apex Learning

Overview Help others overcome their fear of mathematics and teach students how to reach their career potentials with numerology. This unique course will train you to become an accomplished mathematical teacher and advance the knowledge of pupils in this area. The Functional Skills Maths course is packed with information regarding Functional Maths and uses varied educational methods to embed the knowledge. You will find that you will quickly attain the ability to teach Maths in a lively and personal way, giving you a genuine advantage in the UK education system. From integers to fractions, and percentages, enrol now and learn to make maths easy. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Functional Skills Maths. It is available to all students, of all academic backgrounds. Requirements Our Functional Skills Maths is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 13 sections • 67 lectures • 06:56:00 total length •Lecture 1 Introduction: 00:02:00 •Lecture 2 Multiplying any digit number by 11, 22, and 33: 00:09:00 •Lecture 3 Integers and ordering of integers: 00:06:00 •Lecture 4 Addition and Subtractions of Integers: 00:07:00 •Lecture 5 Operations on Integers: 00:04:00 •Lecture 6 Multiplication and Division of Integers: 00:04:00 •Lecture 7 Powers of Integers (Exponents): 00:04:00 •Lecture 8 Complete knowledge about factors and multiples: 00:06:00 •Lecture 9 Divisibility tests for 2,3,4,5,6: 00:07:00 •Lecture 10 Divisibility rules 7,8,9,10,11: 00:06:00 •Lecture 11 Prime Factorization: 00:06:00 •Lecture 12 Highest Common Factor HCF: 00:10:00 •Lecture 13 Least Common Multiple LCM: 00:16:00 •Lecture 14 Relation between LCM and HCF: 00:04:00 •Lecture 15 Classification of Fractions: 00:04:00 •Lecture 16 Convert mixed to improper and improper to mixed fractions: 00:03:00 •Lecture 17 Equivalent Fractions: 00:04:00 •Lecture 18 Comparing Fractions after converting to like fractions: 00:09:00 •Lecture 19 Reducing a fraction to lowest term: 00:04:00 •Lecture 20 Addition and subtraction OF fractions: 00:08:00 •Lecture 21 Multiplication and division of fractions: 00:11:00 •Lecture 22 Word problems on fractions: 00:16:00 •Lecture 23 BODMAS and rules to remove brackets: 00:03:00 •Lecture 24 Simplify expressions using BODMAS rules: 00:05:00 •Lecture 25 Simplify expressions involving fractions using BODMAS: 00:07:00 •Lecture 26 Decimal numbers in relation to fractions: 00:08:00 •Lecture 27 Like and unlike Decimals: 00:05:00 •Lecture 28 Ordering of Decimal numbers: 00:10:00 •Lecture 29 Addition and subtraction of Decimal: 00:07:00 •Lecture 30 Multiplication of Decimal: 00:03:00 •Lecture 31 Division of Decimal: 00:05:00 •Lecture 32 Rational number: 00:02:00 •Lecture 33 Representation of Rational Numbers on Number line: 00:04:00 •Lecture 34 Determining which fraction is terminating or non terminating: 00:05:00 •Lecture 35 shortcut method of writing decimal expansion of fraction to decimal: 00:08:00 •Lecture 36 Rounding to whole number: 00:06:00 •Lecture 37 Rounding to required number of decimals (1 d.p. ): 00:05:00 •Lecture 38 rounding to significant digits: 00:07:00 •Lecture 39 Practice question on three methods of approximation: 00:05:00 •Lecture 40 Estimation: 00:05:00 •Lecture 41 Scientific Notation: 00:07:00 •Lecture 42 Operation on numbers when they are in scientific notation: 00:06:00 •Lecture 43 Percentage to fraction and fraction to percentage: 00:06:00 •Lecture 44 Percentage of a quantity and conversation to decimal: 00:06:00 •Lecture 45 Expressing one quantity as percentage of another quantity: 00:06:00 •Lecture 46 Finding increase decrease percent: 00:05:00 •Lecture 47 Uses of percentages-Word Problems: 00:09:00 •Lecture 48 Ratio- How to express as simple ratio: 00:09:00 •Lecture 49 How to compare Ratios: 00:04:00 •Lecture 50 Word problems on finding ratios: 00:07:00 •Lecture 51To divide a given quantity into a given Ratio: 00:11:00 •Lecture 52 Proportion: 00:04:00 •Lecture 53 Practice problems on Proportion: 00:06:00 •Lecture 54 Continued proportion: 00:06:00 •Lecture 55 Direct Variation ( or proportion): 00:04:00 •Lecture 56 Problems based on Direct proportion: 00:10:00 •Lecture 57 Inverse Variation ( or proportion): 00:10:00 •Lecture 58 Multiple Ratios: 00:10:00 •Lecture 59 Basics - Profit and Loss: 00:04:00 •Lecture 60 More practice problems on Profit & Loss: 00:06:00 •Lecture 61 Selling price formula and Problems: 00:04:00 •Lecture 62 Cost price formula and Problems: 00:03:00 •Lecture 63 Higher problems on Profit and Loss: 00:08:00 •Lecture 64 Basics - Discount.mp4: 00:05:00 •Lecture 65 Practice problems on Discount: 00:04:00 •Lecture 66 Tax: 00:06:00 •Assignment - Functional Skills Maths - Level 2: 00:00:00

Functional Skills Maths - Level 2
Delivered Online On Demand6 hours 56 minutes
£12

Learning Cooking

4.9(27)

By Apex Learning

Overview Advance your culinary knowledge and skills and whip up a new career working with food, by enrolling in our Learning Cooking. The course offers a wide array of training modules to provide you with a complete understanding of cooking and food preparation skills, exploring some delicious recipes. Cooking is undoubtedly a great stress buster. After your successful completion, you'll be far more capable of acquiring the qualities of a great chef, adopting proper knife techniques. Get introduced to the food business basics, test recipes and much more. You will be able to explore the latest trends and take your creativity to the next level. Enrol today to make delicious five star meals. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Learning Cooking. It is available to all students, of all academic backgrounds. Requirements Our Learning Cooking is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 4 sections • 91 lectures • 07:25:00 total length •Can TV Chefs Teach You To Cook?: 00:30:00 •Improving Cooking And Food Preparation Skills: 00:15:00 •Catering To Unique Tastes: 00:30:00 •Qualities Of A Successful Chef: 00:30:00 •Achieve Perfection As A Saucier: 00:30:00 •Becoming The Perfect Chef: 01:00:00 •Equipment For Perfect Chefs: 00:30:00 •How To Become The Perfect Chef: Attending School: 00:30:00 •The Keys To Getting and Using Feedback: 00:30:00 •What Can You Do With A Culinary Degree: 01:00:00 •Knife Skills For The Perfect Chef: 00:30:00 •Making Meals Easy to Eat Healthy: 00:30:00 •Plating for the At Home Chef: 00:30:00 •Perfect Chefs Choose A Speciality: 00:30:00 •Finding Local Cooking Classes: 00:30:00 •How Can You Become a Professional Chef: 00:30:00 •The Physical Qualities of the Perfect Chef: 00:15:00 •The Importance of Testing Recipes: 00:15:00 •The Chefs Important Baking Tools: 01:00:00 •The Learning Curve To Becoming The Perfect Chef: 00:15:00 •The Job of a Professional Chef: 00:30:00 •The Mix of Sweet, Spicy and Savory: 00:30:00 •The Perfect At Home Chef: 00:30:00 •The Perfect Chef Opens A Restaurant: 00:15:00 •The Physical Demand of Being a Chef: 00:15:00 •Buying Kitchen Equipment: Tips And Tricks To Save Money: 01:00:00 •The Well Equipped Kitchen: 00:15:00 •Take Inventory: 01:00:00 •Be Wary Of The Latest Trends: 01:00:00 •Inexpensive Vs. Cheap: 00:15:00 •Needing Vs. Wanting: 01:00:00 •Comparison Shopping: 01:00:00 •How To Find The Best Deals: 01:00:00 •Secrets Of Outdoor Cooking Recipes: 01:00:00 •Once A Month Cooking Recipes: 00:15:00 •Mother's Day Cooking Made Easy: 01:00:00 •Mardi Gras Cooking Cajun Style: 00:30:00 •Learn To Cook Italian Food On Vacation: 01:00:00 •Cooking With A Dutch Oven: 01:00:00 •Recipes Of Italian Vegetarian Cooking: 01:00:00 •Home Cooking Network: An Array Of Recipes: 00:30:00 •America's Home Cooking: The Television Program: 01:00:00 •A Wonderful Experience With Outdoor Cooking Burners: 00:30:00 •Cooking For Sunday Dinner: 01:00:00 •Healthy Cooking Oils: 01:00:00 •Cooking Cajun Food: 01:00:00 •Paula's Home Cooking Recipes: 00:30:00 •The Importance Of Eating A Healthful Vegetarian Diet: 01:00:00 •Italian Food On A Date: 00:30:00 •The History Of Pasta In Italian Food: 01:00:00 •Review Of Different Vegetarian Cooking Shows: 00:30:00 •Italian Cooking Brochutto: 01:00:00 •Cooking Christmas Cookies: 01:00:00 •Back To Beginning For President's Day Cooking: 00:30:00 •Microwave Bacon Cooking Equipment: 00:30:00 •Cheap Italian Food In Milan: 01:00:00 •Chinese Cooking Wok: 01:00:00 •7 Useful Cooking Tips And Hints: 01:00:00 •Down Home Cooking: 00:30:00 •Italian Cooking School: 00:30:00 •Cooking Games: 00:30:00 •Italian Cooking Recipes: 00:30:00 •French Cooking Holidays: 00:30:00 •Food Business Basics: 00:50:00 •Put Together Your Business Concept: 00:30:00 •Identify your Target Market: 00:30:00 •Identify Your Competition: 00:30:00 •Write A Mission Statement: 00:30:00 •Downline Basics: 00:30:00 •Equipment And Supplies: 00:30:00 •Marketing And Quality Control: 00:30:00 •Wrapping Up: 00:15:00 •Recipe - I: 01:00:00 •Recipe - II: 01:00:00 •Recipe - III: 01:00:00 •Recipe - IV: 01:00:00 •Recipe - V: 01:00:00 •Recipe - VII: 00:10:00 •Recipe - VIII: 00:12:00 •Recipe - IX: 00:10:00 •Recipe - X: 00:15:00 •Recipe - XI: 00:30:00 •Recipe - XII: 00:30:00 •Recipe - XIII: 00:15:00 •Recipe - XIV: 00:30:00 •Recipe - XV: 00:30:00 •Recipe - XVI: 00:10:00 •Recipe -XVII: 00:15:00 •Recipe -XVIII: 00:15:00 •Recipe -XIX: 00:13:00 •Recipe -XX: 00:10:00

Learning Cooking
Delivered Online On Demand7 hours 25 minutes
£12

Django Rest Framework Level 4

4.9(27)

By Apex Learning

Overview This comprehensive course on Django Rest Framework Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Django Rest Framework Level 4 comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Django Rest Framework Level 4. It is available to all students, of all academic backgrounds. Requirements Our Django Rest Framework Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 82 lectures • 04:40:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: How to make the best of this course: 00:02:00 •Module 01: What is REST?: 00:06:00 •Module 02: Why REST: 00:08:00 •Module 03: What and Why DJango REST Framework: 00:06:00 •Module 01: Install DJango: 00:03:00 •Module 02: Install DJango REST Framework: 00:01:00 •Module 03: Install MySql and MySql workbench: 00:03:00 •Module 04: Launch MySql workbench: 00:02:00 •Module 05: Install python mysqlclient: 00:01:00 •Module 06: Install ATOM: 00:03:00 •Module 07: Install Postman: 00:01:00 •Module 01: Create the project: 00:02:00 •Module 02: Create a view: 00:02:00 •Module 03: Configure the URL and TEST: 00:03:00 •Module 04: Create app level urls: 00:02:00 •Module 05: Create a model class: 00:03:00 •Module 06: Configure the database and run migrations: 00:03:00 •Module 07: Use the model in the view and test: 00:03:00 •Module 01: DRF Components: 00:06:00 •Module 02: Function Based Views: 00:05:00 •Module 03: Serializers: 00:04:00 •Module 04: Create the Project: 00:02:00 •Module 05: Create the Model: 00:02:00 •Module 06: Create the Serializer: 00:02:00 •Module 07: GET single student: 00:04:00 •Module 08: Create Student: 00:04:00 •Module 09: Implement Non Primary Key Based Operations: 00:07:00 •Module 10: Use @api_view: 00:01:00 •Module 11: Configure the URLs: 00:02:00 •Module 12: Test: 00:07:00 •Module 13: Test Using Postman: 00:04:00 •Module 01: Introduction: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Implement Non Primary Key Based Operations: 00:06:00 •Module 04: Implement Primary Key Based Operations: 00:07:00 •Module 05: Configure the URLs and TEST: 00:04:00 •Module 01: Introduction: 00:05:00 •Module 02: Non Primary Key based operations: 00:04:00 •Module 03: Primary Key based operations: 00:02:00 •Module 04: Configure the URLs and TEST: 00:02:00 •Module 01: Generics: 00:03:00 •Module 02: Generics in action: 00:03:00 •Module 01: Introduction: 00:03:00 •Module 02: Create ViewSet: 00:02:00 •Module 03: Configure URLs and Test: 00:04:00 •Module 01: Create the Project: 00:03:00 •Module 02: Create model: 00:03:00 •Module 03: Create Serializers: 00:04:00 •Module 04: Create REST endpoints: 00:03:00 •Module 05: Configure URLs: 00:02:00 •Module 06: Test: 00:03:00 •Module 01: Introduction: 00:06:00 •Module 02: Pagination in action: 00:05:00 •Module 03: Pagination at class level: 00:03:00 •Module 04: Using LimitOffsetPagination: 00:01:00 •Module 01: Introduction: 00:04:00 •Module 02: Authentication in action: 00:03:00 •Module 03: Authorization in action: 00:06:00 •Module 04: Global Security: 00:04:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Create Model Classes: 00:03:00 •Module 04: Create Reservation Model: 00:01:00 •Module 05: Create Serializers: 00:01:00 •Module 06: Create ViewSets: 00:02:00 •Module 07: Configure the Router: 00:02:00 •Module 08: Run Migrations: 00:01:00 •Module 09: Initial round of testing: 00:04:00 •Module 10: Implement findFlights endpoint: 00:03:00 •Module 11: Test findFlights: 00:05:00 •Module 12: Implement Save Reservation: 00:06:00 •Module 13: Test Save Reservation: 00:04:00 •Module 01: In-Built Validations: 00:04:00 •Module 02: Allowing Blank and Null Values: 00:02:00 •Module 03: Create Custom Validator: 00:05:00 •Module 04: Two more ways: 00:07:00 •Module 01: Introduction: 00:03:00 •Module 02: Configure Token Auth: 00:05:00 •Module 03: Create Users and Token: 00:04:00 •Module 04: Token Auth in action: 00:03:00 •Module 05: Automate Token Creation: 00:09:00

Django Rest Framework Level 4
Delivered Online On Demand4 hours 40 minutes
£12

Diploma in Counselling Skills Training - Level 6 (QLS Endorsed)

By Kingston Open College

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Diploma in Counselling Skills Training - Level 6 (QLS Endorsed)
Delivered Online On Demand3 hours
£15

Train the Trainer

By The Teachers Training

Develop impactful training skills with our Train the Trainer course. Learn to effectively deliver training, engage learners, and enhance professional development.

Train the Trainer
Delivered Online On Demand2 hours
£15

Business Strategy Consulting

4.9(27)

By Apex Learning

Overview This comprehensive course on Business Strategy Consulting will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Strategy Consulting comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Strategy Consulting. It is available to all students, of all academic backgrounds. Requirements Our Business Strategy Consulting is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 17 sections • 88 lectures • 07:09:00 total length •Welcome to this Mini MBA Business Strategy Consulting Course: 00:03:00 •Mini MBA Business Strategy - Executive Summary - What you will learn: 00:10:00 •What is Business Strategy?: 00:05:00 •Business Vision and the Mission Statement: 00:04:00 •The Strategy Hierarchy within a Firm: 00:06:00 •Introduction to Business Strategy Design: 00:02:00 •Business Model Design with the Business Model Canvas: 00:13:00 •Business Model Canvas Template: 00:01:00 •Lafley & Martin's Five Step Strategy Model: 00:05:00 •Hambrick & Frederickson's Strategy Diamond: 00:06:00 •Understanding Life Cycles: 00:02:00 •The Industry Life Cycle: 00:07:00 •The Business Life Cycle: 00:06:00 •The Product Life Cycle: 00:05:00 •The Corporate Funding Life Cycle: 00:04:00 •External Analysis Using Broad Factors: 00:02:00 •PEST Analysis: 00:08:00 •PESTEL Analysis: 00:05:00 •PESTEL Analysis Template: 00:01:00 •CASE STUDY EXERCISE: PESTEL Analysis of Starbucks: 00:02:00 •CASE STUDY SOLUTION: PESTEL Analysis of Starbucks: 00:07:00 •CASE STUDY EXERCISE: PESTEL Analysis of the Global Aviation Industry: 00:07:00 •CASE STUDY SOLUTION: PESTEL Analysis of the Global Aviation Industry: 00:02:00 •Strategic Options from Internal and External Analysis: 00:16:00 •SWOT Analysis: 00:05:00 •Conducting A SWOT Analysis: 00:04:00 •SWOT Analysis Template: 00:02:00 •TOWS Matrix Analysis: 00:05:00 •TOWS Analysis Template: 00:14:00 •SOAR: 00:04:00 •SOAR Analysis Template: 00:01:00 •CASE STUDY EXERCISE: SWOT Analysis - Amazon: 00:02:00 •CASE STUDY SOLUTION: SWOT ANALYSIS - Amazon: 00:09:00 •Michael Porter and Business Strategy Analysis: 00:02:00 •Industry Analysis and Introducing Michael Porter: 00:10:00 •Competitive Forces Model - Porter's Five Forces: 00:12:00 •Full List of Porter's Five Forces Factors: 00:02:00 •Michael Porter's Five Forces Template: 00:01:00 •CASE STUDY EXERCISE PORTERS FIVE FORCES Global Aviation Industry: 00:02:00 •CASE STUDY SOLUTION: Porter's Five Forces - Global Airline Industry: 00:15:00 •Generic Strategies and Industry Forces: 00:10:00 •Michael Porter's Value Chain Analysis: 00:07:00 •Value Chain Analysis Template: 00:02:00 •Boston Consulting Group (BCG) Matrix: 00:07:00 •BCG Matrix and the Life Cycle: 00:03:00 •BCG Matrix Advantages and Disadvantages: 00:03:00 •Adapting the BCG Matrix: 00:05:00 •Boston Consulting Group (BCG) Matrix Template: 00:03:00 •CASE STUDY EXERCISE: BCG Matrix - Facebook: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Facebook: 00:04:00 •CASE STUDY EXERCISE: BCG Matrix - Apple: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Apple: 00:04:00 •CASE STUDY EXERCISE: BCG Matrix - Unilever: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Unilever: 00:05:00 •Competitive Advantage - Deriving Strategy from Inside the Firm: 00:03:00 •Core Competency: 00:05:00 •VRIO - Resources to Competitive Advantage: 00:06:00 •CASE STUDY EXERCISE: Core Competency - Apple: 00:02:00 •CASE STUDY SOLUTION: Core Competency - Apple: 00:05:00 •Defining the Unique Selling Proposition: 00:05:00 •ADL Matrix - Understanding Your Competitive Position: 00:07:00 •ADL Matrix Template: 00:02:00 •Ansoff Product Market Matrix - How to Grow Your Business: 00:05:00 •Organic vs Inorganic Growth: 00:02:00 •Internal and External Growth Strategies Expanded: 00:11:00 •CASE STUDY EXERCISE: Amazon's Growth Strategy: 00:02:00 •CASE STUDY SOLUTION - Amazon's Growth Strategy: 00:06:00 •Blue Ocean Strategy: 00:05:00 •Blue Ocean Case Study - Apple: 00:05:00 •Comparing Red Ocean and Blue Ocean Strategies: 00:04:00 •How to Survive in an Over Fished Ocean: 00:05:00 •How to Create a Comparative Competitive Analysis on a Page: 00:04:00 •Making the Connection between Strategy and Finance: 00:04:00 •What is an Integrated Financial Model?: 00:06:00 •Key Drivers of an Integrated Financial Model: 00:08:00 •Model Structure: 00:03:00 •Detailed Model Schedules: 00:07:00 •Chart of Accounts: 00:02:00 •Financial Statement Inputs and Outputs: 00:03:00 •10 Steps to Building an Integrated Financial Model: 00:05:00 •Summary of the Strategic Analysis Process: 00:03:00 •Understanding the Strategic Planning Process: 00:06:00 •Four Step Strategic Management Process: 00:03:00 •Strategy Formulation in Six Steps: 00:07:00 •Mintzberg's Five Configurations: 00:05:00 •Course Summary and Wrap Up: 00:05:00 •Additional Materials: 00:00:00 •Assignment - Business Strategy Consulting: 00:00:00

Business Strategy Consulting
Delivered Online On Demand7 hours 9 minutes
£12

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.9(27)

By Apex Learning

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£12

Diploma in Professional Chef

4.9(27)

By Apex Learning

Overview The Diploma in Professional Chef course is specifically designed to prepare students for the demands of this rapidly growing industry. With over 15 hours of content spread across various essential topics, this course provides a comprehensive understanding of the culinary world. It covers various topics such as improving cooking and food preparation skills, catering to unique tastes, and mastering the art of saucier. The Diploma in Professional Chef course delves deep into the intricacies of becoming a successful chef, with modules dedicated to the physical qualities and demands of a chef and the importance of testing recipes.  It also provides insights into the business side of the culinary world, with modules like Food Business Basics and Marketing and Quality Control. The course also offers many recipes and cooking tips, from traditional Italian and Chinese cooking to modern culinary trends. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Diploma in Professional Chef. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Professional Chef is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 92 lectures • 14:45:00 total length •Can TV Chefs Teach You To Cook?: 00:30:00 •Improving Cooking And Food Preparation Skills: 00:15:00 •Catering To Unique Tastes: 00:30:00 •Qualities Of A Successful Chef: 00:30:00 •Achieve Perfection As A Saucier: 00:30:00 •Becoming The Perfect Chef: 01:00:00 •Equipment For Perfect Chefs: 00:30:00 •How To Become The Perfect Chef: Attending School: 00:30:00 •The Keys To Getting and Using Feedback: 00:30:00 •What Can You Do With A Culinary Degree: 01:00:00 •Knife Skills For The Perfect Chef: 00:30:00 •Making Meals Easy to Eat Healthy: 00:30:00 •Plating for the At Home Chef: 00:30:00 •Perfect Chefs Choose A Speciality: 00:30:00 •Finding Local Cooking Classes: 00:30:00 •How Can You Become a Professional Chef: 00:30:00 •The Physical Qualities of the Perfect Chef: 00:15:00 •The Importance of Testing Recipes: 00:15:00 •The Chefs Important Baking Tools: 01:00:00 •The Learning Curve To Becoming The Perfect Chef: 00:15:00 •The Job of a Professional Chef: 00:30:00 •The Mix of Sweet, Spicy and Savory: 00:30:00 •The Perfect At Home Chef: 00:30:00 •The Perfect Chef Opens A Restaurant: 00:15:00 •The Physical Demand of Being a Chef: 00:15:00 •Buying Kitchen Equipment: Tips And Tricks To Save Money: 01:00:00 •The Well Equipped Kitchen: 00:15:00 •Take Inventory: 01:00:00 •Be Wary Of The Latest Trends: 01:00:00 •Inexpensive Vs. Cheap: 00:15:00 •Needing Vs. Wanting: 01:00:00 •Comparison Shopping: 01:00:00 •How To Find The Best Deals: 01:00:00 •Secrets Of Outdoor Cooking Recipes: 01:00:00 •Once A Month Cooking Recipes: 00:15:00 •Mother's Day Cooking Made Easy: 01:00:00 •Mardi Gras Cooking Cajun Style: 00:30:00 •Learn To Cook Italian Food On Vacation: 01:00:00 •Cooking With A Dutch Oven: 01:00:00 •Recipes Of Italian Vegetarian Cooking: 01:00:00 •Home Cooking Network: An Array Of Recipes: 00:30:00 •America's Home Cooking: The Television Program: 01:00:00 •A Wonderful Experience With Outdoor Cooking Burners: 00:30:00 •Cooking For Sunday Dinner: 01:00:00 •Healthy Cooking Oils: 01:00:00 •Cooking Cajun Food: 01:00:00 •Paula's Home Cooking Recipes: 00:30:00 •The Importance Of Eating A Healthful Vegetarian Diet: 01:00:00 •Italian Food On A Date: 00:30:00 •The History Of Pasta In Italian Food: 01:00:00 •Review Of Different Vegetarian Cooking Shows: 00:30:00 •Italian Cooking Brochutto: 01:00:00 •Cooking Christmas Cookies: 01:00:00 •Back To Beginning For President's Day Cooking: 00:30:00 •Microwave Bacon Cooking Equipment: 00:30:00 •Cheap Italian Food In Milan: 01:00:00 •Chinese Cooking Wok: 01:00:00 •7 Useful Cooking Tips And Hints: 01:00:00 •Down Home Cooking: 00:30:00 •Italian Cooking School: 00:30:00 •Cooking Games: 00:30:00 •Italian Cooking Recipes: 00:30:00 •French Cooking Holidays: 00:30:00 •Food Business Basics: 01:00:00 •Put Together Your Business Concept: 00:30:00 •Identify your Target Market: 00:30:00 •Identify Your Competition: 00:30:00 •Write A Mission Statement: 00:30:00 •Downline Basics: 00:30:00 •Equipment And Supplies: 00:30:00 •Marketing And Quality Control: 00:30:00 •Wrapping Up: 00:15:00 •Recipe - I: 01:00:00 •Recipe - II: 01:00:00 •Recipe - III: 01:00:00 •Recipe - IV: 01:00:00 •Recipe - V: 01:00:00 •Recipe - VI: 01:00:00 •Recipe - VII: 01:00:00 •Recipe - VIII: 01:00:00 •Recipe - IX: 01:00:00 •Recipe - X: 01:00:00 •Recipe - XI: 00:30:00 •Recipe - XII: 00:30:00 •Recipe - XIII: 00:15:00 •Recipe - XIV: 00:30:00 •Recipe - XV: 00:30:00 •Recipe - XVI: 01:00:00 •Recipe -XVII: 01:00:00 •Recipe -XVIII: 01:00:00 •Recipe -XX: 01:00:00 •Recommended Reading: Diploma in Professional Chef: 00:00:00

Diploma in Professional Chef
Delivered Online On Demand14 hours 45 minutes
£12

Portuguese Speaking Course

4.9(27)

By Apex Learning

Overview This comprehensive course on Portuguese Speaking Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Portuguese Speaking Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Portuguese Speaking Course. It is available to all students, of all academic backgrounds. Requirements Our Portuguese Speaking Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 35 sections • 88 lectures • 14:04:00 total length •Do You Speak Portuguese: 00:31:00 •I Understand A Little Portuguese: 00:22:00 •Good Morning Miss: 00:22:00 •Don't Speak Portuguese Very Well: 00:19:00 •Want to Learn Portuguese: 00:21:00 •Where Are You Now on The Street: 00:21:00 •Where Are You Now: 00:35:00 •I Want to Eat: 00:23:00 •You Have to Leave: 00:22:00 •I'm Thirsty: 00:22:00 •See You Later: 00:24:00 •Would Like to Eat Something: 00:20:00 •How Much Does It Cost?: 00:18:00 •Count From 11 To 100: 00:24:00 •What Time Is It: 00:06:00 •Its Midday: 00:04:00 •One Minute Please: 00:05:00 •I Am in A Hurry: 00:06:00 •I Am Late: 00:04:00 •God Be with You: 00:09:00 •Where Are You From: 00:07:00 •I Am from England: 00:10:00 •Countries Vocabulary: 00:10:00 •My God, I Am So Late: 00:07:00 •Where Do You Live: 00:05:00 •Near Far: 00:06:00 •As You Wish: 00:08:00 •Where Are You: 00:04:00 •I Am at Home: 00:06:00 •I Am Close to Work: 00:05:00 •I Live Close to The Subway: 00:08:00 •Jobs Vocabulary: 00:06:00 •What Do You Do for A Living?: 00:06:00 •Verb to Work: 00:06:00 •The Possessive Pronoun Feminine: 00:08:00 •I Don't Work; I Am A Housewife: 00:06:00 •I Am Sick: 00:05:00 •The verb to Do and To Make: 00:12:00 •I Think I Am Sick: 00:05:00 •Do You Have Children: 00:07:00 •Need to Go to The Doctor: 00:14:00 •Wish You A Speedy Recovery: 00:04:00 •I Need to Go Out Section: 00:08:00 •I Am Going To Buy Things For Her: 00:10:00 •I Am Really Busy: 00:05:00 •Because Of The Children: 00:08:00 •There Are 10 Girls At My Work: 00:08:00 •My Wife Is At Home: 00:06:00 •Every Day I Walk To Work: 00:06:00 •They Are Brazilians: 00:09:00 •How Are You Guys Being: 00:05:00 •Where Are You Guys From: 00:07:00 •They Are Leaving Because They Are in A Hurry: 00:09:00 •They Are Leaving Because They Are in A Hurry: 00:09:00 •We Are Eating at San Paulo Restaurant: 00:08:00 •She Understands Portuguese Very Well: 00:05:00 •My Friend Doesn't Want to Have Dinner Now: 00:07:00 •The Possessive Pronoun His: 00:04:00 •We Are Working A Lot These Days: 00:07:00 •I Would Like to Have Dinner with You: 00:08:00 •I Love You: 00:07:00 •How to Conjugate the Verb for Pronoun We in The Present Simple?: 00:11:00 •Pronoun We (A Gente): 00:07:00 •What Do You Guys Do: 00:04:00 •How to Conjugate the Verb for Pronoun We in The Present Simple?: 00:11:00 •I Am Going Out with My Friend: 00:09:00 •Who Is Speaking?: 00:07:00 •The Possessive Pronoun Her: 00:04:00 •I Am Going Out with My Friends: 00:09:00 •We Are Going Out At 7.30: 00:07:00 •We are going out exactly at 10: 00:09:00 •It's A Pleasure to Meet You: 00:10:00 •It's Still Early: 00:05:00 •Let's Go to The Mail: 00:10:00 •Leave It for Tomorrow: 00:09:00 •We Can Go to The New Restaurant: 00:08:00 •I Need to Buy Some Stuff: 00:07:00 •What Would You Like to Order?: 00:06:00 •I Will Order Meat: 00:06:00 •The Compound Future: 00:08:00 •The Food Is Delicious: 00:09:00 •I Will Take Orange Juice: 00:06:00 •Debit or Credit: 00:06:00 •Can We Pay in Doller?: 00:09:00 •Keep the Change: 00:04:00 •Do You Guys Want to Go Out with Us: 00:05:00 •What Would You Like for Dessert?: 00:05:00 •Is There Ice Cream: 00:04:00

Portuguese Speaking Course
Delivered Online On Demand14 hours 4 minutes
£12

Master English Speaking 3

4.9(27)

By Apex Learning

Overview This comprehensive course on Master English Speaking 3 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master English Speaking 3 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Master English Speaking 3. It is available to all students, of all academic backgrounds. Requirements Our Master English Speaking 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 25 sections • 91 lectures • 05:33:00 total length •Introduction: 00:02:00 •Lesson 1 -Alcohol drinking: 00:08:00 •Practice phrases in real situation: 00:03:00 •Practice phrases in movies: 00:04:00 •Practice and check yourself: 00:03:00 •10 phrases about talents and experiences: 00:08:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:03:00 •10 phrases for being rich or poor: 00:07:00 •Practice phrases in real situations: 00:04:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:03:00 •10 Phrases for Talking about Statistics: 00:07:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:03:00 •10 ways for telling people to wait: 00:06:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 Ways to speak estimating and guessing: 00:06:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:02:00 •10 phrases for making decisions: 00:07:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 phrases to speak about bad and good luck: 00:06:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 ways to speak about relief and stress: 00:07:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 ways to speak about future: 00:07:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:02:00 •10 Phrases to avoid answering a question: 00:06:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:03:00 •10 phrases to express your uncertainty: 00:07:00 •Practice phrases in real situations: 00:03:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:03:00 •10 phrases to speak about sth interesting or boring: 00:06:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies s14 3: 00:03:00 •Practice and check yourself: 00:02:00 •10 phrases for cheering someone up: 00:05:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 ways to speak about disappointment: 00:06:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 ways to say you don't believe someone: 00:06:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 words we use for bad people: 00:05:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:02:00 •10 phrases for describing speaking: 00:05:00 •Practice phrases in real situation: 00:02:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:02:00 •10 ways to speak about facial expressions: 00:06:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •10 ways to describe offending: 00:08:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:01:00 •10 phrases to speak about bad travel experience: 00:06:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:03:00 •Practice and check yourself: 00:02:00 •10 phrases to give people compliments: 00:04:00 •Practice phrases in real situations: 00:02:00 •Practice phrases in movies: 00:02:00 •Practice and check yourself: 00:02:00 •Download it now: 00:30:00 •Assignment - Master English Speaking 3: 00:00:00

Master English Speaking 3
Delivered Online On Demand5 hours 33 minutes
£12