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