close

Find Events

Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World



Use Advanced search

business logo

Workshop on Business Reports and Dashboard Using Excel

By: Human Capital Associates Global Consult Ltd

Rivers State, Nigeria

25 - 29 Sep, 2023  5 days

Follow Event

  

NGN 195,500

Venue: Aldgate Congress Resort Hotel Ltd, Plot 308 Abacha Road, GRA Phase 3, Opposite Next-Time Supermarket, Port Harcourt

Business professionals are frequently required to prepare management reports, scorecards, and dashboards. Attending this course will help you reach advanced Excel levels allowing you to produce such important reports. The course starts with pivot tables, the most important tool ever created to perform data reporting, analysis and reconciliation. It then continues with high level modeling techniques, integration and report visualization, and it ends with automation. Your take-away is guaranteed to add value to your daily and periodic tasks. This course is a must for every intermediate-level Excel user.

For Whom

Business professionals, accountants, finance analysts, senior and junior accountants, business analysts, accounting and finance professionals, research professionals, marketing and sales, administrative staff, supervisors, general staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations, and analysis. Pre-requisite: Intermediate-level Excel knowledge.

Learning Objectives

At the end of the program, participants will be able to:

  • Use their Excel expertise in data slicing and dicing, data massaging, data aggregation, data integration with Access, web, text, SQL, and other databases using pivot tables
  • Perform advanced and dynamic data validations
  • Design outstanding visualization charts, dashboards, scorecards, and flash reports
  • Develop master-level report solutions using advanced form controls and buttons
  • Record, write and edit powerful macros that will perform routine tasks in no-time
Aldgate Congress Resort Hotel Ltd, Plot 308 Abacha Road, GRA Phase 3, Opposite Next-Time Supermarket, Port Harcourt Sep 25 - 29 Sep, 2023

Registration: 08:30:am - 09:00:am

Class Session: 09:00:am - 04:30:am

NGN 195,500.00 + 9,775.00 (VAT)
USD 500.00 + 25.00 (VAT)
(Convert Currency)

Asije Philip 08029170491, 08068933608, 07087578814, 08051365946, 08145745664, 08184727337

Group discount available
Ben O. Chuks - CEO/MD Ebenny Info World - A graduate of Banking and Finance, An Associate member of Chartered Institute of Bankers of Nigeria (CIBN), Certificate in Project Management from Project Management Institute (PMI), Diploma in Accounting University of Benin and Certificate in Accounting Software packages Sage Certified user, Mr. Ben started his career with Compact Technologies ltd, as an ICT facilitator in software department with versed experience on training and consultancy services in Lagos and Benin City. A season Facilitator on Accounting Software Packages, on Sage, QuickBooks, Tally ERP, Advance Microsoft Excel, Data Analytics and application packages etc. He will join others to his experience in this program.OMOREGHA, SOLA. FIAM, ACA - Controller Stores, Megavons West Africa Ltd (WAEC subsidiary). A self-directed, competent Internal Auditor with skills in system application software’s, management of Internal Control System, Risk Assessment, Safeguard of Corporate Assets, Process and Proficient in Pre and Post Cost Control. Mr. Omoregha is an advocate of responsibility accounting and cost control management. Mr. Omoregha is proficient in budgeting, forecasting and trend analysis, Financial Modeling Expert (To prepare Income Statement, statement of financial Position, Cash Flow, and Proficient in investment analysis using discounting methods, (NPV, IRR.) USING EXCEL, Break Even Analysis to measure margin of safety, anticipated profit, Using Scenario Manager, goal seek for analysis, Business and Financial Risk Assessment, Inventory Control Management, Budget preparation and defense, variance analysis
Visit Website Contact Person Download Brochure

Tags:

Financial Management Investment Analysis Risk Management Financial Reporting Account Payables Account Reconciliation ICT Training in Nigeria Courses in Lagos Workshops in Lagos Seminars in Lagos Nigeria Africa September 2023 April 2023 2023