Get certified online, master technical and soft skills, and stand out to clients–no prior experience necessary
Skills You’ll Gain:
Financial Planning, Practice Management, Business Dev, Relationship Management, Investment Management, and more
Great For:
Financial Planning, Investment Advisement, Portfolio Management, Retail, Private Banking, and more
MS-EDA program: 15 total courses, 16 required for exam eligibility
Training session and Self-paced & 100% online
The five days workshop training on Advanced Microsoft Office Excel for Data Analysis and Automation (MASTER CLASS) is an interactive and practical workshop intended to increase efficiency and effectiveness by equipping you with comprehensive knowledge and experience in designing Data Analysis using Advanced formulas and functionalities in Microsoft Excel. Participants will also learn how to automate everyday tasks, apply advanced analysis techniques to more complex data sets, and leverage Excel's advanced functionality to simplify and streamline their day-to-day tasks.
Master advanced Excel techniques for data analysis, automation, and business intelligence. Learn to leverage powerful formulas, functions, and tools
Master Excel’s Advanced Features: This course will equip participants with advanced Excel skills, including customising the user interface, utilising top Excel shortcuts, and managing workbooks and worksheets to enhance efficiency in daily tasks.
Data Management and Analysis: This course will enable participants to handle large datasets proficiently, perform complex data manipulation, and apply advanced sorting and formatting techniques for accurate data presentation and analysis.
Excel for Financial Data Analysis: Teach participants how to use Excel’s advanced tools for financial data analysis, including logical functions, lookup functions, and conditional formatting, to improve data-driven decision-making.
PivotTables and Power Query: Instruct participants on creating and customizing PivotTables and using Power Query for data transformation, summarization, and analysis, ensuring seamless data integration from multiple sources.
Automation of Routine Tasks: Empower participants to automate repetitive tasks using Excel’s advanced features, including calculated fields, custom filters, and advanced charting, to increase productivity and efficiency.
Practical Application and Real-World Scenarios: Provide hands-on experience with real-world datasets and scenarios, allowing participants to apply their learning directly to their professional roles in accounting, finance, and auditing.
Dr. CPA David Dickson Kiwia
Founder and Managing Director
At African Hub of Business and Technology, we believe that people are the driving force behind innovation, growth, and success. Our mission is to empower individuals and organizations by providing exceptional opportunities for learning and career advancement in the ever-evolving world of business and technology.
Master advanced Excel techniques for data analysis, automation, and business intelligence. Learn to leverage powerful formulas, functions, and tools
interactive and practical workshop intended to increase your efficiency and effectiveness by equipping you with comprehensive knowledge and experience in designing, preparing and automating Financial Statements and Payroll using Advanced formulas and functionalities in Microsoft Excel
Master essential project management skills for development sector success. Learn strategic planning, stakeholder engagement, and impact-focused execution techniques.
Enhance senior management skills in audit oversight and risk governance. Learn strategic approaches to internal controls, compliance, and enterprise risk management.
List of Excel Shortcuts... worth the investment to take the time...
Complete resource covering model design and common tips...
The Structured Query Language... definitions and examples...