Fully Accredited Program Certified Data Analytics Manager Using Excel (CDAME™)

Data analytics are transforming companies into global champions. One of the most successful companies globally today, Netflix, owe much of their success to data analytics. The global streaming company uses data analytics to help them understand their audience, improve customer experience, and develop new content. They even use it for internal purposes including planning, production optimization, and scheduling workflows.

This Certified Data Analytics Manager Using Excel (CDAME™) program will help you master the advanced analytics skills required to transform data into powerful insights. Led by Duncan Williamson, an award-winning author, you will learn how to harness the power of Excel to gain a solid understanding of analytics and the data stack. By getting familiar with the most used advanced Excel formulas and functions, you will also beef up your data analytics skills and leverage Excel to extract critical insights from raw data. Participants will also learn how to explain complex data with clarity by developing stunning visualizations and interactive dashboards

By the end of the program and upon passing the Chartered exam, you will have earned the Certified Data Analytics Manager Using Excel (CDAME™) designation which you can use to demonstrate your professional credentials and expertise in data analytics and business intelligence with the use of advanced Excel functions.

 

4.7 (2531 ratings)

This program will entitle you:

Download Brochure Pricing & Registration
  • Attain your Certified Data Analytics Manager Using Excel (CDAME™) designation that you can use across your professional credentials (including LinkedIn and CV)
  • Experience 3 days of instructor-led live program and in-depth learning on Data Analytics and Excel functions
  • 5 powerful industry case studies and best practices on effective data analysis  
  • For inquiries, chat with our Program Advisors at [email protected] or call us at
    • Singapore and Asia Pacific: +65 6716 9980
    • Australia and New Zealand: +61 3 9909 7310
    • UK, Europe and Middle East: +44 (020) 335 57898
    • USA: +1 888 745 8875

Accreditations

4.5

The Certified Data Analytics Manager Using Excel (CDAME™) is a mark of excellence and distinction that signifies a fully qualified data analytics professional with Microsoft Excel expertise and skill sets. It is accredited by the Chartered Institute of Professional Certifications, which maintains the governing standards for all members. The CDAME™ designation is a trademarked charter available only to professionals who have completed and passed this program. The certification is governed and maintained by Chartered Institute of Professional Certifications with over 90,000 members around the world. It is also endorsed by prominent associations and organizations worldwide.

The content of this program has also been fully certified and independently accredited by CPD as conforming to Continuing Professional Principles.

What Can You Expect

This Certified Data Analytics Manager Using Excel (CDAME™) is designed to help you become a data analytics expert by harnessing the power of Excel. You will learn how to convert large, unstructured data into powerful insights that can be useful for decision making, predictive modeling, and uncovering hidden trends. By using the latest advanced Excel formulas and functions, participants will gain a solid understanding of analytics and the data stack, improve their data manipulation skills and learn powerful techniques that can turn numbers into sophisticated knowledge. This program will also show you how to use Excel's advanced built-in data analysis features to analyze patterns within your data and leverage sophisticated tools to create stunning visualizations that can help you explain complex data with clarity.

By the end of the program and upon passing the Chartered exam, you will have earned the Certified Data Analytics Manager Using Excel (CDAME™) designation which you can use to demonstrate your professional credentials and expertise in data analytics and business intelligence with the use of advance Excel functions.

Globally demanded and recognized, this designation is an industry-recognized trademarked charter developed by the Chartered Institute of Professional Certifications and has lifelong validity. It’s also fully accredited by CIPD (Chartered Institute of Personnel and Development), with 160,000 membership organizations worldwide.

Key Skills You Will Gain

  • Data Analytics
  • Data Mining
  • Business Intelligence
  • Descriptive Statistics
  • Predictive Analytics
  • Advance Excel Functions
  • Text Analytics
  • Inferential Statistics
  • Data Processing
  • Data Visualization
  • Financial Analysis
  • Lookup Functions
  • Dynamic Array Functions
  • Data Cleaning
  • Data Consolidation
  • Regression Analysis
  • Data Exploration
  • Key Performance Indicators
  • Data Communication
  • Building Pivot Tables

Your Faculty Director

Duncan Williamson
Duncan Williamson
Award Winning Author, Faculty Leader and Contributor

Duncan Williamson is an author, trainer and business consultant specializing in Financial, Management Accounting and Spreadsheet Modelling with a sustained record of success established in the Financial and Commercial marketplaces. He is an inspirational presenter whose excellent communication skills have been demonstrated across countries and cultures assisting executive professionals to achieve their full potential. 

Duncan’s international experience includes multimillion dollars projects and consultancies carried out in the Middle East, Africa, Central Asia, South Asia, the Caucasus, the Balkans, Central Europe and Denmark. In addition to working as a consultant and trainer, Duncan worked in a wide variety of settings, ranging from working as a management accountant in process industries in the UK to product cost consulting in several industries in Eastern Europe and the Oil and Gas industry in the Middle East. 

Duncan has published widely over the years on cost and management accounting, and is a major contributor to various magazines, journals and websites. Duncan is a best-selling author across many financial books including "Excel Power Query". Prior to that, he has written “Excel Solutions for Accountants” in three volumes in June 2015, and “The Accounting and Bookkeeping Coach”, published in April 2014.

Program Agenda

Module 1 - The Types of Data Analytics
Module 2 - Data Analytics With Excel
Module 3 - Data Analysis
Module 4 - Using Lookup Functions And Dynamic Array Functions
Module 5 - More Advanced Data Analytics
Module 6 - Exploring Data
Module 7 - Hierarchies
Module 8 - Communication
Module 9 - More Advanced / Creative Examples
Module 10 - Data Analysis Case Studies
Examination

Chartered Exam

At the end of the program, there will be a Chartered exam comprised of 50 multiple-choice questions. Upon passing the exam, you will be accredited with your Certified Data Analytics Manager Using Excel (CDAME™) designation.

  • 98% of students who have taken this exam have passed the exam successfully. Almost all professionals who have taken our courses have passed this exam and attained their Certified Data Analytics Manager Using Excel (CDAME™) designation
  • The exam has 50 multiple-choice questions and you need to answer 25 out of 50 questions correctly to pass the exam
  • You can re-take the exam online as many times as you want, with no additional charges for retaking of exams
  • The program cost already includes the exam fees, so there are no additional charges for taking the exam

If you have challenges passing the exam, you can secure assistance from our team and faculty leader to help you pass the exam.

Certified Data Analytics Manager Using Excel (CDAME™) Designation

After completing the program and passing the exam, you will be awarded the Certified Data Analytics Manager Using Excel (CDAME™) Designation charter that can be used in your resume, CV, and other professional credentials. This designation is a global trademark and industry-recognized with lifelong validity.

Globally demanded and recognized, this designation will help you distinguish your skillsets and you have attained expertise in cleansing, transforming, and analyzing raw data to assist your businesses in making strategic decisions.

Pricing & Registration

Please select one of the locations:

Australia & New Zealand

Dates: 3 - 5 Apr 2023

Venue: Online Executive Program (via Zoom)

Time: 9:00am - 4:30pm Australian Eastern Standard Time (AEST)
11:00am - 6:30pm New Zealand Standard Time (NZST)


Early Bird Packages Regular Pricing
By 14 Feb 2023 By 28 Mar 2023 After 28 Mar 2023
Australia Delegates AUD 2,595 AUD 2,795 AUD 2,895
New Zealand Delegates NZD 2,595 NZD 2,795 NZD 2,895

Group Discount: 2nd participant get 10%, or register 3 participants and 4th participant get a complimentary seat (1 discount scheme applies).

Asia Pacific

Dates: 24 - 26 May 2023

Venue: Online Executive Program (via Zoom)

Time: 10:00am - 5:30pm Singapore Standard Time (SGT)


Early Bird Packages Regular Pricing
By 21 Mar 2023 By 02 May 2023 After 02 May 2023
Asia Pacific Countries Delegates SGD 2,595 SGD 2,795 SGD 2,895

Group Discount: 2nd participant get 10%, or register 3 participants and 4th participant get a complimentary seat (1 discount scheme applies) Note: GST is applicable to participants from Singapore registered companies.

Download Brochure

You can download our program brochure below. If you have any inquiries on this program, please contact our Program Advisor at [email protected] or call us at:

  • Singapore and Asia Pacific: +65 6716 9980
  • Australia and New Zealand: +61 3 9909 7310
  • UK, Europe and Middle East: +44 (020) 335 57898
  • USA: +1 888 745 8875

Download brochure Download Brochure

On Demand Learning

If you are unable to make it to this program due to the dates, you can also enroll in our program through our on-demand learning. Click on the link below to go to our on-demand learning to discover how you can enroll in the program and earn your Charter or certificate through our on-demand learning platform.

Go to Our On Demand Learning Here

Certified Data Analytics Manager Using Excel (CDAME™) Reviews and Testimonials

This is a great program if you want to enhance your data analytics skills to the next level. I would recommend it to anyone in the data analysis industry or want to learn more about data analysis.
This is a top-notch program. It's very detailed and professionally planned. Duncan is highly qualified and very knowledgeable on the topics he is covering and the real world examples he provides.
This course was very helpful in teaching me how to do things in Excel I never knew existed. The instructor did an excellent job at explaining the material and encouraging students.
I appreciated the resources that are available for the students to access, including case studies, sample projects and coding opportunities.
This is a very interactive training program, I like it very much. It's also helping me to understand the concepts and tools that are needed to be strong in data analytics.
I had a great time and learned a ton. The faculty leader did a really good job of making sure everyone was engaged and understanding the content that was being taught. It gave me a good insight to the program.

Convincing Your Boss To Attend This Program

Securing approval from your boss to attend this program can be difficult if you don’t know what to say. So we’ve prepared a template for you! All you need to do is to download this template, copy and paste in email and send it to your boss!

Download the Template Here

Certified Data Analytics Manager Using Excel (CDAME™)

4.7 (2531 ratings)