574 Magic courses in Elgin delivered Online

Highlights of the Course Course Type: Online Learning Duration: 4 Hours 26 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Cisco CCNA IPv4 networking Understand the core competencies and principles of Cisco CCNA IPv4 networking Explore the various areas of Cisco CCNA IPv4 networking Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert networking engineer Cisco CCNA IPv4 Complete Training Course Master the skills you need to propel your career forward in Cisco CCNA IPv4 networking . This course will equip you with the essential knowledge and skillset that will make you a confident networking engineer and take your career to the next level. This comprehensive cisco CCNA IPv4 course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this cisco CCNA IPv4 course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Cisco CCNA IPv4 networking practice and equip you with the essential skills, confidence and competence to assist you in the Cisco CCNA IPv4 networking industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Cisco CCNA IPv4 networking . This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for networking engineer or for people who are aspiring to specialise in Cisco CCNA IPv4 networking . Enrol in this cisco CCNA IPv4 course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive cisco CCNA IPv4 course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Cisco CCNA IPv4 networking can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This cisco CCNA IPv4 course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This cisco CCNA IPv4 course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This cisco CCNA IPv4 course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction to the IPv4 Course Introduction 00:13:00 IP Addressing Introduction to Section 00:02:00 Common Hardware Used On A Network 00:08:00 What is an IP Address 00:04:00 Special IP Addresses 00:10:00 Classes of IP Addresses 00:11:00 The Subnetmask 00:06:00 Summary of Section 00:04:00 Introduction to Conversions and Basic Configurations Introduction to Section 00:02:00 CIDR to Dotted Decimal Conversions 00:08:00 Planning Your Interface 00:11:00 Assigning Your IP's To End Devices 00:07:00 Summary of Section 00:03:00 Introduction to Basic Router Configurations and IP's Introduction to Section 00:01:00 Basic Router Configurations 00:11:00 Configuring a Router Interface 00:10:00 Private IP's VS Public IP's 00:08:00 Summary of Section 00:02:00 Subnetting Introduction to Subnetting Section 00:01:00 The Need for Subnetting 00:03:00 How Do We Subnet 00:15:00 Subnetting Different Classes of IPv4 Addresses 00:12:00 The Magical Line Concept 00:16:00 Summary of Section 00:05:00 Summarization Introduction to Summarization Section 00:02:00 How to Summarize the Binary Way 00:16:00 The Importance of Summarization 00:10:00 Summary of Section 00:03:00 VLSM Introduction to the VLSM Section 00:01:00 What is VLSM 00:13:00 How Do We Calculate VLSM Networks 00:15:00 Summary of Section 00:02:00 Wildcard Masking Introduction To The Wildcard Masking Section 00:01:00 How Do We Calculate Wildcard Mask 00:07:00 Examples Of Using Wildcard Masking 00:07:00 Summary of Section 00:02:00 Summary of the Course SUMMARY OF THE COURSE! 00:05:00 Assessment Assessment - Cisco CCNA IPv4 Complete Training 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

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

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!

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

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

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

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

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!

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

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