Excel Course for Auditors and Consultants

$339

Online Excel for Auditors and Consultants

Data Cleanup in Excel

An online course that will help you with all your data clean up issues including

  • Reformating data to be able run reports or reconciliations.
  • Splitting columns into names and surnames, product codes and product names
  • Deleting rows that contains unnecessary headers, footers, subtotals and other unwanted information.
  • Changing dates into any format even if Excel refuses to change the format.
  • Filling in gaps in reports

To see some preview lessons and the detailed contents visit http://online-excel-training.auditexcel.co.za/course/data-cleanup-in-excel/

Pivot Tables in Excel 2013 and higher

An online course that will help you with all your pivot table issues including

  • Setting up a pivot table
  • Enhancing the values to give % of and running totals
  • Normalising data
  • Using slicers to control all the pivots in a spreadsheet
  • Create Pivot Charts
  • Use Timelines
  • Extract information from a Pivot Table
  • Create your own fields

To see some preview lessons and the detailed contents visit http://online-excel-training.auditexcel.co.za/course/pivot-tables-excel-2013/

Excel Dashboards and Management Reporting

Excel Dashboards and Management Reporting

Get & Transform PowerQuery Online Course

An online course that will help you with all your data clean up issues using PowerQuery (Get & Transform) including:

  • Reformatting data to be able run reports or reconciliations.
  • Splitting columns into names and surnames, product codes and product names
  • Deleting rows that contains unnecessary headers, footers, subtotals and other unwanted information.
  • Changing dates into any format even if Excel refuses to change the format.
  • Filling in gaps in reports

To see some preview lessons and the detailed contents visit https://online-excel-training.auditexcel.co.za/course/get-and-transform-excels-data-cleanup-tool/

Categories: ,

Description

A bundle of courses that cover everything auditors or consultants will need relating to their Excel knowledge.

You may also like…