6290 Courses

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? 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 Sales Analysis in Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales Analysis in Excel 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 Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Welcome to the Course 00:03:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00

Course Overview The comprehensive Microsoft Excel 2016 has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Microsoft Excel 2016 today, and learn from the very best the industry has to offer! This best selling Microsoft Excel 2016 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Microsoft Excel 2016 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Microsoft Excel 2016 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Microsoft Excel 2016 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Microsoft Excel 2016, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Microsoft Excel 2016 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Microsoft Excel 2016 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

***24 Hour Limited Time Flash Sale*** Operations Management Advanced Diploma Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Operations Management Advanced Diploma Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Operations Management Advanced Diploma bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Operations Management Advanced Diploma Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Operations Management Advanced Diploma Career Bundle: Course 01: Operations Management Course 02: Project Management Training Course 03: Operations Management: Enterprise Resource Planning Course 04: Operations Management: Process Mapping & Supply Chain Course 05: Operations Management: Resource & Workout Layout Course 06: Supply Chain Management Course 07: Line Management Course 08: Risk Assessment & Management Course 09: Material Management Course 10: Certificate in Purchasing and Procurement Course 11: Essential Communication Skills for Professionals Course 12: Delegation Skills Course 13: Financial Analysis Course 14: Team Management Level 5 Course 15: Introduction to VAT Course 16: Diploma in Lean Process and Six Sigma Course 17: Business Development Course 18: Compliance and Risk Management Course Course 19: Financial Management Course 20: Tax Accounting Course 21: Raise Money and Valuation for Business Course 22: Decision-Making and Critical Thinking Course 23: Cost Control & Project Scheduling Course 24: Purchase Ledger Course 25: Making Budget & Forecast Course 26: Learn to Read, Analyse, and Understand Annual Reports Course 27: Improve your Financial Intelligence Course 28: Understanding Financial Statements and Analysis Course 29: Time Management Training - Online Course Course 30: Fundamentals of Quality Management With the Operations Management Advanced Diploma, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in the Operations Management Advanced Diploma today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of Operations Management Advanced Diploma Get a free student ID card with Operations Management Advanced Diploma Lifetime access to the Operations Management Advanced Diploma course materials Get instant access to this Operations Management Advanced Diploma course Learn Operations Management Advanced Diploma from anywhere in the world 24/7 tutor support with the Operations Management Advanced Diploma course. Start your learning journey straightaway with our Operations Management Advanced Diploma Training! The Operations Management Advanced Diploma premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Operations Management Advanced Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Operations Management Advanced Diploma course. After passing the Operations Management Advanced Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Operations Management Advanced Diploma course is ideal for: Students seeking mastery in Operations Management Advanced Diploma Professionals seeking to enhance Operations Management Advanced Diploma skills Individuals looking for an Operations Management Advanced Diploma-related career. Anyone passionate about Operations Management Advanced Diploma Requirements This Operations Management Advanced Diploma doesn't require prior experience and is suitable for diverse learners. Career path This Operations Management Advanced Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Level 2 Microsoft Office Essentials

Unlock the power of data analysis with our specialized Data Analysis in Excel Course. Learn essential techniques and tools to analyze data effectively using Microsoft Excel. Whether you're a beginner or looking to enhance your skills, this course provides hands-on training to help you interpret data, create insightful reports, and make informed business decisions. Enroll now to harness the full potential of Excel for data analysis and take your analytical skills to the next level.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Boost Your Career By Enrolling In This Water Chemistry Bundle To Overcome Your Challenges! Get a Free 1 QLS Endorsed Certificate Course with 10 Additional CPDQS Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Water Chemistry and boost your career, then take a step in the right direction with this industry-standard, comprehensive Water Chemistry bundle of courses, which are well organised. This Water Chemistry bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPDQS Accredited Certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress in your career with 12 months of unlimited access to this bundle of courses. If you enrol in this Water Chemistry package, you will not be charged any extra fees. This Water Chemistry Bundle Package includes: Diploma in Water Chemistry at QLS Level 5 10 Additional CPDQS Accredited Courses - Biochemistry Diploma in Basic Chemistry Level 3 Basic Biology Online Course Lab Analyst Training Agricultural Science Forestry Diploma in Water Treatment Infection Prevention and Immunisation Diploma in Creative Problem Solving Time Management Success becomes a lot simpler with this Water Chemistry bundle package, which allows you to monetise your skills. This bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium Water Chemistry bundle of courses helps your professional development by receiving an endorsement from the Quality Licence Scheme and CPDQS Accredited Certificate. You'll be able to practice in your own time and speed. The course materials for Water Chemistry are designed by experts, and you can access them. easily from any of your smartphones, laptops, PCs, tablets, etc. Master the skills. You need to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer This Water Chemistry Bundle? You will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPDQS Get a free student ID card! (£10 postal charges will be applicable for international delivery) Engaging voiceover and visual elements for your convenience. Complete the bundle at your own pace. Free assessments and immediate results. 24/7 tutor support. Course Curriculum: *** Water Chemistry *** Module 01: Introduction to Water Chemistry Water Physical Properties of Water and Aqueous Solutions Changes of State of Water Density and Viscosity Surface Tension Hydrogen Ion and pH Value Conductivity Aqueous Solutions Solubility of Solid Substances in Water Solubility of Liquids in Water Solubility of Gases in Water Turbidity Module 02: Concepts of Basic Chemistry Molecule Elements Compounds Mixture Phase Chemical Bonding Ionic Bond Covalent Bond Hydrogen Bond Metallic Bond Energy Reaction Module 03: Alkalinity of Water Alkalinity Contributors to Alkalinity Measuring Alkalinity Titration Method Alkalinity to Phenolphthalein Caustic Alkalinity Module 04: Hard Water and Basic Water Treatment Principles Occurrence of Hard Water Types of Water Hardness Calcium-Magnesium Hardness Carbonate-Noncarbonate Hardness Objections to Hard Water Scale Formation Effect on Soap Basic Principles of Water Treatment Lime Process Ion exchange process Distillers Module 05: Water Treatment and Purification Water Treatment Straining and Microstraining Straining Microstraining Sedimentation Filtration Flotation Clarification Ion Exchange Adsorption Extraction Membrane Separation Processes Degassing Thermal Degassing Chemical Degassing Module 06: Chemical Processes of Water Treatment Neutralisation Precipitation Oxidation and Reduction Oxidation Reduction Incineration Electrochemical Processes Radiation-Chemical Processes Module 07: Inorganic Chemicals Inorganic Substances in Water IOC Sample Collection Chain of Custody Procedures Chemical Analysis of Major and Minor Ions Module 08: Volatile and Synthetic Organic Compounds Definition of VOC Specific Components Paints and Coatings Chlorofluorocarbons and Chlorocarbons Benzene Methylene Chloride Perchloroethylene MTBE Formaldehyde Health Risks Reducing Exposure to VOC's Chemical Fingerprinting of VOC Definition of SOC SOC's Health Effects Treatment of SOC's Module 09: Metalloid Section Metalloid Physical and Chemical Properties Near Metalloids Categorisation and Periodic Table Territory Other Metalloids Best Practices for Effective Communication about Chronic Contaminants Module 10: Metals and Heavy Metal Section Metal Structure and Bonding Properties of Metal Categories of Metal Extraction of Metal Environmental Impact of Metals Heavy Metal Effects of Heavy Metal Antimony Cadmium Lead Mercury Pollution and Pollution Control Toxic Metals Decontamination Toxic Heavy Metals Trace Elements with Toxicity Heavy Metals in Water Treating Heavy Metal Contamination in Water Module 11: Laboratory Safety Laboratory Hazards Safety Awareness Protective Equipment Laboratory Safety Equipment First Aid and Emergency Procedures Chemical Safety Biological Hazards Hazard Recognition and Control Electrical Hazards Fire Hazards General Housekeeping Rules Module 12: Chemical Hygiene Plan Organisation and Content Required CHP Elements Worker Training Must Include Medical Exams and Consultation How is the Water Chemistry Bundle Assessment Process? We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analyzed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. Show off Your New Skills With a Certification of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with completely free of charge in this package. Certification Accredited by CPD. Upon finishing the course, you will receive an accredited certification that is recognised all over the UK and also internationally. The pricing schemes are - 10 GBP for Digital Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The bundle aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPD Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Water Chemistry and Water Treatment - CPD Certified Hard copy certificate - Included

Secure workplace health with our COSHH Training. Master regulatory compliance, identify hazardous substances, conduct risk assessments, and implement safety measures. This course is essential for anyone managing or working with hazardous materials.

Boost Your Career By Enrolling In This Real Estate Investor Bundle To Overcome Your Challenges! Get Free 1 QLS Endorsed Certificate Course with 10 Additional CPD Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Real Estate Investor and boost yourself for your desired career, then take a step in the right direction with this industry-standard, comprehensive Real Estate Investor course designed by professionals. This bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPD Accredited Certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress in your career with 12 months of unlimited access to this bundle of courses. If you enrol in this package, you will not be charged any extra fees. This Bundle Package includes: Course 01: Diploma in Real Estate Investor Training at QLS Level 5 10 Additional CPD Accredited Premium Courses - Course 01: Conveyancing Diploma Course 02: Mortgage Adviser Course Course 03: Social Housing and Tenant Support Course 04: Portfolio Building for Property Course 05: Understanding Wills and Probate Laws Course 06: Property Law and Taxation Course 07: Business Law Course 08: Sales and Marketing Coordinator Course 09: Capital Budgeting & Investment Decision Rules Course 10: Document Control Success becomes a lot simpler with this bundle package, which allows you to monetise your skills. This bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer This Bundle Course? You will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPDQS Get a free student ID card! (£10 postal charges will be applicable for international delivery) Engaging voiceover and visual elements for your convenience. Complete the bundle at your own pace. Free assessments and immediate results. 24/7 tutor support. *** Course Curriculum: *** Module 01: Property Development Module 02: Different Types of Property Module 03: Land Law Principles- Rights and Interests Module 04: Ownership, Co-ownership and Possession of the Property Module 05: Lease Bailment, License, Mortgage and Insurance Related Law Module 06: Real Estate Investment Module 07: Strategies for a Real Estate Investor Module 08: Marketing Your Property Module 09: Introduction to Property Management Module 10: The Property Management Process Module 11: The Role and Responsibilities of a Property Manager Module 12: Listing Properties and Marketing What is the Real Estate Investor Bundle Assessment Process? We offer an integrated assessment framework to make the process of evaluating learners easier. You have to complete the assignment questions given at the end of the Real Estate Investor course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Real Estate Investor Training at QLS Level 5 exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Real Estate Investorpackage training is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! This bundle is also ideal for those who want to learn more about this subject in-depth and stay up to date with the latest details. Enrollment in this bundle is open to everybody. You can access the Real Estate Investor bundle materials from anywhere in the world; there are no restrictions. You should enrol in this bundle if you: Wish to gain a better understanding of Real Estate Investor. Already working in this field and want to learn more about Real Estate Investor. Is a student pursuing a relevant field of study? Looking for a job in the Real Estate industry. Requirements You will not need any prior background or expertise. All you need to take this Bundle is - A smart device. A secure internet connection. Being over the age of 16. And a strong drive for learning and literacy. Certificates Diploma in Real Estate Investor Training at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certification of Completion After successfully completing the Diploma in Real Estate Investor Training at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, completely free of charge. For Additional the Quality Licence Scheme Endorsed Certificate you have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 Certificate Accredited by CPD Upon finishing the Real Estate Investor Bundle, you need to order to receive a Certificate Accredited by CPD that is recognised all over the UK and also internationally. The pricing schemes are - Printed Hardcopy Certificate £29 Inside the UK £39 Outside the UK (International Delivery) Certificate Accredited by CPD Digital certificate - £10 Upon passing the Real Estate Investor Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD.

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? 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 Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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 Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease.  The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Microsoft Excel Masterclass course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job.