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

573 Magic courses in Caterham delivered Online

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses 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 Excel Formulas Detailed: Introduction to three Excel Models 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 Formula Based Prepaid Expenses Model 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 Calculate Prepaid Expenses Amortisation from Exact Start Date 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 Prepaid Expenses Summary with Power Query and Pivot Table 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 Advanced VBA Prepaid Expenses Amortisation Model 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 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way 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 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic 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 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Kids Party Planner: Crafts and Decorations

4.3(43)

By John Academy

Unlock the secrets to creating unforgettable kids' parties with our 'Kids Party Planner: Crafts and Decorations' course. Learn budget-friendly planning, imaginative theme selection, entertaining activities, and hands-on skills like face painting. Elevate your party planning expertise and make every celebration a magical experience for children. Join us now for a journey of creativity, organization, and joy!

Kids Party Planner: Crafts and Decorations
Delivered Online On Demand1 hour 30 minutes
£23.99

Creating Children's Room and Decorating for Kids

By NextGen Learning

You're giving your Children's Room a makeover, excited to make it a place that ignites their imagination and fills their heart with joy. As you search for ideas online to create Children's Room, you feel overwhelmed and unsure of how to bring your vision to life. If you yearn for expert guidance in decorating Children's Rooms, Look no further than the Creating Children's Room and Decorating for Kids course. This comprehensive program will teach you everything you need to know, from choosing playful colours to setting up your own decorating business. With newfound skills and knowledge, you'll transform your child's room into a magical space that sparks creativity and delights both kids and parents. Learning Outcomes: Upon completing this Creating Children's Room course, you will be able to - Develop a keen eye for creating colour combinations that evoke a playful and joyful ambience. Master the art of decorating floors and ceilings to create immersive and visually captivating spaces. Learn the essentials of furnishing children's rooms with practicality and style. Discover innovative storage solutions that maximise space and maintain a tidy environment. Explore the enchanting realm of themed rooms, from whimsical fairylands to adventurous pirate hideaways. Acquire business setup and marketing skills to lau Let your creativity soar as we journey through the modules that compose the Creating Children's Room and Decorating for Kids course. In the Creative Colour module, you will unlock the secrets of combining hues to create vibrant and harmonious spaces that stimulate the imagination. From soft pastels to bold splashes of colour, you will learn how to infuse rooms with personality and charm. Decorating Floor and Ceiling will transport you to a world of artistic possibilities, where you will discover how to transform these often-overlooked spaces into mesmerising backdrops that captivate young minds. The Furnishing module will guide you in selecting furniture and décor that strike the perfect balance between functionality and aesthetic appeal. In Storage Spaces for Children's Rooms, you will explore clever storage solutions that keep toys, books, and belongings organised, fostering a sense of order and calm. The enchanting world of Themed Rooms awaits, where you will delve into the intricacies of creating immersive environments that transport children into their favourite imaginative realms. As you progress, the course takes a practical turn, providing insights into setting up your own children's room decorating business. From understanding the market to effective marketing strategies, you will gain the necessary skills to turn your passion for creating magical spaces into a fulfilling and profitable career. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring interior designers with a specific interest in children's room design. Parents and caregivers looking to create inspiring and nurturing spaces for their children. Professionals in the home decor industry seeking to specialize in children's room design. Individuals with a passion for creativity and a desire to launch a children's room decorating business. Career path Here are some potential paths and their respective salary ranges in the UK: Children's Room Interior Designer: £20,000 - £40,000 per year Home Decor Specialist: £18,000 - £35,000 per year Children's Room Decorator: £15 - £35 per hour (freelance) Home Staging Consultant specialising in children's rooms: £20,000 - £40,000 per year

Creating Children's Room and Decorating for Kids
Delivered Online On Demand3 hours
£15

Professional Wedding Planner

4.9(27)

By Apex Learning

Overview Make every wedding magical and become a sought after wedding planner, by joining the Professional Wedding Planner course. As a professional wedding planner, you will require both creativity and management skills. In this innovative course, you will gain the expertise and fundamental skillsto planthemed and traditional wedding programson a minimal budget. What's more, you will learn how to get clients and launch your own wedding planning business from scratch. 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 Professional Wedding Planner. It is available to all students, of all academic backgrounds. Requirements Our Professional Wedding Planner 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 7 sections • 7 lectures • 02:17:00 total length •Wedding Planner as a Profession: 00:18:00 •The Big Day Planning: 00:19:00 •Wedding Party Dresses: 00:30:00 •The Reception, Party and Gifts: 00:20:00 •Final Budget: 00:13:00 •Wedding Planner Business Marketing: 00:16:00 •Starting a Business as a Wedding Planner: 00:21:00

Professional Wedding Planner
Delivered Online On Demand2 hours 17 minutes
£12

Herbal Mastery Advanced Course - Level 4

4.9(27)

By Apex Learning

Overview Recover your mental and physical wellness through herbs. Learn about the ancient art of herbal medicine!This Herbal Mastery Advanced Course - Level 4 course will teach you all about the magical properties of herbs and their uses, plant chemistry, herbal skincare and the history of traditional Chinese remedies. You will discover how herbs and their roots are used to heal a range of common ailments such as high blood pressure and low immunity. You will learn to utilise the power of the natural world and gain the skills to work in a range of associated professions.Master these traditional cures and use your knowledge to help yourself and others live longer, healthier and happier. 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 Herbal Mastery Advanced Course - Level 4. It is available to all students, of all academic backgrounds. Requirements Our Herbal Mastery Advanced Course - Level 4 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 2 sections • 12 lectures • 03:20:00 total length •Introduction to Herbal Medicine: 00:18:00 •Regulations and Safety: 00:10:00 •Introduction to Botany: 00:09:00 •Chemistry of Herbs: 00:22:00 •Preparation of Herbal Remedies: 00:27:00 •Herbal Hair and Skin Care: 00:30:00 •Herbalist Approach and Conventional Herbal Medicines: 00:17:00 •Herbs of Bible and China: 00:14:00 •Ayurvedic Medicine: 00:22:00 •Aromatherapy: 00:22:00 •Creating a Successful Herbal Business: 00:09:00 •Assignment - Herbal Mastery Advanced Course - Level 4: 00:00:00

Herbal Mastery Advanced Course - Level 4
Delivered Online On Demand3 hours 20 minutes
£12

Life Coach Certificate

4.9(27)

By Apex Learning

Overview Gain excellence in interpersonal communication and fast-track your career towards success by attending the Life Coach Certificate course. The course offers interactive study materials of coaching fundamentals and additional constructive ideas that will develop your leadership skills and make you a witty professional. Being a coach requires diverse talent to possess. Our expert educator will also train you in implementing the acquired skills effectively. 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 Life Coach Certificate. It is available to all students, of all academic backgrounds. Requirements Our Life Coach Certificate 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 3 sections • 21 lectures • 07:46:00 total length •Module 01: Introduction to Life Coaching: 01:00:00 •Module 02: History of Life Coaching: 00:10:00 •Module 03: Listening as a Coach: 00:30:00 •Module 04: The Language of Coaching: 01:00:00 •Module 05: Coaching as a Developmental Change Process: 00:45:00 •Module 06: Empowering the Client: 01:00:00 •Module 07: Ethics in Coaching: 00:50:00 •Module 08: Becoming an Effective Leader and Coach: 00:20:00 •Introduction : Let's begin the journey to true love!: 00:09:00 •Mindfulness Practice 01 : Breath- a doorway to freedom!: 00:13:00 •Meditation 02 : Are you ready to fall in love with your body as a sacred temple?: 00:13:00 •Practice 03 : Discover the mystery of the present through sensation tracking: 00:13:00 •Practice 04- If you like freedom this practice is for you!: 00:10:00 •Practice 05 : Opening to the Secret of the Magical Pause: 00:11:00 •Practice 06 : Lining Up Your Speech with Integrity: 00:09:00 •Practice 07 : Dropping Down Into the Mystery of the Golden Realms: 00:09:00 •Practice 08- A Return to the Bliss of Self-Love: 00:07:00 •Now You're Ready to Dive Into Practice - A Review of it All: 00:04:00 •Bonus- Relating to Family In Present Time - Yes you can do it!: 00:02:00 •Guided Meditation- 'Open Your Heart & Experience Unconditional: 00:16:00 •Guided Meditation- 'The Awakened Body': 00:15:00

Life Coach Certificate
Delivered Online On Demand7 hours 46 minutes
£12

Creative Writing - Fantasy Story Writing

4.7(160)

By Janets

Embark on a journey of imagination with our Creative Writing - Fantasy Story Writing course! Unleash your creativity, craft compelling characters, and weave enchanting worlds in this immersive writing adventure. Whether you're a novice or a seasoned wordsmith, dive into the realms of magic, mythical creatures, and epic quests. Unlock the secrets of fantasy storytelling and bring your wildest dreams to life on the page. Join now and let your imagination soar!

Creative Writing - Fantasy Story Writing
Delivered Online On Demand1 hour
£9.99

Advanced Certificate in Game Design - QLS Endorsed

By Kingston Open College

FREE Certification:QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support

Advanced Certificate in Game Design - QLS Endorsed
Delivered Online On Demand9 days
£15

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

Urban Farming and Gardening - Level 3

4.5(3)

By Studyhub UK

Experience the joy of cultivation within city bounds with our Level 3 course on 'Urban Farming and Gardening'. The course provides an introduction to the concept and principles of urban farming, exploring the potential of transforming urban spaces into productive green havens. The course further delves into various agricultural and gardening techniques suitable for urban areas, highlights the importance of sustainable practices, and the role of urban farming in promoting food security. It concludes with a comprehensive guide on how to establish and manage an urban farm or garden, turning learners into competent urban farmers. Learning Outcomes Understand the concept and principles of urban farming and gardening. Employ various farming and gardening techniques in an urban setting. Implement sustainable practices in urban farming. Recognise the role of urban farming in promoting food security. Establish and manage an urban farm or garden effectively. Why choose this Urban Farming and Gardening - Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Urban Farming and Gardening - Level 3 course for? Individuals interested in transforming urban spaces into green areas. Environmental enthusiasts seeking to learn about sustainable agricultural practices. Homeowners looking to establish home gardens or farms. Urban planners and architects interested in incorporating green spaces in designs. Students and professionals in agriculture, horticulture, or environmental science. Career path Urban Farmer: £20,000 - £30,000 Community Garden Coordinator: £18,000 - £28,000 Urban Planner: £25,000 - £45,000 Agricultural Consultant: £25,000 - £50,000 Horticultural Therapist: £20,000 - £35,000 Urban Garden Designer: £20,000 - £40,000 Prerequisites This Urban Farming and Gardening - Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Urban Farming and Gardening - Level 3 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Comparative Literature Introduction to Comparative Literature 00:12:00 Module 02: Literary Theory and Comparative Analysis Literary Theory and Comparative Analysis 00:18:00 Module 03: Epic Tales Across Cultures Epic Tales Across Cultures 00:22:00 Module 04: Love, Identity, and Magical Realism Love, Identity, and Magical Realism 00:19:00 Module 05: Literary Movements and Themes Literary Movements and Themes 00:14:00 Module 06: Comparative Study of Literary Genres Comparative Study of Literary Genres 00:16:00 Module 07: Regional Focus Literature from Asia and Africa Regional Focus Literature from Asia and Africa 00:24:00 Module 08: Postcolonial and Contemporary Global Voices Postcolonial and Contemporary Global Voices 00:21:00

Urban Farming and Gardening - Level 3
Delivered Online On Demand2 hours 26 minutes
£10.99