240 Pivot Table courses delivered Online

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

24 Hours Left! Enrol Now in this Data Analyst Course! Today's world revolves around data. Organisations across all industries increasingly depend on Data Analysts to make crucial business decisions. So, if you want to collect, evaluate, and understand data using various methods and business intelligence tools and further enhance your Data Analyst skills, our comprehensive Data Analyst course is perfect for you. Designed for success, this Data Analyst course covers everything from basics to advanced topics in Data Analyst. Each lesson in this Data Analyst course is crafted for easy understanding, enabling you to become proficient in Data Analyst. Whether you are a beginner or looking to sharpen your existing skills, this Data Analyst is the ideal choice. Learning Outcomes of Data Analyst course: Introduce yourself to the critical concepts of analysing data. Know how to build, change, and format charts. Become well-versed in working with multiple worksheets and workbooks. Master the key aspects of modifying a worksheet. Discover how to work with lists. Understand how to use PivotTables, PivotCharts, Lookup Functions, and Formula Auditing. Explore the process of applying data validation, searching for invalid data and formulas with errors, and working with macros. Find out how to automate workbook functionality, create sparklines, and map data. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of Data Analyst Get a free student ID card with Data Analyst Training Get instant access to this Data Analyst course. Learn Data Analyst from anywhere in the world The Data Analyst is affordable and simple to understand The Data Analyst is an entirely online, interactive lesson with voiceover audio Lifetime access to the Data Analyst course materials The Data Analyst comes with 24/7 tutor support Start your Data Analyst Diploma journey straightaway! This Data Analyst's curriculum has been designed by Data Analyst experts with years of Data Analyst experience behind them. The Data Analyst course is extremely dynamic and well-paced to help you understand Data Analyst with ease. You'll discover how to master the Data Analyst skill while exploring relevant and essential topics. *** Course Curriculum *** Here is the curriculum breakdown of this course: Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analysing Data Module 04: Visualizing Data with Charts Module 05: Using Pivot Tables and Pivot Charts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08: Automating Workbook Functionality Module 09: Creating Sparklines and Mapping Data Module 10: Forecasting Data Assessment Process After passing the Diploma in Data Analyst exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Data Analyst Diploma Anyone willing to gain a better understanding. Already working in this field and want to learn more about Data Analyst Requirements Data Analyst Diploma You will not need any prior background or expertise. Career path Career Path: Data Analyst Data Scientist Data Analytics Manager Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in Data Analysis at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the Diploma in Data Analysis at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for international delivery CPD Accredited Certificate Upon finishing the Data Analyst (Data Analytics)course, you need to order to receive a Certificate Accredited by CPD that is accepted all over the UK and also internationally. The pricing schemes are: 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

From business to research, having a solid grasp of Excel Data analysis can open doors of opportunity in various industries. Learn this valuable skill set from the comfort of your home with the Data Analysis In Excel course. This course will introduce you to the ins and outs of Excel data analysis. This Data Analysis In Excel course will help you establish a solid foundation in Excel data analysis. This course will help you pick up the skills to visualise data with charts in Excel. Here, you will also learn about Pivot Tables and Charts. Furthermore, the course will teach you how to work with multiple Workbooks. In addition, you will learn about Lookup factions and how to use them. By the end of this course, you will know the essentials of automating Workbook functionality. This course will assist you in securing effective data analysis skills. In addition, you will receive a QLS-endorsed certificate of achievement. This certificate will enhance your employability in the relevant job market. Join now!  Learning Outcomes Understand the basic principles of data analysis with Excel Learn how to visualise data with Excel charts Build your expertise in using Pivot Tables and Charts Grasp the techniques of working with multiple Worksheets and Workbooks Know the process of automating Workbook functionality Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £99. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Research Assistant Researcher Business Analyst

Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Microsoft Office 2016 Excel Beginner to Advanced Course Description At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Receptionist Office Admin Data entry Officer Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! 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

Microsoft Excel - Beginner, Intermediate & Advanced Course Enrolling in a Microsoft Excel - Beginner, Intermediate & Advanced CPD Professional Course is pivotal in today's modern world. Microsoft Excel proficiency is indispensable across industries for data analysis, reporting, and decision-making. In the UK, Microsoft Excel skills are highly sought after, with job opportunities spanning various sectors, including finance, healthcare, and technology. Entry-level positions often require basic Microsoft Excel knowledge, while intermediate and advanced proficiency can unlock higher-paying roles with salaries ranging from £25,000 for beginners to over £40,000 for experienced professionals annually. The demand for Microsoft Excel expertise is increasing, with businesses relying on data-driven insights for strategic planning and operational efficiency. Whether for financial modeling, project management, or statistical analysis, Microsoft Excel proficiency enhances employability and career advancement prospects. As industries continue to evolve digitally, mastering Microsoft Excel is not just advantageous but essential for professionals aiming to thrive in the ever-competitive job market. Key Features This Microsoft Excel - Beginner, Intermediate & Advanced- CPD Professional Course Includes: This Microsoft Excel Course is CPD Certified Free Certificate from Reed CIQ Approved Microsoft Excel Course Developed by Specialist Lifetime Access Course Curriculum Microsoft Excel Course: Module 01: Microsoft Excel 2019 Enhanced Features Module 02: Introduction to Microsoft Excel Module 03: Performing Mathematical Operations Module 04: Adjusting a Worksheet Module 05: Formatting Data in a Worksheet Module 06: Printing in Microsoft Excel Module 07: Workbook Management Techniques Module 08: Utilizing Functions Module 09: Data Management Techniques Module 10: Data Analysis Methods Module 11: Visual Representation with Charts Module 12: Mastering PivotTables and PivotCharts Module 13: Managing Multiple Sheets and Workbooks Module 14: Utilizing Lookup Functions and Formula Auditing Module 15: Sharing and Securing Workbooks Module 16: Automation in Microsoft Excel Module 17: Creating Sparklines and Geographic Data Visualization Learning Outcomes Microsoft Excel Course: Identify and utilize new features in Microsoft Excel 2019 effectively. Perform complex calculations and manipulate data efficiently in Microsoft Excel. Apply formatting techniques and create professional-looking spreadsheets. Analyze and interpret data using advanced functions and tools in Microsoft Excel. Construct dynamic charts, pivot tables, and visual representations of data. Automate tasks and enhance productivity through Microsoft Excel's advanced functionalities. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Microsoft Excel. Moreover, this course is ideal for: Beginners seeking comprehensive Microsoft Excel skills Intermediate users aiming to enhance proficiency Advanced users desiring mastery of Microsoft Excel functionalities Professionals in various fields requiring data management expertise using Microsoft Excel. Individuals pursuing career advancement opportunities using Microsoft Excel Students preparing for roles involving data analysis and reporting in Microsoft Excel. Requirements There are no requirements needed to enrol into this Microsoft Excel course. We welcome individuals from all backgrounds and levels of experience to enrol into this Microsoft Excel course. Career path After finishing this Microsoft Excel course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Microsoft Excel are: Data Analyst - £30K to 50K/year. Financial Analyst - £35K to 60K/year. Business Intelligence Analyst - £40K to 70K/year. Operations Manager - £40K to 60K/year. Project Manager - £45K to 70K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you looking to enhance your Microsoft Office Course skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office Course will assist you in producing the best possible outcome by mastering the Microsoft Office Course skills. The Microsoft Office Course is for those who want to be successful. In the Microsoft Office Course, you will learn the essential knowledge needed to become well versed in Microsoft Office Course. Our Microsoft Office Course starts with the basics of Microsoft Office Course and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office Course is intuitive and easy to understand. Why would you choose the Microsoft Office Course from Compliance Central: Lifetime access to Microsoft Office Course materials Full tutor support is available from Monday to Friday with the Microsoft Office Course Learn Microsoft Office Course skills at your own pace from the comfort of your home Gain a complete understanding of Microsoft Office Course Accessible, informative Microsoft Office Course learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Microsoft Office Course bundle Study Microsoft Office Course in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Microsoft Office Course Improve your chance of gaining in demand skills and better earning potential by completing the Microsoft Office Course Microsoft Office Course Curriculum Breakdown of the Microsoft Office Course Section 01: Getting Started Section 02: Excel 2021: Basics Section 03: Excel 2021: Rows, Columns, and Cells Section 04: Excel 2021: Data Handling Section 05: Excel 2021: Page Setting Up and Print Section 06: Excel 2021: Sorting and Filtering Section 07: Excel 2021: Writing Formulas Section 08: Excel 2021: Advanced Formulas Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 Section 10: Excel 2021: Data and Tools Section 11: Excel 2021: Formatting data and tables Section 12: Excel 2021: Pivot Tables Section 13: Excel 2021: Charts Section 14: PowerPoint 2021: Course Introduction Section 15: PowerPoint 2021: Basics Section 16: PowerPoint 2021: Text and Bullet Options Section 17: PowerPoint 2021: Adding Graphic Assets Section 18: PowerPoint 2021: Picture Formatting Section 19: PowerPoint 2021: SmartArt Graphics Section 20: PowerPoint 2021: Working with Tables Section 21: PowerPoint 2021: Working with Charts Section 22: PowerPoint 2021: Adding Multimedia Section 23: PowerPoint 2021: Working with Transition Section 24: PowerPoint 2021: Animation Section 25: PowerPoint 2021: Slideshow Effects Section 26: Word 2021: Introduction Section 27: Word 2021: Basics Section 28: Word 2021: Word Formatting Section 29: Word 2021: Tables Section 30: Word 2021: Styles Section 31: Word 2021: Page Layout Section 32: Word 2021: Envelops and Lables Section 33: Word 2021: Mail Merges Section 34: Word 2021: Review and Printing CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office Course. It is also great for professionals who are already working in Microsoft Office Course and want to get promoted at work. Requirements To enrol in this Microsoft Office Course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office Course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Course. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you looking to enhance your Microsoft Office All-in-One Package skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office All-in-One Package will assist you in producing the best possible outcome by mastering the Microsoft Office All-in-One Package skills. The Microsoft Office All-in-One Package is for those who want to be successful. In the Microsoft Office All-in-One Package, you will learn the essential knowledge needed to become well versed in Microsoft Office All-in-One Package. Our Microsoft Office All-in-One Package starts with the basics of Microsoft Office All-in-One Package and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office All-in-One Package is intuitive and easy to understand. Why would you choose the Microsoft Office All-in-One Package from Compliance Central: Lifetime access to Microsoft Office All-in-One Package materials Full tutor support is available from Monday to Friday with the Microsoft Office All-in-One Package Learn Microsoft Office All-in-One Package skills at your own pace from the comfort of your home Gain a complete understanding of Microsoft Office All-in-One Package Accessible, informative Microsoft Office All-in-One Package learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Microsoft Office All-in-One Package bundle Study Microsoft Office All-in-One Package in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Microsoft Office All-in-One Package Improve your chance of gaining in demand skills and better earning potential by completing the Microsoft Office All-in-One Package Microsoft Office All-in-One Package Curriculum Breakdown of the Microsoft Office All-in-One Package Section 01: Getting Started Section 02: Excel 2021: Basics Section 03: Excel 2021: Rows, Columns, and Cells Section 04: Excel 2021: Data Handling Section 05: Excel 2021: Page Setting Up and Print Section 06: Excel 2021: Sorting and Filtering Section 07: Excel 2021: Writing Formulas Section 08: Excel 2021: Advanced Formulas Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 Section 10: Excel 2021: Data and Tools Section 11: Excel 2021: Formatting data and tables Section 12: Excel 2021: Pivot Tables Section 13: Excel 2021: Charts Section 14: PowerPoint 2021: Course Introduction Section 15: PowerPoint 2021: Basics Section 16: PowerPoint 2021: Text and Bullet Options Section 17: PowerPoint 2021: Adding Graphic Assets Section 18: PowerPoint 2021: Picture Formatting Section 19: PowerPoint 2021: SmartArt Graphics Section 20: PowerPoint 2021: Working with Tables Section 21: PowerPoint 2021: Working with Charts Section 22: PowerPoint 2021: Adding Multimedia Section 23: PowerPoint 2021: Working with Transition Section 24: PowerPoint 2021: Animation Section 25: PowerPoint 2021: Slideshow Effects Section 26: Word 2021: Introduction Section 27: Word 2021: Basics Section 28: Word 2021: Word Formatting Section 29: Word 2021: Tables Section 30: Word 2021: Styles Section 31: Word 2021: Page Layout Section 32: Word 2021: Envelops and Lables Section 33: Word 2021: Mail Merges Section 34: Word 2021: Review and Printing CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office All-in-One Package helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office All-in-One Package. It is also great for professionals who are already working in Microsoft Office All-in-One Package and want to get promoted at work. Requirements To enrol in this Microsoft Office All-in-One Package, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office All-in-One Package will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office All-in-One Package. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

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