12784 Manager courses delivered Online

Sexual Harassment Awareness Training course offers comprehensive insights into recognising, understanding, and effectively managing instances of sexual harassment within the workplace. This Sexual Harassment Awareness Training online course delves into the different types of harassment, exploring both its psychological and social impacts, as well as the legal standards designed to protect individuals and uphold equality. Learners will gain practical knowledge of workplace policies, procedures, and best practices for addressing harassment, alongside techniques to create a safe, inclusive environment for all employees. With modules covering the nuances of dealing with toxicity, fostering respect, and understanding equality, this training equips individuals to advocate for positive workplace dynamics and ensure professional boundaries are maintained. Learning Outcomes of the Sexual Harassment Awareness Training Course By completing this Sexual Harassment Awareness Training course, learners will: Understand the impact and consequences of sexual harassment in professional settings. Identify various types and signs of sexual harassment. Familiarise themselves with workplace policies and relevant legal standards. Learn effective methods for addressing and preventing incidents of harassment. Gain insights into fostering inclusivity to minimise toxicity and promote equality. Key Features of the Sexual Harassment Awareness Training Course CPD-accredited certification for career enhancement. Flexible, on-demand learning with expert-developed resources. Continuous support from experienced industry professionals. Requirements Open to everyone; no prior experience required. Accessible on any internet-enabled device. CPD Certificate from Course Gate Upon successful course completion, learners may obtain a CPD certificate: PDF for £9, a hard copy for £15, or both for £22. Who Is This Sexual Harassment Awareness Training Course For? HR managers and team leaders aiming to reinforce workplace safety. Individuals seeking a deeper understanding of harassment issues. Professionals committed to promoting a respectful, harassment-free workplace. Career Path This Sexual Harassment Awareness Training enhances skills for roles such as: Human Resources Specialist Workplace Compliance Officer Employee Relations Manager Equality and Diversity Advisor

Duration 3 Days 18 CPD hours This course is intended for Analyst End User Implementer Manager Overview Create a Work Breakdown Structure Define roles and resources Assign roles Assign resources Analyze resources Optimize the project plan Understand data structures Create a project Add activities View calendars Create relationships Schedule the project Assign constraints Create reports Format schedule data Execute the project Enrolling in this course will help you understand P6 Professional's basic features and functionality so you can apply them to your organization's project management processes. You'll also learn how to manage projects on time and within budget Understanding P6 Data Describing Enterprise and Project-Specific data Logging In Opening an Existing Project Opening and Customizing Layouts Enterprise Project Structure Describing Components of EPS Creating a Project Create a project Navigating in the Projects Window Viewing Project Details Creating a Work Breakdown Structure Defining a Work Breakdown Structure Creating the WBS Hierarchy Adding Activities Describing an Activity and its Components Describing Activity Types Adding Activities Adding a Notebook Topic Adding Steps to an Activity Assigning Activity Codes Creating Relationships Viewing a Network Logic Diagram Relationship Types Creating Relationships Scheduling Performing a Forward and Backward Pass Describing Float Assigning Constraints Applying an Overall Deadline to a Project Apply a Constraint to an Activity Using Reflection Projects Creating a Reflection Project Merging Changes Formatting Schedule Data Grouping Activities Sorting Filtering Roles and Resources Describing Roles and Resources Viewing Dictionaries Assigning Roles Assigning Roles to an Activity Assign Rates on Roles Assigning Resources Assigning Resources Adjusting Budgeted Units/Time Analyzing Resources Displaying the Resource Usage Profile Optimizing the Project Plan Analyzing Schedule Dates Shortening a Project Schedule Analyzing Resource Availability Baselining the Project Plan Creating a Baseline Plan Display Baseline Bars on the Gantt Chart Project Execution and Control Describing Methods for Updating the Schedule Using Progress Spotlight Statusing Activities Rescheduling the Project Reporting Performance Describing Reporting Methods Running a Schedule Report Creating a report with the Report Wizard Additional course details: Nexus Humans Primavera P6 Professional Fundamentals Rel 19 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Primavera P6 Professional Fundamentals Rel 19 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

***24 Hour Limited Time Flash Sale*** Level 5 Diploma in People Management & HR - CPD Approved Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In today's rapidly evolving workplace, effective people management is paramount for sustaining organizational growth and achieving strategic goals. Recent studies have shown that businesses in the UK with strong management practices are 56% more productive and 75% more profitable. Yet, how can managers elevate their skills to navigate complex team dynamics, adapt to changing market demands, and drive performance? This Level 5 Diploma in People Management Bundle addresses these critical questions, offering a comprehensive pathway to mastering the art of leading and developing people. This meticulously curated bundle comprises 25 courses, ranging from foundational people management principles to specialised disciplines such as Agile Project Management and Compliance Risk Management. Learners will explore advanced strategies in HR management, team building, strategic and operational management, alongside acquiring crucial soft skills like motivation, public speaking, and conflict resolution. With a strong emphasis on practical applications and current trends, this program equips participants with the tools to make informed decisions, inspire teams, and implement effective changes within their organizations. With this Level 5 Diploma in People Management course, you will get 25 CPD Accredited PDF Certificates, Hard Copy Certificate of Level 5 Diploma in People Management and our exclusive student ID card absolutely free. Courses Are Included In This Level 5 Diploma in People Management Bundle: Course 01: Level 5 Diploma in People Management Course 02: Organisation & People Management Course 03: HR Management Diploma Course 04: Strategic Management Training Course 05: Agile Project Management Course 06: Diploma in Team Management at QLS Level 5 Course 07: Diploma in Performance Management Course 08: Diploma in Employee Management Course 09: Motivation Skills Course 10: Team Building & Management Diploma Course 11: Office Administration & Skills Diploma Course 12: Diploma in Meeting Management Course 13: Change Management Course 14: Recruitment Consultant Diploma Course 15: Talent Management Level 3 Course 16: Diploma in Operations Management Course 17: Payroll Administrator Training Course 18: Leadership Skills Course Course 19: Smart Goal Setting Course 20: Critical Thinking in The Workplace Course 21: Confidence Building & Assertiveness Course 22: Public Speaking Diploma Course 23: Conflict Management Training Course 24: Cross-Cultural Awareness Training Course 25: Compliance Risk and Management Embarking on Level 5 Diploma in People Management is more than just taking an online course; it's an investment in your future. By completing this bundle, you'll not only gain invaluable skills but also open doors to new career opportunities and advancements, boosting your earning potential. Don't miss this chance to elevate your career and skillset. Enrol in Level 5 Diploma in People Management today and take the first step towards achieving your goals and dreams. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of this course Get a free student ID card with this Training This course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to this course materials This course comes with 24/7 tutor support Start your learning journey straightaway ! Whether you're looking to ascend to a leadership position, enhance your managerial capabilities, or refine your team's performance, this Level 5 Diploma in People Management Bundle presents an unparalleled opportunity. Embrace the chance to transform your career trajectory, foster a thriving work environment, and contribute to your organization's success. Enrol now and take the first step towards becoming an influential leader in the modern workforce. How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £25*12.99 = £324) CPD Hard Copy Certificate: Free ( For The Title Course: Previously it was £29.99) CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements This bundle doesn't require prior experience and is suitable for diverse learners. Career path This 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 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard copy certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Course Overview "Stock Trading Analysis with Volume Trading" is designed to provide learners with a comprehensive understanding of how to leverage volume analysis in stock trading. This course covers essential volume indicators, strategies, and techniques, empowering learners to make informed trading decisions. The course aims to enhance trading skills by explaining how volume trends can influence stock price movements, offering learners practical insights into market behaviour. By the end of the course, learners will have the ability to interpret volume data, use it to spot market trends, and apply it within their trading strategies, enhancing their confidence and decision-making capabilities in stock trading. Course Description This course delves into the critical aspect of volume analysis in stock trading, providing a thorough exploration of how trading volume can provide valuable market insights. Learners will study various volume indicators and their applications, uncover trading strategies that incorporate volume as a key factor, and gain the skills necessary to identify profitable market movements. The course also includes practical examples and analysis to demonstrate how volume impacts stock trends, while familiarising learners with the tools used in volume trading. By completing this course, learners will develop the expertise to utilise volume trading strategies to enhance their trading performance and make more informed decisions in real-time market scenarios. Course Modules Module 01: Volume Analysis Module 02: Volume Studies and Indicators Module 03: Volume Trading Strategies and Techniques Module 04: Examples and Analysis Module 05: Trading Platform (See full curriculum) Who is this course for? Individuals seeking to enhance their stock trading skills Professionals aiming to develop expertise in volume trading strategies Beginners with an interest in stock market analysis Anyone looking to understand the role of volume in trading decisions Career Path Stock Trader Financial Analyst Investment Advisor Trading Platform Specialist Portfolio Manager

Are you ready to embark on an enlightening journey of wisdom with the Business Theory 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 - Business Theory (MBA, International Business & Business Development). Delve into eight immersive CPD Accredited courses, each a standalone course: Business Studies Mini MBA Diploma in Business Analysis International Business Principles Business Law 2021 Learn Business Development & Sales from A-Z Marketing Principles Learn to Identify and Solve Business Problems Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Business Theory (MBA, International Business & Business Development) bundle illuminate your path to wisdom. The Business Theory (MBA, International Business & Business Development) 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 Business Theory (MBA, International Business & Business Development) 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 Business Theory 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 Business Theory (MBA, International Business & Business Development) community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Business Theory bundle. Establish robust bases across each course nestled within the Business Theory bundle. Decipher intricate concepts through the articulate content of the Business Theory 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 Business Theory 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 Business Theory 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 Business Theory bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Business Theory 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 Business Theory bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Business Theory 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 Business Theory 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 Business Theory 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 Hardcopy Transcript - £9.99

Did you know that people conflict has cost UK organisations £28.5 billion in total, with 10 million people experiencing conflict at work and 5 million suffering from stress, anxiety or depression as a result? Join us for this unmissable HR Roundtable to explore important topics of workplace dignity and respect, how to combine operational excellence with HR excellence, safeguarding reputation and much more. SPEAKER IAN KIRKPATRICK Join us for an exclusive session featuring Ian Kirkpatrick, an esteemed professional with over 25 years of experience operating at the Board level across various industries and sectors. His unique blend of expertise in Operations, Supply Chain Management, and Human Resources Leadership makes him a true industry leader.

Ethics Matters: Corporate Governance and CFOs,” the podcast where we dive deep into the critical intersection of corporate governance. Sustainability and ESG reporting have gained significant attention in recent years. How do CFOs incorporate these considerations into their financial strategies and decision-making? CFOs recognise that sustainable practices and ESG considerations are not only ethical imperatives but also critical for long-term business success. We incorporate these considerations into financial strategies by assessing the environmental and social impacts of our operations, supply chains, and investment decisions. By incorporating ESG factors into our financial analyses, we make more informed decisions that align with our company’s values and stakeholder expectations. Furthermore, CFOs play a pivotal role in ESG reporting. We collaborate with cross-functional teams to collect relevant data, establish reporting frameworks, and communicate the company’s sustainability initiatives to stakeholders. This transparency fosters trust and accountability while allowing investors, customers, and the broader community to evaluate our commitment to sustainable practices. Board engagement is essential for effective corporate governance. How can CFOs contribute to building a strong relationship between the CFO and the board of directors? Building a strong relationship with the board of directors begins with open and transparent communication. CFOs provide timely and accurate financial information, strategic insights, and risk assessments to the board. We actively participate in board meetings, present financial reports, and engage in discussions about financial performance, strategic initiatives, and potential risks. By demonstrating our financial expertise and ethical leadership, we contribute to a healthy and productive relationship with the board. It’s also crucial for CFOs to provide independent perspectives and challenge conventional thinking when necessary. By offering well-informed insights and raising critical questions, we contribute to robust board discussions and decision-making. This collaborative approach fosters an environment where diverse perspectives are valued, and ethical considerations are thoroughly examined. I would encourage fellow CFOs to prioritise ethics and corporate governance as integral components of their roles. Embed ethical considerations into decision-making processes, ensure robust governance structures, and actively engage with stakeholders. By doing so, we can drive sustainable, responsible, and successful organizations. https://www.fdcapital.co.uk/podcast/ethics-matters-corporate-governance-and-cfos/ Tags Online Events Things To Do Online Online Conferences Online Business Conferences #event #ethics #matters #cfos #corporategovernance

he role of a CFO extends beyond day-to-day financial management and plays a pivotal role in preparing a business for an exit. The role of a CFO extends beyond day-to-day financial management and plays a pivotal role in preparing a business for an exit, whether it be through a merger, acquisition, or other strategic transaction. Here are some key points to consider: Financial Due Diligence: CFOs play a crucial role in conducting financial due diligence to assess the company’s financial health and identify any potential risks or issues. This involves reviewing financial statements, accounting practices, contracts, and other financial data to ensure accuracy and transparency. Valuation and Financial Modeling: CFOs work closely with the executive team, external advisors, and investment bankers to determine the company’s valuation. They develop financial models, assess growth projections, and analyze market comparables to arrive at a fair and realistic valuation range. Financial Documentation and Reporting: CFOs ensure that financial documentation and reporting are in order, accurate, and compliant with regulatory requirements. This includes preparing financial statements, management reports, and other financial disclosures necessary for the exit process. Negotiation and Deal Structuring: CFOs collaborate with legal and executive teams to negotiate the terms of the exit transaction. They provide financial insights and expertise to structure the deal in a way that maximizes value for the company and its stakeholders. Tax Planning and Optimisation: CFOs work closely with tax advisors to develop tax-efficient strategies for the exit transaction. They assess potential tax implications, explore tax-saving opportunities, and ensure compliance with applicable tax laws and regulations. Financial Communication and Investor Relations: CFOs play a critical role in communicating the financial aspects of the exit to internal and external stakeholders. They work with investor relations teams to ensure that key messages are effectively conveyed, providing transparency and clarity throughout the exit process. https://www.fdcapital.co.uk/podcast/the-vital-role-of-cfos-in-business-exit-preparation/ Tags Online Events Things To Do Online Online Seminars Online Business Seminars #business #cfo #preparation #exit #vital

Identifying, attracting and shortlisting candidates for the recruitment process to fulfil the requirements of the business brief.

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst 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:04: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:04: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 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 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:07: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 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 Excel's 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 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:14: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 Lopps 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 Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00