308161b8c91426ba0e234d4daed83d72.jpg
Recorded

Excel Prowess: Establishing and Using Powerful Dashboards

Discovering how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources.

Speaker(s): David H. Ringstrom, CPA
Industry : Human Resource, Payroll & Accounting, BFSI, Microsoft Office, Education, Accounting and Taxation , Banking, Payroll, Excel, Performanace Management
Duration : 75 minutes

1310fe063de4c0d9a43a9d19bcfe9739.jpg
Recorded

Excel PivotTables Crash Course: How to Crunch Numbers Like an Expert

Learning how to create Pivot Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This training will provide you with a solid foundation that you can use to build your own pivot tables and reports.

Speaker(s): Mike Thomas
Industry : Payroll & Accounting, BFSI, Microsoft Office, Accounting and Taxation , Banking, Payroll, Excel
Duration : 90 minutes

1310fe063de4c0d9a43a9d19bcfe9739.jpg
Recorded

Improve Your Excel Accuracy – Master VLOOKUP, MATCH and INDEX Functions

VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) formulas in Excel. Used properly, they will help you to achieve this.

Speaker(s): Mike Thomas
Industry : Payroll & Accounting, BFSI, Microsoft Office, Accounting and Taxation , Banking, Payroll, Excel
Duration : 60 minutes

308161b8c91426ba0e234d4daed83d72.jpg
Recorded

Excel Prowess: Intermediate Pivot Tables

Speaker(s): David H. Ringstrom, CPA
Industry : Payroll & Accounting, BFSI, Microsoft Office, Accounting and Taxation , Banking, Payroll, Excel
Duration : 75 minutes