11 Excel Secrets for Accountants - February 4 - Webinar

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

Excel Secrets for Accountants

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

Details

Date:
February 4, 2021
Time:
11:00 am - 12:00 pm - ET EST
Event Categories:
,

This webinar will take place on the Cisco Webex platform. Once registered, we will send you the links required to join the Live Webinar.
Hope to see you at the webinar. For questions, reach out to linda@voxism.com, or call 705-466-7477.

Loading Events