Nigerian Seminars and Trainings

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

business logo

3 -Day Online Training on Data Management and Analysis using Advanced Excel

By: Cynet East Africa Consultancy

Kenya

02 - 04 Apr, 2024  3 days

Follow Event

  

USD 120

Get 80.00% off

Venue: Virtual

Master the essentials of Data Management and Analysis using Advanced Excel at the comfort of your location. Grab our 3 Day Easter Special offer and gain Advanced Excel Skills at an extremely pocket friendly investment. Data Analysis and Management using Advanced Excel is designed to provide participants with a comprehensive and hands-on approach to harness the full potential of Microsoft Excel for data analytics. The course begins with an introduction to fundamental Excel functions and formulas, gradually progressing to advanced features like pivot tables, Power Query, and Power Pivot. Participants will gain proficiency in organizing, cleaning, and analyzing large datasets, enhancing their ability to derive meaningful insights.

Program Objectives

  • 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, analyze, and present data through pivot tables and charts.

Modules

Module 1: Excel Basics

  • 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 Formatting

  • 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

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

Certification

Upon successful completion of the training, participants will be awarded Cynet East Africa Consultancy certificate.

Virtual Apr 02 - 04 Apr, 2024

Registration: 03:30:am - 06:30:am

USD 120.00
(Convert Currency)

Janet Cherono/Nancy Kemunto +254 792 972525/+254 204401089

80% Discounted Easter Special Offer
Kevin Ochieng' and Benard Mwai
NST PPC Advert

Related Courses

Web-Based GIS and Mapping Web-Based GIS and Mapping

5 days, 05 - 09 Aug, 2024 

2024-08-05 12:08:00 2024-08-05 12:08:00
Kenya

Cynet East Africa Consultancy

This training program on Web-based GIS and Mapping equips participants with knowledge on how to build GIS web portal using open source GIS end to end solutions. Includes open source GIS software ...

Electronic Government Procurement Electronic Government Procurement

5 days, 12 - 16 Aug, 2024 

2024-08-12 12:08:00 2024-08-12 12:08:00
Kenya

Cynet East Africa Consultancy

Government agencies all around the world have initiated the implementation of e-GP systems to help them reduce operational costs, exercise greater control over purchasing, and improve the image by ...

Training on Warehouse and Store Management Training on Warehouse and Store Management

6 days, 28 Apr - 03 May, 2024 

2024-04-28 12:04:00 2024-04-28 12:04:00
Kenya

Cynet East Africa Consultancy

Warehouse and stores management involves the effective planning, organizing, and controlling of the storage and movement of goods within a warehouse or storage facility. The primary goal is to ensure ...

Introduction to Data Management and Analysis Using Stata Introduction to Data Management and Analysis Using Stata

5 days, 03 - 07 Jun, 2024 

2024-06-03 12:06:00 2024-06-03 12:06:00
Kenya

Cynet East Africa Consultancy

Data analysis with STATA is designed to train participants to be professional data analysts. To be an expert in using STATA, one requires a basic knowledge on descriptive statistics. It is only ...