Loading Events
  • This event has passed.
Request archive of this event
11 Excel Secrets for Accountants - July 17 - Webinar VOX ISM

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

VOX ISM will be hosting 80 training webinars this summer, yes two every day, for your enjoyment and continuing education. Please make us part of your daily summer routine, whether you are working from home or at the office.

https://voxism.com/events/

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:
July 17, 2020
Time:
11:00 am - 12:00 pm - ET EDT
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 on the webinar. For questions, reach out to linda@voxism.com, or call 905-840-7477

Privacy Preference Center