ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Advanced Excel

•
•
P
PioneersAcademy

This document provides details about an advanced Microsoft Excel training course, including general objectives to help participants understand and use Excel's advanced features, topics that will be covered such as formatting, charts, filters, pivot tables, and VBA macros. The training is intended for intermediate to expert level financial analysts, managers, accountants, auditors, and data analysts. It will take place over two days from 6-9pm, costs 300 JD originally but has a 30% discount.

1 of 3
Download to read offline
Our International Authorization +962 6 5150843 +962 6 5150844 +962 798206406
General objectives: • Preface about MS excel • Pinpointing the participants about the importance of MS excel in day to day process • Assist the participants in comprehension & understanding the re- quired needs from MS excel. • Grant the participants the required skills in order to use Topics & Elements: • Introduction about Advanced Excel. • Advanced Format Cells. • Advanced Paste Special. • Advanced Using Form Features • Advanced Protect In Excel 20071 • Advanced Conditional Format 1 • Advanced Validation. • Advanced Formula. • Array Formula. • Sum Product Formula. • Introduction for Charts. • Advanced Charts. • Filter with Advanced Filter and its Tricks • Sort • Consolidate • Subtotal and Outline • What If Analysis • Introduction for PivotTable • Advanced PivotTable • PivotChart • VBA Environment • Recording and Using Macro
Course Level:] • Intermediate Level • Higher Intermediate Level • Expert Level Targeted classes & • Financial Analyst group: • Finance Manager • Accountants • Auditors • Data analyst • Researcher Course Details: • Duration :(26) Hours. • Material Language: English - Arabic Training Aids: • White board. • Flip chart. • Training labs Time: 6:00 - 9:00pm Date: 22/04/2012 - 23/04/ 2012 Price: 300 JD Special Discount 30%

More Related Content

Advanced Excel

  • 1. Our International Authorization +962 6 5150843 +962 6 5150844 +962 798206406
  • 2. General objectives: • Preface about MS excel • Pinpointing the participants about the importance of MS excel in day to day process • Assist the participants in comprehension & understanding the re- quired needs from MS excel. • Grant the participants the required skills in order to use Topics & Elements: • Introduction about Advanced Excel. • Advanced Format Cells. • Advanced Paste Special. • Advanced Using Form Features • Advanced Protect In Excel 20071 • Advanced Conditional Format 1 • Advanced Validation. • Advanced Formula. • Array Formula. • Sum Product Formula. • Introduction for Charts. • Advanced Charts. • Filter with Advanced Filter and its Tricks • Sort • Consolidate • Subtotal and Outline • What If Analysis • Introduction for PivotTable • Advanced PivotTable • PivotChart • VBA Environment • Recording and Using Macro
  • 3. Course Level:] • Intermediate Level • Higher Intermediate Level • Expert Level Targeted classes & • Financial Analyst group: • Finance Manager • Accountants • Auditors • Data analyst • Researcher Course Details: • Duration :(26) Hours. • Material Language: English - Arabic Training Aids: • White board. • Flip chart. • Training labs Time: 6:00 - 9:00pm Date: 22/04/2012 - 23/04/ 2012 Price: 300 JD Special Discount 30%