7589 Courses delivered On Demand

Overview Learn the secrets to delivering excellent customer service and gain an insight into how the retail industry works, with the Understanding Retail and Operations Management Strategies! This course is perfect for anyone looking to establish a successful career in the retail sector. It covers fundamental retail operations, retail etiquettes and best practices, ideal for those who are new to the industry. Ensure your career gets off to a great start with the proper training you need to excel in any retail environment and gain a recognised qualification from the comfort of your own home! Why buy this Understanding Retail and Operations Management Strategies? 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 Understanding Retail and Operations Management Strategies you will be able to take the MCQ test that will assess your knowledge. 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 Understanding Retail and Operations Management Strategies does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Understanding Retail and Operations Management Strategies 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 Understanding Retail and Operations Management Strategies is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Understanding Retail and Operations Management Strategies Module 01 Introduction to Retail Management 00:30:00 Handling Merchandise in Retail Management 00:30:00 Structure of Your Business 01:00:00 The Sales Process and Checkout 00:30:00 POS (Point of Sale) Retail System 00:15:00 Module 02 Importance of Consumer Behaviour 00:30:00 Importance of Communication in Retail Industry 00:15:00 Effective Inventory Management 01:00:00 Choosing a Retail Store Location 00:30:00 Retail Psychology 00:30:00 Manage Your Suppliers 00:30:00 Negotiate The Right Deal With Suppliers 00:30:00 Module 03 Develop Store Security Procedures 00:15:00 Management Skills For Leading Your Team 00:15:00 Retail Marketing 00:15:00 Role of Coupons in Retail Marketing 00:15:00 Retail Brand Management 00:15:00 Health And Safety Obligations For Retailers 00:15:00 Consumer Rights Act 00:30:00 Mock Exam Mock Exam - Understanding Retail and Operations Management Strategies 00:20:00 Final Exam Final Exam - Understanding Retail and Operations Management Strategies 00:20:00

Description: The Operation and Security Management Diploma course teaches both Operational Management and Security Management concepts and techniques. Throughout the course, you will learn the basics of operation management, human resource management, assets management, supply chain management, and cost management.  Then the course covers the concepts, skills and techniques of Security Management such as types of security threats, identity theft, piracy, data classification, ways of protecting your digital information, malware and more. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Operation and Security Management Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Operation and Security Management Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Operation and Security Management Diploma - Updated Version Module 01: Introduction To Operations Management Introduction To Operations Management 00:23:00 Module 02: Project Management Project Management 00:22:00 Module 03: Business Development And Succession Planning Business Development And Succession Planning 00:27:00 Module 04: Process Management Process Management 00:26:00 Module 05: Supply Chain Management Supply Chain Management 00:23:00 Module 06: Planning & Forecasting Operations Planning & Forecasting Operations 00:23:00 Module 07: Procurement & Purchasing Management Procurement & Purchasing Management 00:23:00 Module 08: Manufacturing & Delivery Operations Manufacturing & Delivery Operations 00:19:00 Module 09: Quality Management Quality Management 00:23:00 Module 10: Managing Risk And Recovery Managing Risk And Recovery 00:29:00 Module 11: Performance Management Performance Management 00:21:00 Module 12: Talent Management Talent Management 00:20:00 Module 13: Communication Skills Communication Skills 00:26:00 Module 14: Negotiation Techniques Negotiation Techniques 00:19:00 Module 15: Conflict Management Conflict Management 00:17:00 Module 16: Stress Management Stress Management 00:19:00 Module 17: Time Management Time Management 00:40:00 Module 18: Business Environment Business Environment 00:19:00 Module 19: Business Writing Skills Business Writing Skills 00:39:00 Operation and Security Management Diploma - Old Version Module 01 Designing Your Organizational Structure 00:30:00 Introduction to Operations Management 00:15:00 Understanding Financial Terms 00:30:00 Getting the Right People in Place 00:15:00 Getting Your Product Together 00:15:00 Building a Corporate Brand 00:30:00 Marketing Your Product 01:00:00 Selling Your Product 00:15:00 Planning for the Future 00:15:00 Goal Setting and Goal Getting 00:30:00 Succession Planning 101 00:15:00 Managing Your Money 00:15:00 Ethics 101 00:15:00 Building a Strong Customer Care Team 00:15:00 Training Employees for Success 00:15:00 Leadership Essentials 00:15:00 Module 02 The Fundamentals of Business Process Management 00:30:00 Defining Business Process Management 00:30:00 The Business Process Life Cycle 00:15:00 The Vision Phase 00:15:00 The Design Phase 01:00:00 The Modeling Phase 00:30:00 The Execution Phase 01:00:00 The Monitoring Phase 00:30:00 The Optimizing Phase 01:00:00 Module 03 What is Gap Analysis? 00:30:00 The Gap Analysis Process 00:30:00 Supporting Tools 00:30:00 Creating a Gap Analysis Report 00:15:00 Understanding Lean 00:30:00 The Toyota Production System 00:30:00 The Toyota Production System House 00:15:00 The Five Critical Improvement Concepts 00:15:00 Understanding Value with the Kano Model 00:15:00 Types of Waste 00:15:00 Creating a Lean Enterprise 00:15:00 The Plan, Do, Study, Act (PDSA) Cycle 00:15:00 Using the R-DMAIC-S Model 00:15:00 Lean Thinking Tools 00:15:00 Kaizen Events 00:00:00 Data Gathering and Mapping 00:30:00 A Plan to Take Home 00:15:00 Defining Continuous Improvement 00:15:00 Stage One - Identify Areas For Improvement 00:15:00 Stage Two - Create a Plan for Improvement 00:15:00 Stage Three - Implement the Changes 00:15:00 Stage Four - Review the Impact 00:15:00 Test Driving 00:15:00 Module 04 The Evolution of the Supply Chain 00:15:00 The Basic Supply Chain Structure 00:15:00 Supply Chain Drivers 00:15:00 Aligning Your Supply Chain with Business Strategy 00:15:00 Managing Supply Chain Risks 00:15:00 Tracking and Evaluating Supply Chain Data 00:30:00 Troubleshooting Supply Chain Problems 00:15:00 Sharing Supply Chain Activities 00:15:00 Sustainable Supply Chain Strategies 00:15:00 Applying Lean Techniques to the Supply Chain 00:15:00 The Future of Supply Chain Management 00:15:00 Supply Chain Management Basics 00:30:00 The Purchasing Cycle 00:45:00 Purchasing Toolkit 01:00:00 Managing Competitive Bids 00:45:00 Improving Efficiency and Accuracy 00:30:00 Analyzing and Reducing Risk in the Supply Chain 00:30:00 Managing Internal Relationships 00:30:00 Tools of the Trade 00:30:00 Module 05 What is Inventory? 00:30:00 Types of Inventory 00:15:00 Key Players 00:30:00 Setting up the Warehouse 00:15:00 What Makes a Good Inventory Management System? 00:15:00 The Warehouse Inventory Cycle 00:15:00 Identifying Demand 00:15:00 The Receiving Process 00:15:00 Validating Inventory 00:15:00 The Put-Away Process 00:15:00 Maintaining Inventory Accuracy 00:30:00 The Outbound Process 00:30:00 Industry Trends 00:15:00 Module 06 Concept of Quality FREE 00:19:00 Key Terms 00:23:00 Categories 00:21:00 Customer Input 00:11:00 Plan Quality 00:08:00 Design of Experiments 00:07:00 Quality Control 00:11:00 Control Charts 00:11:00 Sampling 00:11:00 Six Sigma 00:08:00 The Steps 00:10:00 The 6 Six Sigma Challenges 00:05:00 Module 07 The Basics Of Security Management 00:15:00 Security Management Planning And Implementing 00:15:00 How to Build a Security Management Team 00:15:00 The Role And Responsibilities of a Security Officer 00:30:00 Security Management Governance 00:15:00 Organizational Security Models 00:30:00 Understanding Risk, Threat, And Vulnerability 00:15:00 Information Risk Management 00:30:00 Different Types of Crimes 00:15:00 Understanding What Burglaries Are 00:15:00 Definition and Dangers of Hijacking 00:15:00 Domestic Violence in the Workplace 00:30:00 Child abuse: Identification, Reporting, and Prevention 00:30:00 Sexual Violence: Prevention Strategies 00:15:00 Module 08 Types of Security Threats 00:29:00 Social Engineering 00:31:00 Identity Theft 00:29:00 Data Classification 00:28:00 Protecting Your Digital Information 00:45:00 Malware 00:17:00 Security from End-to-End 00:27:00 Piracy 00:16:00 Security Policies 00:17:00 Moving Forward 00:12:00 Mock Exam Mock Exam- Operation and Security Management Diploma 00:30:00 Final Exam Final Exam- Operation and Security Management Diploma 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Launch your educational expedition into the fascinating world of fungi with our 'Diploma in Mycology: Fungi Studies' course. This program offers a unique opportunity to delve into the mysterious and often overlooked kingdom of fungi. The course opens with an engaging introduction to mycology, laying a comprehensive foundation for understanding the diverse roles and characteristics of fungi. As you progress through the modules, you'll uncover the microscopic details of the fungal cell, appreciating the complexity and diversity that define this extraordinary kingdom. This course isn't just an academic pursuit; it's a captivating exploration into a realm that plays a crucial role in our ecosystem, medicine, and food industry. Continue your mycological journey with an in-depth study of fungal genetics and life cycles, unraveling the secrets behind their unique reproductive strategies and adaptability. The course further examines the ecological roles of fungi, from their symbiotic relationships in mutualism and decomposition to their impact as parasites and pathogens. In the later modules, you'll explore the intriguing world of edible mushrooms and the pioneering field of fungal biotechnology, revealing the potential of fungi in culinary arts and scientific innovation. This comprehensive program doesn't just equip you with theoretical knowledge; it prepares you to apply this understanding in various scientific, environmental, and industrial contexts. Learning Outcomes Acquire a foundational understanding of mycology and fungal biology. Explore the structure, function, and diversity of fungal cells. Understand fungal genetics, reproduction, and life cycles. Learn about the ecological roles of fungi in mutualism, decomposition, and as pathogens. Gain insights into the application of fungi in biotechnology and culinary arts . Why choose this Diploma in Mycology: Fungi Studies? 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 Diploma in Mycology: Fungi Studies for? Biology students and enthusiasts keen on specializing in mycology. Environmental scientists interested in fungal ecology and biodiversity. Professionals in biotechnology exploring fungal applications. Culinary experts and chefs specializing in mushroom-based cuisine. Amateur mycologists and nature enthusiasts. Career path Mycologist: £25,000 - £45,000 Environmental Consultant: £28,000 - £50,000 Biotechnologist: £30,000 - £55,000 Food Scientist: £27,000 - £48,000 Research Scientist (Biology): £29,000 - £50,000 Academic Lecturer (Biology): £33,000 - £55,000 Prerequisites This Diploma in Mycology: Fungi Studies does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in Mycology: Fungi Studies was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Mycology Introduction to Mycology 00:04:00 Module 02: The Fungal Cell and Diversity The Fungal Cell and Diversity 00:06:00 Module 03: Fungal Genetics and Life Cycles Fungal Genetics and Life Cycles 00:05:00 Module 04: Fungal Mutualism and Decomposition Fungal Mutualism and Decomposition 00:06:00 Module 05: Fungi as Parasites and Pathogens Fungi as Parasites and Pathogens 00:07:00 Module 06: Edible Mushrooms and Fungal Biotechnology Edible Mushrooms and Fungal Biotechnology 00:06:00

Learn how to improve your communications, boost your effectiveness -- and enhance your relationships! Includes Good Communication, Questioning & Listening, Face-to Face, Telephone, Writing and Fixing Communication.

Overview This comprehensive course on Finance Assets will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Finance Assets 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 Finance Assets. It is available to all students, of all academic backgrounds. Requirements Our Finance Assets 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 5 sections • 45 lectures • 02:02:00 total length •Finance and Free Market Economies: 00:02:00 •Principles of Finance - Theory (Part 1): 00:04:00 •Principles of Finance - Theory (Part 2): 00:02:00 •Discounted Cash Flow (DCF): 00:01:00 •Interest Rates, Bonds and Annuities: 00:03:00 •Bonds: 00:03:00 •Bond Duration: 00:02:00 •Capital Market Theory - Risk & Return: Efficient Market Hypothesis: 00:03:00 •Security Market Line - Risk & Return: 00:04:00 •Security Market Line: 00:02:00 •Capital Asset Pricing Model: 00:01:00 •Portfolio Theory: 00:03:00 •Corporate Finance: 00:03:00 •Optimal Capital Structure - Debt vs. Equity: 00:03:00 •Interest Tax Shield / Cost of Financial Distress: 00:04:00 •Financial Leverage and Weighted Average Cost of Capital (WACC): 00:02:00 •Degree of Financial Leverage (DFL): 00:05:00 •Arbitrage Pricing Theory (APT): 00:01:00 •Capital Budgeting Methods / Techniques: 00:02:00 •Internal Rate of Return Method (IRR): 00:03:00 •Understanding Financial Statements / Financial Ratio Analysis: 00:06:00 •Company Stock Valuations: 00:02:00 •Valuation (Enterprises / Companies / Project): 00:06:00 •DCF Method - Company Enterprise Value: 00:02:00 •Calculation of the Free Cash Flow: 00:02:00 •Common Stock Valuation: 00:02:00 •Derivatives - Options and Future Contracts: 00:04:00 •Future Contracts: 00:04:00 •Call Option: 00:05:00 •SWAPS: 00:02:00 •Options Valuation and Pricing - Numerical and Black-Scholes: 00:02:00 •Cost, Price, Rates and Dividends: 00:02:00 •Analysis for Trading Purposes - Technical Analysis: 00:03:00 •Types of Trends: 00:02:00 •Support and Resistance / Volume: 00:02:00 •Moving Averages: 00:03:00 •Moving Average Convergence: 00:01:00 •Fundamental vs. Technical Analysis: 00:02:00 •Financial Forecasting: 00:02:00 •Regression, Correlation and Covariance: 00:02:00 •Time Series Analysis- Congregation and Random Walk: 00:05:00 •Errors in Statistical Forecasts: 00:03:00 •Econometrics Tools - Seasonality, Smoothing and Errors: 00:02:00 •Smoothing Techniques: 00:01:00 •Qualitative Methods - Survey, Research and Delphi: 00:02:00

Overview This comprehensive course on Finance Principles will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Finance Principles 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 Finance Principles. It is available to all students, of all academic backgrounds. Requirements Our Finance Principles 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 6 sections • 46 lectures • 02:02:00 total length •Finance and Free Market Economies: 00:02:00 •Principles of Finance - Theory (Part 1): 00:04:00 •Principles of Finance - Theory (Part 2): 00:02:00 •Discounted Cash Flow (DCF): 00:01:00 •Interest Rates, Bonds and Annuities: 00:03:00 •Bonds: 00:03:00 •Bond Duration: 00:02:00 •Capital Market Theory - Risk & Return: Efficient Market Hypothesis: 00:03:00 •Security Market Line - Risk & Return: 00:04:00 •Security Market Line: 00:02:00 •Capital Asset Pricing Model: 00:01:00 •Portfolio Theory: 00:03:00 •Corporate Finance: 00:03:00 •Optimal Capital Structure - Debt vs. Equity: 00:03:00 •Interest Tax Shield / Cost of Financial Distress: 00:04:00 •Financial Leverage and Weighted Average Cost of Capital (WACC): 00:02:00 •Degree of Financial Leverage (DFL): 00:05:00 •Arbitrage Pricing Theory (APT): 00:01:00 •Capital Budgeting Methods / Techniques: 00:02:00 •Internal Rate of Return Method (IRR): 00:03:00 •Understanding Financial Statements / Financial Ratio Analysis: 00:06:00 •Company Stock Valuations: 00:02:00 •Valuation (Enterprises / Companies / Project): 00:06:00 •DCF Method - Company Enterprise Value: 00:02:00 •Calculation of the Free Cash Flow: 00:02:00 •Common Stock Valuation: 00:02:00 •Derivatives - Options and Future Contracts: 00:04:00 •Future Contracts: 00:04:00 •Call Option: 00:05:00 •SWAPS: 00:02:00 •Options Valuation and Pricing - Numerical and Black-Scholes: 00:02:00 •Cost, Price, Rates and Dividends: 00:02:00 •Analysis for Trading Purposes - Technical Analysis: 00:03:00 •Types of Trends: 00:02:00 •Support and Resistance / Volume: 00:02:00 •Moving Averages: 00:03:00 •Moving Average Convergence: 00:01:00 •Fundamental vs. Technical Analysis: 00:02:00 •Financial Forecasting: 00:02:00 •Regression, Correlation and Covariance: 00:02:00 •Time Series Analysis- Congregation and Random Walk: 00:05:00 •Errors in Statistical Forecasts: 00:03:00 •Econometrics Tools - Seasonality, Smoothing and Errors: 00:02:00 •Smoothing Techniques: 00:01:00 •Qualitative Methods - Survey, Research and Delphi: 00:02:00 •Assignment - Finance Principles: 00:00:00

Flash Sale Now On | 11-in-1 Bundle | CPD QS Certified | Lifetime Access | 110 CPD Points | Free Hardcopy + PDF Certificate - Worth 180 | Enrol Now

🌟 Master the Art of Crafting Concise Business Presentations: Enroll Now! 🌟   Are you tired of lengthy, dull presentations that fail to engage your audience? Do you want to captivate attention, convey your message effectively, and leave a lasting impact in every business meeting or pitch? Introducing 'Crafting Concise Business Presentations: A Quick Guide' - the ultimate online course designed to transform your presentation skills from ordinary to extraordinary in no time!   🚀 What You'll Learn: ✅ The secrets to condensing complex ideas into clear, compelling messages ✅ Techniques to structure your content for maximum impact in minimal time ✅ How to captivate your audience with engaging visuals and storytelling ✅ Tips for delivering confident, persuasive presentations that resonate ✅ Strategies to tailor your message for different stakeholders and scenarios ✅ Practical exercises and real-life examples to reinforce your learning   👩‍💼 Who Is This Course For? Business professionals seeking to enhance their presentation skills Entrepreneurs and startup founders aiming to pitch their ideas effectively Sales and marketing professionals wanting to create impactful presentations Anyone looking to communicate with clarity and conviction in a business setting   🎓 Why Choose This Course? ️ Comprehensive lessons designed for busy professionals ️ Learn at your own pace, anytime, and anywhere ️ Expert guidance from seasoned presenters and communication specialists ️ Practical techniques you can implement immediately in your work ️ Access to a supportive community for networking and feedback   💡 Elevate your presentations and make a lasting impression in the boardroom, during client meetings, or at conferences. Join 'Crafting Concise Business Presentations: A Quick Guide' and unlock the power of impactful communication today! Enroll now and take the first step toward becoming a confident, concise communicator who commands attention and drives results in every business scenario.   Don't miss this opportunity to transform the way you present your ideas. Enroll now and revolutionize your business communication skills! 🌟✨ Course Curriculum INTRODUCTION Introduction 00:00 5 MINUTE SHOWCASE Step #1 - Create an Attention Grabber 00:00 Step #2 - Share Your Elevator Speech 00:00 Step #3 and #4 - State Your Full Name and Company Name 00:00 Step #5 - Add a Short Story About Yourself 00:00 Step #6 - Deliver Valuable Content 00:00 Step #7 - Call to Action 00:00 Step #8 - End with a Memorable Statement 00:00 Review 00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel 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 Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. 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 office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel 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 Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. 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 office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 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