Overview
Learn how to combine tables with a single function. Discover functions that mimic a PivotTable report without needing to refresh. See how to easily split and join text.
Why you should Attend
Are you still manually copying and pasting separate ranges to create a table? See how you can automate the process and handle when extra rows are added.
Are you still manually splitting text, like first name and last name? Learn about functions that can do it automatically.
Areas Covered in the Session
- New dynamic array functions explained and demonstrated
- LET, LAMBDA, BYROW, BYCOL, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK and HSTACK
- See how to summarise a formatted table with GROUPBY and PIVOTBY
- Learn techniques to split and join text
- Discover array syntax what it is and how it can be used
- See how to combine multiple ranges in a single formula
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Instructor
Neale Blackwood