Data Management, Manipulation and Analysis using Excel Course

Our Data Management training course using Excel empowers you to manipulate and analyze data for a competitive business advantage. BMC Training offers Data Management, Manipulation and Analysis using Excel Course in Management and Leadership Courses.

  • English
  • 192 Training Sessions
  • Confirmed
  • One Week
Data Management, Manipulation and Analysis using Excel Training Course

Detailed description for visually impaired users: The image presents a view of Data Management, Manipulation and Analysis using Excel Training Course

Type a city name or a month
Venue Start Date End Date Net Fees Details & Registration
London , UK 16 - Jun - 2024 20 - Jun - 2024 4950 GBP
Madrid , Spain 16 - Jun - 2024 20 - Jun - 2024 6950 GBP
Munich , Germany 16 - Jun - 2024 20 - Jun - 2024 7900 GBP
Berlin , Germany 16 - Jun - 2024 20 - Jun - 2024 7900 GBP
New York , United States 16 - Jun - 2024 20 - Jun - 2024 10900 GBP
Amsterdam , Netherlands 16 - Jun - 2024 20 - Jun - 2024 8100 GBP
Istanbul , Turkey 23 - Jun - 2024 27 - Jun - 2024 4700 GBP
Bali , Indonesia 23 - Jun - 2024 27 - Jun - 2024 8100 GBP
Singapore , Singapore 23 - Jun - 2024 27 - Jun - 2024 7500 GBP
Washington , United States 23 - Jun - 2024 27 - Jun - 2024 11000 GBP
Milan , Italy 16 - Jun - 2024 20 - Jun - 2024 6950 GBP
Kuala Lumpur , Malaysia 7 - Jul - 2024 11 - Jul - 2024 4750 GBP
Rome , Italy 7 - Jul - 2024 11 - Jul - 2024 7300 GBP
Barcelona , Spain 7 - Jul - 2024 11 - Jul - 2024 6950 GBP
Zurich , Switzerland 7 - Jul - 2024 11 - Jul - 2024 7950 GBP
Kuala Lumpur , Malaysia 14 - Jul - 2024 18 - Jul - 2024 4750 GBP
Rome , Italy 14 - Jul - 2024 18 - Jul - 2024 7300 GBP
Barcelona , Spain 14 - Jul - 2024 18 - Jul - 2024 6950 GBP
Zurich , Switzerland 14 - Jul - 2024 18 - Jul - 2024 7950 GBP
Kuala Lumpur , Malaysia 21 - Jul - 2024 25 - Jul - 2024 4750 GBP
Rome , Italy 21 - Jul - 2024 25 - Jul - 2024 7300 GBP
Barcelona , Spain 21 - Jul - 2024 25 - Jul - 2024 6950 GBP
Zurich , Switzerland 21 - Jul - 2024 25 - Jul - 2024 7950 GBP
Dubai , UAE 28 - Jul - 2024 1 - Aug - 2024 4987.5 GBP
Paris , France 28 - Jul - 2024 1 - Aug - 2024 6700 GBP
Hong Kong , Hong Kong 28 - Jul - 2024 1 - Aug - 2024 8500 GBP
London , UK 14 - Jul - 2024 18 - Jul - 2024 4950 GBP
Madrid , Spain 14 - Jul - 2024 18 - Jul - 2024 6950 GBP
Munich , Germany 14 - Jul - 2024 18 - Jul - 2024 7900 GBP
Berlin , Germany 14 - Jul - 2024 18 - Jul - 2024 7900 GBP
New York , United States 14 - Jul - 2024 18 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 14 - Jul - 2024 18 - Jul - 2024 8100 GBP
London , UK 21 - Jul - 2024 25 - Jul - 2024 4950 GBP
Madrid , Spain 21 - Jul - 2024 25 - Jul - 2024 6950 GBP
Munich , Germany 21 - Jul - 2024 25 - Jul - 2024 7900 GBP
Berlin , Germany 21 - Jul - 2024 25 - Jul - 2024 7900 GBP
New York , United States 21 - Jul - 2024 25 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 21 - Jul - 2024 25 - Jul - 2024 8100 GBP
London , UK 7 - Jul - 2024 11 - Jul - 2024 4950 GBP
Madrid , Spain 7 - Jul - 2024 11 - Jul - 2024 6950 GBP
Munich , Germany 7 - Jul - 2024 11 - Jul - 2024 7900 GBP
Berlin , Germany 7 - Jul - 2024 11 - Jul - 2024 7900 GBP
New York , United States 7 - Jul - 2024 11 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 7 - Jul - 2024 11 - Jul - 2024 8100 GBP
Tokyo , Japan 28 - Jul - 2024 1 - Aug - 2024 9750 GBP
Milan , Italy 14 - Jul - 2024 18 - Jul - 2024 6950 GBP
Milan , Italy 21 - Jul - 2024 25 - Jul - 2024 6950 GBP
Milan , Italy 7 - Jul - 2024 11 - Jul - 2024 6950 GBP
Kuala Lumpur , Malaysia 4 - Aug - 2024 8 - Aug - 2024 4750 GBP
Rome , Italy 4 - Aug - 2024 8 - Aug - 2024 7300 GBP
Barcelona , Spain 4 - Aug - 2024 8 - Aug - 2024 6950 GBP
Zurich , Switzerland 4 - Aug - 2024 8 - Aug - 2024 7950 GBP
London , UK 11 - Aug - 2024 15 - Aug - 2024 4950 GBP
Madrid , Spain 11 - Aug - 2024 15 - Aug - 2024 6950 GBP
Munich , Germany 11 - Aug - 2024 15 - Aug - 2024 7900 GBP
Berlin , Germany 11 - Aug - 2024 15 - Aug - 2024 7900 GBP
New York , United States 11 - Aug - 2024 15 - Aug - 2024 10900 GBP
Amsterdam , Netherlands 11 - Aug - 2024 15 - Aug - 2024 8100 GBP
Istanbul , Turkey 18 - Aug - 2024 22 - Aug - 2024 4700 GBP
Bali , Indonesia 18 - Aug - 2024 22 - Aug - 2024 8100 GBP
Singapore , Singapore 18 - Aug - 2024 22 - Aug - 2024 7500 GBP
Washington , United States 18 - Aug - 2024 22 - Aug - 2024 11000 GBP
Dubai , UAE 25 - Aug - 2024 29 - Aug - 2024 4987.5 GBP
Paris , France 25 - Aug - 2024 29 - Aug - 2024 6700 GBP
Hong Kong , Hong Kong 25 - Aug - 2024 29 - Aug - 2024 8500 GBP
London , UK 25 - Aug - 2024 29 - Aug - 2024 4950 GBP
Madrid , Spain 25 - Aug - 2024 29 - Aug - 2024 6950 GBP
Munich , Germany 25 - Aug - 2024 29 - Aug - 2024 7900 GBP
Berlin , Germany 25 - Aug - 2024 29 - Aug - 2024 7900 GBP
New York , United States 25 - Aug - 2024 29 - Aug - 2024 10900 GBP
Amsterdam , Netherlands 25 - Aug - 2024 29 - Aug - 2024 8100 GBP
Milan , Italy 11 - Aug - 2024 15 - Aug - 2024 6950 GBP
Tokyo , Japan 25 - Aug - 2024 29 - Aug - 2024 9750 GBP
Milan , Italy 25 - Aug - 2024 29 - Aug - 2024 6950 GBP
Kuala Lumpur , Malaysia 22 - Sep - 2024 26 - Sep - 2024 4750 GBP
Rome , Italy 22 - Sep - 2024 26 - Sep - 2024 7300 GBP
Barcelona , Spain 22 - Sep - 2024 26 - Sep - 2024 6950 GBP
Zurich , Switzerland 22 - Sep - 2024 26 - Sep - 2024 7950 GBP
Kuala Lumpur , Malaysia 1 - Sep - 2024 5 - Sep - 2024 4750 GBP
Rome , Italy 1 - Sep - 2024 5 - Sep - 2024 7300 GBP
Barcelona , Spain 1 - Sep - 2024 5 - Sep - 2024 6950 GBP
Zurich , Switzerland 1 - Sep - 2024 5 - Sep - 2024 7950 GBP
London , UK 8 - Sep - 2024 12 - Sep - 2024 4950 GBP
Madrid , Spain 8 - Sep - 2024 12 - Sep - 2024 6950 GBP
Munich , Germany 8 - Sep - 2024 12 - Sep - 2024 7900 GBP
Berlin , Germany 8 - Sep - 2024 12 - Sep - 2024 7900 GBP
New York , United States 8 - Sep - 2024 12 - Sep - 2024 10900 GBP
Amsterdam , Netherlands 8 - Sep - 2024 12 - Sep - 2024 8100 GBP
Dubai , UAE 15 - Sep - 2024 19 - Sep - 2024 4987.5 GBP
Paris , France 15 - Sep - 2024 19 - Sep - 2024 6700 GBP
Hong Kong , Hong Kong 15 - Sep - 2024 19 - Sep - 2024 8500 GBP
London , UK 1 - Sep - 2024 5 - Sep - 2024 4950 GBP
Madrid , Spain 1 - Sep - 2024 5 - Sep - 2024 6950 GBP
Munich , Germany 1 - Sep - 2024 5 - Sep - 2024 7900 GBP
Berlin , Germany 1 - Sep - 2024 5 - Sep - 2024 7900 GBP
New York , United States 1 - Sep - 2024 5 - Sep - 2024 10900 GBP
Amsterdam , Netherlands 1 - Sep - 2024 5 - Sep - 2024 8100 GBP
London , UK 22 - Sep - 2024 26 - Sep - 2024 4950 GBP
Madrid , Spain 22 - Sep - 2024 26 - Sep - 2024 6950 GBP
Munich , Germany 22 - Sep - 2024 26 - Sep - 2024 7900 GBP
Berlin , Germany 22 - Sep - 2024 26 - Sep - 2024 7900 GBP
New York , United States 22 - Sep - 2024 26 - Sep - 2024 10900 GBP
Amsterdam , Netherlands 22 - Sep - 2024 26 - Sep - 2024 8100 GBP
Milan , Italy 8 - Sep - 2024 12 - Sep - 2024 6950 GBP
Tokyo , Japan 15 - Sep - 2024 19 - Sep - 2024 9750 GBP
Milan , Italy 1 - Sep - 2024 5 - Sep - 2024 6950 GBP
Milan , Italy 22 - Sep - 2024 26 - Sep - 2024 6950 GBP
Kuala Lumpur , Malaysia 20 - Oct - 2024 24 - Oct - 2024 4750 GBP
Rome , Italy 20 - Oct - 2024 24 - Oct - 2024 7300 GBP
Barcelona , Spain 20 - Oct - 2024 24 - Oct - 2024 6950 GBP
Zurich , Switzerland 20 - Oct - 2024 24 - Oct - 2024 7950 GBP
London , UK 27 - Oct - 2024 31 - Oct - 2024 4950 GBP
Madrid , Spain 27 - Oct - 2024 31 - Oct - 2024 6950 GBP
Munich , Germany 27 - Oct - 2024 31 - Oct - 2024 7900 GBP
Berlin , Germany 27 - Oct - 2024 31 - Oct - 2024 7900 GBP
New York , United States 27 - Oct - 2024 31 - Oct - 2024 10900 GBP
Amsterdam , Netherlands 27 - Oct - 2024 31 - Oct - 2024 8100 GBP
Istanbul , Turkey 6 - Oct - 2024 10 - Oct - 2024 4700 GBP
Bali , Indonesia 6 - Oct - 2024 10 - Oct - 2024 8100 GBP
Singapore , Singapore 6 - Oct - 2024 10 - Oct - 2024 7500 GBP
Washington , United States 6 - Oct - 2024 10 - Oct - 2024 11000 GBP
Dubai , UAE 13 - Oct - 2024 17 - Oct - 2024 4987.5 GBP
Paris , France 13 - Oct - 2024 17 - Oct - 2024 6700 GBP
Hong Kong , Hong Kong 13 - Oct - 2024 17 - Oct - 2024 8500 GBP
London , UK 13 - Oct - 2024 17 - Oct - 2024 4950 GBP
Madrid , Spain 13 - Oct - 2024 17 - Oct - 2024 6950 GBP
Munich , Germany 13 - Oct - 2024 17 - Oct - 2024 7900 GBP
Berlin , Germany 13 - Oct - 2024 17 - Oct - 2024 7900 GBP
New York , United States 13 - Oct - 2024 17 - Oct - 2024 10900 GBP
Amsterdam , Netherlands 13 - Oct - 2024 17 - Oct - 2024 8100 GBP
Milan , Italy 27 - Oct - 2024 31 - Oct - 2024 6950 GBP
Tokyo , Japan 13 - Oct - 2024 17 - Oct - 2024 9750 GBP
Milan , Italy 13 - Oct - 2024 17 - Oct - 2024 6950 GBP
Kuala Lumpur , Malaysia 17 - Nov - 2024 21 - Nov - 2024 4750 GBP
Rome , Italy 17 - Nov - 2024 21 - Nov - 2024 7300 GBP
Barcelona , Spain 17 - Nov - 2024 21 - Nov - 2024 6950 GBP
Zurich , Switzerland 17 - Nov - 2024 21 - Nov - 2024 7950 GBP
Kuala Lumpur , Malaysia 24 - Nov - 2024 28 - Nov - 2024 4750 GBP
Rome , Italy 24 - Nov - 2024 28 - Nov - 2024 7300 GBP
Barcelona , Spain 24 - Nov - 2024 28 - Nov - 2024 6950 GBP
Zurich , Switzerland 24 - Nov - 2024 28 - Nov - 2024 7950 GBP
London , UK 3 - Nov - 2024 7 - Nov - 2024 4950 GBP
Madrid , Spain 3 - Nov - 2024 7 - Nov - 2024 6950 GBP
Munich , Germany 3 - Nov - 2024 7 - Nov - 2024 7900 GBP
Berlin , Germany 3 - Nov - 2024 7 - Nov - 2024 7900 GBP
New York , United States 3 - Nov - 2024 7 - Nov - 2024 10900 GBP
Amsterdam , Netherlands 3 - Nov - 2024 7 - Nov - 2024 8100 GBP
Dubai , UAE 10 - Nov - 2024 14 - Nov - 2024 4987.5 GBP
Paris , France 10 - Nov - 2024 14 - Nov - 2024 6700 GBP
Hong Kong , Hong Kong 10 - Nov - 2024 14 - Nov - 2024 8500 GBP
London , UK 24 - Nov - 2024 28 - Nov - 2024 4950 GBP
Madrid , Spain 24 - Nov - 2024 28 - Nov - 2024 6950 GBP
Munich , Germany 24 - Nov - 2024 28 - Nov - 2024 7900 GBP
Berlin , Germany 24 - Nov - 2024 28 - Nov - 2024 7900 GBP
New York , United States 24 - Nov - 2024 28 - Nov - 2024 10900 GBP
Amsterdam , Netherlands 24 - Nov - 2024 28 - Nov - 2024 8100 GBP
London , UK 17 - Nov - 2024 21 - Nov - 2024 4950 GBP
Madrid , Spain 17 - Nov - 2024 21 - Nov - 2024 6950 GBP
Munich , Germany 17 - Nov - 2024 21 - Nov - 2024 7900 GBP
Berlin , Germany 17 - Nov - 2024 21 - Nov - 2024 7900 GBP
New York , United States 17 - Nov - 2024 21 - Nov - 2024 10900 GBP
Amsterdam , Netherlands 17 - Nov - 2024 21 - Nov - 2024 8100 GBP
Milan , Italy 3 - Nov - 2024 7 - Nov - 2024 6950 GBP
Tokyo , Japan 10 - Nov - 2024 14 - Nov - 2024 9750 GBP
Milan , Italy 24 - Nov - 2024 28 - Nov - 2024 6950 GBP
Milan , Italy 17 - Nov - 2024 21 - Nov - 2024 6950 GBP
Kuala Lumpur , Malaysia 15 - Dec - 2024 19 - Dec - 2024 4750 GBP
Rome , Italy 15 - Dec - 2024 19 - Dec - 2024 7300 GBP
Barcelona , Spain 15 - Dec - 2024 19 - Dec - 2024 6950 GBP
Zurich , Switzerland 15 - Dec - 2024 19 - Dec - 2024 7950 GBP
London , UK 22 - Dec - 2024 26 - Dec - 2024 4950 GBP
Madrid , Spain 22 - Dec - 2024 26 - Dec - 2024 6950 GBP
Munich , Germany 22 - Dec - 2024 26 - Dec - 2024 7900 GBP
Berlin , Germany 22 - Dec - 2024 26 - Dec - 2024 7900 GBP
New York , United States 22 - Dec - 2024 26 - Dec - 2024 10900 GBP
Amsterdam , Netherlands 22 - Dec - 2024 26 - Dec - 2024 8100 GBP
Istanbul , Turkey 8 - Dec - 2024 12 - Dec - 2024 4700 GBP
Bali , Indonesia 8 - Dec - 2024 12 - Dec - 2024 8100 GBP
Singapore , Singapore 8 - Dec - 2024 12 - Dec - 2024 7500 GBP
Washington , United States 8 - Dec - 2024 12 - Dec - 2024 11000 GBP
Dubai , UAE 1 - Dec - 2024 5 - Dec - 2024 4987.5 GBP
Paris , France 1 - Dec - 2024 5 - Dec - 2024 6700 GBP
Hong Kong , Hong Kong 1 - Dec - 2024 5 - Dec - 2024 8500 GBP
London , UK 1 - Dec - 2024 5 - Dec - 2024 4950 GBP
Madrid , Spain 1 - Dec - 2024 5 - Dec - 2024 6950 GBP
Munich , Germany 1 - Dec - 2024 5 - Dec - 2024 7900 GBP
Berlin , Germany 1 - Dec - 2024 5 - Dec - 2024 7900 GBP
New York , United States 1 - Dec - 2024 5 - Dec - 2024 10900 GBP
Amsterdam , Netherlands 1 - Dec - 2024 5 - Dec - 2024 8100 GBP
Milan , Italy 22 - Dec - 2024 26 - Dec - 2024 6950 GBP
Tokyo , Japan 1 - Dec - 2024 5 - Dec - 2024 9750 GBP
Milan , Italy 1 - Dec - 2024 5 - Dec - 2024 6950 GBP

Course Syllabus

Introduction

This course is aimed at professionals who have, or will soon have, responsibility for managing and manipulating data using MS Excel on a day to day basis.  The course assumes zero knowledge, begins with an introduction to the Excel environment and ends with delegates being skilled in using 50+ MS Excel functions, sophisticated data management and charting techniques and advanced data analysis capability.

Do you still think that Excel is a tool that is used only by people in your company’s finance department?If so, you are wrong. It does have fantastic financial modeling capability but it offers so much more than that. Excel is not reserved for financial data. Everyone in middle to senior management manages some kind of data and hence the need to attend this course.

This course will feature:

  • Advanced data analysis
  • Both textual and numerical data
  • Forecasting
  • Advanced charting
  • Scenario analysis

objectives

By the end of this course, participants will be able to:

  • Analyse relationships across information and data using MS Excel.
  • Generate data forecast susing MS Excel.
  • Organise your company’s data in a more structured manner.
  • Analyse your data effectively using various MS Excel techniques.
  • Select the appropriate chart for your data.

Contents

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

Related Courses

MNG101

Business Strategy Essentials Course

Learn the key elements of business strategy in this essential course. Gain actionable insights to drive success.
MNG256

Enhancing Efficiency and Governance in Port Operations Course

Explore methods to elevate port operations through our course, focusing on boosting efficiency and enhancing governance for optimal performance.
MNG167

Leadership and Strategic Thinking in the Oil and Gas Industry Course

Develop leadership and strategic thinking skills tailored for the Oil and Gas industry with our specialized training course.
MNG156

The Complete Course on Management Course

Master all facets of effective management with our comprehensive training course, designed for current and aspiring managers.
MNG177

Advanced Conflict Resolution and Change Management Strategies Course

Master advanced conflict resolution and change management strategies with our intensive training course, tailored for managers.
MNG246

Managing Successful Classroom Courses and Webinars-Tools and Techniques for Success Course

Acquire skills for managing successful classroom courses and webinars in this training course. Learn techniques for effective training delivery.

Available Cities