AAT Business School
Advanced Ms Excel for Data Analysis
Advanced Ms Excel for Data Analysis PDF Print E-mail

Covering 40 topics within Ms Excel demonstrating the intrinsic feature and shortcuts the package offers for the analyzing data.

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, graphic, 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

24th July 2019 | Wednesday 9.00 am - 6.00 pm | One day Workshop

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



Delegates should have a basic knowledge of MS Excel


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

3CPD Credits for AAT Members

As we have limited seats, please send your application early along with the payments.

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  

Download Application

Mode of Payment                                                                                                                       

  •  Cash @ AAT Centre (Monday to Friday 9.00am-4.45pm, Saturdays 9.00am-4.00pm)
  •  Cheque in favour of “Association of Accounting Technicians of Sri Lanka” & Crossed “Account Payee Only”
  •  Online payments through www.aatsl.lk
  •  Direct deposits to Association of Accounting Technicians of Sri Lanka,
      A/C No. 039020327099 Hatton National Bank Bambalapitiya Branch

Use the Depositors reference No

For AAT members :-

          Member payment code

For AAT Students :-

        Student Registration code

Others :-

Call 112559670 for “Depositors reference No”

(Send the scan copy and submit the original bank – slip at the Business School Counter. Also write the “Depositors reference No” in the Application form)

Click to make an Online Inquiry

Feel free to contact us for any clarification Tel: 0112 559670 | This e-mail address is being protected from spambots. You need JavaScript enabled to view it |

Find us on facebook.com/aatbusinessschool


for More Details...

              IT Courses

                Tax Courses