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.
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.
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
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