The video is sponsored by dbrownconsulting's Excel and Power BI Clinic series (Sep 2017 Episode).
In this months episode of our monthly Excel and Power BI Webinars, we solve a real-life reconciliation headache for a group of companies trying to consolidate many line items of their financials from very unconventional data sets per company.
I use a combination of helper tables, the INDIRECT function, SUMIFS, the & Operand and a whole lot of logic. We discuss my 10 tips for becoming a guru in Excel
For our online Excel and financial Modelling courses. visit www.OfficeTrainingHub.com
Comment below and share your thoughts. Enjoy! and join next months webinar on www.meetup.com/Nigeria-Excel-...
Негізгі бет Complex Reconciliation with INDIRECT Function and more
Пікірлер