Are you Microsoft Dynamics 365 Business Central (NAV) accountant that works too in Excel a lot? Are you interested in learning Excel Secrets for Accountants from other Dynamics 365 Business Central accountants on how to work faster and smarter in Excel?  

In this webinar, we’ll focus on using Excel better and teaching fellow accountants some fancy formulas, short-cuts and integration tools available in 2020. The next reporting tool that Dynamics 365 Business Central accountants use is Power BI have a look, it is as easy to use as Excel, this should be your summer 2020 project! 

Bring your notepad, questions and have your spreadsheets open for 45 minutes of training.

Agenda:

• Exporting from BC

• Exporting from BC – using filters

• Sorting and Subtotaling

• Including from table to a range

• Nested Subtotals

• Pivot tables

• Pivot table settings

• Slicers

• Pivot table calculated fields

• Vertical Lookup

• Data validation

• What if

• Auditing

• Export update, Refresh & Publish data in BC

• Power BI – the next generation

If you can’t make it, register now, and we’ll send you a link to the webinar recording once it’s ready.