Microsoft Office Applications

Excel training

Microsoft Excel

Benefit from one of the professionally thought lessons as we walk you through work-related examples. Enhance your confidence and speed across the various proficiency levels offered as below:

Excel training
To pass this proficiency level, participants must demonstrate the skills below:
  • Working With Workbooks, Templates and Other Excel Types
  • Understand Cell and Range Naming Conventions
  • Formatting Cells, Using Templates and Styles
  • Copy, Paste and Paste Special
  • Cell Functions and Behaviours with Sort, Deletes and Filters
  • Graphing Techniques: Presenting Information
  • Printing: Page Numbers, Grids, Repeat Columns and Rows
  • Google Sheets, Excel Options And Help
Target Audience

Junior And Senior Clerks

Officers at Entry Levels

Training Days

Two (2) days

Training Fees

GHS 500.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
Various work roles have unique usage of the Excel. but most struggle with presentation of information which is what we deal with here:
  • Referencing Worksheets Within Workbook(s)
  • Fills, Text to Columns: Splitting Data
  • Freeze Pane, Group Data Rows & Columns
  • Functions: Logical, Text, Date and Lookups
  • Pivot Tables, Pivot Charts, Sparklines
  • Table Formats and Related Functions
  • Go To Tracing, Error Checking & Circular References.
  • Sharing The Workbook and Macro Recording
Target Audience

Finance, Risk,

Human Resources,

Compliance and Audit

Training Days

Three (3) days

Training Fees

GHS 750.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
Data manipulation need more than Basic Excel. Topics at this level improves understanding and help cut down on data manipulation errors.
  • Multiple IF statements with other logical functions.
  • Advanced Functions: Date, Statistical, Lookups & wildcards.
  • Conditional Formatting, Functions (SUMIFs) and Wildcards
  • Goal Seek, Scenario Manager and Forecasts.
  • Name Manager and Worksheet Queries.
  • Working Smart on Multiple Sheets and Data Consolidation.
  • Dashboard Sliders and 3D Maps
  • Power Pivot, Data Relationships, Measures & KPIs
Target Audience

Finance, Risk,

Human Resources

Compliance and Audit

Training Days

Three (3) days

Training Fees

GHS 900.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
Excel Template designs cut across many functions. But this knowledge builds on data  manipulation skills. Here we explore such topics to equip participants.
  • Data Validation and Cell Protection
  • Template Design Functions: Index, Match and Offset
  • Queries & Parameters for External Source Data
  • Array Functions and Methods
  • Power Pivot and DAX Functions
  • Using Solver for Complex Business Solutions.
  • Using Data Analysis Tools: ANOVA, Regression, t-tests
  • Graphing with Shapes and Active X Objects.
Target Audience

Finance, Risk,

Human Resources

Compliance and Audit

Training Days

Four (4) days

Training Fees

GHS 1,200.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
This is the default Tab content. Feel free to delete it.
Access training

Microsoft Access

Many working roles require the use of personal or team databases. For lack of knowledge workers' resort to  using Excel. Explore the advantages of relational databases at the various proficiency levels we offer.

Access training
Beginners may only have the need to capture data into databases already designed. The skills required to pass this proficiency level includes the abilities to:
  • Create, Open and Save Access Databases.
  • Understanding the types of Access Databases and Uses.
  • Design Tables: Understand Primary, Foreign and Composite Keys
  • Design Tables: Understand Data Types
  • Capturing Data Into Tables Using Forms.
  • Filter and Sorting Form or Table Data & Mail Merge
  • Opening Reports through Forms and Printing
  • Query Design And Access Options
Target Audience

Data Clerks,

Officers,

Supervisors

Training Days

Two (2) days

Training Fees

GHS 500.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
Tracking work activities for workers becomes a challenge and critical risk area for companies. At this level, we teach the building of databases to track your simple tasks.
  • Plan Database Creation and Maintaining Existing Ones.
  • Relational Database Principles & Indexing
  • Import Excel or Text File Data into Tables
  • Design Tables & Forms Using Validations and Expression
  • Perform SELECT and UNION SELECT statements
  • Types of Joins: INNER, LEFT, RIGHT AND CROSS
  • Child & Parent Form Design With Aggregation
  • Building Reports Using Wizard & Introduction to Macros
Target Audience

Sales, Finance, Risk,

Human Resources,

Compliance and Audit

Training Days

Three (3) days

Training Fees

GHS 750.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
Automating reporting tasks can be the best way of generating error-free reports. Participant who yearn for this benefits are encouraged to take-up lesson on:
  • Design Action and Cross-tab Queries
  • Understand Nested Sub-Queries & Using Exists, In and Distinct.
  • Query Expressions & Functions
  • Forms & Object Designs: Formats, Data & Events
  • Form Input Validations & Conditional Formatting
  • Navigation Menu and Related Macro Commands.
  • Reporting: Groups, Sub-Totals and Running Totals
  • Reporting: Using Excel PowerPivot and PivotCharts
Target Audience

Finance, Risk

Payroll Officers,

Compliance and Audit

Training Days

Three (3) days

Training Fees

GHS 900.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
Institutions upgrade Access databases to SQL and etc. Learning to build Access databases eases the job of users and developers alike. We touch on design issues as:
  • Linking & Interacting With Multiple Databases.
  • Designing & Executing Data Definition Queries.
  • Writing Pass-Through Queries
  • Creating Switchboard Items
  • Synchronizing InfoPath & Access for Departmental Forms
  • Creating Switchboards and Other Dialog Forms.
  • Table-based Macro Actions: Before/After Insert/Update.
  • Database Report Automation
Target Audience

Finance, Risk,

Human Resources,

Compliance and Audit

Training Days

Three (3) days

Training Fees

GHS 1,200.00

  • 10% Early Payment Discount
  • 7.5% Early Bird Discount
MsOfficeLogo

Microsoft Others

The application of Office tools vary across many fields. We touch on some specialized areas useful for most types of organizations.

MsOfficeLogo
Business Intelligence
Participants will learn how to extract data from cubes, use Excel cube functions and employ data mining tools to extract perspectives. 
  • Connecting to the Cube Data Source
  • Extracting Results: Dimensions and Measures
  • Extracting Results: Dimension Properties
  • Creating Customized Calculated Members
  • Cube Functions - Sets, Values, Members And KPIs
  • Data Drilldown from Cube
Target Audience

Data Clerks,

Officers,

Supervisors

Training Days

Three (3) days

Training Fees

GHS 1,200.00

  • 15% Early Payment Discount
  • 10% Early Bird Discount
Participants will combine data sources to create dimensions and calculated measures from new data sources while making their reports refreshable.
  • Data Import from Web, Tables, Queries and Cubes
  • Creating Relationships and Hierarchies
  • Creating Calculated Fields - Related, Calculate and etc.
  • Map - Based Power Pivot Reports
  • Interactive Power Pivot Reports
  • Incorporating KPI targets in Power Pivot
Target Audience

Data Analysts,

Reporting Officers,

Business Analysts

Training Days

Three (3) days

Training Fees

GHS 800.00

  • 15% Early Payment Discount
  • 10% Early Bird Discount
Visual Basic Programming