Overview This comprehensive course on Bookkeeping Tool : Google Sheets will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Bookkeeping Tool : Google Sheets 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 Bookkeeping Tool : Google Sheets. It is available to all students, of all academic backgrounds. Requirements Our Bookkeeping Tool : Google Sheets 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 1 sections • 12 lectures • 00:38:00 total length •Unit 1: Introduction: 00:03:00 •Unit 2: Google Sheets Users: 00:03:00 •Unit 3: Cash Bookkeeping: 00:04:00 •Unit 4: Advantages of Google Sheets in Bookkeeping: 00:02:00 •Unit 5: Chart of Accounts: 00:03:00 •Unit 6: Templates view: 00:02:00 •Unit 7: Invoice Template: 00:02:00 •Unit 8: Creating an Expense Book: 00:03:00 •Unit 9: Creating the Profit and Loss Statement: 00:06:00 •Unit 10: Making Records in the Revenue Book: 00:03:00 •Unit 11: Making Records in the Expense book: 00:04:00 •Unit 12: How the Profit and Loss Statement Updates: 00:03:00
Register on the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content 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 Thank you 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 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Our masterclass series goes behind the studio door and explores the processes of globally respected people, studios and businesses.
ðï¸ Store Assistant Training Course Overview: Excelling in Retail Excellence Ready to embark on a rewarding journey in the retail industry? Our comprehensive 'Store Assistant Training Course' is crafted to equip you with the skills and knowledge essential for success in the dynamic world of retail. From store operations to customer service, this course covers it all to transform you into a proficient and customer-focused store assistant. ð Module 1: Introduction to Retail Industry Begin your retail adventure with a deep dive into the vibrant and ever-evolving retail landscape. Understand the key players, market trends, and the fundamental principles that shape the industry. Get ready to navigate the exciting challenges of retail with confidence. ð¢ Module 2: Store Operations Uncover the inner workings of a retail store, from inventory management to merchandising and beyond. Learn the art of effective organization and optimization of store spaces to create a seamless and customer-friendly shopping environment. ð Module 3: Product Knowledge Become a product expert! This module focuses on enhancing your knowledge about the products you sell. From features and benefits to understanding customer needs, gain the expertise to assist customers in making informed purchasing decisions. ð° Module 4: Sales Techniques Refine your sales skills and discover the art of persuasion. Explore effective sales techniques, including upselling and cross-selling strategies, to maximize revenue and provide customers with a personalized shopping experience that keeps them coming back. ð¤ Module 5: Customer Service Elevate your customer service game to new heights. Understand the importance of building strong customer relationships, handling inquiries, and resolving issues with a smile. Learn to exceed customer expectations and create a positive and lasting impression. ð Why Choose Our Store Assistant Training Course? Practical Learning: Hands-on exercises and real-world scenarios for practical skill development. Industry-Relevant Content: Stay updated on the latest trends and customer expectations in the retail sector. Experienced Instructors: Learn from seasoned retail professionals with a wealth of industry knowledge. Career Advancement: Open doors to diverse opportunities within the retail industry. ð Enroll Now and Transform Your Retail Career! Don't miss the chance to embark on a fulfilling career as a skilled store assistant. Our Store Assistant Training Course is designed to equip you with the expertise needed to excel in the competitive retail landscape. Enroll now and unlock the keys to success in this dynamic and customer-centric industry! Course Curriculum Module 1_ Introduction to Retail Industry. Introduction to Retail Industry. 00:00 Module 2_ Store Operations. Store Operations. 00:00 Module 3_ Product Knowledge. Product Knowledge. 00:00 Module 4_ Sales Techniques. Sales Techniques. 00:00 Module 5_ Customer Service. Customer Service. 00:00
ð Unleash Your Sales Potential with 'Crafting an Effective Business Sales Blueprint' Online Course! ð Are you tired of hit-or-miss sales strategies that yield inconsistent results? Do you want to elevate your business's revenue and establish a rock-solid sales foundation? Look no further! Introducing our groundbreaking online course: ð Crafting an Effective Business Sales Blueprint ð Unlock the Doors to Sales Success! ð What You'll Learn: ð Module 1: INTRODUCTION Lay the groundwork for your sales journey with a comprehensive overview of the course. Understand the importance of a well-crafted sales blueprint in today's dynamic business landscape. Gain insights into successful sales techniques used by industry leaders. ð Module 2: THE SELLING STRATEGY FRAMEWORK Dive deep into the proven strategies that form the backbone of successful sales campaigns. Explore the psychology of buying and learn how to tailor your approach to different customer segments. Develop a strategic mindset to tackle challenges and adapt to market changes. ð¨ Module 3: BUILD YOUR SELLING STRATEGY Put theory into action as you construct your personalized selling strategy. Utilize practical exercises to refine your approach and address unique business needs. Receive personalized feedback and guidance from industry experts to fine-tune your blueprint for success. ð¡ Why Choose Our Course: ð Expert Guidance: Learn from seasoned professionals with a track record of success in diverse industries. ð Interactive Learning: Engage in hands-on exercises, case studies, and discussions to reinforce your understanding. ð Lifetime Access: Enjoy lifetime access to course materials, updates, and a supportive community of like-minded learners. ð Real-World Application: Apply your knowledge immediately with actionable strategies that drive results. ð Certificate of Completion: Showcase your expertise with a certificate upon successfully finishing the course. ð¯ Who Should Enroll: Entrepreneurs and business owners looking to boost sales. Sales professionals seeking to enhance their skills and results. Anyone eager to build a robust sales strategy for business success. Don't miss this opportunity to transform your approach to sales and propel your business to new heights! Enroll now and start crafting your path to unparalleled success with 'Crafting an Effective Business Sales Blueprint.' ð Enroll Today and Ignite Your Sales Revolution! ð Course Curriculum INTRODUCTION Importance of a Selling Strategies 00:00 THE SELLING STRATEGY FRAMEWORK Creating a Selling Strategy Framework 00:00 BUILD YOUR SELLING STRATEGY Step 1 - Determine Your Selling Model 00:00 Step 2 - Analyzing Your Competition 00:00 Step 3 - Examine the Costs 00:00 Step 4 - Internal Consistency 00:00 Step 5 - Creating Your Selling Strategy 00:00
Feeling Stuck in Your Career? The Event Management, Conference & Hospitality Management - 30 Courses Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Event Management, Conference & Hospitality Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Event Management, Conference & Hospitality Management - 30 Courses Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Event Management, Conference & Hospitality Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Event Management, Conference & Hospitality Management - 30 Courses bundle on your job life and career growth! This Event Management, Conference & Hospitality Management - 30 Courses Bundle Comprises the Following CPD Accredited Courses: Course 01: Event Management and Planning Course Course 02: Party Planner Course 03: Event Planner Course 04: Kids Party Planner Diploma Course 05: Wedding Planner Course 06: Hospitality Management Course 07: Concierge Course 08: Restaurant Management Course 09: Catering Management Course 10: Receptionist Skills Course 11: Hotel Revenue Management Course 12: Hotel Chief Accountant Training Course 13: Travel and Tourism Course 14: Travel Agent and Consultant Training Course 15: Tour Guide Training Course 16: Travel Blogger Course 17: Basic Photography Course 18: Customer Relationship Management Course 19: Operations Management Course 20: Delegation Skills Course 21: Career Development Plan Fundamentals Course 22: CV Writing and Job Searching Course 23: Learn to Level Up Your Leadership Course 24: Networking Skills for Personal Success Course 25: Ace Your Presentations: Public Speaking Masterclass Course 26: Learn to Make a Fresh Start in Your Life Course 27: Motivation - Motivating Yourself & Others Course 28: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 29: Decision Making and Critical Thinking Course 30: Time Management Training - Online Course What will make you stand out? Upon completion of this online Event Management, Conference & Hospitality Management - 30 Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this Event Management, Conference & Hospitality Management Bundle After successfully completing the Event Management, Conference & Hospitality Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Event Management, Conference & Hospitality Management Bundle The online test with immediate results You can study and complete the Event Management, Conference & Hospitality Management bundle at your own pace. Study for the Event Management, Conference & Hospitality Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Event Management, Conference & Hospitality Management - 30 Courses bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Event Management, Conference & Hospitality Management bundle, a comprehensive, complete collection of 30 courses. Each course in the Event Management, Conference & Hospitality Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Event Management, Conference & Hospitality Management bundle offers the flexibility and convenience to learn at your own pace. Make the Event Management, Conference & Hospitality Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Event Management, Conference & Hospitality Management - 30 Courses is perfect for: Expand your knowledge and skillset for a fulfilling career with the Event Management, Conference & Hospitality Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Event Management, Conference & Hospitality Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Event Management, Conference & Hospitality Management bundle. Learn on your schedule, in the comfort of your home - the Event Management, Conference & Hospitality Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Event Management, Conference & Hospitality Management bundle. Certificates CPD Certificates Digital certificate - Included
Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 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 Thank you 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 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00
The drop-dead simple method to master QuickBooks Pro in this comprehensive course bundle.
A podcast is a free service that allows internet users to download audios, videos, and listen to music from podcast websites. Learn how to start a podcast production business using a single USB mic to record your show through our precise contents of the Podcasting Training course. The outlines of the course will support to run your business smoothly through the proper use of podcasts. The Podcasting Training course teaches you the basic of audio theory, building up a studio, and getting the ultimate best outcomes spending a little amount of money. The course instructs you how to set up your podcasts in different ways to get connected with your target audience. It mainly focuses on how to start a podcast with editing, recording, inserting images, and manage WordPress and plugins. It also teaches you how to market, get website traffic, and generate revenue with your podcasts. At the end of the course, you will learn how to pursue your paid clients, and upload and publish podcasts, content and more. What you'll learn You will know how to purchase the necessary equipment for recording You will know how to set up your equipment for recording You will know how to syndicate a podcast into multiple forms (video, articles, guest posts & more) You will know how to syndicate your podcast to other audio libraries You will know how to edit your recordings with FREE software You will know how to structure your podcast for better conversion rates Requirements You should know how to use a PC at a beginner level You will need a microphone (USB or Cardioid) to record You may need additional equipment to improve your recording sound quality (but is not mandatory) Introduction Introduction FREE 00:01:00 Blueprint FREE 00:09:00 Recording & Setup Tools I Personally Use for Recording 00:12:00 OBS Setup 00:10:00 Creating a Professional Background for $50 00:04:00 The Perfect Webcam Settings 00:07:00 Voice Inflection for 2X Sales 00:17:00 Editing Editing Your Video with Free Softwares 00:01:00 Reduce Your Podcast File Sizes with Audacity 00:03:00 Podcast Optimization Podcast Structure 00:07:00 1 vs Group 00:06:00 Transcribing Your Podcast 00:02:00 Podcast Hosting 00:07:00 Syndicate Your Podcast 00:02:00 Course Certification