Microsoft Excel specialists

Power import and analysis in Excel for Finance

The Wringing the most out of PivotTables & MS Query for Finance course is for you if you want to:

  • Import text files and solve common problems
  • Use MS Query to import data from Access, SQL Server and other sources
  • Create powerful reports with PivotTables
  • Enhance your PivotTables with advanced techniques

The Power Pivot & Power BI for Finance course is for you if you want to:

  • Get started with Power Pivot
  • Summarise data quickly and effectively in Power Pivot
  • Open new analytical horizons with the DAX formula language in Power Pivot
  • Combine PivotTable power with formula flexibility
  • Manipulate and consolidate data with Power Query
  • Build a powerful Power Pivot Profit & Loss report
  • Construct an informative Power Pivot Cash Flow forecast
  • Produce a dynamic Power Pivot Aged Debtors report
  • Facilitate friendly user-interaction
  • Share reports with the whole company

Prerequisites:


Learn in a positive environment



  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

The courses cover Microsoft Excel releases XP(2002) through 2013.
Where there are differences among the covered releases, they are pointed out.


Course cancellation policy:



A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.