Call for Professional Training: Advanced Excel tender at DNR Partners CPA Ltd
401 Days Ago
Linkedid Twitter Share on facebook

Call for Professional Training: ‘Advanced Excel’

Dear customers, after successful completion of the previous Advanced Excel workshop, after receiving your interests in attending day, evening and weekend Programs, we are here for you!!

‘Knowledge is the glorious & victory of your company!’

  • Course Title: Advanced Excel for efficiency
  • Training dates: Day program, November 1-2, 2023

                         : Evening Program, November 1-2, 2023

                         : Weekend Program, November 5&12, 2023

  • Number of days: 2 days:
  • Training Venue: DNR PARTNERS INTERNATIONAL CPA Office located in Kigali City, Gasabo District, Kacyiru Sector, KG 647St
  • Phone: +250788 271 647 /+250 788 386 134 / +250 788 306 057 /

1. Introduction

DNR PARTNERS INTERNATIONAL CPA is an international Consulting Firm licensed to certify the financial statement, providing Management consulting services and corporate Trainings in Rwanda, Burundi, Kenya, Zambia, Zimbabwe, South Africa and England.

Who should attend:

  • Accountants and Finance Officers
  • Finance & Admin Manager
  • Chief Finance Officers
  • Human Resources Officers
  • Budget Officers
  • Financial Modelling Officers

The training workshop is themed ‘Advanced Excel for efficiency’

2. Workshop expected outcomes

  • Use advanced functions and productivity tools to assist in developing worksheets
  • Prepare efficiently the payrolls for the organization or institution
  • Use consolidation to summarize and report results from multiple worksheets
  • Handle large amount of data
  • Aggregate numeric data and summarize into categories and subcategories
  • Filtering, sorting and grouping data or subsets of data
  • Use automation (Macros) to generate pivot tables 

3. Course content 

This course will cover the following sub-topics: 

Day

Topic description

1

  • Excel Basics: Familiarize with the Excel interface, navigation, and basic functionalities like entering data, formatting cells, and using formulas.
  • Working with Formulas and Functions: How to create and use basic and advanced Excel formulas to perform calculations, manipulate data, and solve complex problems.
  • Data Analysis: Discover techniques for sorting, filtering, and managing large datasets effectively. Use functions like SUMIF, COUNTIF, and AVERAGEIF for data summarization.
  • Charts and Graphs: Create visually appealing charts and graphs to represent data trends, comparisons, and patterns for better data visualization.
  • Pivot Tables and Pivot Charts: Master the power of PivotTables and Pivot Charts to quickly analyze and summarize data from multiple perspectives.

2

  • Data Validation: Ensure data accuracy and consistency by setting up data validation rules and restrictions for cell entries.
  • Conditional Formatting: Learn to apply conditional formatting to highlight specific data based on predefined criteria, making it easier to identify trends and outliers.
  • Data Analysis with Power Query: Utilize Power Query to import, transform, and clean data from various sources, enabling efficient data analysis.
  • Automating Tasks with Macros: Understand the basics of Excel macros and learn how to automate repetitive tasks to save time and effort.
  • What-If Analysis: Use tools like Goal Seek, Scenario Manager, and Data Tables to perform what-if analysis and forecast outcomes based on different variables.
  • Advanced Functions: Explore advanced functions like VLOOKUP, HLOOKUP, INDEX-MATCH, and array formulas for powerful data manipulation.

3

  • Data Analysis with Power Pivot: Delve into Power Pivot to create data models, build relationships, and perform sophisticated data analysis.
  • Collaboration and Sharing: Discover how to collaborate with others on workbooks, protect data with passwords, and share Excel files securely.
  • Excel Tips and Tricks: Learn time-saving tips, shortcuts, and best practices to maximize productivity and efficiency while working in Excel.
  • Final Assessment and Course Review

4. Programs

No

PROGRAM

DATES

START

END

1

Day program

November1-2, 2023

9:00’am

3:30’p.m

2

Evening Program

November1-2, 2023

5:00pm

8:30Pm

3

Weekend Program

November 5&11, 2023(Sundays only)

8:00a.m

4:00Pm

5. Training methods

This training course will be run in a workshop style with a high degree of participants’ involvement for the sessions to be more interactive and more productive via exploring adult learning methodologies. Live Scenarios shall be used and each participant shall have enough time to practice.

6. Issuance of International Certificates 

As DNR PARTNERS is the consulting firm Audit firm with international standards, will issue certificates which are recognized internationally.

7. Training fees

  • Fees for Participation: 100,000 RW per delegate, including registration fees 10,000 RW deductible from the total training fees.
  • Bank Name: Bank of Kigali
  • Bank Account: 000400697670519
  • Account Name: DNR PARTNERS CPA LTD.

Registration: https://docs.google.com/forms/d/e/1FAIpQLSdqeB6o1goAOCc_JhxXmHXUoK2ijtVgqDMgzUsXsibRM4wi6w/viewform?usp=sf_link 

Note: After your Payment, kindly scan the bank slip then send it to info@dnrpartners.com OR bring the hard copy of bank slip to DNR PARTNERS Office.

Should you need further clarifications, kindly call us via +250 788 271 647/ +250 788 306 057 +250 788 386 134 /

Kigali, October 17, 2023

Dieudonné NGIRIMANA  MBA, FCCA, CPA

The Managing Partner

Job Info
Job Category: Tenders in Rwanda
Job Type: Full-time
Deadline of this Job: Tuesday, October 31 2023
Duty Station: Kigali
Posted: 18-10-2023
No of Jobs: 1
Start Publishing: 18-10-2023
Stop Publishing (Put date of 2030): 18-10-2066
Apply Now
Notification Board

Join a Focused Community on job search to uncover both advertised and non-advertised jobs that you may not be aware of. A jobs WhatsApp Group Community can ensure that you know the opportunities happening around you and a jobs Facebook Group Community provides an opportunity to discuss with employers who need to fill urgent position. Click the links to join. You can view previously sent Email Alerts here incase you missed them and Subscribe so that you never miss out.

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.