246 Pivot Table courses delivered Online

Master Excel in 2024 with our crash course! Learn essential tips, functions, and tools, including the exclusive XLOOKUP for Excel 2021 and Office 365, and unlock the full potential of data analysis.

Master Microsoft Office 2021 with our comprehensive course. From Excel to PowerPoint and Word, learn essential tools and techniques for enhanced productivity and efficiency.

This course will fully prepare you for virtually any Excel-related career path

Full Excel Course Beginner to Advanced 6hrs

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00

A special focus will be put on advanced MS Excel tips and tricks for career advancement in this course.

🚀 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

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.

Dive into the world of data like never before with this Power BI Training Course—where dashboards become a canvas and numbers finally make sense. Whether you're working with spreadsheets that never end or reports that need more punch, Power BI turns all that chaos into clear, useful insight. This course shows you how to shape data, build visuals, and tell a story your team will actually understand—without needing a maths degree or a magic wand. From sales figures to survey responses, learn how to make sense of it all using Microsoft's popular business intelligence tool. It doesn’t matter if you're from finance, marketing, logistics or even a tea-making department—if there's data, there’s Power BI. This course is fully online, so no awkward group exercises or cold meeting rooms involved—just clear, engaging learning designed to suit your pace. Whether you're fresh to the concept or already poking around with pivot tables, there's something here to sharpen your skills and make data feel less like a chore and more like a superpower. Curriculum Power BI - Introduction Overview of the Course Intro High-Level Flow Install and Sign Up Power Query Intro Power Pivot Intro Power View Intro Your First Power BI Dashboard Big Picture Get Data How to Get More Data Modelling Data Adding Relationships Manually Visualization Visualization Customization More Visualizations Visualization Format and Analytics Ask a Question Your Advanced Dashboard with Real Live Data Real World Example Get Data Modelling Data Visualization with multiple charts Publishing Power BI Website Course Bounses FINAL Key Features Accredited by CPD Instant e-certificate Fully online, interactive course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Accreditation All of our courses are fully accredited, including this Power BI course, 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 Power BI course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by CPD Quality Standards Requirements No prior degree or experience is required to enrol in this course. Certificates Certificate of completion Digital certificate - Included Certificate of completion 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.

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