BE A MASTER IN DATA ANALYSIS & MICROSOFT EXCEL

excel

Today’s business environment is fast paced with critical data transactions, calculations and analysis constantly dictating the extent of business success. Business is transacted at the speed of light. Companies, who operate at manual speeds and/or in the old ways, generally find themselves behind their competitors and do not achieve the goals. Microsoft Excel and Data Analysis is one of the critical tools organizations need to survive in today’s fast pace business environment.

COST: $100 USD each
VENUE: ICT Center Liberia, 24 Street Sinkor, Airfield Short Cut, Monrovia
Schedule: Monday & Wednesday (5 to 7pm) for 3 weeks.
Starting Date: June 7th 2021

Contents
Lesson 1: Calculating Data with Advanced Formulas

  • Apply cell and range names
  • Calculate data across worksheets
  • Use specialized functions
  • Analyse data with logical and lookup (H & V lookup) functions.

Lesson 2: Organizing Worksheet and Table Data

  • Create and modify tables
  • Format tables
  • Sort or filter worksheet or table data
  • Use functions to calculate data.

Lession 3: Presenting Data Using Charts

  • Create a chart
  • Format charts
  • Modify charts
  • Use functions to calculate data.

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable report
  • Use Slicers for filtering data
  • Analyze data using PivotCharts

Lesson 5: Customizing and Enhancing the Excel Environment

  • Customize the Excel environment
  • Customize workbooks
  • Manage themes
  • Create and use templates

Who are we? We are a group of ICT professionals poised to delivering cutting edge technologies to companies and institutions in Liberia. We have the capabilities, people, processes, technology and the desire to be your strategic partner of choice in ICT training.
Organizations that have engaged our service in IT training: CHAI (MOH Staff), IRC, County Health Team (Maryland & River Gee), Concern Worldwide, DRC, WHO, UNICEF, GVL, GIZ Endev, MercyCorps, WAVF, NDS, Afriland First Bank, Equity Assurance, FIB and many more
Provision:
ICT Center Liberia provides a training manual, data and certificate for each candidate, note that it is a responsibility of the candidate to provide laptop to be used during training, we can supply few copies at no charge.
Mode of delivery:
The above-mentioned modules will be delivered through ICT Center Liberia Consultants. The course manuals are prepared with Lab Activities that will guarrantee that participants practice what is taugth right in the class and at a later time. The course manual will also serve as a guide to the participants after the duration of the course.
Certificate
This is a certificated course, an ICT Center Liberia certificate of successful participation is issued at the completion of the training and assessment.
Compliance
The Course curriculum correspond to the Microsoft Office Specialist (MOS) Certification curriculum.
Guarantee: We attach 3 months guarantee to our training; therefore, any candidate will be admitted for further training on the module if he or she requires additional help.
Cooperate Engagement: Should you desire training for your staff, we will be willing to train your staff in your choice venue, kindly contact us.

Payment
Check in favor of ICT Center Liberia, Transfer Bank Details below:
Bank: UBA Liberia Ltd,
Account Name: ICT Center Liberia
Account Number: 53030160007340

Kindly register in the form below for the MS EXCEL MASTER CLASS