22473 Management courses in Huntingdon delivered On Demand

"Embark on an exploration of the intricate realm of consumer psychology, decoding the intricate links between cognition, emotional responses, and their profound impact on consumer behavior. This comprehensive course delves into pivotal theories and models shaping consumer behavior, including the Theory of Buyer Behavior, Theory of Reasoned Action, Theory of Planned Behavior, Howarth Sheth Model, Sociological Model, Family Decision-Making Model, Engel Blackwell Kollat Model, and Webster and Wind Model. Upon completion, you'll master: Understand the role of Psychology in Consumer behaviour including the effects of cognition and emotions on decision making. Understand the nature and application of behavioural theories in relation to consumer decision-making. Understand and apply the recommendation of different models used in consumer behavior and decision-making. This course aims to explore the key concepts and theories of consumer psychology, cognition, and emotional reactions, as well as the various models and frameworks that help explain buyer behaviour, including the Howarth Sheth Model, Sociological Model, Family Decision Making Model, Engel Blackwell Kollat Model, and Webster and Wind Model. Students will gain a comprehensive understanding of how these theories and models apply to real-world consumer behaviour and decision-making processes. This course aims to explore the complex world of consumer psychology, including cognition and emotional reactions, and how they affect buyer behaviour. Additionally, the course will cover the major theories and models of consumer behaviour, such as the Theory of Buyer Behaviour, Theory of Reasoned Action, Theory of Planned Behavior, Howarth Sheth Model, Sociological Model, Family Decision Making Model, Engel Blackwell Kollat Model, and Webster and Wind Model. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Consumer Behavior Models And Theories Self-paced pre-recorded learning content on this topic. Consumer Behaviour Models and Theories Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Consumer Behaviour Analyst Market Research Manager Behavioural Economist Consumer Insights Consultant Decision Making Strategist Consumer Psychology Researcher Consumer Insights Analyst Behavioral Scientist Market Intelligence Specialist Customer Experience Designer Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

The series CompTIA A+ 900 Certification Advanced Diploma provides an extensive lesson about CompTIA A+ 900 Certification. A+ Certification is one of the leading certificates in the computer industry. It certifies the competency of PC Service Specialists. Sponsored by CompTIA - the Computing Technology Industry Association, and tests, the course is administered by Pearson VUE. The course includes more than 50 lessons related to the Computer industry. The course starts by describing firmware and BIOS configuration options. After that, the course will teach you about the motherboard basics including motherboard sizes, form factors, and AMD CPU socket types. The course also includes topics such as Expansion slots, RAM types and features, install and configure PC expansion cards, install and configure storage device, CPU's and cooling methods and PC connection interfaces. The course will also focus on power supplies, PC connectors, printing technologies, networking tools, etc. In short, the course provides all the necessary information about computer hardware and operating system. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then CompTIA A+ 900 Certification Advanced Diploma is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the accredited qualification. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £30,000. The sky really is the limit. Course Curriculum Configuring BIOS Firmware 00:07:00 BIOS Configuration Options 00:25:00 Motherboards Motherboard Sizes Form Factors 00:14:00 The Motherboard 00:12:00 AMD CPU Socket Types 00:11:00 Expansion Slots Expansion Cards 00:13:00 Bus Speeds 00:28:00 RAM Types and Features Memory 00:06:00 Types of RAM 00:07:00 Install and Configure PC Expansion Cards Ports 00:11:00 SCSI Connections 00:14:00 Audio Video Connections 00:26:00 Install and Configure Storage Devices Storage Devices 00:17:00 Hard Drives 00:17:00 Media Capacity 00:21:00 CPU's and Cooling Methods CPU Types and Characteristics 00:14:00 PC Connection Interfaces Physical Connections USB 00:11:00 Physical Connections VGA 00:11:00 Wireless Connections Bluetooth 00:06:00 Power Supplies Power Supply Specifications 00:16:00 Custom Computer Specifications What is a Standard Client 00:13:00 Audio Video Editing Workstations 00:08:00 Installing Displays Display Device Types 00:20:00 Backlighting 00:12:00 PC Connectors DVI to HDMI 00:13:00 Installing Peripheral Standard Input Device Types 00:16:00 Expansion Card Types 00:11:00 Multimedia Devices 00:11:00 Installing Multifunction Devices and SOHO Networks SOHO Networks 00:17:00 WPS 00:16:00 Encryption 00:14:00 Printer Technologies Printers 00:02:00 Printer Technologies Topic B Inkjet Printers 00:13:00 Printer Maintenance Technical Printer Components 00:09:00 Local and Network-Based Printers 00:22:00 Networking Network Interface Card Characteristics 00:20:00 Fiber Optic Cables 00:14:00 Properties and Characteristics of TCP/IP TCP IP 00:14:00 IP Address Classes 00:14:00 Addressing Schemes 00:17:00 TCP vs. UDP Ports 00:09:00 LDAP 00:04:00 Wi-Fi Networking Standards and Encryption Types Standards 00:03:00 Install and Configure SOHO Wireless/Wired Router Setting up your Router 00:10:00 Define Appropriate NAT Policies 00:16:00 Architecture and Internet Connection Types LANs 00:08:00 Network Topologies 00:11:00 ISPs 00:06:00 Networking Tools Cable Testers 00:13:00 Laptop Hardware Components Laptops 00:09:00 Laptop Expansion Options 00:10:00 Auto-Switching and Fixed Input Power Supplies 00:09:00 Mobile Devices What is Mobile Technology 00:09:00 Mobile Device Features 00:09:00 Bluetooth Configuration Method 00:08:00 Mobile Device Ports and Accessories Mobile Device Connection Types 00:10:00 Troubleshooting Mobile Devices 00:11:00 Troubleshooting Theory Troubleshooting Theory 00:16:00 Boot to Incorrect Device 00:16:00 PC Indicator Lights 00:10:00 Repair vs. Replace 00:10:00 Troubleshooting RAID Arrays and Hard Drives Drive and Array Troubleshooting Tools 00:06:00 Common RAID Array Issues 00:17:00 Troubleshooting Video Common Video and Display Issues 00:01:00 Troubleshooting Network Issues Common Network Issues 00:12:00 Troubleshooting Printers Common Printer Troubleshooting Tools 00:14:00 Windows Operating Systems Microsoft Windows 00:12:00 Microsoft Windows Features 00:17:00 Other Operating Systems 01:00:00 Installation Types 00:14:00 Customizing System Options 00:19:00 Command Line Tools The Command Prompt 00:12:00 Microsoft Operating System Features and Tools Administrative Tools 00:41:00 Task Manager 00:28:00 Memory Diagnostic Tool 00:46:00 Control Panel Utilities The Control Panel 00:11:00 Internet Options 00:10:00 Types of User Accounts 00:11:00 Computer My Computer 00:13:00 Permissions 00:31:00 System 00:10:00 Windows Networking on Client Desktops Workgroups 00:20:00 Network Connection Types 00:18:00 Preventative Maintenance Data Backup and Restoration 00:11:00 Scheduling Tasks 00:26:00 Features and Functionality of the Mac OS and Linux Operating Systems Patch Management in Mac OS X and Linux 00:09:00 Screen Sharing 00:06:00 Mac OS Multitouch Gestures - Touchscreen 00:09:00 Client Side Virtualization What is Virtualization 00:08:00 Virtual Desktop Infrastructure 00:12:00 Cloud-based Concepts SaaS (Software as Service) 00:09:00 Network Host Properties Server Roles 00:12:00 Mobile Operating Systems Open Source Software 00:03:00 Mobile Device Network and E-mail Mobile Device Hotspot 00:10:00 Security Malware 00:09:00 Social Engineering 00:13:00 Prevention Methods Physical Security 00:14:00 Hard Drive Sanitation 00:14:00 User Education 00:26:00 Windows Security Settings Users and Groups 00:11:00 Security Best Practices Password Best Practices 00:04:00 Securing Mobile Devices Locks 00:07:00 Troubleshooting Common PC Tools Operating System Troubleshooting Tools 00:12:00 Application Errors 00:16:00 Common Network Issues 00:12:00 Common Security Issues 00:10:00 Common PC Security Issues Browser Issues 00:06:00 Common Mobile Operating Systems Troubleshooting Dim Display 00:09:00 No Sound from Speakers 00:07:00 Common Safety Practices Static Electricity 00:14:00 Electrical Hazards 00:12:00 General Power Issues 00:10:00 Hazardous Material Disposal Procedures 00:07:00 Maintenance Tools and Techniques Professional Conduct 00:11:00 Types of Hardware Toolkits 00:11:00 Hard Drive Self-Tests 00:05:00 Computer Component Maintenance Techniques 00:10:00 Privacy and Licensing Concepts Incident Response 00:08:00 Proper Communication and Professionalism 00:07:00 Set Expectations 00:06:00 Mock Exam Mock Exam - CompTIA A+ 900 Certification Advanced Diploma 00:20:00 Final Exam Final Exam - CompTIA A+ 900 Certification Advanced Diploma 00:20:00

Learn the fundamentals of day trading, including strategies, risk management, and market analysis. Develop skills to navigate volatile markets and make informed decisions in real-time.

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner 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 Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner 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 • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions 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 Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions 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 • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Overview This comprehensive course on Excel Pivot Tables, Pivot Charts, Slicers, and Timelines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 Excel Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 • 15 lectures • 01:21:00 total length •Getting started with your Pivot Table: 00:04:00 •Drill Down: 00:01:00 •Managing the Field List: 00:02:00 •Changing the Calculation type with Value Field Settings: 00:06:00 •Growing your Pivot Table with Multiple Fields: 00:04:00 •Formatting the Pivot Table: 00:05:00 •Sorting and Filtering the Pivot Table: 00:03:00 •Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00 •Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00 •Refreshing the Pivot Data with new data: 00:03:00 •Adding your own calculations into the Pivot Table: 00:03:00 •The power of the Filter Section in the Pivot Table: 00:04:00 •PowerQuery: 00:12:00 •PowerPivot: 00:21:00 •Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00

Overview This comprehensive course on Diploma in Excel Vlookup Xlookup Match and Index will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Diploma in Excel Vlookup Xlookup Match and Index 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 Diploma in Excel Vlookup Xlookup Match and Index. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Excel Vlookup Xlookup Match and Index 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 • 8 lectures • 00:46:00 total length •1.1 Excel vlookup: 00:08:00 •1.2 Excel xlookup: 00:06:00 •1.3 Excel vlookup: 00:08:00 •1.4 Excel vlookup: 00:03:00 •1.5 Excel vlookup: 00:11:00 •1.6 Excel vlookup: 00:05:00 •1.7 Excel vlookup: 00:05:00 •Assignment - Diploma in Excel Vlookup Xlookup Match and Index: 00:00:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Overview This comprehensive course on Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions 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 Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions 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 • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00