17088 Courses delivered Online

Overview This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course. Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry. In This Microsoft Excel: Master Power Query Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Microsoft Excel: Master Power Query skills to help you advance your career. Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts. Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career. This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field.  The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand.  And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects.  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 This Microsoft Excel: Master Power Query course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query 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 Microsoft Excel: Master Power Query course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Microsoft Excel: Master Power Query Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention. Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations.  The course will cover: Navigating the Regulatory Landscape: Understanding the Framework for COLPs Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under. Shouldering the Responsibility: Unpacking the Duties of a COLP Explore the multifaceted responsibilities that come with the role of a COLP. Choosing the Right Leader: Identifying the Ideal COLP Candidate Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP. Cracking the Codes: Key Elements of Codes and SRA Principles Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance. Building a Robust Foundation: Understanding Compliance Systems for All Firms Explore the concept of compliance systems, what they entail, and why every firm should have one in place. Reporting Matters: Recognising 'Serious' Issues, SRA Enforcement Strategy, and Reporting Protocols Uncover the definition of 'serious' matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA. Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it's integral to compliance. Personal Liability: Understanding and Mitigating Risks Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks. Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance. Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing. Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs. Target Audience This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

Overview This Upgrade Your Excel Skills course will unlock your full potential and will show you how to excel in a career in Upgrade Your Excel Skills. So upskill now and reach your full potential. Everything you need to get started in Upgrade Your Excel Skills is available in this course. Learning and progressing are the hallmarks of personal development. This Upgrade Your Excel Skills will quickly teach you the must-have skills needed to start in the relevant industry. In This Upgrade Your Excel Skills Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Upgrade Your Excel Skills to help you advance your career. Acquire a comprehensive understanding of various Upgrade Your Excel Skills topics and tips from industry experts. Learn in-demand Upgrade Your Excel Skills that are in high demand among UK employers, which will help you to kickstart your career. This Upgrade Your Excel Skills course covers everything you must know to stand against the tough competition in the Upgrade Your Excel Skills field.  The future is truly yours to seize with this Upgrade Your Excel Skills. Enrol today and complete the course to achieve a Upgrade Your Excel Skills certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Upgrade Your Excel Skills course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Upgrade Your Excel Skills course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Upgrade Your Excel Skills course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Upgrade Your Excel Skills is suitable for anyone aspiring to start a career in Upgrade Your Excel Skills; even if you are new to this and have no prior knowledge on Upgrade Your Excel Skills, this course is going to be very easy for you to understand.  And if you are already working in the Upgrade Your Excel Skills field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Upgrade Your Excel Skills course is a win-win for you in all aspects.  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 This Upgrade Your Excel Skills course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Upgrade Your Excel Skills 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 Upgrade Your Excel Skills course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00

Overview With the ever-increasing demand for Data Analysis in Microsoft Excel in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Data Analysis in Microsoft Excel may be. Learning about Data Analysis in Microsoft Excel or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Data Analysis in Microsoft Excel . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Data Analysis in Microsoft Excel is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Data Analysis in Microsoft Excel course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Data Analysis in Microsoft Excel course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Data Analysis in Microsoft Excel course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Data Analysis in Microsoft Excel , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Data Analysis in Microsoft Excel , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Data Analysis in Microsoft Excel , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Data Analysis in Microsoft Excel course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1_ Introduction to Microsoft Excel Introduction to Microsoft Excel 00:00 Module 2_ Data Visualization and Advanced Functions Data Visualization and Advanced Functions 00:00 Module 3_ PivotTables and Regression PivotTables and Regression 00:00 Module 4_ Time Series Analysis in Excel Time Series Analysis in Excel 00:00

Overview   With the ever-increasing demand for MS Excel in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in MS Excel may be.   Learning about MS Excel or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in MS Excel. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on MS Excel is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by compete high in this Microsoft Excel Beginner to Intermediate course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Microsoft Excel Beginner to Intermediate course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Microsoft Excel Beginner to Intermediate course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of MS Excel, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in MS Excel, Anyone looking for a certificate of completion on doing an online training on this topic, Students of MS Excel, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Microsoft Excel Beginner to Intermediate course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 01-Excel Interface Module 01-Excel Interface 00:00 Module-02-Basic Functions Module-02-Basic Functions 00:00 Module-03-Working With Worksheet Module 03-Working With Worksheet 00:00 Module-04-Work with Data and Excel tables Module-04-Work with Data and Excel tables 00:00 Module-05-Basic Calculations Module-05-Basic Calculations 00:00 Module-06-Shortcuts in Excels Module-06-Shortcuts in Excels 00:00

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00

🚀 Unleash Your Excel Mastery with 'Microsoft Excel 2016 (Basic to Advanced)' Course! 🚀 Are you tired of spending hours grappling with Excel, only to end up with frustrating and inefficient solutions? Do you dream of becoming the Excel wizard in your workplace, effortlessly creating powerful and efficient solutions? Look no further! Introducing our groundbreaking online course: 'Microsoft Excel 2016 (Basic to Advanced).'   🌟 Why Choose 'Microsoft Excel 2016 (Basic to Advanced)'? ✅ Master Advanced Excel Techniques: Dive deep into the world of Excel with our comprehensive modules that cover everything from advanced formulas and functions to data visualization and analysis. ✅ Practical Real-World Applications: Say goodbye to theoretical lessons! We focus on real-world scenarios, ensuring you can immediately apply your newfound skills to solve complex problems in your professional life. ✅ Build Efficiency: Learn the secrets of crafting efficient and streamlined Excel solutions. From automating repetitive tasks to optimizing complex workflows, you'll become a productivity powerhouse. ✅ Expert-Led Instruction: Our experienced instructors are Excel aficionados with a passion for teaching. Benefit from their wealth of knowledge and insider tips, ensuring you stay ahead of the curve. ✅ Interactive Learning: Engage with hands-on exercises, quizzes, and projects that reinforce your understanding and transform you into a confident Excel pro. ✅ Lifetime Access: Gain unlimited access to the course content, updates, and a supportive community. Your learning journey doesn't end - it evolves.   🎓 What You'll Learn: Advanced Formulas and Functions: Supercharge your spreadsheet skills with complex formulas and functions, unlocking Excel's true potential. Data Visualization Mastery: Transform raw data into visually stunning charts and graphs, making your reports and presentations more impactful. Automation Techniques: Streamline your work by mastering Excel's automation features, saving time and reducing errors. Data Analysis Strategies: Unlock the power of PivotTables, data models, and analysis tools to gain valuable insights from your data. Optimizing Workflows: Learn to design efficient workflows and templates that enhance collaboration and productivity.   🌐 Who Is This Course For? Professionals aiming to boost their Excel proficiency. Entrepreneurs seeking to optimize business processes. Students preparing for a data-driven career. Anyone who wants to stay ahead in today's competitive workplace.   Don't miss out on this opportunity to elevate your Excel skills and stand out in the crowd. Join 'Microsoft Excel 2016 (Basic to Advanced)' today and pave the way for a successful and efficient future! Course Curriculum Microsoft Excel 2016 Basic Pre Sell Video 00:00 Lesson 1 - Overview 00:00 Lesson 2 - Interface 00:00 Lesson 3 - File Menu - Part 1 00:00 Lesson 4 - File Menu - Part 2 00:00 Lesson 5 - Home Menu 00:00 Lesson 6 - Insert Menu 00:00 Lesson 7 - Page Layout Menu 00:00 Lesson 8 - Formulas Menu 00:00 Lesson 9 - Data Menu - Part 1 00:00 Lesson 10 - Data Menu - Part 2 00:00 Lesson 11 - Review Menu 00:00 Lesson 12 - View Menu 00:00 Lesson 13 - Templates 00:00 Lesson 14 - Dates 00:00 Lesson 15 - Numbers 00:00 Lesson 16 - Text 00:00 Lesson 17 - B - Calculations-Manual 00:00 Lesson 18 - Calculations 00:00 Lesson 19 - Page Set Up 00:00 Lesson 20 - Print Settings 00:00 Lesson 21 - Conclusion 00:00 Microsoft Excel 2016 Advanced Lesson 1 - Overview 00:00 Lesson 2 - Calculations - Absolute References 00:00 Lesson 3 - Calculations - Relative References 00:00 Lesson 4 - Using Logical Formulas 00:00 Lesson 5 - Using Text Formulas 00:00 Lesson 6 - Using Lookup Formulas 00:00 Lesson 7 - Using Financial Formulas 00:00 Lesson 8 - Using Date and Time Formulas 00:00 Lesson 9 - Sorting Data 00:00 Lesson 10 - Formatting Data into Tables 00:00 Lesson 11 - Using Pivot Tables - Part 1 00:00 Lesson 12 Using Pivot Tables - Part 2 - Design 00:00 Lesson 13 - Formatting Data as Charts 00:00 Lesson 14 - Formatting As Data as Maps 00:00 Lesson 15 - Formatting Data as Formal Reports 00:00 Lesson 16 - Formatting Data for Other Office Documents 00:00 Lesson 17 - Cell Protection and Collaboration 00:00 Lesson 18 - Cell Protection and Collaboration - Part 2 00:00 Lesson 19 - Interface with Google Sheets 00:00 Lesson 20 - Conclusion 00:00

Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!