Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified HR Management and Recruitment Training bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The HR Management and Recruitment Training related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive HR Management and Recruitment Training bundle will help you build a solid foundation to become a proficient worker in the sector. This HR Management and Recruitment Training Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:HR Management Course 02:UK Employment Law Course 03:Interview and Recruitment Course 04:Recruitment and Termination Course 05:Safer Recruitment Training Course 06:Employee Performance Management Course 07:Cross-Cultural Awareness Training Course 08:Document Control Course 09:Information Management Course 10:Microsoft Word, PowerPoint & Outlook Course 11:Corporate Paralegal Course 12:Admin, Secretarial & PA Course 13:Stakeholder Management Course 14:Contract Analyst Course 15:Management Skills: A New Manager Course 16:Decision Making and Critical Thinking Course 17:Presentation Skills Course 18:Equality, Diversity and Discrimination Course 19:Workplace Confidentiality Course 20:General Data Protection Regulation (GDPR) Awareness Course 21:Workplace Productivity Course 22:Leadership and People Management Diploma Course 23:Change Management Course 24:Team Management Course 25:Employee Relations Course 26:Corporate Governance Course 27:Online Meeting and Virtual Conference Course 28:Facilities Management Course 29:Motivation Course 30:Life Coaching and Career Counselling 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made HR Management and Recruitment Training bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This HR Management and Recruitment Training Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the HR Management and Recruitment Training bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in HR Management and Recruitment Training Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.
Uncover the secrets behind financial foresight in our captivating Actuarial Science course. Navigate through the intricate world of financial risk assessment and valuation with a curriculum meticulously designed to empower you with the skills demanded in today's dynamic financial landscape. Delve into the realm of cash flow valuation and deterministic models, gaining insights into the backbone of financial decision-making. Explore life tables, annuities, and insurance, mastering the stochastic approach to contingencies. Confront challenges posed by taxation and inflation, unravel probabilistic models, and refine individual risk assessment. Embrace the principles of premium calculation and delve into the intricacies of multiple decrement theory. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In this riveting exploration, discover the art of individual risk models and the principles of premium calculation. Craft a profound understanding of multiple decrement theory, equipping yourself with indispensable knowledge for navigating the complexities of financial landscapes. Elevate your financial acumen with this comprehensive exploration of actuarial science, where each module unravels a layer of strategic financial insight. Course Curriculum Module 1: Introduction to Actuary Module 2: Actuaries and Their Environment Module 3: The Valuation of Cash Flows Module 4: The Basic Deterministic Model Module 5: The Life Table Module 6: Life Annuities Module 7: Life Insurance Module 8: The Stochastic Life Contingencies Model Module 9: The Stochastic Approach to Insurance and Annuities Module 10: Taxation and Inflation Module 11: Probabilistic Models, Uncertain Payment and Profit Testing Module 12: Individual Risk Models Module 13: Principles of Premium Calculation Module 14: Multiple Decrement Theory Learning Outcomes: Analyze and value cash flows with precision for strategic decision-making. Master the stochastic life contingencies model for advanced risk assessment. Apply principles of premium calculation to craft financially sound strategies. Develop a deep understanding of taxation and inflation in financial scenarios. Navigate uncertainties with individual risk models for robust financial planning. Acquire expertise in multiple decrement theory for comprehensive risk management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Financial Analysts seeking advanced risk assessment skills. Actuarial Enthusiasts eager to delve into stochastic life contingencies models. Strategic Planners aiming to apply premium calculation principles effectively. Financial Managers wanting to master taxation and inflation dynamics. Risk Management Professionals looking to enhance individual risk modeling skills. Career path Financial Analyst Risk Manager Actuarial Consultant Investment Strategist Insurance Analyst Pension Fund Manager Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Get ready for an exceptional online learning experience with the Inventory Management bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. Imagine the opportunities that await you as a certified expert in Inventory Management! With this credential, top companies across industries will seek you for you, including retail, manufacturing, logistics, and more. Open doors to lucrative positions such as Inventory Manager, Supply Chain Analyst, or Operations Director, where you'll be entrusted with the critical responsibility of optimising inventory levels, reducing costs, and ensuring seamless operations. As part of this package, you will receive complimentary PDF certificates for all courses in this Inventory Management bundle at no extra cost. Equip yourself with the Inventory Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Inventory Management Bundle Comprises the Following CPD Accredited Courses: Inventory Management Product Management Certificate in Purchasing and Procurement Supply Chain Management Operations Management: Process Mapping & Supply Chain Merchandising Import/Export Logistics Management SAP Controlling (CO) - Product Costing S4HANA Commercial law Warehouse Operative Warehouse Safety Manager Diploma in Lean Process and Six Sigma Retail Psychology Visual Merchandising Diploma Compliance and Risk Management Diploma Career Development Plan Fundamentals Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Master efficient inventory management techniques for increased profitability. Develop strategic product management expertise to drive revenue growth. Understand industry trends and best practices through the Inventory Management Bundle. Acquire skills in purchasing and procurement for cost-effective sourcing Enhance personal and professional growth with the Inventory Management Bundle. Build a strong knowledge base in your chosen course via thisBundle. Develop expertise in SAP Controlling, commercial law, and warehouse operations. With the Inventory Management package, validate your learning with a CPD certificate. Master the art of inventory management, optimising levels to reduce costs and improve operational efficiency. Develop strategic product management skills, enabling you to strategically develop, launch, and manage products that meet market demands and drive business growth. Acquire expertise in purchasing and procurement, negotiating deals and implementing cost-saving measures. Embrace the future of learning with Inventory Management, a rich anthology of 20 diverse courses. Each course in the Inventory Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This bundle will take you on a unique and enriching educational journey. Successfully navigate the challenges of import/export and logistics management, ensuring seamless movement of goods across international borders and maximising opportunities in the global marketplace. Specialise in key aspects of inventory management, including SAP Controlling (CO) - Product Costing S4HANA, to handle product costs and enhance financial performance proficiently. Acquire a solid understanding of commercial law to ensure compliance and mitigate legal risks. Enrol in our Inventory Management bundle today and unlock the keys to efficient supply chain operations. Take the first step towards a successful career in inventory management and supply chain excellence. Don't miss out on this opportunity - join us now and gain the knowledge and skills needed to thrive in this dynamic field. Let's embark on this transformative journey together! CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Inventory Management bundle is perfect for: Lifelong learners are looking to expand their knowledge and skills. Professionals are seeking to enhance their careers with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Our Inventory Management bundle will prepare you for a range of careers, including: Inventory Manager Supply Chain Analyst Purchasing Specialist Logistics Coordinator Operations Manager Supply Chain Consultant Professionals in these roles can expect a combined salary range of £30,000 to £70,000 per year in the United Kingdom. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.
Level 4- Two Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access
Overview Every day, millions and billions of important data are uploaded and updated. This massive surge of data requires skilled professionals who can ensure its safety and security. This is where our GDPR Training UK comes in. Our premium course is designed to educate current and future data professionals on data protection and help them ensure the utmost protection. The course will help you understand the core principles and significance of GDPR. From the comprehensive modules, you will learn about the legal foundation and governance of GDPR. In addition, you will grasp the techniques for protecting data and international transactions. You will also get an in-depth understanding of national security. After the completion of the course, you will receive a certificate of achievement. This certificate will demonstrate your expertise in this area and help you seek your dream career. Enrol now! Course Preview Learning Outcomes Understand the principles of the UK GDPR Familiarise yourself with the legal foundation of GDPR Deepen yourself with the governance of GDPR Know the process of protecting personal data Gain in-depth knowledge of international transactions and national security Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? GDPR Knowledge Data Protection Who Should Take this GDPR Training UK? Whether you're an existing practitioner or an aspiring professional, this course is an ideal opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This GDPR Training UK course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Pathâ This exclusive GDPR Training UK course will equip you with effective skills and abilities and help you explore career paths such as Data Privacy Officer Cybersecurity Analyst Data Security Analyst IT Officer Module 01:Exemptions to GDPR Exemptions to GDPR 00:12:00 Module 02:International Transactions and National Security International Transactions and National Security 00:14:00 Module 03:Protecting Personal Data Protecting Personal Data 00:13:00 Module 04:The Governance of GDPR The Governance of GDPR 00:12:00 Module 05:The Legal Foundations of GDPR The Legal Foundations of GDPR 00:12:00 Module 06:The Purpose and Principles of the UK GDPR The Purpose and Principles of the UK GDPR 00:11:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Level 3 & 4 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access
Are you looking for a career in finance? Do you want to learn the skills you need to succeed in this exciting field? If so, then the Finance Assistant / Accounts Assistant - Career Mentoring & Support with Job Opportunity program is perfect for you! Enrol today and earn upto •90,000 with the help of our guidance. We will help you until you find a job, so you won't have to worry about a thing. Just gain knowledge and learn skills, getting you a job is our duty. You will receive career mentoring and support from our experienced team of professionals. We will help you develop your resume, network with potential employers, and land your dream job! We are committed to being with you every step of the way, from your job search to your ultimate success. Why Choose Us Our mission is simple: to be your trusted partner and assist you every step of the way until you land the job of your dreams. Here's what makes our Finance / Accounts Assistant Program stand out from the crowd: Personalised Job Search Assistance: We're in this together! Our dedicated team will work tirelessly to support your entire job searching process. From crafting a standout resume to submitting it to top companies, we'll ensure you have a compelling application that gets noticed. Expertly Crafted CV: Your resume is your ticket to the interview room. Our professional resume writers will create a customised CV highlighting your unique skills and experiences. This will maximise your chances of standing out among the competition. Strategic Placement: We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. One-On-One Consultation Sessions with Industry Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the finance & accounts field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and finesse. Comprehensive Skill Development: Our program is designed to equip you with the most sought-after skills in Finance & Accounts. From mastering cutting-edge tools to honing your skills, we'll ensure you have the knowledge and expertise to excel in any finance environment. Ongoing Support: We understand that the journey to landing your dream job doesn't end with placement. That's why our commitment to your success extends well beyond your initial training. Our support team will be available to answer your questions, provide guidance, and assist you as you progress in your career. Here are the 25 courses we will provide once you enrol in the program: Accounting and Finance Business Finance Corporate Finance Financial Analysis Methods Xero Accounting and Bookkeeping Online Capital Budgeting & Investment Decision Rules Making Budget & Forecast Cashflow Management and Forecasting Finance: Financial Risk Management Sage 50 Accounts Training Quickbooks Online Accounting and Bookkeeping Diploma Tax Accounting Cost Control Process and Management Charity Accounting Course Pension UK Investment Banking Operations Professional Operations Management Financial Planning Debt Management, Assessment, Financing & Counselling Credit Control and Compliance Training Improving Your Credit Score: Financial Health Strategies FinTech Forex Trading Essentials of UK VAT These courses will help you to develop your knowledge and skills to become a successful Finance / Accounts Assistant. The Program is completed in 5 easy steps: Step 1 - Enrol in the program and start learning from the courses we provide After you enrol in the Finance Assistant / Accounts Assistant Program, you will get lifetime access to 25 premium courses related to Finance and Accounts. These courses will teach you the knowledge and skills required to become a successful Finance / Accounts Assistant. Our customer service team will help you and keep in contact with you every step of the way. Step 2 - Complete your courses and get certifications After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks for the first course and 80% for the rest relevant courses. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 3 - Get a consultation session from a professional Take your Finance and accounts skills to new heights with a one-on-one consultation session led by a seasoned professional. Gain invaluable insights, expert tips, and tailored advice that will propel your career forward. Step 4 - Complete the CV and attend the interview Once you've successfully obtained the certifications, our team of professionals will build you a compelling CV and LinkedIn profile. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Kickstart your Finance career with a starting salary ranging from •25,000 to •40,000 annually. Step into the industry with the assurance of a promising future. Step 5 - We will not leave you until you find a job Our commitment to your success goes above and beyond. We won't stop until you land that dream job. With personalised support, expert guidance, and unwavering dedication, we'll be by your side until you secure the perfect opportunity. Your job search becomes our mission, ensuring you have the best chance at a successful career in Finance / Accounts. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Finance Assistant / Accounts Assistant program is ideal for: Recent finance or accounting graduates seeking practical guidance and support in their career journey. Professionals looking to transition into the finance or accounting field and in need of targeted mentoring and job placement assistance. Individuals who want to enhance their finance and accounting skills and improve their job prospects in the industry. Career changers who aspire to become finance or accounts assistants and require comprehensive training and guidance. Anyone who wants personalised support in building a strong CV and navigating the competitive job market in the finance and accounting sector. Requirements No experience required. Just enrol & start learning. Career path After successfully completing this program, you can explore these career pathways: Finance Assistant: •25,000 - •40,000 per year. Accounts Assistant: •25,000 - •45,000 per year. Assistant Accountant: •30,000 - •45,000 per year. Senior Finance Assistant: •35,000 - •50,000 per year. Assistant Financial Analyst: •40,000 - •55,000 per year. Accounting Supervisor/Team Leader: •45,000 - •65,000 Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included Student ID Card Digital certificate - Included
Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20: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