LEARN ADVANCE EXCEL FM WITH BUSINESS INTELLIGENCE BY SIR NADEEM SHAH IN BADIN

E-SHARP Institute of Computerized Accounting offers Excel Advanced Financial Modeling Formula Based Training with Dashboard (2 Months Course) by SIR NADEEM SHAH (Writer of Peachtree, Tally, QuickBooks, Excel Advanced, MS-ACCESS, Excel Financial Modeling, MS-Office Books)
Excel Advanced Financial Modeling with MS-Access
(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
E-SHARP Institute, Gulshan e Iqbal, Main Nipa Chowrangi, Momin Square, 2nd Floor, B6. Opposite: SHAN Hospital and Anglophile. Upp Ghanies Uniform, Karachi.
PHN 0345-2246537