• اللغة العربية
Data Management, Manipulation & Analysis using Excel®

An Intensive 5-day Training Course

Data Management, Manipulation
& Analysis using Excel®

Excel with the Power of Data

UPCOMING SESSIONS

Classroom sessions
DateVenueFee
28 Apr-02 May 2025London - UK$5,950RESERVE A SEAT
08-12 Sep 2025Dubai - UAE$5,950RESERVE A SEAT
01-05 Dec 2025Dubai - UAE$5,950RESERVE A SEAT
Online sessions
DateVenueFee
21-25 Apr 2025Online$3,950RESERVE A SEAT
07-11 Jul 2025Online$3,950RESERVE A SEAT
22-26 Sep 2025Online$3,950RESERVE A SEAT
08-12 Dec 2025Online$3,950RESERVE A SEAT

Training Course Overview

Data has never been more abundant and accessible than it is today. From our daily routines to business operations and personal achievements, data is constantly generated. This wealth of data presents incredible opportunities to solve problems and drive improvements across all aspects of our lives, particularly in commercial activities. Traditionally, solving such problems required advanced quantitative skills. However, often overlooked on nearly every desktop computer is an underutilized tool: Excel.

In this Data Management, Manipulation & Analysis using Excel® training course, you will learn how to harness Excel to query data, test hypotheses, and tackle complex problems. By the end of the course, you will become proficient in over 50 Excel functions, a diverse array of charts, and various analytical tools.

Training Course Objectives

By attending this Anderson training course, delegates will be able to:

  • Be familiar with 50+ Excel functions
  • Recognise the right chart for the right task
  • Manipulate both textual and numerical data
  • Analyse data using appropriate tools
  • Analyse relationships amongst variables and generate forecasts

Designed for

This Anderson training course is suitable for middle and senior managers who have responsibility for divisional or organizational success, as well as consultants and professionals who support them. For example:

  • Anyone with line manager responsibility
  • HR professionals
  • Oil and Gas, energy and telecom team engineers
  • Senior finance professionals
  • Board level executives and non-executives

The Course Outline

Day One: An Introduction to the MS Excel Environment
  • Cell referencing, cell formatting and entering formula
  • Workbooks versus Worksheets
  • Copy and pasting
  • Left click versus right click
  • Paste Special
  • Introductory charts
Day Two: Using MS Excel Functions for Fundamental Data Analysis
  • Use of text function, FIND(), LEN(), LEFT(), RIGHT() and &
  • Use of count functions, COUNTA(), COUNTIF(), COUNTIFS() and SUMIF()
  • Basic statistical functions, Max and Average
  • Filtering, sorting and use of conditional formatting
  • Scatter diagrams
Day Three: Intermediate MS Excel Functions
  • Use of VLOOKUP() and HLOOKUP()
  • Date functions, YEAR(), MONTH(), DAY(), YEARFRAC()
  • Selecting appropriate charts
  • Introduction to Pivot tables
Day Four: Carrying out Statistical Analysis using MS Excel
  • Using MS Excel to calculate mean, mode and median
  • The difference between the various standard deviation and variance function in MS Excel
  • Using MS Excel to examine inter-dependency
  • Drawing histograms in MS Excel
  • Introduction to Data Analysis functions
Day Five: What if and Scenario Analysis Using MS Excel
  • Naming cells in MS Excel
  • Linking cells together to undertake scenario analysis
  • Introduction to solver
  • Advanced charting
  • Sharing MS Excel output with other office formats

The Certificate

  • Anderson Certificate of Completion will be provided to delegates who attend and complete the course.
Course Enquiry

    Download Course
    BROCHURE
    Course Category
    Do you want this training to be held on your premises?
    Learn more about our In-house solutions
    FREQUENTLY ASKED QUESTIONS

    Learn More About
    this course

    How can I register for a training course?

    There are several convenient ways to register for our training programs:

    • Online: Explore our training calendar, choose the course that suits your needs, and click the “Register Now” button on the course details page.
    • Email: Share your details, including your name, organization, email address, and selected course, by sending an email to  [email protected]
    • Phone: Reach out to us directly at +971 4 273 3503, and our team will guide you through the registration process.

    When will I receive confirmation of my registration?

    Once your registration is successfully completed, you will receive a confirmation email within 24 hours. This email will contain your registration details, invoice, and the necessary joining instructions for the course.

    What does the training fee cover?

    The training fees include full access to the training venue, along with comprehensive training materials to enhance your learning experience. Additionally, participants will be provided with writing supplies and stationery. To ensure comfort and convenience, the fee also covers lunch and refreshing coffee breaks throughout the duration of the course.

    Where are your training courses held?

    Our training programs are hosted at luxurious five-star hotels in prestigious destinations across the globe. Some of our popular locations include Dubai, London, Kuala Lumpur, Amsterdam, New York, Paris, Vienna, and many other iconic cities.

    Can I request customized corporate training?

    Yes, we offer tailored corporate training solutions to meet your organization’s specific needs. Please contact us at [email protected] or call +971 4 273 3503 for more information.

    Still have questions?
    Can’t find the what you are looking for? Contact us and we’ll be happy to assist you.
    Enhance Your Skills

    RELATED COURSES

    Microsoft Power BI: Data Analysis & AI Dashboards
    Microsoft Power BI: Data Analysis & AI Dashboards
    In today’s data-driven world, businesses must adapt to make informed decisions that are powered by data. Power BI, a leading...
    Learn more
    Strategic Performance Management using an Executive Dashboard
    Strategic Performance Management using an Executive Dashboard
    This Strategic Performance Management using an Executive Dashboard training course provides you with essential tools to implement your strategy and...
    Learn more
    Key Performance Indicators & Optimisation
    Key Performance Indicators & Optimisation
    Why do some organizations struggle to maintain competitiveness in the market? One of the primary reasons is the absence of...
    Learn more
    The Complete Course on Data Science & Big Data Analytics
    The Complete Course on Data Science & Big Data Analytics
    If your organization is moving forward and not stuck in the past, you’re already exploring the opportunities of Big Data...
    Learn more
    Certificate in World Class Business Sustainability
    Certificate in World Class Business Sustainability
    In today's high-pressure business environment, sustainability has transcended its role as mere window-dressing and emerged as a transformative force in...
    Learn more
    Data Analytics for Managerial Decision Making
    Data Analytics for Managerial Decision Making
    Effective and decisive decision-making is crucial for successful managers. Utilizing evidence-based information is a key factor in achieving this. Professionals...
    Learn more
    Upstream Data Dynamics
    Upstream Data Dynamics
    In the ever-evolving world of upstream oil and gas operations, the effective management and use of data is key to...
    Learn more
    Cybersecurity Specialist Training Course
    Cybersecurity Specialist Training Course
    As digital technologies continue to evolve rapidly, cybersecurity has become an essential element in safeguarding sensitive data, securing networks, and...
    Learn more
    Data Analytics for Accounting and Finance Professionals
    Data Analytics for Accounting and Finance Professionals
    In today’s rapidly changing financial world, data analytics has become a crucial tool for accounting and finance professionals. Organizations are...
    Learn more
    Cybersecurity Audit Essentials
    Cybersecurity Audit Essentials
    Cybersecurity threats and risks have become ubiquitous, especially in the media. While news outlets often exaggerate or even overhype the...
    Learn more
    STAY UP TO DATE

    SIGN UP FOR OUR NEWSLETTER