45 Courses

Master Microsoft Power BI in 90 minutes! Learn to create dashboards and handle live data, turning information into insight.

Microsoft Power BI 90 Minutes Training is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Power BI 90 Minutes Training and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 2 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. WHY CHOOSE TEACHERS TRAINING Some of our features are: * This is a dedicated website for teaching * 24/7 tutor support * Interactive Content * Affordable price * Courses accredited by the UK's top awarding bodies * 100% online * Flexible deadline ENTRY REQUIREMENTS No formal entry requirements. You need to have: * Passion for learning * A good understanding of the English language * numeracy and IT * Desire for entrepreneurship * over the age of 16. ASSESSMENT The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. CERTIFICATION CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. * You can get your digital certificate (PDF) for £4.99 only * Hard copy certificates are also available, and you can get one for only £10.99 * You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Power BI - Introduction Overview of the Course 00:02:00 Power BI Introduction 00:03:00 Power BI High Level Flow 00:02:00 Installing and Signing Up for Power BI 00:03:00 Power Query Introduction 00:05:00 Power Pivot Introduction 00:01:00 Power View Introduction 00:02:00 Your First Power BI Dashboard! The Big Picture 00:02:00 Get Data 00:07:00 How to Get More Data 00:01:00 Modelling Data 00:03:00 Adding Relationships Manually 00:02:00 Visualization 00:05:00 Visualization Customization 00:01:00 More Visualizations 00:02:00 Visualization Format and Analytics 00:03:00 Ask a Question in Power BI 00:02:00 Your Advanced Power BI Dashboard With Real Live Real World Example 00:06:00 Get Data 00:13:00 Modelling Data 00:05:00 Visualization with multiple charts 00:11:00 Publishing 00:05:00 Power BI Website 00:08:00

COURSE OVERVIEW Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course. In this course, you will develop a comprehensive understanding of the PivotTable and PivotChart and explore how they work. In this Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course, you will learn the steps to create your Pivot table and Pivot chart. We'll show you how to use Pivot tables to summarize large amounts of data. You'll also learn how to use PivotChart to provide visual representation to your summarized data. We will then take you through adding sorts, filters, timelines and slicers to create dynamic dashboards. You will also learn how to use the slicer to slice and dice your data the way you want. LEARNING OUTCOMES * Learn how to summaries data with Pivot Table * Be able to add graphical representation to your summarized data with PivotChart * Learn how to update the Pivot Table with new data * Deepen your understanding of sorting and filtering * Be able to import data from various sources with Power Query * Gain an excellent understanding of Power Pivot WHO IS THIS COURSE FOR? Professionals who want to learn how to summaries large sums of data into meaningful information using Excel Pivot and Charts can take this course. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. 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 Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: * Data Analyst  * Accountants  * Financial Analyst Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs. Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it. Why Choose Microsoft Office Essentials - 3 Course Bundle? * Opportunity to boost your CV/Resume with CPD accredited proficiency * Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) * Certificates available in both PDF and hard copy format * Interactive, high-quality course content with 24/7 online access * Full tutor support and learning assistance included Course Curriculum Breakdown: Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course: Microsoft Excel 2022 New Features * Introduction to Microsoft Excel 2019 New Features * CONCAT * IFS * MAXIFS * MINIFS * SWITCH * TEXTJOIN * Map Chart * Funnel Chart * Better Visuals * Pivot Table Enhancements * Power Pivot Updates Getting Started with Microsoft Office Excel * Navigate the Excel User Interface * Use Excel Commands * Create and Save a Basic Workbook * Enter Cell Data * Use Excel Help Performing Calculations * Create Worksheet Formulas * Insert Functions * Reuse Formulas and Functions Modifying a Worksheet * Insert, Delete, and Adjust Cells, Columns, and Rows * Search for and Replace Data * Use Proofing and Research Tools Formatting a Worksheet * Apply Text Formats * Apply Number Format * Align Cell Contents * Apply Styles and Themes * Apply Basic Conditional Formatting * Create and Use Templates Printing Workbooks * Preview and Print a Workbook * Set Up the Page Layout * Configure Headers and Footers Managing Workbooks * Manage Worksheets * Manage Workbook and Worksheet Views * Manage Workbook Properties Working with Functions * Work with Ranges * Use Specialized Functions * Work with Logical Functions * Work with Date & Time Functions * Work with Text Functions Working with Lists * Sort Data * Filter Data * Query Data with Database Functions * Outline and Subtotal Data Analyzing Data * Apply Intermediate Conditional Formatting * Apply Advanced Conditional Formatting Visualizing Data with Charts * Create Charts * Modify and Format Charts * Use Advanced Chart Features Using PivotTables and PivotCharts * Create a PivotTable * Analyze PivotTable Data * Present Data with PivotCharts * Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks * Use Links and External References * Use 3-D References * Consolidate Data * Using Lookup Functions and Formula Auditing * Use Lookup Functions * Trace Cells * Watch and Evaluate Formulas Sharing and Protecting Workbooks * Collaborate on a Workbook * Protect Worksheets and Workbooks Automating Workbook Functionality * Apply Data Validation * Search for Invalid Data and Formulas with Errors * Work with Macros Creating Sparklines and Mapping Data * Create Sparklines * MapData Forecasting Data * Determine Potential Outcomes Using Data Tables * Determine Potential Outcomes Using Scenarios * Use the Goal Seek Feature * Forecasting Data Trends Excel Templates * Excel Templates CPD 11 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? The Microsoft Office Essentials - 3 Course Bundle has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Office Essentials - 3 Course Bundle. REQUIREMENTS Enrol on the Microsoft Office Essentials - 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials - 3 Course Bundle without any delay. CERTIFICATES CPD ACCREDITED CERTIFICATE Digital certificate - Included CPD ACCREDITED CERTIFICATE Hard copy certificate - £29

DESCRIPTION Learn to create data dashboard and visualization within minutes using Microsoft Power BI. Microsoft Power BI - Master Power BI in 90 Minutes! course teaches you how to transform your data into live dashboards and reports and helps you to find answers to your company's most important questions. Microsoft Power BI is data visualization software. It is a business analytics service provided by Microsoft that will deliver insights throughout your organization.  You can connect hundreds of data sources. It simplifies data prep and drives ad hoc analysis. Microsoft Power BI - Master Power BI in 90 Minutes! course covers all the essential features and usage of Microsoft Power BI and guides you to use the program for organizing your business tasks. Throughout the course, you will learn how to unify data from many sources to create interactive, immersive dashboards and reports which will provide actionable insights and drive business results. ASSESSMENT: * At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. * Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. CERTIFICATION: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. WHO IS THIS COURSE FOR? Microsoft Power BI - Master Power BI in 90 Minutes! is certified by CPD Qualifications Standards and CiQ. This makes it 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. REQUIREMENTS Our Microsoft Power BI - Master Power BI in 90 Minutes! 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 PATH After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Power BI - Introduction Overview of Power BI Course 00:02:00 Power BI Intro 00:03:00 03 - Power BI High Level Flow 00:02:00 04 - Install and Sign Up 00:03:00 05 - Power Query Intro 00:05:00 06 - Power Pivot Intro 00:01:00 07 - Power View Intro 00:02:00 Your First Power BI Dashboard 08 - Big Picture 00:02:00 09 - Get Data 00:07:00 10 - How to Get More Data 00:01:00 11 - Modelling Data 00:03:00 12 - Adding Relationships Manually 00:02:00 13 - Visualization 00:05:00 14 - Visualization Customization 00:01:00 15 - More Visualizations 00:02:00 16- Visualization Format and Analytics 00:03:00 17 - Ask a Question 00:02:00 Your Advanced Power BI Dashboard with Real Live Data Adv 01 - Real World Example 00:06:00 Adv 02 - Get Data 00:13:00 Adv 03 - Modelling Data 00:05:00 Adv 04 - Visualization with multiple charts 00:11:00 Adv 05 - Publishing 00:05:00 Adv 06 - Power BI Website 00:08:00 Course Bounses FINAL 00:01:00 Resources Resources - Microsoft Power BI - Master Power BI in 90 Minutes! 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

5-in-1 Exclusive Microsoft Excel Bundle Course!!! Come and join in, on this exceptionally designed Microsoft Excel bundle course to transform yourself into an Excel wizard, regardless of your current skill level. With over 80% of jobs now requiring Excel skills in the UK, the ability to navigate and master this tool is more than just a resume booster-it's a necessity. From basics to advanced formulas, and even automated dashboards, this bundle is your golden ticket to unlocking the full potential of Excel, making data analysis and presentation not just easier, but a true delight. This comprehensive bundle starts by guiding you through Beginner, Intermediate, and Advanced levels of Excel. You'll then explore the Newest Functions and dive deep into 25 Must-know Formulas and Functions that are game-changers. But we don't stop there; you'll learn to create Automated Dashboards using Advanced Formulas, VBA, and Power Query, and even get a mastery tour of the entire Microsoft Office Suite, including Word, PowerPoint, and 365. It's a well-rounded education designed to make you proficient and efficient in handling any task Excel throws your way. The Microsoft Excel Course includes these 5 Premium Courses: * Course 01: Microsoft Excel - Beginner, Intermediate & Advanced * Course 02: New Functions in Microsoft Excel * Course 03: Microsoft Excel - 25 Must-Know Formulas and Functions * Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query * Course 05: Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Streamline your business processes, or just attempt to upskill for personal satisfaction, our Microsoft Excel Bundle Course is the leap forward you've been waiting for. In today's data-driven world, being Excel-savvy isn't just an asset; it's a must-have skill. Join us on this journey to becoming an Excel expert and open doors to endless career opportunities. Enrol now! Learning Outcomes of Microsoft Excel Course: * Navigate Excel from basic operations to advanced functionalities confidently. * Master new functions and 25 essential formulas in Excel. * Design and implement automated dashboards with VBA and Power Query. * Utilise the full suite of Microsoft Office for professional use. * Analyse and present data effectively using Excel. * Increase workplace productivity with advanced Excel skills. Why Choose Our Microsoft Excel Course? * Get a Free CPD Accredited Certificate upon completion of Microsoft Excel course. * Get a free student ID card with Microsoft Excel Training. * Get instant access to this Microsoft Excel course. * Learn Microsoft Excel from anywhere in the world. * This Microsoft Excel course is affordable and simple to understand. * The Microsoft Excel course is an entirely online, interactive lesson with voiceover audio. * Lifetime access to the Microsoft Excel course materials. * The Microsoft Excel course comes with 24/7 tutor support. Start your learning journey straight away! Course 01: Microsoft Excel - Beginner, Intermediate & Advanced * Module 01: Excel From A-Z Course Introduction * Module 02: Getting Started With Excel * Module 03: Values, Referencing And Formulas * Module 04: Intro To Excel Functions * Module 05: Adjusting Excel Worksheets * Module 06: Visually Pleasing Cell Formatting * Module 07: How To Insert Images And Shapes! * Module 08: Visualize Data With Charts * Module 09: Excel's Printing Options * Module 10: Benefits Of Using Excel Templates * Module 11: Working With Excel Datasets * Module 12: Excel Database Functions * Module 13: Excel Data Validation * Module 14: Excel PivotT ables * Module 15: Excel's Power Pivot Add-In * Module 16: Excel's Conditional Functions * Module 17: Excel's Lookup Function * Module 18: Text Based Functions In Excel * Module 19: Auditing Formulas And Views In Excel * Module 20: Excel's 'What If?' Tools * Module 21: Welcome To Excel VBA * Module 22: The VBA Language * Module 23: Writing VBA Code * Module 24: Important VBA Tools And Logic * Module 25: Excel VBA Lopps * Module 26: Triggering Macros * Module 27: Excel User Forms * Module 28: Starting A Career In Excel Course 02: New Functions in Microsoft Excel * Module 01: Introduction and Agenda * Module 02: RANDARRAY * Module 03: UNIQUE * Module 04: SEQUENCE * Module 05: SORT and SORTBY * Module 06: SORT A Practical Example * Module 07: FILTER * Module 08: FILTER A Practical Example * Module 09: Other Useful New Functions * Module 10: Using the New Functions in Reports Course 03: Microsoft Excel - 25 Must-Know Formulas and Functions * Module 01: 25 Must-Know Formulas and Functions =========>>>>> And 2 More Courses <<<<<========= This course's curriculum has been designed by Microsoft Excel experts with years of Microsoft Excel experience behind them. The Microsoft Excel course is extremely dynamic and well-paced to help you understand Microsoft Excel with ease. You'll discover how to master the Microsoft Excel skill while exploring relevant and essential topics. 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 £12.99*5 = £65) CPD 50 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: * Job seekers * Office professionals * Data analysts * Business owners * Students * Career improvers REQUIREMENTS You will not need any prior background or expertise to enrol in this bundle. CAREER PATH After completing this bundle, you are to start your career or begin the next phase of your career. * Data Analyst - £30,000 to £50,000 * Financial Analyst - £35,000 to £60,000 * Administrative Assistant - £20,000 to £30,000 * Project Manager - £40,000 to £70,000 * Business Analyst - £35,000 to £65,000 * Accountant - £25,000 to £50,000 CERTIFICATES CPD ACCREDITED CERTIFICATE Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD. CPD ACCREDITED CERTIFICATE Hard copy certificate - £29 * Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. * If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Microsoft Office Skills Diploma (Excel, Word, PowerPoint) + Office Skills for Administration Being proficient in Microsoft Office isn't just an advantage-it's become essential. With over 1.2 billion people worldwide using Microsoft Office and UK businesses increasingly relying on digital tools for efficiency, mastering these applications can significantly boost your career prospects. The Microsoft Office Skills Diploma offers an all-encompassing curriculum designed to elevate your expertise from basic functionalities to advanced data analysis and automation techniques, ensuring you stand out in the competitive job market. This Microsoft Office Skills Diploma covers everything from Office 365 Automation to Advanced Excel, including Data Management, Microsoft Word, PowerPoint, Outlook, Power BI, and VBA, along with collaborative tools like Teams. master Pivot Tables, Charts, and more, gaining a comprehensive skill set in Microsoft Office's most powerful features for professional growth. Courses are included in this Microsoft Office Package: * Course 01: Microsoft Office 365 Automation Course * Course 02: Microsoft Office Excel - Beginner, Intermediate & Advanced * Course 03: Diploma in Complete Excel Course for All at QLS Level 5 * Course 04: Microsoft Office (Microsoft Word, PowerPoint & Outlook) In 90 Minutes! * Course 05: Office Skills for Administration Diploma * Course 06: Microsoft Office Power BI Masterclass 2021 * Course 07: Microsoft Excel: Excel Sheet Comparison with VBA * Course 08: Microsoft Teams for Everyone * Course 09: Microsoft Excel - 25 Must-Know Formulas and Functions * Course 10: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Open a gateway to numerous career opportunities, enhancing your ability to manage. Analyse and present data effectively with this Microsoft Office Skills Diploma bundle. Join us on this journey to become a Microsoft Office expert and take your professional abilities to the next level! Learning outcome of this Microsoft Office Skills Diploma (Excel, Word, PowerPoint) + Office Skills for Administration - CPD Certified Course: * Automate tasks and workflows in Microsoft Office 365 efficiently. * Master Excel from basic operations to advanced data analysis and visualisation. * Utilise Word, PowerPoint, and Outlook to their full potential. * Analyse data with Power BI and create impactful visual reports. * Automate Excel sheet comparisons using VBA for enhanced productivity. * Design and manage advanced Excel features like pivot tables and charts. Why Prefer this Course? * Get a chance to order a QLS Endorsed Certificate upon completion of the course * Get a Free Student ID Card with this training program * The course is Affordable and Simple to understand * Get Lifetime Access to the course materials * The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Microsoft Office 365 Automation Course * Module 01: Microsoft Office 365 Automation Course 02: Microsoft Office Excel - Beginner, Intermediate & Advanced * Module 01: Excel From A-Z Course Introduction * Module 02: Getting Started With Excel * Module 03: Values, Referencing And Formulas * Module 04: Intro To Excel Functions * Module 05: Adjusting Excel Worksheets * Module 06: Visually Pleasing Cell Formatting * Module 07: How To Insert Images And Shapes! * Module 08: Visualize Data With Charts * Module 09: Excel's Printing Options * Module 10: Benefits Of Using Excel Templates * Module 11: Working With Excel Datasets * Module 12: Excel Database Functions * Module 13: Excel Data Validation * Module 14: Excel Pivot Tables * Module 15: Excel's Power Pivot Add-In * Module 16: Excel's Conditional Functions * Module 17: Excel's Lookup Function * Module 18: Text Based Functions In Excel * Module 19: Auditing Formulas And Views In Excel * Module 20: Excel's 'What If?' Tools * Module 21: Welcome To Excel VBA * Module 22: The VBA Language * Module 23: Writing VBA Code * Module 24: Important VBA Tools And Logic * Module 25: Excel VBA Lopps * Module 26: Triggering Macros * Module 27: Excel User Forms * Module 28: Starting A Career In Excel Course 03: Microsoft Excel Course for Everyone - Complete Excel Course * Module 01: Getting Started * Module 02: Excel Basics * Module 03: Excel Essential Functions * Module 04: XLookup Only For Excel 2021 And Office 365 * Module 05: Get Data And Tools * Module 06: Formatting Data And Tables * Module 07: Pivot Tables * Module 08: Excel Charts * Module 09: Advanced Excel Charts * Module 10: Pivot Charts * Module 11: Maps Chart Above 2019 * Module 12: Business-Geo Charts * Module 13: Named Ranges * Module 14: Import Data Into Excel * Module 15: Advanced Excel =========>>>>> And 7 More Courses <<<<<========= Assessment Process Once you have completed all the modules on the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 100 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: * Microsoft Office users of all levels. * Individuals seeking Excel expertise. * Professionals aiming to automate tasks. * Those looking to boost Office Skills for Administration skills. * Quick learners of Word, PowerPoint, and Outlook. * Aspiring data analysts. REQUIREMENTS You will not need any prior background or expertise to enrol in this Microsoft Office Skills Course. CAREER PATH After completing this bundle, you are to start your career or begin the next phase of your career. * Microsoft Office Expert: £18,000 - £30,000 * Data Analyst: £25,000 - £50,000 * Business Analyst: £30,000 - £60,000 * Office Administrator: £18,000 - £30,000 * Power BI Developer: £35,000 - £70,000 CERTIFICATES CPD ACCREDITED DIGITAL CERTIFICATE Digital certificate - £12.99 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 - £29 Please note that International students have to pay an additional £10 as a shipment fee. DIPLOMA IN COMPLETE EXCEL COURSE FOR ALL - QLS ENDORSED Hard copy certificate - £119 Please note that International students have to pay an additional £10 as a shipment fee

Microsoft Excel 2019 for Beginner course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease. Key Features of the Microsoft Excel 2019 for Beginner Course : * Instant e-certificate and hard copy dispatch by next working day * Fully online, interactive course with audio voiceover * Developed by professionals in the field * Self-paced learning and laptop, tablet, smartphone-friendly * 24/7 Learning Assistance * Discounts on bulk purchases *** Additional Gifts *** * Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Microsoft Excel 2019 for Beginner course is as follows: ***Microsoft Excel 2019*** Microsoft Excel 2019 New Features * Introduction to Microsoft Excel 2019 New Features * CONCAT * IFS * MAXIFS * MINIFS * SWITCH * TEXTJOIN * Map Chart * Funnel Chart * Better Visuals * Pivot Table Enhancements * Power Pivot Updates Getting Started with Microsoft Office Excel * Navigate the Excel User Interface * Use Excel Commands * Create and Save a Basic Workbook * Enter Cell Data * Use Excel Help Performing Calculations * Create Worksheet Formulas * Insert Functions * Reuse Formulas and Functions Modifying a Worksheet * Insert, Delete, and Adjust Cells, Columns, and Rows * Search for and Replace Data * Use Proofing and Research Tools Formatting a Worksheet * Apply Text Formats * Apply Number Format * Align Cell Contents * Apply Styles and Themes * Apply Basic Conditional Formatting * Create and Use Templates Printing Workbooks * Preview and Print a Workbook * Set Up the Page Layout * Configure Headers and Footers Managing Workbooks * Manage Worksheets * Manage Workbook and Worksheet Views * Manage Workbook Properties Working with Functions * Work with Ranges * Use Specialized Functions * Work with Logical Functions * Work with Date & Time Functions * Work with Text Functions Working with Lists * Sort Data * Filter Data * Query Data with Database Functions Outline and Subtotal Data Analyzing Data * Apply Intermediate Conditional Formatting * Apply Advanced Conditional Formatting Visualizing Data with Charts * Create Charts * Modify and Format Charts * Use Advanced Chart Features Using PivotTables and PivotCharts * Create a PivotTable * Analyze PivotTable Data * Present Data with PivotCharts * Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks * Use Links and External References * Use 3-D References * Consolidate Data Using Lookup Functions and Formula Auditing * Use Lookup Functions * Trace Cells * Watch and Evaluate Formulas Sharing and Protecting Workbooks * Collaborate on a Workbook * Protect Worksheets and Workbooks Automating Workbook Functionality * Apply Data Validation * Search for Invalid Data and Formulas with Errors * Work with Macros Creating Sparklines and Mapping Data * Create Sparklines * MapData Forecasting Data * Determine Potential Outcomes Using Data Tables * Determine Potential Outcomes Using Scenarios * Use the Goal Seek Feature * Forecasting Data Trends WHO IS THIS COURSE FOR? Anyone with a knack for learning new skills can take this Microsoft Excel 2019 for Beginner course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Accreditation All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. REQUIREMENTS The Microsoft Excel 2019 is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. CAREER PATH This course will give you a comprehensive understanding of the Microsoft Excel platform and assist you in pursuing several exciting employment opportunities, such as - * Administrative Assistant * Accountants * Business Analyst * Cost Estimator * Data Entry Specialist * Project Manager And many more! These job prospects pay an average of £15k to £55k a year in the UK. CERTIFICATES DIGITAL CERTIFICATE Digital certificate - Included HARD COPY CERTIFICATE Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 97% of UK businesses use Microsoft Office? Mastering Microsoft Word is a valuable skill for almost any job role. Do you struggle with formatting documents, creating professional layouts, or using mail merge? This comprehensive Complete Microsoft Word bundle can help! This complete Microsoft Word bundle offers a variety of courses designed to take you from beginner to expert. Learn the fundamentals of creating, editing, and formatting documents. Discover advanced features like tables, mail merge, macros, and more. Beyond Word, the bundle includes additional courses on Excel, PowerPoint, Microsoft Teams, and Outlook, giving you a well-rounded skillset for office productivity. Our Microsoft Office Bundle Course contains 10 of our popular courses for one discounted price: * Course 01: Learn Microsoft Word, PowerPoint & Outlook * Course 02: Complete Microsoft Word * Course 03: Microsoft Excel Complete Course * Course 04: PowerPoint * Course 05: The Ultimate Microsoft Teams Complete Training Bundle (2020) * Course 06: Microsoft Outlook Advanced Course * Course 07: Excel Training: Depreciation Accounting * Course 08: Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Learn from relevant industry professionals and quickly equip yourself with the specific knowledge and skills needed to excel in your chosen career through the Microsoft Office bundle training. Expand your expertise with high-quality training - study the Microsoft Office course and get an expertly designed training experience. Learning Outcomes of Complete Microsoft Word * Create professional documents with effective formatting. * Utilise tables, charts, and graphics to enhance communication. * Automate tasks with formulas and macros (Excel). * Collaborate seamlessly with colleagues using Microsoft Teams. * Manage emails efficiently with advanced Outlook features. * Develop presentations that engage and inform your audience (PowerPoint). You'll get a Free Student ID card by enrolling in this Bundle course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the Bundle will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Bundle Course. Why Choose Us? * Get a Free CPD Accredited Certificate upon completion of Microsoft Word * Get a free student ID card with Microsoft Word Training program (£10 postal charge will be applicable for international delivery) * The Microsoft Word is affordable and simple to understand * This course is entirely online, interactive lesson with voiceover audio * Get Lifetime access to the Microsoft Word course materials * The Microsoft Word comes with 24/7 tutor support Start your learning journey straight away with this Bundle course and take a step toward a brighter future! ****Course Curriculum**** Course 01: Learn Microsoft Word, PowerPoint & Outlook Microsoft Word Essentials * New Word Document and Templates * Tabs, Ribbons and Groups * Zoom and Rulers in Word * Editing the Word Document * Insert Pictures with Word * Insert Shape and Text Box in Word * Review Tab in Word * Layout in Word * File Options in Word * Closing and Reopening in Word Course 02: Complete Microsoft Word Manipulating Images * Integrate Pictures and Text * Adjust Image Appearance * Insert Other Media Elements Using Custom Graphic Elements * Create Text Boxes and Pull Quotes * Add WordArt and Other Text Effects * Draw Shapes * Create Complex Illustrations with SmartArt Collaborating on Documents * Prepare a Document for Collaboration * Mark Up a Document * Review Markups * Merge Changes from Other Documents Adding Document References and Links * Add Captions * Add Cross References * Add Bookmarks * Add Hyperlinks * Insert Footnotes and Endnotes * Add Citations and a Bibliography Securing a Document * Suppress Information * Set Formatting and Editing Restrictions * Restrict Document Access * Add a Digital Signature to a Document Using Forms to Manage Content * Create Forms * Modify Forms Automating Repetitive Tasks with Macros * Automate Tasks by Using Macros * Create a Macro Course 03: Microsoft Excel Complete Course Microsoft Excel 2019 New Features * Introduction to Microsoft Excel 2019 New Features * CONCAT * IFS * MAXIFS * MINIFS * SWITCH * TEXTJOIN * Map Chart * Funnel Chart * Better Visuals * Pivot Table Enhancements * Power Pivot Updates Getting Started with Microsoft Office Excel * Navigate the Excel User Interface * Use Excel Commands * Create and Save a Basic Workbook * Enter Cell Data * Use Excel Help Performing Calculations * Create Worksheet Formulas * Insert Functions * Reuse Formulas and Functions Modifying a Worksheet * Insert, Delete, and Adjust Cells, Columns, and Rows * Search for and Replace Data * Use Proofing and Research Tools Formatting a Worksheet * Apply Text Formats * Apply Number Format * Align Cell Contents * Apply Styles and Themes * Apply Basic Conditional Formatting * Create and Use Templates Printing Workbooks * Preview and Print a Workbook * Set Up the Page Layout * Configure Headers and Footers Managing Workbooks * Manage Worksheets * Manage Workbook and Worksheet Views * Manage Workbook Properties Working with Functions * Work with Ranges * Use Specialized Functions * Work with Logical Functions * Work with Date & Time Functions * Work with Text Functions Working with Lists * Sort Data * Filter Data * Query Data with Database Functions * Outline and Subtotal Data Analyzing Data * Apply Intermediate Conditional Formatting * Apply Advanced Conditional Formatting Visualizing Data with Charts * Create Charts * Modify and Format Charts * Use Advanced Chart Features Using PivotTables and PivotCharts * Create a PivotTable * Analyze PivotTable Data * Present Data with PivotCharts * Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks * Use Links and External References * Use 3-D References * Consolidate Data Using Lookup Functions and Formula Auditing * Use Lookup Functions * Trace Cells * Watch and Evaluate Formulas Sharing and Protecting Workbooks * Collaborate on a Workbook * Protect Worksheets and Workbooks Automating Workbook Functionality * Apply Data Validation * Search for Invalid Data and Formulas with Errors * Work with Macros Creating Sparklines and Mapping Data * Create Sparklines * MapData Forecasting Data * Determine Potential Outcomes Using Data Tables * Determine Potential Outcomes Using Scenarios * Use the Goal Seek Feature * Forecasting Data Trends Excel Templates * Excel Templates =========>>>>> And 5 More Courses <<<<<========= 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 £12.99*8 = £103) * CPD Hard Copy Certificate: £29.99 CPD 80 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: * Students * Graduates * Admin Staff * Business Professionals * Entrepreneurs * Freelancers REQUIREMENTS You will not need any prior background or expertise to enrol in this bundle. CAREER PATH After completing this bundle, you are to start your career or begin the next phase of your career. * Office Manager * Virtual Assistant * Data Analyst * Project Manager * Marketing Specialist * Business Analyst 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 - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

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: 1. Acquire proficiency in using Excel Power Query for efficient data management. 2. Master the art of transforming raw data into actionable insights. 3. Learn advanced techniques for data manipulation and analysis. 4. Develop the ability to streamline complex data processes. 5. 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 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 8. 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 1. Data Analyst: £25,000 - £40,000 Per Annum 2. Business Analyst: £30,000 - £50,000 Per Annum 3. Financial Analyst: £28,000 - £45,000 Per Annum 4. Marketing Analyst: £24,000 - £40,000 Per Annum 5. Operations Analyst: £26,000 - £42,000 Per Annum 6. 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