LEARN EXCEL ADVANCED FM BY SIR NADEEM SHAH WRITER OF 5 EXCEL ADVANCED IN KARACHI

Excel BASIC TO ADVANCED FINANCIAL MODELING

Teacher Name: Sir Nadeem Shah (Writer of 17 Computer Books)
, Friday OFF.
Course Duration: 40 Hours
(2 Months 40 Hrs)
SAT/SUN Batches of SIR NADEEM SHAH
COURSE CONTENTS
• Introduction to Spreadsheet
• Excel Nuts and Bolts (Basic Concepts)
• Basic Formulas (60)
• Advanced Formulas (60)
• Data Analyzing
• Business Intelligence
• Business Modelling
• Stats Functions
• IF Functions
• Lookup Functions
• Date/Time Functions
• D Functions
• Array Functions
• Accounting Functions
• Text Functions
• Pivot Filter Sorting, Subtotals, Consolidation
• Charts Simple Quick Charts
• Dynamic Charts Pivot Charts Formula Charts
• Dashboard Reporting
• Macros (Simple/Advanced)
• Excel with MS-Access Database
• Tables, Forms Queries Reports Linking
• Conditional Formatting Basic to Advanced
• Data Table Goal Seek Scenario
• Validation Protection Skills
• Names, Text to Columns
• Special Tips and Tricks of Excel 2000 to 2013.
• Advanced Printing
• 120 Formulas and Functions Solved

Address:
Esharp Institute, Gulshan-e-Iqbal Main Nipa Chowrangi, Momin Square, Office Number B6, 2nd Floor, Opposite SHAN Hospital and Anglophile Institute, Upp: Ghanies Uniform, Near Nijlas Beauti Parlor, Karachi.
NOTE:
Sir Nadeem Shah will teach this course, Sir Nadeem Shah has written 17 Computer Books including (Peachtree, Tally, QuickBooks, Excel Advanced, Excel Financial Modeling, MS-Office, ICMAP Practical Guide, ICAP Practical Guide etc