Curriculum
- 7 Sections
- 26 Lessons
- 5 Weeks
Expand all sectionsCollapse all sections
- 1. Introduction & Warm upMicrosoft Excel is more than just a spreadsheet tool; it's a dynamic platform for data analysis, automation, and decision-making. In this advanced course, we'll explore the features and techniques that will transform you from an Excel user to an Excel expert.1
- 2. Advanced Formulas and FunctionsLearn to create complex formulas, including nested functions and array formulas, to handle intricate data scenarios.9
- 3. Data AnalyticsExplore the world of Big Data Analytics with Excel. Learn pivot tables and pivot charts, gaining proficiency in their creation, customization, and integration with Power Pivot. • Dive into data transformation with Power Query, and explore data modeling and analysis with Power Pivot and DAX functions. • Elevate your data analysis skills with advanced sorting, filtering, and statistical functions. Utilize Scenario Manager and Solver for in-depth analysis.3
- 4. Automation in MS ExcelDiscover the efficiency of automation using macros and delve into the fundamentals of VBA (Visual Basic for Applications) for unparalleled customization.2
- 5. Advanced Excel DashboardsMicrosoft Excel Dashboard help user visualizes complex scenarios and problem better. Manager with the help of Advanced Excel dashboard can make better business decisions. This course accelerates data analysis and reporting, teaching efficient creation of powerful calculations, KPIs, and metrics in Excel. It covers advanced techniques like mapping data in dashboards and explores three dashboard types, emphasizing Pivot tables, functions, and macros for Excel proficiency.3
- 6. Data CleaningThe Data Cleaning Course in MS Excel aims to equip participants with fundamental to advanced skills for ensuring data accuracy in analytics. It covers techniques such as removing duplicates, error detection, and advanced transformations using Power Query. The course emphasizes practical application, fostering best practices and enabling participants to contribute to informed decision-making with reliable, cleaned datasets in professional scenarios.2
- 7. Trouble Shooting & OptimizingThe "Troubleshooting and Optimizing in Excel" course aims to enhance participants' skills in identifying and resolving issues within Excel spreadsheets. Covering advanced troubleshooting techniques and optimization strategies, participants will learn to address common errors, streamline complex calculations, and optimize large datasets. The course emphasizes the use of Excel's diagnostic tools for efficient problem-solving, ultimately enabling participants to navigate and optimize Excel workbooks effectively in professional settings.6
Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access lots of exercise files relevant to the lessons. You will also have the option to register for additional online classes to enable you access to our hand-on expert lecturer.
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an in-depth knowledge about the topic.
Yes absolutely & that's one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos multiple times & so on.
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligible to get certificate of course completion.
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Please write to us at info@wits.ac.ke or call us on the number on our website and our support team will get back to you as soon as possible.
Requirements
- Knowledge of Basic MS Excel
- Some Previous Working With Excel
- Installed MS Excel to follow lectures
Features
- 1. Advanced Formulas, Functions and Array Formulas
- 2. Data Analytics Techniques: Excel for BI
- 3. Data Analytics: Pivot Tables, Pivot Charts, Power Query and Power Pivot
- 4. Automation: Macros and VBA (Visual Basic for Applications):
- 5. Advanced Excel Dashboards: Charting and Graphing
- 6. Data Cleaning
- 7. Troubleshooting and Optimizing
Target audiences
- Finance and Accounting Professionals
- Finance Analysts, Data Analysts and MIS Teams
- Managers, Planners and Analysts
- Business Planners & BI Teams
- Project Managers
- Financial Modelling and Budgeting Teams
- HR & Administrative & Professionals
- Marketing Professionals
- Professionals Seeking Career Advancement