|Date:||March 21, 2018|
|Time:||1:00 PM AEDT|
|Event:||FREE Webinar - Excel Yourself 2017|
|Topic:||Excel Yourself 2017|
|Registration:||Click here to register.|
FREE Webinar – Excel Yourself 2017
This is my annual smorgasbord session. I revisit four of my magazine articles from the year and add some extra content.
I will revisit four of my magazine articles from 2017 and add some extra content. We cover a few functions (two new ones); an automated filtering solution using a macro and how to calculate moving annual totals. The Excel file includes the examples from ten of my articles from 2017.
This session covers four of my articles from 2017.
• XNPV and XIRR functions
• Moving annual totals
• Advanced Filter automation
• TEXTJOIN and CONCAT functions (new to some versions of Excel 2016)
Content applies to Excel 2007 and later versions, except the two new Excel 2016 functions.
As always I will share some other tips along the way.