BE A MASTER IN DATA ANALYSIS & MICROSOFT EXCEL 2 SATURDAYS IN APRIL

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: $110 USD each
VENUE: Business Startup Center (BSC) By the University Basket Ball Court UL Monrovia
Date: Saturdays APRIL 18 and 25 (10am to 4pm)

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), 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 and data for each candidate and lunch, 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, a certificate of successful participation is issued at the end of the training and assessment.
Compliance
The Course curriculum correspond to the Microsoft Office Specialist (MOS) Certification curriculum.

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