Advanced Data Management and Analysis using Microsoft Excel

6 months ago Posted By : User Ref No: WURUR174293 0
  • Image
  • TypeTraining or Development Class
  • Image
  • Location **** OTHER ****, Kigali, Rwanda
  • Price
  • Date 17-06-2024 - 21-06-2024
Training or Development Class Title
Advanced Data Management and Analysis using Microsoft Excel
Event Type
Training or Development Class
Training or Development Class Date
17-06-2024 to 21-06-2024
Last Date for Applying
17-06-2024
Location
**** OTHER ****, Kigali, Rwanda
Organization Name / Organize By
Kigali Institute of Capacity Development and Data Analytics
Organizing/Related Departments
Kigali Institute of Capacity Development and Data Analytics
Organization Type
Organization
Training or Development ClassCategory
Both (Technical & Non Technical)
Training or Development ClassLevel
International
Related Industries

Education/Teaching/Training/Development

Research/Science

Business Development

Location
**** OTHER ****, Kigali, Rwanda

Course venue: Kigali Rwanda

Course duration - 5 days

Registration Fee : 750 USD

Course date

15/01/2024 – 19/01/2024 : https://bit.ly/3vu1pak

12/02/2024 – 16/02/2024 : https://bit.ly/3vu1pak

11/03/2024 – 15/023/2024 : https://bit.ly/3vu1pak

22/04/2024 – 26/04/2024 : https://bit.ly/3vu1pak

27/05/2024 – 31/05/2024 : https://bit.ly/3vu1pak

17/06/2024 – 21/06/2024 : https://bit.ly/3vu1pak

Contacts: +250 784 481 618 or +250 786 156 256

Whatsapp : +250 793 086 968

E-mail: [email protected]

About the Course

Excel has powerful tools that enable busy users to set up systems that simplify data management, analysis and presentation. Effectively using Excel allows users to devote their time more profitably to making decisions about and acting on results, with more effective outcomes. This Data Management and Analysis Using Microsoft Excel course gives practical experience in the use of Microsoft Excel for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel in your workplace functions. We look at data entry and management, pivot tables, formulae, graphics for results presentation and useful shortcuts. Participants will learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants will also receive a manual describing all the techniques learned.

Target Participants

This course is aimed at persons who handle a lot of data, often processing and analyzing it using Microsoft Excel. It is ideal for monitoring and evaluation practitioners, researchers as well as accounting/finance and administrative support staff.

What you will learn

By the end of the course the learner should be able to:

  • Familiarize with advanced formulas and functions in Microsoft Excel
  • Easily combine, link and export data
  • Create key outputs from data (tables and graphs)
  • Reduce the amount of time spent in delivering output through Microsoft Excel through time-saving keyboard shortcuts
  • Easily summarize, analyse and present data through pivot tables and charts.

Course duration

5 days

Course Outline

Module 1:

Introduction

  • Navigating within the sheet
  • Making selection
  • Entering data
  • Data management in Excel
  • Deleting unwanted data
  • Find errors, conditional formatting and data validation

Module 2:

Introduction to Excel Formating

  • Adjusting Numeric Formats
  • Controlling Fonts, Borders and Cell Color
  • Alignment Tools & Other formatting Tools
  • Row, Column and Sheet Adjustment & Adding Picture
  • Referencing in Excel
  • Working with Structured tables
  • Excel Formula Basics
  • Keyboard shortcuts in Excel

Module 3:

Pivot Table and Pivot Charts

  • Preparing data for use with Pivot Table
  • Creating Pivoting Tables
  • Summarizing PivotTable Data
  • Sorting and Filtering Pivot Table
  • Formatting PivotTable
  • Applying Conditional Formatting
  • Working with Calculated Fields
  • Grouping Data
  • Filters and Advanced Filter
  • Advanced Data Field Settings
  • Creating Pivot Chart
  • Power Query
  • Printing Pivot Tables and Pivot Charts
  • GETPIVOTDATA function

Module 4:

Excel Functions

  • Lookup/Ref Functions
  • String/Text Functions
  • Date/Time Functions
  • Math/Trig Functions
  • Statistical Functions
  • Logical Functions
  • Information Functions
  • Financial Functions
  • Database Functions

Module 5:

Practical application of Excel

  • Project assignment involving huge application of Pivot Tables, Formulae and Shortcuts
  • Additional topics: Plans will be made to cover a few additional topics as per the suggestions that would be made by the participants.

Training Approach: Data Management and Analysis Using Microsoft Excel

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 on Data Management and Analysis Using Microsoft Excel

We can also do this as a tailor-made course to meet organization-wide needs. Contact us to find out more – Email: [email protected]; Call: or +250 784 481 618 or +250 786 156 256

Payment

The training fee covers tuition fees, learning materials, and training venue. Accommodation and airport transfer are arranged for our participants upon request.

Payment should be sent to our bank account before start of training and proof of payment sent to [email protected]

Sharing is caring:

 

Registration Fees
Available
Registration Fees Details
750 USD
Registration Ways
Email
Phone
Website
Address/Venue
Kigali, Rwanda  Kigali, Rwanda 
Contact

Kigali, Rwanda

   0793086968

Kigali, Rwanda

   0793086968