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
Time:
11:00 am - 12:00 pm - ET EDT
Event Categories:
,

Venue

WebEx Conference Line

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

Loading Events

« All Events

  • This event has passed.

11 Excel Secrets for Accountants – July 17 – Webinar

July 17 @ 11:00 am - 12:00 pm EDT

Best Practices for Accounts Receivable and Accounts Payable - July 16 - Webinar VOX ISM
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
Time:
11:00 am - 12:00 pm - ET EDT
Event Categories:
,

Venue

WebEx Conference Line

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

Details

Date:
July 17
Time:
11:00 am - 12:00 pm - ET EDT
Event Categories:
,

Venue

WebEx Conference Line