An Intensive 5-day Training Course
Data Analysis Techniques
Analysis Methods and Evidence-based
Decision-making using Microsoft Excel
Course Introduction
Everyone agrees that evidence-based decision making is the key to corporate high performance. In a world where everything is now measured and recorded, the data that companies hold can be a very rich and powerful source of evidence, but only if it can be analyzed and interpreted accurately and reliably. This Data Analysis Techniques training course shows delegates, by example, how to analyze and interpret data and hence how to make robust and defensible evidence-based business decisions.
The Data Analysis Techniques training course shows delegates how to use Microsoft Excel to perform a wide range of powerful analysis and interpretations, using real data. This is possible because, although most people are familiar with Microsoft Excel, they generally only use a small fraction of its true capability. This training course will show delegates how to make the most of Excel by explaining and demonstrating many of the very powerful analytical, visualization and interpretation capabilities that it is capable of.
This Oxford Management Centre training course will highlight how to:
- Approach a data analysis problem in a logical manner
- Maximize the accuracy of analysis and minimize the chance of errors
- Extract and represent information from complex numerical data
- Interpret features from within data and make evidence-based decisions
- Perform a ‘what if’ scenario analysis
- Predict the future behavior of a system or a process using regression analysis
- Predict the future behavior of a system or a process, using data science methods
- Use analysis of variance (ANOVA) to minimize the risk of false interpretation
- Make the most of Microsoft Excel by using many of the advanced features that it contains
Objectives
This Data Analysis Techniques training course aims to provide those involved in analyzing numerical data with the understanding and practical capabilities needed to convert data into information via appropriate analysis, how to represent these results in ways that can be readily communicated to others in the organization, and how to use the information to make evidence-based business decisions.
At the end of this Data Analysis Techniques training course, you will have:
- A good understanding and extensive practical experience of a range of common analytical techniques and interpretation methods for numerical data
- The ability to recognize which types of analysis are best suited to particular types of problems
- The ability to judge when an applied technique will likely lead to incorrect conclusions
- A good understanding of a wide range of common statistical methods and approaches
- The ability to use Microsoft Excel 2016, 2019 or 365 to analyze and interpret a wide range of real data types
- Experience of how to transform numerical data into evidence and hence how to make informed business decisions
It should be noted that the course does not cover the subjects of data acquisition, databases, data management, dashboards or the analysis of text-based information.
Training Methodology
This Oxford Management Centre Data Analysis Techniques training course adopts a problem-based learning approach, whereby delegates are presented with a series of highly realistic data analysis problems, which are drawn from the widest possible range of applications – from engineering to finance and from product sales to six sigma quality control.
Each problem has been carefully chosen to present and exemplify a specific data analysis approach. All of the analytical methods are generic, meaning that they can be applied to data from any industry sector, business type or organization.
The Data Analysis Techniques training course is entirely hands-on, with delegates spending all of their time working in Microsoft Excel to solve the problems posed.
Organisational Impact
Modern corporate ethos demands continual improvements in workplace efficiency and reductions in operating, maintenance, support service and administration costs.
Managers, administrators and analysts must continue to make better use of data to inform the business decision-making process, to identify improvements and efficiencies, and hence to achieve ever more stretching performance targets.
This Data Analysis Techniques training course will provide employees with the tools and understanding to analyze all forms of numerical business data and the ability to make robust, evidence-based decisions from it.
Personal Impact
Delegates will gain experience and hence confidence in how to approach a data analysis problem in a planned and logical manner. They will learn and practice how to extract information from wide ranging forms of numerical data and how to interpret this to make evidence-based decisions.
Delegates will also become much more proficient in the use of Microsoft Excel, including the use of many of its advanced features like Pivot Tables, interactive spreadsheets using Forms Controls, the Data Analysis Tool pack and the inbuilt solving engine called Solver.
Who Should Attend?
This Oxford Management Centre Data Analysis Techniques training course has been designed for any professional whose job involves the manipulation, analysis, representation and interpretation of data, including the subsequent evidence-based business decision making process.
Familiarity with a PC and in particular with Microsoft Excel (2013 or higher) is assumed, and delegates will be expected to be numerate and to enjoy working with numerical data on a computer.
This training course is suitable for a very wide range of professionals from any industry sector, but will greatly benefit people working in the following fields:
- Performance assessment and monitoring
- Planning
- Data analysis
- Management and leadership
- Finance
- Human resources
- Quality control
- Engineering and technology
- …in fact, any job function which uses data to make decisions.
Course Outline
Day One
Logical and Reliable Data Analysis, Descriptive Statistics, and Pivot Tables
- Importing data into Excel
- Best practice when analyzing data
- Analyzing and representing coded data
- Descriptive statistics and their real meanings
- Performing a frequency analysis
- The use of pivot tables and pivot charts
- Noisy and incomplete data, statistical significance and dealing with outliers
Day Two
Data Mode Shape Analysis
- Plotting data against time
- Generating data mode shapes
- Fitting curves to data
- Correlating mode shape to time-based events
- Interpreting time series analyses
- Moving average calculations
Day Three
Scenario Analysis and Interactive Spreadsheets
- Representing analytical problems as multi-input, single-output (MISO) systems
- Deterministic systems analysis
- What if and visual scenario analysis
- Dynamic / interactive spreadsheets and the use of forms control
- Moving window, conditional and adaptive calculations
- Measuring the sensitivity of calculated variables
Day Four
Regression Analysis and Correlation
- Equations of curves
- The prediction of future behavior using data shape – regression analysis
- Linear, polynomial, exponential and power curve fits
- The dangers of over-fitting
- Data end effects
- Goodness of fit (sum of square error – SSE) and R2
- Evaluating equations, solving equations, and using Solver
- Correlation and causality
Day Five
Data Driven Methods and Analysis of Variance
- Non-deterministic system
- Data driven methods
- One step ahead future prediction using data science (multivariate correlation)
- Single factor analysis of variance (ANOVA)
- Two factor analysis of variance
- A demonstration of artificial intelligence – the travelling salesman problem
Certificate
On successful completion of this training course, Oxford Management Centre Certificate with eligible Continuing Professional Education credits (CPE) from National Registry of CPE Sponsor will be awarded to the delegates
Accreditation
In association with
Related Courses
Robotic Process Automation (RPA)
Date: 04-08 May 2026 Location: London Fee: $5,950
Data Science for Operational Excellence
Date: 06-10 Apr 2026 Location: Dubai Fee: $5,950
Certified Data Management Professional
Date: 17-21 Nov 2025 Location: Barcelona Fee: $5,950
Excel for Financial Professionals
Date: 22-26 Dec 2025 Location: London Fee: $5,950
Data Privacy Certification (CIPM and CIPP)
Date: 29 Jun-03 Jul 2026 Location: London Fee: $5,950
Data Strategy Development
Date: 22-26 Jun 2026 Location: London Fee: $5,950
Data Management Body of Knowledge (DMBoK) and Certified Data Management Professional (CDMP) Exam Preparation
Date: 15-19 Jun 2026 Location: Online Fee: $3,950
Advanced Data Analysis Application Using the R Programming Language
Date: 15-19 Dec 2025 Location: London Fee: $5,950
Analytics and Artificial Intelligence (AI) for Strategic Management
Date: 08-12 Dec 2025 Location: London Fee: $5,950
FREQUENTLY ASKED QUESTIONS
Yes, we provide assistance in securing both hotel reservations & entry visa on all our international training venues, for delegates attending our training courses. For further information / assistance, please contact our Customer Service at:
- Telephone: +971 50 985 0174
- E-mail: info@oxford-management.com
Yes, Oxford Management Centre is accredited by the following professional bodies;
National Association of State Board of Accountancy (NASBA)
The Oxford Management Centre is registered with NASBA as a sponsor of Continuing Professional Education (CPE) on the National Registry of CPE Sponsors. NASBA have final authority on the acceptance of individual courses for CPE credit.
Yes, discounts are available. For further information please call +971 50 985 0174 or email, info@oxford-management.com
Note: Discounts are not applicable with any other special offer that may be available.
All course bookings made through Oxford Management Centre are non-refundable. By registering for a course, you acknowledge and accept that fees are payable in full and are not subject to refund under any circumstances, including but not limited to participant dissatisfaction, changes in personal or professional circumstances, or partial attendance.
Oxford Management Centre reserves the right to make reasonable adjustments to course content, trainers, or schedules where necessary, without entitling delegates to a refund. Full details of each course – including objectives, target audience, and content – are clearly outlined prior to enrolment, and it is the responsibility of the delegate to ensure suitability before booking.
There are 2 easy ways to register:
- Online: Select the training course you want to register for, Click the “Book Your Place” button on the course page, complete the form and click submit.
- E-mail: Send your details to info@oxford-management.com
We request that all cancellations be made at least one week before the class start date. You may reschedule this class without any penalty. If not, a $250 fee will be charged for cancellations received less than one week before a class begins and for no-shows. Cancellation penalties and any fees incurred by Oxford Management Centre will be deducted from refunds.
For more information request, email info@oxford-management.com or call +971 50 985 0174.
The classroom training fees include course presentation, relevant materials, physical & digital documentation, lunch and refreshments served during entire training. Accommodation and transportation are not included in the training course fees.
While, online training fees cover the course presentation and digital documentation and relevant materials.
The Oxford Management Centre Certificate of Completion with corresponding CPE credits shall be awarded to delegates who has successfully completed the training course.
Payment must be received before the training course commences. You can make payment by bank draft, cash, credit card or wire transfer.
Note: If the payment is not received, Oxford Management Centre has the right to refuse admission.
Upon receipt of your registration form, we will send you the following by e-mail:
- Registration Confirmation
- Invoice/Receipt (where appropriate)
If you register online you will receive an e-mail within 24 hours confirming your registration.
