Excel Software Development Centre (ESDC) - Tema, Ghana

Excel Software Development Centre (ESDC) is an IT training and consulting firm specializing in providing Professional-level MICROSOFT EXCEL training at three levels:
1. Basic Professional Skills Training
2. Intermediate Professional Skills Training
3. Advanced Professional Skills Training

There is also a special course for those who are new to Computing, that is, those without any knowledge of using a computer from both personal and professional standpoints. The details of the course (Computer Basics for Absolute Beginners) is presented in section (B) of the course listings below.

For those with advanced skills in Excel, the following courses are recommended:
* MICROSOFT EXCEL STATISTICAL DATA ANALYSIS FOR BUSINESS DECISION-MAKING; details are found in SECTION (C) of the  

Show more

course listings below.
* EXCEL-BASED SIMULATION /ANIMATION SOFTWARE DESIGN FOR PROFESSIONALS; details are found in SECTION (D) of the course listings below.

For those with basic computing skills seeking to acquire transferable skills in the job-market, the course, MICROSOFT EXCEL, is recommended; details are found in SECTION (A) of the course listings below.

We also provide Excel-based Software Development and Intelligent or Smart Spreadsheet Design Services for managing your business operations. We provide, in particular, software for managing, planning, and tracking expenses on activities such:
(i) Family Budget
(ii) Utility Bills (electricity, water, phone, etc.)
(iii) Funerals
(iv) Parties
(v) Building Projects
(vi) Business Processes
...
COURSES AND THEIR OUTLINES
******************************
SECTION (A): MICROSOFT EXCEL:
1. Basic Professional Skills Training (10 Hours): Delivered within a maximum of 2 months.
******************************************************************************
Module 1 (5 Hours): Delivered within an a maximum of 1 month.
(i) Microsoft Excel Basics: understanding the "Language of Microsoft Excel" from the perspective of the business world.
(ii) Distinguish between "Academic-Level training" and "Professional-Level training".
(iii) Why Microsoft Excel?-The leading Spreadsheet Application in the business world.
(iv) Data Security in professional practice.
(iv) The "golden-rule" of Microsoft Excel and its application.
(v) Formula formulation (creation) from the professional standpoint.
(vi) Basics of Spreadsheet Layout Design.
(vii) Cell References: Relative Reference, Absolute Reference, Mixed Reference
(viii) Excel In-built Functions and their applications.
(ix) Application of the following Excel In-built Functions:
* SUM()
* SUMIF()
* MAX()
*MIN()
* COUNT()
* COUNTIF()
* AVERAGE()
* AVERAGEIF()
Module 2 (5 Hours): Delivered within an a maximum of 1 month.
(i) Application of the following function:
*IF()
* SUBTOTAL()
* VLOOKUP()
(ii) Data Analysis using the SUBTOTAL() function for Report Creation
(iii) Data Visualization: Creating basic graphs
Mode of Assessment: Project Work
Evidence of Training: Award of Certificate of Completion and Course-Transcript.
Target Groups:
* Business Managers
* Accountants
* Engineers
* Teachers
* Financial Analysts
* School Leavers
* Students
* Job Seekers
* Office Administrators
* General Managers
* Record Keepers
* Warehouse Managers
* Transport Managers
* Inventory/Stock Control Managers
* Retail Store Managers

2. Intermediate Professional Skills Training (10 Hours): Delivered within a maximum of 2 months.
***************************************************************************************
Module 1 (5 Hours): Delivered within a maximum of 1 month.
(i) Spreadsheet Design and its application in industry
(ii) Recap of Cell References: Relative Reference, Absolute, and Mixed Reference
(iii) Data Visualization: Creating advanced graphs from a dataset
(iv) Advanced Filter and its application
(v) Conditional Formatting
(vi) PIVOT-Table and its Applications
Module 2 (5 Hours): Delivered within a maximum of 1 month.
(vii) Application of the INDEX() and MATCH Functions
(viii) Application of the CHOOSE() and SUMPRODUCT Functions
(ix) Setting up a Database
(ix)Application of Database Functions such as:
* DSUM()
* DCOUNT()
* DAVERAGE()
*DMAX()
Mode of Assessment: Project Work
Evidence of Training: Award of Certificate of Completion and Course-Transcript.
Target Groups:
* Business Managers
* Accountants
* Engineers
* Teachers
* Financial Analysts
* School Leavers
* Students
* Job Seekers
* Office Administrators
* General Managers
* Record Keepers
* Warehouse Managers
* Transport Managers
* Inventory/Stock Control Managers
* Retail Store Managers

3. Advanced Professional Skills Training (10 Hours): Delivered within a maximum of 2 months.
***********************************************************************************
Module 1 (5 Hours): Delivered within a maximum of 1 month.
(i) Analysis of Business Problems
(ii) Business Process Re-engineering (BPR) using Microsoft Excel
(iii) Array Formula formulation and application.
(iv) Advanced Data Analysis using Array Formulas
(v) Advanced Spreadsheet Design
Module 2 (5 Hours): Delivered within a maximum of 1 month.
(i) Introduction to Programming: Concepts and Paradigms
(ii) Excel Programming (Macros)
(iii) Spreadsheet-based Application Design (For example: A Financial Model)
(iv) Userform-based Application Design
(v) Introduction to Business Intelligence (BI):
(a) Big Data and Data Model
(b) Application of
* PowerQuery
* PowerPivot
(vi) Dynamic Business Dashboard Design using Power BI Desktop tool
Mode of Assessment: Project Work
Evidence of Training: Award of Certificate of Completion and Course-Transcript.
Target Groups:
* Business Managers
* Accountants
* Engineers
* Teachers
* Financial Analysts
* School Leavers
* Students
* Job Seekers
* Office Administrators
* General Managers
* Record Keepers
* Warehouse Managers
* Transport Managers
* Inventory/Stock Control Managers
* Retail Store Managers

SECTION (B): COMPUTER BASICS FOR ABSOLUTE BEGINNERS (10 Hours): Delivered within a maximum of 2 months.
***********************************************************************************************
Designed to impart professional skills to people with little or no previous knowledge in computing.
COURSE OUTLINE:
Module 1 (5 Hours): Delivered within a maximum of 1 month.
(i) Fundamentals of Computing: understanding how a computer works
(ii) Terminology associated with Computing: learning the language of Computing
(iii) Using the Computer:
Learning how to power-on (boot) and shut-down a computer
(iv) File Creation and Organization: Learn how to create a file (document), a folder, and saving the file in a folder
(v) Computer Performance Optimization: performing basic operations to enhance computer performance
(vi) Basic Troubleshooting Techniques
(vii) The Internet and its application in the business world
(viii) Importance of an anti-virus software and dangers of malware
(ix) Business Opportunities associated with the Internet.
(x) The Internet as a collaborative tool (Using Google Docs.)
Module 2 (5 Hours): Delivered within a maximum of 1 month.
(i) Microsoft Office: Learn to use
* Microsoft Word to design professional-looking documents
* Microsoft PowerPoint to design Presentation-Slides and how to make presentations.
* Introduction to Microsoft Excel for basic data analysis.
Mode of Assessment: Project Work
Evidence of Training: Award of Certificate of Completion and Course-Transcript.
Target Groups:
* Business Managers
* Accountants
* Engineers
* Teachers
* Financial Analysts
* School Leavers
* Students
* Job Seekers
* Office Administrators
* General Managers
* Record Keepers
* Warehouse Managers
* Transport Managers
* Inventory/Stock Control Managers
* Retail Store Managers

SECTION (C): MICROSOFT EXCEL STATISTICAL DATA ANALYSIS FOR BUSINESS DECISION-MAKING (10 Hours): Delivered within a maximum of 2 Months.
*****************************************************************************************************
Module 1 (5 Hours): Delivered within a maximum of 1 month.
(i) Recap of Statistical Concepts
(ii) Excel Statistical Functions
Module 2 (5 Hours): Delivered within a maximum of 1 month.
Application of Excel Statistical Functions for business decision-making
Mode of Assessment: Project Work
Evidence of Training: Award of Certificate of Completion and Course-Transcript.
Target Groups:
* Business Managers
* Accountants
* Engineers
* Teachers
* Financial Analysts
* School Leavers
* Students
* Job Seekers
* Office Administrators
* General Managers
* Record Keepers
* Warehouse Managers
* Transport Managers
* Inventory/Stock Control Managers
* Retail Store Managers

SECTION (D): EXCEL-BASED SIMULATION /ANIMATION SOFTWARE DESIGN FOR PROFESSIONALS (10 Hours): Delivered within a maximum of 2 Months.
****************************************************************************************************
Module 1 (5 Hours): Delivered within a maximum of 1 month.
(i) Introduction to Simulations/Animations Software Design
(ii) Scenario Analysis
(ii) Recap of relevant Excel elements
Module 2 (5 Hours): Delivered within a maximum of 1 month.
(i) Simulation/Animation implementation in Excel VBA (Visual Basic for Application) programming language
(ii) Testing the simulation software.
Mode of Assessment: Project Work
Evidence of Training: Award of Certificate of Completion and Course-Transcript.
Target Groups:
* Business Managers
* Accountants
* Engineers
* Teachers
* Financial Analysts
* School Leavers
* Students
* Job Seekers
* Office Administrators
* General Managers
* Record Keepers
* Warehouse Managers
* Transport Managers
* Inventory/Stock Control Managers
* Retail Store Managers

MODES OF TRAINING
********************
(i) Special One-on-One Training (Instructor-led)
(ii) Corporate Training (Instructor-led)

OTHER SERVICES
*****************
(i) Excel-based Application Software Development
Manage your business with:
* Automated Invoice Spreadsheet (Software)
* Store Management Systems (Software)
* School Management Systems (Software)
* Personal Data Management Systems (Software)
* Inventory/ Stock Control Management Systems (Software)
* Small Business Management Systems (Software)
* Business Dashboard for monitoring business activities (Software)
(ii) Intelligent Spreadsheet Design:
* Excel Worksheet for Automatic Data Analysis and Report Generation (Software)
(iii) Data Processing/Analysis:
* Get your company data processed and analysed for a data-driven decision-making to enhance your business.
(iv) Data Entry Services:
* Get your company data transferred from books into Excel Spreadsheet for and data analysis and safe storage.