Data Management, Manipulation and Analysis Using Excel

Date Format Fees  
02 Jul - 05 Jul, 2019 Classroom ₦160,000 Register
02 Jul - 05 Jul, 2019 Classroom ₦160,000 Register
10 Dec - 13 Dec, 2019 Classroom ₦160,000 Register

Event Details

By the end of this 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.

 

1ST BATCH: 2nd – 5th July, 2019

2ND BATCH: 10th – 13th December, 2019

  • Venue

    Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Share this course