Call for Trainings of QuickBooks Software,Advanced Excel,Infographics,SPSS and STATA.
Venue: ERP-STATISTICS LAB Venue at Kigali
Contact:0788303975
Email:erpstatisticslab10@gmail.com
1. QUICKBOOKS ACCOUNTING SOFTWARE TRAINING
Duration:3 Days
Venue: ERP-STATISTICS LAB Venue at Kigali
Training fees:118.000 (VAT Inclusive)
Dates:18th to 20th November 2021
:25th to 27th November 2021
:09th to 11th December 2021
:16th to 18th December 2021
Workshop objectives
This course is designed to continue learning the computerized accounting cycle and some of the more important aspects of Payroll and Taxes.
Upon completion of this hands-on course, a trainee will be able to:
- Run all accounting transactions by use of QuickBooks;
- Perform possible accounting adjustments
- Report with QuickBooks;
- Complete a wide range of specialized and advanced QuickBooks functions in order to meet the bookkeeping needs of a typical small business or organization.
Target audience
Accountants from the Private and public sector and NGOs, bookkeepers, Accountants Graduates, Auditors, Tax advisors, and consultants, and all others who want to master the skills of QuickBooks.
WORKSHOP COURSE OUTLINES:
Lesson 1: Setting Up a Company in QuickBooks
Lesson 2: Work with Customers Module to manage Sales or Funds in QuickBooks
Lesson 3: Work with Suppliers Module to manage Purchases in QuickBooks
Lesson 4: Work with Inventory Module to Manage Stock in QuickBooks
Lesson 5: Work with VAT Module in QuickBooks
Lesson 6: Working with Banking Module in QuickBooks
Lesson 7: General Journals &End year Adjustments with QuickBooks
Lesson 8: Multiple Currencies in QuickBooks
Lesson 9: Work with Accountant Copy to enable working out of Server
Lesson 10:Management of Exchange loss and Gains in QuickBooks
Lesson 11: Creating Reports in QuickBooks
REGISTRATION GATE:
Get an invitation letter by sending an e-mail to:
erpstatisticslab10@gmail.com or call us on 0788 30 39 75
DISCOUNT Available to group application as follow:
Group of 2 people:5%
Group of 3 People:10%
Above 3 people:15%
2. ADVANCED EXCEL & MACROs TRAINING
Duration:3 Days
Venue: ERP-STATISTICS LAB Venue at Kigali
Training fees:118.000 (VAT Inclusive)
Dates:15th to 17th November 2021
:21th to 23rd November 2021
:01th to 03rd December 2021
:19th to 21st December 2021
Workshop objectives
This course is designed to help MS Excel users to discover some challenges and Different settings of MS Advanced Excel and to get enough skills to fulfill the Data Management &accounting and statistical responsibilities.
Target audience
All people who want to master the skills of Advanced Excel
This Professional Training will cover:
1. DATE & TIME FUNCTIONS
- LOGICAL FUNCTIONS
3. FORMULA AUDITING
- WHAT-IF ANALYSIS
- SOLVER
- VALIDATING DATA
- LOOKUP FUNCTIONS
- DATA CONSOLIDATION
- PIVOT TABLES& DASHBOARD MANAGEMENT
10. MACROS
11. TIME SERIES FORECAST USING ADVANCED EXCEL
REGISTRATION GATE:
Get an invitation letter by sending an e-mail to:
erpstatisticslab10@gmail.com or call us on 0788 30 39 75
DISCOUNT Available to group application as follow:
Group of 2 people:5%
Group of 3 People:10%
Above 3 people:15%
4. DATA VISUALIZATION USING INFOGRAPHICS
Duration:2 Days
Venue: ERP-STATISTICS LAB Venue at Kigali
Training fees:150.000 (VAT Inclusive)
Dates::18th to 20th December 2021
:21th to 22nd December 2021
Training objectives
This course is designed to help MS Excel users to discover some challenges and Different settings of MS Advanced Excel and to get enough skills to enable smooth Data Presentation.
Course Outlines:
1. Data Visualization Key Principles Section
2. Tips and tricks for more impact Section
3. Data visualization with MS Excel Section
4. Data Visualization with Canva Section
- Final Workshop – Packaging Gender Issues using gender statistics – tables, summary statistics, data visualization
REGISTRATION GATE:
Get an invitation letter by sending an e-mail to:
erpstatisticslab10@gmail.com or call us on 0788 30 39 75
DISCOUNT Available to group application as follow:
Group of 2 people:5%
Group of 3 People:10%
Above 3 people:15%
3. “SPSS AND STATA (Combined) FOR STATISTICAL DATA ANALYSIS
Duration:3 Days
Venue: ERP-STATISTICS LAB Venue at Kigali
Training fees:118.000 (VAT Inclusive)
Dates:15th to 17th November 2021
:21th to 23rd November 2021
:01th to 03rd December 2021
:19th to 21st December 2021
II.SPSS & STATA Course outlines:
1. Introduction key terms in SPSS AND STATA
Definition of SPSS and STATA
Data Types
Defining Variables
Defining Missing Values
2. Data Entry in SPSS AND STATA
Questionnaire design for SPSS and STATA
Hands-on Exercises with Survey Data
Import Data from Excel
Access Databases
Text files
Delimited Text Files
Hands-on Exercises with Survey Data
3. Tabulation of Data Entry in SPSS AND STATA
Introduction
Frequency Tables
Cross Tabulation
Basic & General Tables
Multi Response Tables
- Data Manipulation Entry in SPSS AND STATA
Compute
Recode
5 Data Handling
Case Selection Procedures
File Split Procedures
Aggregation Procedures
Hands-on Exercises with Survey Data
- Merging Datasets Entry in SPSS AND STATA
Cases
Variables
- Statistical Analysis – I Entry in SPSS AND STATA
Descriptive Statistics and reporting writing with APA Format
Chi-Square test Statistics and reporting writing with APA Format
- Statistical Analysis – II Entry in SPSS AND STATA
T-test (Comparison of Means) Statistics and reporting writing with APA Format
Hands-on Exercises with Survey Data
- Statistical Analysis – III Entry in SPSS AND STATA
ANOVA Statistics and reporting writing with APA Format
Linear Regression Analysis Statistics and reporting writing with APA Format
Hands-on Exercises with Survey Data
Presentation on the Exercise
- Statistical Analysis – III Entry in SPSS AND STATA
Correlation analysis Statistics and reporting writing with APA Format
Hands-on Exercises with Survey Data
Presentation on the Exercise
REGISTRATION GATE:
Get an invitation letter by sending an e-mail to:
erpstatisticslab10@gmail.com or call us on 0788 30 39 75
DISCOUNT Available to group application as follow:
Group of 2 people:5%
Group of 3 People:10%
Above 3 people:15%
The deadline: 4th December 2021.
