Advanced Data Analysis & Reconciliation
Delivered in 3 Classroom Days or 6 Virtual Sessions + Online Pre-work + 24 PL Credits Per Participants (CFA) + 24 Continuing Professional Development CPD UK Units;
The Advanced Data Analysis & Reconciliation course teaches the use
of Excel Functions, Pivot Tables, Solver Tool, and the new modern Data Analysis tools for extracting, transforming, and loading Data called Power Query. It also covers Reconciliation techniques using excel functions, pivot tables, power query and new reconciliation tools like Inquire Addin..
.
Why this Course is just right for you and your team:
If you do a lot of reporting and your style of reporting is not very effective and time consuming, so you’d like to be more efficient in the use of productive tools like Excel, Power Query, DAX etc
Your organization has different datasets for reporting, and you’d like your team to know and understand how to connect different datasets together using Power Pivot in Excel for reporting and writing DAX in Excel
You or your team would like to gain mastery of the advanced use of Excel for reporting, and to have a proper understanding of data transformation using Power Query
Sign up for this Course!.
About the Course
This course will take the blended approach of teaching Excel Functions and Pivot Tables while using real world case studies to bring home the concept. Participants will learn our report automation methodology and learn the secrets for building dynamic dashboards.
Inside the course participants will learn
- Preparing Data with Data Query
- Analyzing Data with Excel
- Reconciling Data with Excel
Download the full brochure to learn more about our carefully crafted modules.
By the end of the course, you will be able to:
- Apply Excel analysis functions like XLOOKUP, VLOOKUP, MATCH, SUMIFS, OFFSET, INDEX and more functions in real life scenarios.
- Illustrate the use of a modern Reporting Infrastructure in Excel
- Modify an existing report by implementing Reporting Building Blocks
- Describe the interface for the Power Query tools.
- Apply Power Query to automate the report update process.
- Develop Visualizations for performance reports.
- Understand the steps for working effectively with Pivot Tables and Pivot Charts
- Understand the use of Solver tool in Excel to build Optimization and financial planning solutions.
- Discover how to use Excel to carry out basic to advanced reconciliation tasks.
- Construct an advanced and automated reconciliation tool using the Power Query application.
- Learn tips and tricks for effective analysis and reconciliation in using Excel.
- Reinforce all the skills learnt via access to our online course in “Report Automation in Modern Excel.”
Equip you or your team with the Advanced Data Analysis & Reconciliation skills today.
Enroll Now
Testimonials
Here’s feedback from trainings with participants of the course.
Saliu Ayodele
Very explicit, and I love the fact that it’s hands on, I can get to do it myself, very interactive also. Kudos.
Iliyasu Abubakar
The session was epic and great. The instructor was very professional in his delivery, very interactive, dedicative and willing. I found the session very educative and informative. In fact, today's session inspired me to learn more about excel..
Molly N'DRIN
I am feeling like I can do everything I want in terms of reports with Excel would love to have a refresher course soon.
Advanced Data Analysis and Reconciliation
5 Weeks Program: Online Self-Directed | 6 Virtual Sessions |6 Assignments | ₦306,375 |$900
24 PL Credits | CPD 24 Units
| Run | Live Session | Days & Times (GMT +1) | Start Date | End Date | Register |
|---|---|---|---|---|---|
| 1 | Tue & Fri | 9.00am - 11.00am | 25-April-23 | 26-may-23 | closed → |
| 1 | Tue & Fri | 9.00am - 11.00am | 10-Oct-23 | 10-Nov-23 | Register → |
How we deliver training
This Virtual course includes lifetime access to our course portal, here is how you will learn:
- We cover knowledge content for the first two weeks via our online portal, you will receive login details once you are registered for the course.
- You will then start your virtual sessions; each session runs for 2 hours and we usually have 2 sessions a week.
- You will join a group of your peers and be required to complete assignments after each session. You must upload your completed assignment on our portal before the next session. All assignments are graded.
- Once you complete the course, you will receive a digital certificate of completion which can be linked to your social media Profiles. You will also earn CPD Credits if available for this course. Some courses also prepare you for external certifications issued by our partners e.g. Financial Modeling Institute & Microsoft.
- 3 Months after the course, we would follow up on a call with key stakeholders at your organisation to measure the impact of the training (Premium Clients only).
- You have lifetime access to the hundreds of videos in your online portal and you will become a member of our community of learners and experts where you can chat with our trainers and your course mates and ask for help anytime you need it.
Certificate & CPD Credits for this course
Certificate of Completion
Once you complete the program; you achieve 100% completion as recorded in your online portal for the course. We will automatically send you your Digital Certificate of completion for the course which you can attach to your social media profiles.
dbrownconsulting is an accredited provider of CPD UK, An internationally recognized certification service. This course will qualify you for 24 Credit Units.
You also get 24 PL Credits | CPD 24 Units
Enroll Now
Corporate Plans
We understand that your employees are your most valuable assets and investing in their professional development can have a significant impact on the success of your organization. That's why we offer a range of training plans that are designed to help your employees improve their skills, knowledge, and productivity. We offer three distinct training plans for Corporate Team Training. These plans include;.
Testimonial
If you're still undecided, we invite you to watch Nkechi's video testimonial about her experience with our training program at FBN Quest Academy.
Watch HereInterested, in booking multiple seats? Please fill out this form
Get in touch with us
Please fill the form below
FAQ's
What Technology do I need to Attend this Course?
What is the default time zone for the virtual sessions in?
Is this Course Offered in-Person?
Must I do Prep Work?
How do I submit Assignments?
What are your cancellation and refund policy?
Do you have a Training Calendar for Public (Open) programs?
Will there be opportunities to practice
How are Virtual Sessions Structured?
Do I get CPD Credits from this course?
What do your Premium Clients Get?
Other Courses you may be interested in
Specialist
Report Automation & Analytics Academy with Power BI
Report Automation & Analytics Academy ™ is the only implementation program of its kind that not only uses a validated system for automating all your data reports without any IT support
Essential
Advanced Financial Modeler Course
The Advanced Financial Modeler Course is carefully crafted to take anyone from basic to expert level through the delivery of our expertly designed modules. From our online pre-work course where you get extra course to build your knowledge before the course starts, down to the courses and our Mock Examination Simulation, you or your team will acquire skills to confidently build models that impress top-tier companies and take your career to new heights.
Advanced
Advanced DAX for Reporting
DAX is a truly a wonderful language that quickly solves common business data analytics issues like calculating variance over multiple time. boss abeg otp from the app abeg needed urgently thanks boss
Connect with us
30.1k Subscribers
