ð Introducing: Invoicing and Sales Mastery Course! Are you ready to supercharge your business's financial success? Dive into the world of invoicing and sales with our comprehensive text course designed to elevate your skills and propel your career to new heights. Whether you're a seasoned entrepreneur, a budding freelancer, or a curious professional looking to expand your knowledge, this course is your ticket to mastering the art of invoicing and sales. ð Why Invoicing and Sales Matter: Unlock Your Business's Potential Invoicing and sales are the lifeblood of any successful enterprise. Efficient invoicing ensures timely payments, smooth cash flow, and stronger client relationships. Meanwhile, mastering the art of sales empowers you to close deals, expand your customer base, and drive revenue growth. With our course, you'll gain invaluable insights into crafting persuasive sales pitches, streamlining invoicing processes, and optimizing your financial workflows for maximum efficiency and profitability. ð What You'll Learn: Invoicing Essentials: Discover the fundamentals of creating professional invoices, including best practices for formatting, itemizing, and sending invoices to clients. Say goodbye to overdue payments and hello to prompt, hassle-free transactions. Sales Strategies: Uncover the secrets of effective sales techniques, from building rapport with prospects to overcoming objections and sealing the deal. Whether you're selling products, services, or ideas, our course equips you with the tools you need to close more deals and drive revenue. Financial Management: Learn how to manage your business's finances like a pro, from tracking expenses and revenue to forecasting cash flow and optimizing profitability. With our expert guidance, you'll gain the confidence to make informed financial decisions that propel your business forward. Customer Relationship Management: Cultivate lasting relationships with your clients by mastering the art of customer relationship management. From nurturing leads to providing exceptional post-sales support, you'll learn how to delight your customers at every touchpoint and turn them into loyal brand advocates. Automation and Efficiency: Harness the power of automation to streamline your invoicing and sales processes, saving time and reducing errors. Our course introduces you to cutting-edge tools and technologies that revolutionize how you do business, empowering you to work smarter, not harder. ð©âð¼ Who Is This For? Entrepreneurs: Whether you're running a startup or a seasoned business owner, mastering invoicing and sales is essential for driving growth and profitability. Freelancers: Take control of your freelance career by mastering the art of invoicing and sales. With our course, you'll learn how to attract clients, negotiate rates, and ensure timely payments for your services. Sales Professionals: Sharpen your sales skills and take your career to the next level with our comprehensive course. From entry-level sales reps to seasoned sales executives, there's something for everyone in our curriculum. Small Business Owners: Running a small business comes with its unique challenges, but mastering invoicing and sales doesn't have to be one of them. Our course provides you with the tools and strategies you need to succeed in today's competitive marketplace. ð Career Path: Sales Representative: Kickstart your career in sales with a solid foundation in sales techniques and strategies. Our course equips you with the skills you need to excel in entry-level sales roles and climb the corporate ladder. Sales Manager: Elevate your career to the next level by mastering advanced sales management techniques. With our course, you'll learn how to lead sales teams, drive revenue growth, and exceed targets with confidence. Entrepreneur: Launch and grow your own business with confidence, armed with the knowledge and skills to succeed in today's competitive marketplace. Our course provides you with the essential tools and strategies you need to turn your entrepreneurial dreams into reality. Financial Analyst: Leverage your expertise in financial management to pursue a career as a financial analyst. Our course equips you with the skills to analyze financial data, make informed recommendations, and drive strategic decision-making for businesses of all sizes. ð Frequently Asked Questions (FAQs): Q: Is this course suitable for beginners? A: Absolutely! Our course is designed to cater to learners of all levels, from beginners looking to build a strong foundation to seasoned professionals seeking to enhance their skills. Q: How long does it take to complete the course? A: The duration of the course varies depending on your pace of learning and availability. On average, most learners complete the course within a few weeks, but you're free to progress at your own pace. Q: Are there any prerequisites for enrolling in the course? A: There are no specific prerequisites for enrolling in the course. However, a basic understanding of business concepts and terminology may be beneficial. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successfully completing the course, you'll receive a certificate of achievement to showcase your newfound skills and expertise. Q: Is there ongoing support available after completing the course? A: Absolutely! We're committed to your success every step of the way. Our dedicated support team is on hand to answer any questions you may have and provide assistance as you apply your newfound skills in the real world. ð Unlock Your Potential: Enroll Today! Don't let the complexities of invoicing and sales hold you back from achieving your business goals. Join thousands of successful entrepreneurs, freelancers, and professionals who have transformed their careers with our Invoicing and Sales Mastery Course. Enroll today and take the first step towards unlocking your full potential! Course Curriculum Module 1_ Introduction to Invoicing and Sales Introduction to Invoicing and Sales 00:00 Module 2_ Creating Professional Invoices Creating Professional Invoices 00:00 Module 3 Invoicing Software and Tools Invoicing Software and Tools 00:00 Module 4 Sales Techniques and Strategies Sales Techniques and Strategies 00:00 Module 5 Effective Negotiation Strategies for Sales and Procurement Effective Negotiation Strategies for Sales and Procurement 00:00 Module 6 Contract Management and Business Agreements Contract Management and Business Agreements 00:00
Embark on a journey to bridge the worlds of design and technology with the AutoCAD Programming Using C#.NET course. This expertly crafted curriculum begins with the essentials, guiding you through the .NET Framework and Visual Studio 2017 Community Edition, setting a solid foundation before diving into the complexities of programming. As the course unfolds, you will unravel the intricacies of C# fundamentals, crucial for manipulating the powerful AutoCAD .NET API. Your skills will progressively sharpen, enabling you to create and modify AutoCAD objects with precision and creativity. Learning Outcomes Acquire proficiency in the .NET Framework and navigate the Visual Studio 2017 environment with confidence. Master C# fundamentals to construct robust AutoCAD programming solutions. Operate the AutoCAD .NET API for creating precise and customised AutoCAD objects. Gain expertise in manipulating AutoCAD Dictionaries and implementing user input functions. Complete a hands-on project developing a title block, solidifying your programming acumen. Why choose this AutoCAD Programming Using C#.NET course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the AutoCAD Programming Using C#.NET 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. Who is this AutoCAD Programming Using C#.NET course for? Aspiring developers keen on specialising in engineering and architectural software solutions. Design professionals aiming to expand their technical toolset with programming capabilities. Technicians interested in upgrading their AutoCAD proficiency to include customised automation. Students and graduates seeking to enhance their employability in the design and construction industry. Hobbyists eager to explore the intersection of programming and digital design. Career path CAD Software Developer - £30,000 to £50,000 .NET Software Engineer - £35,000 to £60,000 Architectural Technologist - £25,000 to £40,000 Design Engineer - £27,000 to £45,000 CAD Technician - £20,000 to £35,000 Application Support Analyst - £22,000 to £40,000 Prerequisites This AutoCAD Programming Using C#.NET does not require you to have any prior qualifications or experience. You can just enrol and start learning.This AutoCAD Programming Using C#.NET 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.
Business Finance and Revenue Operations Diploma Upgrade your financial acumen with the Business Finance and Revenue Operations Diploma. This course is designed to equip you with essential skills and knowledge, spanning from the fundamentals of business finance to the intricacies of revenue operations. Learning Outcomes: Acquire a thorough understanding of the various branches of business finance. Master the business finance cycle, from planning to execution. Distinguish between personal and business finance. Analyze financial performance through business finance analysis. Gain proficiency in revenue operations skills. Learn the art of aligning revenue teams for optimum performance. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Business Finance and Revenue Operations Diploma: Branches of Business Finance: Explore the key branches of business finance, such as corporate finance, investments, and financial markets, to develop a holistic understanding of the field. Business Finance Cycle: Familiarize yourself with the stages of the business finance cycle, including budgeting, forecasting, and long-term planning. Personal Finance: Delve into the distinctions between personal and business finance, focusing on risk management, investment strategies, and liquidity management. Business Finance Analysis: Learn advanced techniques for analyzing a company's financial health, including key performance indicators and financial ratios. Revenue Operations Skills: Acquire the necessary skill set for effective revenue operations, encompassing data analysis, automation, and cross-functional collaboration. Aligning Revenue Teams: Understand the importance of aligning revenue-generating teams like sales, marketing, and customer success for achieving organisational goals.
The 'Linux Shell Scripting' course offers comprehensive training in shell scripting for Linux environments. From creating a local Linux shell scripting environment to network scripting and automation, learners will develop practical skills to automate tasks, process data, and improve efficiency using shell scripts. Learning Outcomes: Set up a local Linux shell scripting environment for practical learning. Create shell scripts for user and account management, including password generation and handling shell script arguments. Apply Linux programming conventions to maintain clear and efficient code. Develop shell scripts that parse command-line options for flexible user interaction. Utilize shell scripting for data processing, transformation, and reporting tasks. Automate network scripting and distributed systems for enhanced efficiency. Summarize the key concepts and techniques learned throughout the course. Access additional course extras and resources for further exploration and practice. Why buy this Linux Shell Scripting? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Linux Shell Scripting there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Linux Shell Scripting course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Linux Shell Scripting does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Linux Shell Scripting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Linux Shell Scripting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Course Introduction Introduction and Course Overview 00:02:00 Course Downloads 00:03:00 Unit 02: Creating a Local Linux Shell Scripting Environment Creating a Local Lab Environment Using Vagrant and VirtualBox - Background 00:16:00 Exercise 1 Instructions - Creating a Local Linux Shell Scripting Lab Environment 00:28:00 Exercise 1 - Walkthrough - Part I - Windows Users Only 00:04:00 Exercise 1 - Walkthrough - Part I - Mac Users Only 00:02:00 Exercise 1 - Walkthrough - Part I - Linux (CentOS/RHEL) Users Only 00:03:00 Exercise 1 - Walkthrough - Part II - All Users 00:23:00 Unit 03: User and Account Creation - Shell Scripting Project 1 Section Introduction 00:03:00 Getting Started with Shell Scripting: Naming, Permissions, Variables, Builtins. 00:35:00 Special Variables, Pseudocode, Command Substitution, if Statement, Conditionals. 00:23:00 Exit Statuses, Return Codes, String Test Conditionals, More Special Variables. 00:18:00 Reading Standard Input, Creating Accounts, Username Conventions, More Quoting. 00:23:00 Exercise 2 - Instructions 00:12:00 Exercise 2 - Walkthrough 00:21:00 Unit 04: Password Generation and Shell Script Arguments - Shell Scripting Project 2 Random Data, Cryptographic Hash Functions, Text and String Manipulation. 00:31:00 Positional Parameters, Arguments, for Loops, Special Parameters 00:30:00 The while Loop, Infinite Loops, Shifting, Sleeping 00:16:00 Exercise 3 - Instructions 00:12:00 Exercise 3 - Walkthrough 00:20:00 Unit 05: Linux Programming Conventions - Shell Scripting Project 3 Advanced Standard Input, Standard Output, and Standard Error - Part I 00:13:00 Advanced Standard Input, Standard Output, and Standard Error - Part II 00:26:00 Exercise 4 - Instructions 00:05:00 Exercise 4 - Walkthrough 00:12:00 Unit 06: Parsing Command Line Options - Shell Scripting Project 4 Case Statements 00:20:00 Functions 00:33:00 Parsing Command Line Options with getopts, Part 1 00:20:00 Parsing Command Line Options with getopts, Part 2 00:18:00 Deleting and Disabling Linux Accounts, Part 1 of 4 (Finding Files) 00:11:00 Deleting and Disabling Linux Accounts, Part 2 of 4 (The userdel command) 00:05:00 Deleting and Disabling Linux Accounts, Part 3 of 4 (Archives with tar) 00:14:00 Deleting and Disabling Linux Accounts, Part 4 of 4 (Disabling Accounts) 00:08:00 Deleting Users - Exercise 5 - Instructions 00:14:00 Deleting Users - Exercise 5 - Walkthrough 00:33:00 Unit 07: Transforming Data / Data Processing / Reporting - Shell Scripting Project 5 Cut and Awk 00:22:00 Cut and Awk Demonstration Script: Open Network Ports 00:10:00 Sort and Uniq 00:18:00 Parsing Log Files - Exercise 6 - Walkthrough 00:15:00 Sed 00:29:00 Unit 08: Network Scripting & Automation of Distributed Systems: Shell Scripting Project 6 Configuring a Mini Network and Scripting for Remote Systems 00:30:00 Scripting Remote Commands - Walkthrough - Part 1 00:26:00 Scripting Remote Commands - Exercise - Instructions 00:12:00 Scripting Remote Commands - Walkthrough - Part 2 00:13:00 Unit 09: Course Summary Summary 00:08:00 Unit 10: Course Extras What Shell Scripting Is and Why You Should Learn It 00:10:00 Resources Resources - Linux Shell Scripting 00:00:00 Assignment Assignment - Linux Shell Scripting 00:00:00
Overview This comprehensive course on Changes in Accounting: Latest Trends Encountered by CFOs in 2022 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Changes in Accounting: Latest Trends Encountered by CFOs in 2022 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 Changes in Accounting: Latest Trends Encountered by CFOs in 2022. It is available to all students, of all academic backgrounds. Requirements Our Changes in Accounting: Latest Trends Encountered by CFOs in 2022 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 2 sections • 16 lectures • 03:26:00 total length •Introduction: 00:01:00 •Use Of AI in Accounting: 00:07:00 •Cloud-Based Accounting Software: 00:06:00 •Digital Transformation: 00:10:00 •Workplace Wellness: 00:05:00 •Online Collaboration and Remote Workforce: 00:05:00 •7. Evolution of accountant role, Data Visualisation and Data Security: 00:07:00 •Outsourcing, Tax compliances and other changes: 00:05:00 •CFO Trends - Building Cash Resilience: 00:13:00 •CFO Trend - Creating an Effective budget and forecast during uncertainties: 00:09:00 •CFO Trends - Using automation and digitalisation: 00:08:00 •CFO Trends - Aligning business model with changing: 00:06:00 •CFO Trends - Hybrid Work Office and culture: 00:06:00 •CFO Trends - Growth Through Innovation and non-finance roles: 00:07:00 •Most Anticipated Changes in Accounting: 00:52:00 •The trend for Focus by CFO 2022: 00:59:00
24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The UK mobile app market is expected to reach a staggering £20.5 billion by 2025. With the app development industry booming, there's never been a better time to acquire the skills to build your own apps and potentially launch your next big venture. This App Development Advanced Diploma Bundle equips you with the knowledge and tools to create various applications across different platforms and technologies. With this App Development Advanced Diploma course you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate Flutter & Dart Development for Building iOS and Android Apps and our exclusive student ID card absolutely free. Courses Are Included In This App Development Advanced Diploma Bundle: Course 01: Flutter & Dart Development for Building iOS and Android Apps Course 02: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 03: Level 3 Creating Web App for iPad Course 04: Web Application Penetration Testing Course 05: Industry 4.0 - Automation & Applications Course 06: Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course Course 07: Tic-Tac-Toe Clone - The Complete SFML C++ Game Course Course 08: Flappy Bird Clone: SFML C++ Game Course 09: Modern OpenGL 3D Game Course 10: Blender 3D - Create a Cartoon Character Course 11: Developing Game in Unity 3D Course 12: Unreal Engine 4 for Beginners Course 13: Unreal Engine 4 Course 14: Make Cinematics Using Unreal Engine 5 Course 15: Maya & Unity 3D: Modeling Lowpoly Tree for Mobile Games Course 16: Maya & Unity 3D: Modeling Environments for Mobile Games Course 17: Publish Game Assets to the Unity & Unreal Marketplace for Passive Income Course 18: Monetize Your Mobile Game or App Course 19: The Media Crash Course Course 20: Environment Design Using Unreal Engine 5 Each lesson in this App Development course is crafted for easy understanding, enabling you to become proficient in App Development. Whether you are a beginner or looking to sharpen your existing skills, this App Development is the ideal choice. Learning Outcomes of this Bundle Grasp fundamental programming concepts in various languages like Dart, C#, and C++. Master essential app development frameworks like Unity, Unreal Engine, and Maya. Explore web application security principles to protect your creations. Design and develop engaging 2D and 3D games for different platforms. Enrol in App Development Advanced Diploma today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of this Bundle Get a free student ID card with this Bundle Lifetime access to the course materials Get instant access to this Bundle course Learn from anywhere in the world 24/7 tutor support with the App Development Advanced Diploma course. App Development Advanced Diploma is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway with our App Development Advanced Diploma Training! App Development Advanced Diploma premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of App Development Advanced Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. The App Development course is extremely dynamic and well-paced to help you understand App Development with ease. Certification of App Development You have to complete the assignment given at the end of the App Development Advanced Diploma course and score a minimum of 60% to pass each exam. After passing the App Development Advanced Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This App Development Advanced Diploma course is ideal for: Students seeking mastery in App Development Professionals seeking to enhance App Development skills Individuals looking for a App Development related career. Anyone passionate about App Development Requirements This App Development Advanced Diploma doesn't require prior experience and is suitable for diverse learners. Career path This App Development Advanced Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Mobile App Developer Game Developer Web Developer UI/UX Designer Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.
Unlock the keys to unparalleled customer service excellence with our 'Call Centre Training' course. Dive into the essentials of call center operations, hone communication skills, master telephone etiquettes, and learn effective negotiation techniques. Navigate challenging interactions, manage difficult customers, and grasp the intricacies of call center metrics and benchmarking. Stay ahead of the curve with insights into the latest technology trends shaping the industry. Elevate your career and contribute to organizational success by enrolling today. Develop the skills needed to excel as a call center professional and create lasting customer satisfaction.
Explore the AWS Platform with the expert guidance of a cloud and security instructor
ð Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! ð Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets! ð¥ Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities. ð¡ What Sets Our Masterclass Apart: â Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. â Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. â Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. â Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. â Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come. ð Course Highlights: ð Essential Excel Functions: From basic formulas to advanced functions, we cover it all. ð Data Visualization: Transform your data into impactful charts and graphs. ð Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. ð Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. ð Advanced Formulas: Impress your colleagues with advanced calculations. ð Automation with Macros: Streamline your tasks with Excel automation. ð Error Handling: Learn how to troubleshoot and avoid common mistakes. ð Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity. ð Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. ð Limited seats available. Secure your spot now! ð Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00