Advanced Excel for Data Analysis

: LKR 584

Quick Loan
Field : Information Technology
Provider : AAT Business School
Granting Institute : AAT Business School
Mode of Study: Full time in Sri Lanka
Duration : 9 Hours(1day)

Available Intakes

Please contact the institute for intake information

View Other Courses From This Instiute

Suggest this Advertistment to a friend on


Program Content                                                                                                                       


  •  A one-variable data table

  •  A two-variable data table

  •  Add data labels

  •  Apply data validation to cells

  •  Assign a macro to an object, graphics, or control

  •  Basic Numeric Information

  •  Change the layout of chart elements manually

  •  Conditional Formatting

  •  Conditional Functions

  •  Create a chart from start to finish

  •  Create a custom number format

  •  Create a macro by using Microsoft Visual Basic

  •  Create a Power View report

  •  Create calculated fields

  •  Creating a Template

  •  Creating Dates & Times

  •  Data Lookup Functions

  •  Data table basics

  •  Define and solve a problem by using Solver

  •  Filtering Information

  •  Handle empty cells or zero values

  •  Importing and Exporting Data

  •  Information Functions

  •  Insert subtotals in a list of data in a worksheet

  •  Optimize for Power View reporting

  •  PivotTable data analysis using a Data Model in Excel 2013

  •  Protect a worksheet with or without a password

  •  Record a macro

  •  Scenario basics

  •  Share workbook, Merging copies of a shared workbook

  •  Show or hide data markers

  •  Sorting

  •  Sparklines

  •  Speed up calculation on a worksheet that contains data tables

  •  Statistical Functions

  •  Switch between various sets of values by using scenarios

  •  Text Functions

  •  Use Goal Seek to find the result you want by adjusting an in

  •  Using Common Built-In Functions

  •  Using Hyperlinks

  •  Working with Named Ranges


Investment (Including Lunch, refreshments, Course Materials and Practical DVD)                          

  • Rs.7,000/-



  • On successful completion “Certificate of Participation Advanced Ms. Excel for Data Analysis”

  • 3CPD Credits for AAT Members


Method of Application                                                                                                                       

  •  If an eligible person wishes to follow these courses, he /she should obtain an application form from the AAT Business School.      Send 

      the application form together with his /her cash pay-in – voucher between 9.00am-5.00pm (Monday-Sunday) or 

  •  Download the Online Application form using the link below and register with one of the  following modes of payment •  First-come, first-served| 30 participants only  

Mode of Payment                                                                                                                       

  •  Cash @ AAT Centre (Monday to Friday 9.00am-4.45pm, Saturdays 9.00am-4.00pm)

  •  Cheque in favor of “Association of Accounting Technicians of Sri Lanka” & Crossed “Account Payee Only”

  •  Online payments through

  •  Direct deposits to Association of Accounting Technicians of Sri Lanka, 

      A/C No. 039020327099 Hatton National Bank Bambalapitiya Branch



Institutes Quick Loan