Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Data Management, Manipulation and Analysis Using Excel

By: Alpha Partners  

Ghana

16 - 20 Dec, 2024  5 days

Follow Event

  

USD 6,500

Venue: Accra-Ghana

By the end of this data management, manipulation and analysis using excel training, participants will be able to:

  • Analyse relationships across information and data using MS Excel
  • Generate data forecasts using 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

CONTENT

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

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

Intermediate MS Excel Functions

  • Use of VLOOKUP() and HLOOKUP()
  • Date functions, YEAR(), MONTH(), DAY(), YEARFRAC()
  • Selecting appropriate charts
  • Introduction to Pivot tables

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

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

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

Accra-Ghana Dec 16 - 20 Dec, 2024
USD 6,500.00(The Workshop fee is 6500 (Six Thousand Five Hundred USDollars) only per participant to cover workshop literature and materials, executive bag, tea/coffee, lunch, photograph and certificate.)
(Convert Currency)

Chris Onwuasigwe, FCA – 08033045484 08033045484

5% discount for 3-6 participants and 10% discount for 7 and above number of participants from the same organization.
A distinguished team of facilitators who are eminently qualified professionals has been assembled to lead discussions in course of the workshop.

Related Courses

Public Relation Skills for Medical and Social Workers in a Holistic Environment Public Relation Skills for Medical and Social Workers in a Holistic Environment

5 days, 10 - 14 Feb, 2025 

2025-02-10 12:02:00 2025-02-10 12:02:00
Ghana

Alpha Partners

This training course is designed to equip medical and social workers with essential public relations skills necessary for effective communication and interaction within a holistic healthcare ...

Healthcare Hazard Control and Safety Management Healthcare Hazard Control and Safety Management

5 days, 20 - 24 Jan, 2025 

2025-01-20 12:01:00 2025-01-20 12:01:00
Ghana

Alpha Partners

On completion of this course you should be able to: Get easily digested information through practical checklists and forms that can be readily put to use. Gain knowledge on management, hazard ...