Upcoming Events
16234
tribe_events-template-default,single,single-tribe_events,postid-16234,qode-quick-links-1.0,woocommerce-no-js,tribe-no-js,tribe-filter-live,ajax_fade,page_not_loaded,,columns-4,qode-child-theme-ver-1.0.0,qode-theme-ver-11.1,qode-theme-bridge,hide_inital_sticky,wpb-js-composer js-comp-ver-5.1.1,vc_responsive,events-single,tribe-events-style-full,tribe-events-style-theme,tribe-theme-parent-bridge tribe-theme-child-bridge-child,page-template-page-php,singular

Next Generation Advance Excel For Business & Financial Reporting

Loading Events

« All Events

Next Generation Advance Excel For Business & Financial Reporting

March 22 @ 10:00 am - March 23 @ 4:00 pm

Description

Why Attend

The fact is that Excel is the accountant’s, finance and business professional’s best friend. Companies everywhere are overwhelmed by the abundance of unstructured and unclean data. Monthly, quarterly and annual closings are immensely data driven and require moving and exporting data from ‘ERPs’ and databases to Excel. This hands-on course will advance your data massaging, modeling, integration and automation skills to new levels. You will also master normalization and massaging of noisy data, preparation of reports, analysis and reconciliation.

Course Methodology

20% of the course is ‘design and structure’ focused while 80% uses MS Excel as a powerful tool to perform daily, monthly and periodic tasks. Groups and individuals will be required to complete exercises, case studies, and projects on a daily basis.

Course Objectives

By the end of the course, participants will be able to:

  • Apply Excel reporting expertise in business, finance, and accounting by enhancing data slicing and dicing, data massaging, and data analysis skills
  • Use pivot tables and pivot charts to perform automated report writing, analysis and reconciliation most efficiently
  • Repeat tasks and generate reports efficiently by recording, running and editing macros
  • Acquire numerous tips and tricks that will improve working efficiency

Target Audience

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

Target Competencies

  • Reporting, analysis, and reconciliation
  • Data modeling
  • Integration with external data sources
  • Automation and macros
  • Massaging of unstructured and noisy data

Note

This is a hands-on training course using laptops, participants are required to bring their own laptops with a fully working version of Microsoft Excel 2013/2016.

Venue: The Professional Place, 12B, Olumoroti Street, Gbagada Phase 2, Gbagada Lagos.
Date: 22 – 23 March, 2019
Time: 10:00am – 4:00pm
Fee: N15,000 (30% Discount).

NB: The fee covers for Certificate of Completion, Course Materials (PDF & Video – worth over N40K) and light refreshment. It’s actually free.

Don’t miss out of this whooping offer

More details about training available on https://www.dawibassociates.com/

For Inquiries, Please Call 07061813128 or send an e-mail to training@dawibassociates.com

What can I bring into the event?

All participants are expected to come with their laptops as this is a hands-on practical class

How can I contact the organizer with any questions?

The training is organized by DAWIB ASSOCIATES (https://www.dawibassociates.com/). You can contact via e-mail to training@dawibassociates.com or via:

Mobile Number (Calls & Whatsapp): 07061813128
Mobile Number (Calls only): 08092638979

Details

Start:
March 22 @ 10:00 am
End:
March 23 @ 4:00 pm
Event Categories:
, ,
Event Tags:
, , ,
Website:
https://www.dawibassociates.com/

Organizer

DAWIB Associates Ltd
Phone:
08092638979
Website:
https://www.dawibassociates.com/

Venue

12b Olumoroti Jaiyesimi St
12b Olumoroti Jaiyesimi Street Lagos
Lagos, Lagos Nigeria
+ Google Map
Phone:
07061813128
Website:
https://www.dawibassociates.com/
All Rights Reserved © Copyright BookingAnt