Microsoft Excel Training (Automated Dashboard Using Advanced Formula, VBA & Power Query)

StudyHub

CPD Accredited Hard Copy Certificate

Hard copy certificate - Included

CPD Accredited PDF Certificates

Digital certificate - Included

MCQ/Assessment

Included in course price

The Microsoft Excel Training (Automated Dashboard Using Advanced Formula, VBA & Power Query) bundle gives you a complete view of how to manage, analyse and present data using Excel and related Microsoft tools. You’ll explore Excel from Level 3 through to advanced functions, new Excel 2021 features, automated dashboards, Power Query, formulas, data analysis and pivot tables. You’ll also extend your skills into Microsoft Project, Teams, Word, PowerPoint, Power BI and Outlook, plus Access databases for structured data storage and reporting.

• Course 01: Microsoft Excel Level 3 — Core Level 3 Excel skills for managing data, formulas and worksheets.
• Course 02: New Functions in Microsoft Excel 2021 — Modern Excel 2021 functions to streamline calculation and analysis.
• Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query — Building automated dashboards that update with minimal manual work.
• Course 04: Microsoft Excel: Excel Sheet Comparison with VBA — Comparing sheets and tracking changes using VBA.
• Course 05: Microsoft Excel: Master Power Query in 120 Minutes! — Importing, cleaning and transforming data efficiently with Power Query.
• Course 06: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! — Mastering the most important formulas for everyday work.
• Course 07: Document Control — Managing documents and versions to keep data and files organised.
• Course 08: Touch Typing Essentials — Increasing typing speed and accuracy for faster spreadsheet and office work.
• Course 09: Office Skills and Administration Management Diploma — Practical office and admin skills to support daily operations.
• Course 10: Data Protection and Data Security Level 2 — Understanding how to handle and protect data responsibly.
• Course 11: Planning & Control Using Microsoft Project 2013, 2016 & 2019 — Planning tasks and tracking projects using Microsoft Project.
• Course 12: Microsoft Teams — Collaborating, sharing files and working with colleagues through Teams.
• Course 13: Excel Pivot Tables — Summarising and exploring data using pivot tables.
• Course 14: Data Analysis in Microsoft Excel Complete Training — Applying Excel tools for structured data analysis.
• Course 15: Excel Must know Formulas and Functions — Essential formulas and functions every Excel user should know.
• Course 16: Excel spreadsheet for Beginner — Starting from basics and building confidence with spreadsheets.
• Course 17: Excel Data Analysis — Turning raw data into meaningful insights using Excel techniques.
• Course 18: Excel Vlookup, Xlookup, Match and Index — Using lookup and reference functions to pull the right data quickly.
• Course 19: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines — Creating interactive views of data with pivot features.
• Course 20: MS Word Diploma — Producing professional documents, reports and written outputs.
• Course 21: Proofreading & Copyediting — Checking and correcting written material for clarity and accuracy.
• Course 22: PowerPoint Diploma — Designing clear and effective presentations from your data.
• Course 23: PowerBI Formulas — Applying formulas in Power BI to support advanced reporting.
• Course 24: Outlook Tips and tricks — Managing email, calendar and tasks more efficiently.
• Course 25: Excel PowerQuery and PowerPivot — Working with Power Query and PowerPivot for larger and more complex datasets.
• Course 26: Complete Microsoft Power BI 2021 — Building interactive dashboards and reports in Power BI.
• Course 27: The Complete Microsoft Outlook Masterclass — Using Outlook to manage communication and scheduling at a professional level.
• Course 28: Microsoft Access Complete Course (Beginner, Intermediate, Advanced) — Creating and managing databases to support your Excel reporting.
• Course 29: Microsoft Access Tables and Queries — Designing tables and queries to structure and retrieve data.
• Course 30: Microsoft Access Databases Forms and Reports — Building forms and reports to input and present data effectively.

• Course 01: Career Development Plan Fundamentals — Plan a structured Excel and data-focused career path.
• Course 02: CV Writing and Job Searching — Present your Excel, dashboard and data skills professionally.
• Course 03: Interview Skills: Ace the Interview — Communicate your spreadsheet and reporting experience confidently.
• Course 04: Video Job Interview for Job Seekers — Perform effectively in online interviews for data-heavy roles.
• Course 05: Create a Professional LinkedIn Profile — Position yourself as a strong Excel and data professional.
• Course 06: Business English Perfection Course — Improve communication when presenting figures and reports.
• Course 07: Networking Skills for Personal Success — Build useful connections with analysts, managers and decision-makers.
• Course 08: Boost Your Confidence and Self-Esteem — Share your analysis and recommendations with more confidence.
• Course 09: Public Speaking Training — Present dashboards and findings clearly in meetings.
• Course 10: Learn to Fight Procrastination — Stay consistent with learning, practice and project completion.

After successfully completing the learning and assessment for the Microsoft Excel Training (Automated Dashboard Using Advanced Formula, VBA & Power Query) bundle, you’ll receive a digital PDF Certificate and Transcript. Original Hard Copy certificates must be bought separately for an extra £8.

• Aspiring and junior data or reporting professionals
  
  
• Office staff who rely on Excel and want to work at an advanced level
  
  
• Managers and team leaders who need clear dashboards and reports
  
  
• Career-changers moving into data, analysis or office support roles
  
  
• Anyone who wants to use Excel and Microsoft tools to make smarter, faster decisions

There are no formal prerequisites or qualifications required. The course is designed to be accessible to learners from all educational and professional backgrounds.

This Microsoft Excel Training (Automated Dashboard Using Advanced Formula, VBA & Power Query) bundle supports career development for roles across data analysis and office productivity, including:

• Excel Data Analyst – £26,000–£40,000
• Reporting Analyst – £27,000–£42,000
• Management Information (MI) Analyst – £30,000–£45,000
• Office Administrator (Advanced Excel) – £23,000–£32,000

Currently there are no Q&As for this course. Be the first to ask a question.