{"id":169716,"date":"2020-10-22T16:25:30","date_gmt":"2020-10-22T14:25:30","guid":{"rendered":"https:\/\/www.myza.co.za\/training-on-data-management-and-analysis-using-excel\/"},"modified":"2020-10-22T16:25:30","modified_gmt":"2020-10-22T14:25:30","slug":"training-on-data-management-and-analysis-using-excel","status":"publish","type":"post","link":"https:\/\/www.myza.co.za\/press\/training-on-data-management-and-analysis-using-excel\/","title":{"rendered":"Training on Data Management and Analysis using Excel"},"content":{"rendered":"

Training on Data Management and Analysis using Excel<\/a><\/strong><\/p>\n

A Kenya Event on 2020-11-16 08:00:00<\/i><\/p>\n

About the course
\n 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.<\/p>\n

This course will build the participant\u2019s current Excel skills on the use of Excel\u2019s powerful tools for data management and statistical analysis.<\/p>\n

Target Participants
\nThis course is aimed at professionals in different areas of practice who are looking at improving their data management and analysis skills using Excel. <\/p>\n

Course duration
\n7 days<\/p>\n

What you will learn
\nBy the end of this course the participants will be able to:<\/p>\n

Analyze relationships across information and data using MS Excel
\nGenerate data forecasts using MS Excel
\nOrganize data in a more structured manner
\nAnalyze data effectively using various MS Excel techniques
\nApply most appropriate charting technique data
\nCourse Outline
\nIntroduction to Excel Environment<\/p>\n

Cell referencing, cell formatting and entering formula
\nVariables in Excel
\nIntroduction to Excel Tables
\nFiltering data
\nSorting data
\nUse of conditional formatting
\nData Cleaning and manipulation using Excel<\/p>\n

Importing data into Workbook
\nMove, copy, resize and delete columns and\/or rows and\/or sheets
\nFormat cell contents
\nClear formatting and cell contents
\nFind and Replace data
\nCleaning Data with Text Functions
\nUsing PivotTables<\/p>\n

Running the PivotTable Wizard
\nPivot Table Field Options
\nPivot Table Design and Options
\nBuilding PivotTable Formulas
\nPivot Charts
\nUsing Charts in Excel<\/p>\n

Selecting a Chart Type
\nWorking with Chart Styles
\nChanging Chart Layout
\nChanging a Chart\u2019s Location
\nFormatting 3-D Charts
\nExcel Statistic Functions<\/p>\n

Counting Items in a Data Set
\nAverage and Average IF
\nMeans, Modes, and Medians
\nMin Max
\nFinding Values, Ranks, and Percentiles
\nStandard Deviations and Variances
\nNormal Distributions
\nDescriptive Statistics using Excel<\/p>\n

Using the Excel Analysis tool pack
\nCreating a Histogram
\nRanking by Percentile
\nCalculating Moving Averages
\nExponential Smoothing
\nInferential Statistics using Excel<\/p>\n

Using the t-test Data Analysis Tool
\nPerforming z-test Calculations
\nUsing the Correlation Analysis Tool
\nUsing the Regression Data Analysis Tool
\nUsing the Covariance Analysis Tool
\nUsing the ANOVA Data Analysis Tools
\n Training Approach
\nThis 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.<\/p>\n

Training manuals and additional reference materials are provided to the participants.<\/p>\n

Certification
\nUpon successful completion of this course, participants will be issued with a certificate.<\/p>\n

Tailor-Made Course
\nWe can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more training@devimpactinstitute.com<\/p>\n

at NAIROBI,KENYA<\/a>
\nP O BOX 10549-00400
\nNairobi, Kenya<\/p>\n

Add your Kenya<\/em> event for free here<\/a> on MyZA.<\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2019s current Excel skills on the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9840],"tags":[6552,4732,5855,2694,572,9691],"class_list":{"0":"post-169716","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-eventful","7":"tag-analysis","8":"tag-data","9":"tag-excel","10":"tag-management","11":"tag-training","12":"tag-using","13":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/posts\/169716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/comments?post=169716"}],"version-history":[{"count":0,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/posts\/169716\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/media?parent=169716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/categories?post=169716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myza.co.za\/press\/wp-json\/wp\/v2\/tags?post=169716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}