Activity Page

Comprehensive training on

MS Excel Report Writing

Date:
Tuesday 17 - Friday 20, 2024

Introduction

This comprehensive 1-week training program is designed to equip Lekki Port’s team with the necessary Excel skills and business report writing abilities to handle various aspects operational functions. From basic data entry to advanced data analysis and report creation, participants will learn to create custom reports, automate tasks, and leverage Excel’s capabilities to optimize operations and drive performance.

In general, this training will enable participants to present their Excel analytics in standard business reports format, empowering departments and top management to make data-driven decisions and improve operational efficiency.

Training Facilitators

Olamilekan Adeeko

Microsoft Most Valuable Professional (MVP), Microsoft Certified Trainer and Edtech Specialist.

Read Bio Sketch

Olamilekan Adeeko

- Edtech specialist, data analyst, and AI learning technologist
- First Class university graduate
- Certifications: Microsoft Certified Trainer, Microsoft Certified Power BI Analyst, Microsoft Office Specialist, Innovative Educator Expert Teaching Excellence & Achievement Fellowship by the U.S. Department of State Recognized globally in Dubai, Singapore, and Paris
- Trained over 800 individuals in data analytics using Excel, Power BI, SQL, and Python
- Worked on data analytics projects in education, health, finance, logistics, and sales sectors
- Trained over 35,000 teachers across Nigeria, Botswana, and Ghana
- Represented Nigeria in Ghana, Mauritius, South Africa, Kenya, Dubai, Singapore, France, and the U.S.

Marvellous Okoro

Author, Sales and Marketing expert with multi-disciplinary experience, Founder of Bud of Olives Academy.

Read Bio-Sketch

Marvellous Okoro

- Multi-dimensional woman with expertise in delivering cutting-edge wisdom for transformation and strategic turnaround.
- Sales and Marketing expert with multi-disciplinary experience across various fields: Finance, Tech Education, Marketing Consultancy & Travel
- Combines marketing experience and project management training for: Strategic Planning, Operations Management, etc.
- Trained educator specializing in curriculum creation for youth aged 25 and under.
- Author of The Voyagers, a comprehensive mentoring manual for young people, parents, and youth mentors.
- Founder of Buds of Olives Mentoring Academy.

Training Schedule

Attendance

Day 1 Attendance

Please enable JavaScript in your browser to complete this form.

Name: Layout

Participant's Name: *

Day 2 Attendance

Day 3 Attendance

Day 4 Attendance

Training Sub-Groups

GROUP 1
Akinlotan Yusuf
Okunno Philip
Adebayo Adefunke
Temisan Atikpekpe
Isamail Adeyemi
Opeyemi Emmanuel Olubake

Grp 1 Assignment

GROUP 2
Matthew Oloyede
Igboeli Emmanuel
Ogunfuniloye Bolade
Johnson Oluwasegun
Taiwo Muraino
Akali Darlington Emeka

Grp 2 Assignment

GROUP 3
Ugo Chukwuma Innocent
Adedamola Idowu
Quadri Hassan
Adurayemi Ogundele
Ada Ukonu
Arowolo Mariam

Grp 3 Assignment

Submit your assignment

Assignment Submission

Please enable JavaScript in your browser to complete this form.

Upload Participant's Layout

Participant's Name: *

Upload your Completed Assignment *

Click or drag files to this area to upload. You can upload up to 3 files.

Downloads & Evaluation

MS Excel

Main Course Material

Day 1, Session 1 Workbook

Day 1, Session 2 Workbook

Day 2, Session 1 Workbook

Day 2, Session 2 Workbook

MS Excel Evaluation

Evaluate MS Excel Training

Please enable JavaScript in your browser to complete this form.

Participant's Name: *

Participant's Email *

SECTION 1: Knowledge Confidence by Module

1. How confident are you navigating N4 independently — finding units, applying filters, and using the Unit Inspector? *

A) Fully confident, I can do it on my own
B) Mostly confident, minor things I'd need to check
C) Somewhat confident, I'd need guidance on several steps
D) Not confident, I need more practice

2. How well do you understand the flow of data from N4 through the Cache to XPS? *

A) I can explain it clearly to someone else
B) I understand it but couldn't explain it yet
C) I have a rough idea but key parts are unclear
D) I don't understand it yet

3. Could you create a vessel visit from scratch without trainer support? *

A) Yes, completely
B) Yes, but I'd need to refer to the manual
C) Partially — I'd get stuck at certain steps
D) No, I would need hands-on support

4. How confident are you configuring a business rule or auto-update rule on your own? *

A) Very confident
B) Confident with the manual open
C) I'd need someone to walk me through it
D) Not confident at all

5. Which Security Administration area do you feel least confident about? *

A) Roles & Privileges
B) Business Groups
C) Delegated Security
D) User Monitor & Authentication History

6. If your gate system behaved unexpectedly, how ready are you to troubleshoot it? *

A) I know exactly what steps to take
B) I have a general idea but would need to check the manual
C) I would need support from Biznovate or a colleague
D) I wouldn't know where to start

7. How clearly do you understand where N4 ends and XPS begins — and what breaks when the integration fails? *

A) Very clearly
B) Mostly clear, a few grey areas
C) Somewhat — I'm still confused about the handoff
D) Not clear at all

8. Could you perform a full TOS restart in the correct sequence without the manual? *

A) Yes
B) I know most steps but not all
C) I know the concept but not the sequence
D) No

9. If an inbound EDI message failed to process, what would you do first? *

A) Check the EDI session log and identify the error stage
B) Re-send the message and see if it clears
C) Escalate to IT or Biznovate immediately
D) I'm not sure

10. How confident are you setting up a Billing contract for a new customer independently? *

A) Fully confident
B) Confident but would need to verify configuration steps
C) I'd need guidance
D) Not confident

SECTION 2: Practical Readiness

11. When you return to your terminal, how ready do you feel to work in the live N4 environment? *

A) Ready to work independently
B) Ready for routine tasks, would escalate complex ones
C) Would need a colleague or consultant alongside me
D) Not ready yet — more training needed first

12. Did you identify any processes at your terminal that are now configured incorrectly or sub-optimally? *

A) Yes, several
B) Yes, one or two
C) Possibly, but I need to investigate further
D) No

13. Are there manual or workaround processes at your terminal that N4 could automate based on what you learned? *

A) Yes, definitely
B) Possibly — I need to explore further
C) I don't think so
D) I'm not sure

SECTION 3: Environment-Specific Concerns

14. Which area of your current N4 environment do you feel is most underutilised? *

A) EDI and automated messaging
B) Business rules and auto-update rules
C) Reporting and scheduled jobs
D) Security and role management
E) Billing configuration

15. Do you currently have EDI errors at your terminal that you have accepted as normal? *

A) Yes
B) No
C) I'm not sure

16. Are there reporting needs at your terminal not being met by your current N4 setup? *

A) Yes — significant gaps
B) Yes — minor gaps
C) No, reporting is sufficient
D) I haven't reviewed this yet

SECTION 4: Advanced Training Readiness

17. Which day's content would benefit most from a dedicated advanced follow-up session? *

A) Day 1 — N4 Basics & Vessel Operations
B) Day 2 — Administration, Security & Business Rules
C) Day 3 — Mobile, Gate & XPS
D) Day 4 — TOS Management & EDI
E) Day 5 — Billing

18. Which advanced topic would add the most value for you next training? *

A) Custom Jasper report development
B) Advanced EDI mapping and troubleshooting
C) N4 API integrations
D) Complex business rule scripting / Code Extension
E) Advanced billing and contract configuration

19. What format would you prefer for follow-up support? *

A) Hands-on sessions in our live/test environment
B) Structured classroom training on advanced topics
C) Remote support as issues arise
D) A combination of all three

12. follow-up the

20. Do you have a specific project or system change coming up that you would need Biznovate's support with? *

A) Yes — within the next 3 months
B) Yes — within 3–6 months
C) Possibly, nothing confirmed yet
D) No

SECTION 5: Training Delivery

21. Overall, was the pace of the training right? *

A) Too fast throughout
B) Too fast on some days
C) About right
D) Could have moved faster

22. Which day felt most rushed? *

Day 1
Day 2
Day 3
Day 4
E) Day 5
F) None — pacing was fine throughout

23. Was there enough hands-on practice time in the test environment? *

A) Yes, plenty
B) Mostly, but a bit more would help
C) No — exercises felt rushed
D) Significantly more practice time needed

24. How would you rate the training overall? *

A) Excellent
B) Good
C) Average
D) Needs improvement

SECTION 6: Open Close

25. What is the one thing Biznovate could do in the next 30 days to make sure this training sticks and delivers real value at your terminal? *

Report Writing

Main Course Material

Report Writing Worksheet

Report Writing Evaluation

Evaluate Report Writing Training

Please enable JavaScript in your browser to complete this form.

would you for

Participant's Name: *

Participant's Email *

How would you rate the overall Report Writing training? *

Excellent
Good
Fair
Poor

How useful do you find the skills and knowledge gained? *

Very Useful
Somewhat Useful
Not Useful

Any suggestions for improving the training?

Take Post Training Test

Comprehensive training on

MS Excel Report Writing

Date: Tuesday 17 - Friday 20, 2024

Activity Page

MS Excel

SECTION 1: Knowledge Confidence by Module

SECTION 2: Practical Readiness

SECTION 3: Environment-Specific Concerns

SECTION 4: Advanced Training Readiness

SECTION 5: Training Delivery

SECTION 6: Open Close

Report Writing

Date:
Tuesday 17 - Friday 20, 2024