4798 Operations courses

Are you ready to embark on an enlightening journey of wisdom with the ISO 9001: Quality Management Systems bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Quality Control Assistant with ISO 9001: Quality Management Systems. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Quality Assurance Course 02: Fundamentals of Quality Management Course 03: Quality Management and Strategic Training - ISO 9001 Course 04: Quality Tools and Methods Management Course 05: Diploma in Lean Process and Six Sigma Course 06: Process Improvement: How to Reduce Waste Course 07: Commercial Law Course 08: Facilities Management Diploma Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Quality Control Assistant with ISO 9001: Quality Management Systems bundle illuminate your path to wisdom. The Quality Control Assistant with ISO 9001: Quality Management Systems bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Quality Control Assistant with ISO 9001: Quality Management Systems package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the ISO 9001: Quality Management Systems bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Quality Control Assistant with ISO 9001: Quality Management Systems community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the ISO 9001: Quality Management Systems bundle. Establish robust bases across each course nestled within the ISO 9001: Quality Management Systems bundle. Decipher intricate concepts through the articulate content of the ISO 9001: Quality Management Systems bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the ISO 9001: Quality Management Systems bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The ISO 9001: Quality Management Systems bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the ISO 9001: Quality Management Systems bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The ISO 9001: Quality Management Systems bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the ISO 9001: Quality Management Systems bundle allows learners to make meaningful contributions to their chosen fields. Embark on the ISO 9001: Quality Management Systems journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the ISO 9001: Quality Management Systems bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the ISO 9001: Quality Management Systems bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99

Recruitment Consultant Diploma Level 5 Course Overview The Recruitment Consultant Diploma Level 5 provides learners with in-depth knowledge and expertise required to succeed in the recruitment industry. This course covers a broad range of topics, including recruitment legislation, sales strategies, candidate management, and client acquisition. By the end of the course, learners will gain a comprehensive understanding of the recruitment process and how to effectively manage both candidates and clients. The course is designed to equip individuals with the essential skills needed for success in recruitment consultancy, offering valuable insights into industry practices, strategies, and key performance indicators. Course Description This diploma course offers a detailed exploration of the recruitment industry, starting with an introduction to its significance and the various legislative frameworks that impact recruitment practices in the UK. Learners will delve into strategies for candidate attraction, interview processes, and client acquisition. The modules are designed to help individuals develop critical skills in sales, client management, and the recruitment process itself. Learners will understand how to set key performance indicators, effectively manage candidates, and formulate strategies for success in the recruitment sector. This course is structured to provide comprehensive learning, ensuring that students are well-prepared for careers in recruitment consultancy. Recruitment Consultant Diploma Level 5 Curriculum: Module 01: Introduction to Recruitment: Importance and Implications Module 02: An Overview of the Recruitment Industry Module 03: The UK Recruitment Legislation Module 04: Sales and Selling in the Recruitment Industry Module 05: The Recruitment Process Module 06: Key Performance Indicators for the Recruitment Industry Module 07: Candidate Attraction for Recruitment Module 08: Candidate Management Module 09: Candidate Interview Processes Module 10: Client Acquisition Module 11: Client Strategy in the Recruitment Sector Module 12: Client Management Module 13: Steps to Starting and Running a Successful Recruiting Service (See full curriculum) Who is this course for? Individuals seeking to enter the recruitment industry. Professionals aiming to advance their recruitment career. Beginners with an interest in recruitment consultancy. Those looking to develop a deeper understanding of recruitment processes. Career Path Recruitment Consultant Talent Acquisition Specialist Recruitment Agency Manager Client Relationship Manager in Recruitment Recruitment Operations Specialist

Course Overview This Leadership and Management course provides a comprehensive foundation for individuals aiming to thrive in supervisory or managerial positions across diverse sectors. Designed to enhance your ability to lead with confidence and integrity, the course explores essential leadership theories, management practices, and strategic planning methods. Learners will gain valuable insight into how to cultivate high-performing teams, manage organisational change, and apply ethical leadership principles. With a strong emphasis on effective communication, conflict resolution, and time management, this course ensures a well-rounded understanding of what it takes to guide teams, influence stakeholders, and achieve long-term business objectives. Whether you are aspiring to step into a leadership role or looking to refine your current management approach, this course equips you with the knowledge and awareness needed to lead with purpose and efficiency. Course Description This course delves into the key components of effective leadership and structured management. Covering everything from leadership theories and performance enhancement to organisational skills and emotional intelligence, it is structured to build your capability in motivating teams, handling workplace dynamics, and aligning business goals with people development. Topics such as negotiation, talent management, succession planning, and risk management are explored in depth, supported by modules on communication and corporate responsibility. You will also examine strategies for managing stress, driving change, and responding to office politics constructively. Through a structured and professionally developed curriculum, learners will develop a nuanced understanding of leadership principles and the core responsibilities that accompany managerial roles. This course encourages thoughtful, ethical, and informed leadership, enabling you to foster positive work environments and drive impactful results within any organisation. Course Modules: Module 01: Introduction to The Course Module 02: Understanding Management and Leadership Module 03: Leadership Theories Module 04: Improving Management and Leadership Performance Module 05: High Performance Teams Module 06: Motivating Employees Module 07: Organisational Skills Module 08: Talent Management Module 09: Succession Planning Module 10: Business Process Management Module 11: Communication Skills Module 12: Negotiation Techniques Module 13: Managing Meetings and Giving Feedback Module 14: Managing Change Module 15: Time Management Module 16: Stress Management Module 17: Emotional Intelligence in Leadership Module 18: Managing Conflict Module 19: Dealing with Office Politics Module 20: Risk Management Module 21: Corporate Responsibility and Ethics (See full curriculum) Who is this course for? Individuals seeking to build leadership confidence and strategic thinking. Professionals aiming to transition into management or senior roles. Beginners with an interest in leadership principles and organisational development. Team leads, supervisors, and aspiring managers across industries. Career Path Team Leader Operations Manager Human Resources Officer Department Head Business Development Manager Strategy Consultant Corporate Trainer Project Coordinator Office Manager Organisational Development Advisor

Course Overview The Business Leadership course is designed to empower aspiring and existing leaders with the core competencies required to thrive in dynamic business environments. Through a structured and comprehensive learning journey, this course equips learners with strategic insights into management functions, leadership styles, organisational development, and performance enhancement. It explores key areas such as emotional intelligence, talent management, and ethical decision-making, while also covering communication, conflict resolution, and risk management. Whether you are aiming to lead teams, shape organisational direction, or drive change, this course delivers a strong foundation in leadership theory and practice. Learners will benefit from a thorough understanding of leadership frameworks that are essential for influencing, inspiring, and navigating complex workplace challenges. Upon completion, learners will be well-positioned to step into leadership roles or enhance their contribution to existing roles with confidence and clarity. Course Description This course delves into the essential components of effective business leadership by blending leadership theory with key managerial disciplines. Learners will explore leadership styles, employee motivation strategies, and succession planning, alongside modules on communication skills and managing meetings. Additional topics such as negotiation, conflict management, stress handling, and emotional intelligence provide a holistic perspective on leadership responsibilities. The course also examines organisational skills, risk management, and corporate responsibility—offering learners a solid grasp of strategic and ethical leadership. With practical knowledge of Microsoft Word, Excel, and PowerPoint integrated into the curriculum, learners will also gain competence in using essential tools for business documentation and presentations. Ideal for professionals looking to refine their leadership approach or aspiring individuals preparing for management roles, this course delivers comprehensive guidance on how to lead effectively and ethically across a range of business contexts. Course Modules: Module 01: Understanding Management and Leadership Module 02: Leadership Theories Module 03: Improving Management and Leadership Performance Module 04: High Performance Teams Module 05: Motivating Employees Module 06: Organisational Skills Module 07: Talent Management Module 08: Succession Planning Module 09: Business Process Management Module 10: Communication Skills Module 11: Negotiation Techniques Module 12: Managing Meetings and Giving Feedback Module 13: Managing Change Module 14: Time Management Module 15: Stress Management Module 16: Emotional Intelligence in Leadership Module 17: Managing Conflict Module 18: Dealing with Office Politics Module 19: Risk Management Module 20: Corporate Responsibility and Ethics Module 21: Microsoft Word, Excel, PowerPoint (See full curriculum) Who is this course for? Individuals seeking to build leadership capabilities for organisational roles. Professionals aiming to progress into managerial or executive positions. Beginners with an interest in leadership, team management, or business strategy. Entrepreneurs or business owners wanting to lead teams more effectively. Career Path Team Leader Department Manager Operations Supervisor Project Coordinator Human Resources Officer Business Consultant Organisational Development Executive Corporate Trainer

Course Overview The Teaching Assistant Level 2 course provides an essential foundation for those seeking to build a rewarding career in education support. This comprehensive programme covers the key responsibilities, skills, and knowledge required to assist in classroom settings effectively. Learners will explore a range of topics including child development, SEN support, behaviour management, curriculum understanding, and the role of technology in education. By completing this course, individuals will develop the confidence to work alongside teachers, support diverse learning needs, and foster positive learning environments. The course also highlights career progression opportunities within the education sector, offering valuable insights into future pathways. Whether you are starting out or looking to enhance your current role, this course provides practical knowledge and industry-relevant skills to help you succeed as a Teaching Assistant and contribute meaningfully to pupil achievement and school success. Course Description The Teaching Assistant Level 2 course offers a structured exploration of the duties and expectations placed on modern Teaching Assistants. Learners will gain in-depth knowledge of school operations, safeguarding policies, behaviour management strategies, and methods for supporting literacy, numeracy, and ICT development. The programme places special emphasis on understanding special educational needs (SEN) and nurturing strong communication with students and colleagues. Participants will also examine how to create inclusive learning environments that encourage student participation and success. Designed to enhance both theoretical understanding and workplace readiness, this course equips learners with the tools needed to support teachers, manage small groups, and assist in delivering high-quality education. With a strong focus on professional development and career advancement, this course serves as a stepping stone towards a fulfilling role in educational settings across the UK. Course Modules Module 01: Teaching Assistant Overview Module 02: Professional Developments for a TA Module 03: Working with the School and Its Policies Module 04: Discussion on Curriculum, Assessment and Monitoring Module 05: Providing the Best Learning Environment Module 06: Learn to Implement ICT, Literacy and Numeracy Development Processes as a TA Module 07: Child Development and the SEN Support Module 08: Understanding Behaviour & Relationships as a TA Module 09: Experienced TAs Maintain Strong Communications with the Students Module 10: Career Prospects for TAs in the UK (See full curriculum) Who is this course for? Individuals seeking to begin a career as a Teaching Assistant. Professionals aiming to enhance their educational support skills. Beginners with an interest in working within school environments. Those looking to support children’s academic and personal development. Career changers wanting to transition into the education sector. Career Path Teaching Assistant Learning Support Assistant Special Educational Needs (SEN) Support Worker Classroom Support Worker Behaviour Support Assistant Early Years Teaching Assistant

Strategic Management: Strategic Management Course Online Introducing Strategic Management: Strategic Management Course "Empowering the Next Generation" Online course! Strategic Management: Strategic Management Course involves the planning and implementation of the most important goals and initiatives taken by a corporation's top management on behalf of its owners, based on resource considerations and an assessment of the internal and external environments in which the organization competes. This Strategic Management: Strategic Management Course is designed to provide you the opportunity to gain a thorough understanding of strategic management. Through this Strategic Management: Strategic Management Course, you will learn how to develop a highly effective team, optimize better performance, deal with obstacles, fear, imposter syndrome and much more. Take the Strategic Management: Strategic Management Course to start learning the business strategy and strategy formulation skills you'll need to effectively map the future of your organization. Learning Outcomes After completing this Strategic Management: Strategic Management Course, learner will be able to: Understand The Middle: Where Transformations Either Happen or Stuck Understand how to develop highly effective team and optimize better performance Know how to face the unwanted circumstances wisely with courage and persistence Know how to lead a transformation rather than doing a transformation from the top [ Note: Free PDF certificate as soon as completing the Strategic Management: Strategic Management Course] rategic Management: Strategic Management Course Online This Strategic Management: Strategic Management Course consists of 04 modules. Course Curriculum of Strategic Management: Strategic Management Course Module 01: The Middle: Where Transformations Either Happen or Stuck Module 02: Developing Highly Effective Team and Optimising Better Performance Module 03: Facing The Unwanted Circumstances Wisely With Courage and Persistence Module 04: Leading a Transformation Rather Than Doing a Transformation From the Top Certification of Strategic Management: Strategic Management Course After completing the Strategic Management: Strategic Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Strategic Management: Strategic Management Course After completing Strategic Management: Strategic Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Strategic Management: Strategic Management Course Online This Strategic Management: Strategic Management Course is ideal for professionals whose jobs require strong strategic planning and problem-solving skills. Requirements Strategic Management: Strategic Management Course Online To enrol in this Strategic Management: Strategic Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Strategic Management: Strategic Management Course. Be energetic and self-motivated to complete our Strategic Management: Strategic Management Course. Basic computer Skill is required to complete our Strategic Management: Strategic Management Course. If you want to enrol in our Strategic Management: Strategic Management Course, you must be at least 15 years old. Career path Strategic Management: Strategic Management Course Online The knowledge you will gain through this Strategic Management: Strategic Management Course may lead you to a variety of career opportunities. Such as: Strategic Managers Strategy Analysts Strategic Planning Managers Business Analysts Operations Managers

Diploma in Data Analysis Fundamentals Course Overview The Diploma in Data Analysis Fundamentals provides a comprehensive introduction to the core principles and techniques used in data analysis. Throughout this course, learners will explore various data analysis tools and methods, such as Pareto charts, histograms, and control charts, to gain insights into processes and performance. By focusing on key data analysis skills, including identifying variation and interpreting results, this course empowers learners to use data-driven approaches to improve business processes. Upon completion, learners will have the ability to assess and present data effectively, enabling informed decision-making in a wide range of industries. Course Description This course covers essential topics in data analysis, including the principles of process management, tools for data analysis, and methods to interpret and present performance data. Learners will delve into key techniques such as Pareto charts, histograms, run charts, and control charts, focusing on how to use these tools to identify patterns, variations, and areas for improvement. The course also includes a structured approach to performance measurement and provides exercises to reinforce the theoretical knowledge gained. By the end of the course, learners will be equipped with the skills to analyse data, identify trends, and contribute to process improvement initiatives within their organisations. Diploma in Data Analysis Fundamentals Curriculum Module 01: Introduction Module 02: Agenda and Principles of Process Management Module 03: The Voice of the Process Module 04: Working as One Team for Improvement Module 05: Exercise: The Voice of the Customer Module 06: Tools for Data Analysis Module 07: The Pareto Chart Module 08: The Histogram Module 09: The Run Chart Module 10: Exercise: Presenting Performance Data Module 11: Understanding Variation Module 12: The Control Chart Module 13: Control Chart Example Module 14: Control Chart Special Cases Module 15: Interpreting the Control Chart Module 16: Control Chart Exercise Module 17: Strategies to Deal with Variation Module 18: Using Data to Drive Improvement Module 19: A Structure for Performance Measurement Module 20: Data Analysis Exercise Module 21: Course Project Module 22: Test your Understanding (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to improve decision-making through data insights. Beginners with an interest in process improvement and business analysis. Data enthusiasts looking to build a solid foundation in analysis techniques. Career Path Data Analyst Business Intelligence Analyst Process Improvement Specialist Operations Analyst Quality Control Analyst

Excel Data Analysis Course Overview The Excel Data Analysis course is designed to equip learners with the essential skills needed to analyse and interpret data using Microsoft Excel. This course covers a range of tools and techniques that are vital for processing, summarising, and visualising data. Learners will explore functions, pivot tables, charts, and data manipulation strategies that will enable them to work efficiently with data sets. By the end of the course, learners will be able to transform raw data into meaningful insights, making it an invaluable skill for professionals across various industries. Whether you're looking to improve your data skills or progress in your career, this course offers the foundational knowledge required for data analysis in Excel. Course Description This course delves into the core aspects of Excel Data Analysis, starting with basic functions and advancing to complex data manipulation techniques. Learners will explore how to create and manage pivot tables, perform data filtering, and apply functions such as VLOOKUP and INDEX MATCH. Visualisation tools like charts and graphs will be covered, enabling learners to present their findings in a clear and impactful way. Additionally, learners will be introduced to data modelling, conditional formatting, and advanced formula techniques that will enhance their data analysis capabilities. The course is structured to provide a comprehensive understanding of Excel’s data analysis features, building competency for a wide range of practical applications in both personal and professional settings. Excel Data Analysis Curriculum Module 01: Introduction to Excel for Data Analysis Module 02: Using Excel Functions for Data Manipulation Module 03: Working with Pivot Tables and Pivot Charts Module 04: Data Visualisation: Creating Charts and Graphs Module 05: Advanced Excel Functions for Complex Data Analysis Module 06: Data Filtering and Sorting Techniques Module 07: Conditional Formatting for Data Insights Module 08: Introduction to Data Modelling and Forecasting Module 09: Data Analysis Best Practices and Case Studies (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to advance in data-centric roles. Beginners with an interest in data analysis and Excel. Anyone looking to improve their Excel knowledge for career development. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Administrative Assistant Project Manager Research and Development Analyst

ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Course Overview The ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! course is designed to guide learners from basic understanding to advanced proficiency in using ChatGPT. This course covers a wide range of topics, from the fundamentals of ChatGPT to its integration for business scaling and its applications in specific industries like Excel professionals and students. By the end of the course, learners will have a comprehensive understanding of ChatGPT’s capabilities, how to leverage its potential for various tasks, and how to improve productivity and creativity using this powerful tool. Whether you are looking to enhance your business, excel in academic pursuits, or integrate AI into your work, this course provides the knowledge and skills necessary to succeed. Course Description This course offers an in-depth exploration of ChatGPT, covering its fundamental features and uses across different sectors. Learners will be introduced to ChatGPT’s functionalities, followed by more specialised modules, including its applications for developers, students, and professionals working with Excel. Participants will gain valuable insights into how ChatGPT can be used to automate tasks, enhance business operations, and create innovative content. They will also explore the integration of Dall-E 2 for generating graphic art and the best tools and extensions to improve ChatGPT's functionality. The course is structured to ensure learners gain a clear understanding of how to effectively use ChatGPT for various personal and professional goals. ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Curriculum Module 01: Getting Started Module 02: ChatGPT – Basic Module 03: ChatGPT for Developers Module 04: Build, and Scale your Business Using ChatGPT Module 05: ChatGPT for Students Module 06: The Power of ChatGPT Module 07: ChatGPT for Excel professionals Module 08: Generate Incredible Graphic Art with Dall-E 2 Module 09: The Best Tools and Extensions using ChatGPT (See full curriculum) Who is this course for? Individuals seeking to improve productivity through AI. Professionals aiming to leverage ChatGPT for business growth. Beginners with an interest in learning AI technologies. Developers looking to integrate ChatGPT into applications. Students seeking to optimise learning and research tasks. Career Path AI Integration Specialist Business Automation Expert Developer specialising in AI tools Digital Content Creator Data Analyst using AI tools Academic Support Professional Graphic Designer using AI for art generation

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00