AAT Business School
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

25th Sep 2017 | Friday 9.00am -6.00pm | One day Workshop


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

Rs.7,000/-


Prerequisites                          


Delegates should have a basic knowledge of MS Excel


Certifications                          

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. 165139 – BOC – Narahenpita Branch (send the scan copy and submit the original bank – slip
      at the Business School Counter)
  •  EzCash
  1. 1.Dial #111# from your dialog mobile and select “Institute payment” from menu
  2. 2.Enter your pin number
  3. 3.Enter Institute code AATB
  4. 4.Enter your course code (SME) and follow the instructions

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