Training on Data Management and Analysis using Excel
A Kenya Event on 2020-11-16 08:00:00
About the course
Most people use Excel for basic data manipulation and analysis and are not aware of its sophisticated data management and charting techniques and advanced data analysis capability.
This course will build the participant’s current Excel skills on the use of Excel’s powerful tools for data management and statistical analysis.
Target Participants
This course is aimed at professionals in different areas of practice who are looking at improving their data management and analysis skills using Excel.
Course duration
7 days
What you will learn
By the end of this course the participants will be able to:
Analyze relationships across information and data using MS Excel
Generate data forecasts using MS Excel
Organize data in a more structured manner
Analyze data effectively using various MS Excel techniques
Apply most appropriate charting technique data
Course Outline
Introduction to Excel Environment
Cell referencing, cell formatting and entering formula
Variables in Excel
Introduction to Excel Tables
Filtering data
Sorting data
Use of conditional formatting
Data Cleaning and manipulation using Excel
Importing data into Workbook
Move, copy, resize and delete columns and/or rows and/or sheets
Format cell contents
Clear formatting and cell contents
Find and Replace data
Cleaning Data with Text Functions
Using PivotTables
Running the PivotTable Wizard
Pivot Table Field Options
Pivot Table Design and Options
Building PivotTable Formulas
Pivot Charts
Using Charts in Excel
Selecting a Chart Type
Working with Chart Styles
Changing Chart Layout
Changing a Chart’s Location
Formatting 3-D Charts
Excel Statistic Functions
Counting Items in a Data Set
Average and Average IF
Means, Modes, and Medians
Min Max
Finding Values, Ranks, and Percentiles
Standard Deviations and Variances
Normal Distributions
Descriptive Statistics using Excel
Using the Excel Analysis tool pack
Creating a Histogram
Ranking by Percentile
Calculating Moving Averages
Exponential Smoothing
Inferential Statistics using Excel
Using the t-test Data Analysis Tool
Performing z-test Calculations
Using the Correlation Analysis Tool
Using the Regression Data Analysis Tool
Using the Covariance Analysis Tool
Using the ANOVA Data Analysis Tools
Training Approach
This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
Training manuals and additional reference materials are provided to the participants.
Certification
Upon successful completion of this course, participants will be issued with a certificate.
Tailor-Made Course
We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more training@devimpactinstitute.com
at NAIROBI,KENYA
P O BOX 10549-00400
Nairobi, Kenya
Add your Kenya event for free here on MyZA.
