際際滷

際際滷Share a Scribd company logo

Financial modelling2a

Download as PPT, PDF
A
aliabbasrajput

This document appears to be a presentation on advanced Excel functions and tools. It includes an agenda that covers topics like basic functions, date functions, logical functions, text functions, reference functions, basic tools, more tools, tools++, tools reloaded, and tools extreme. Each section provides examples of functions and tools covered like SUM, COUNT, IF, VLOOKUP, conditional formatting, pivot tables, goal seek, solver, auditing, and data validation. The presentation was given by Tahir Mahmood Fazal on January 30-31, 2013 in Islamabad, Pakistan.

1 of 37
Download to read offline
WELCOMEWELCOME HOUSE NO. 1-B, STREET NO. 34 F-8/1, ISLAMABAD
Advance ExcelAdvance Excel Tahir Mahmood Fazal Associate Member of 30-31 JANUARY 2013
Presentation by Tahir Mahmood FazalPresentation by Tahir Mahmood Fazal 1-B, Street No. 34 F-8/1, Islamabad Ph:0322-5065146
Why Workshop??
Financial modelling2a
Financial modelling2a
Prerequisites Setting up Worksheet Formatting Page / Cells Cut, Copy Paste, Paste Special Mathematical calculations Tool Bars Absolute Formulas
Brain Wash CAN EXCEL THINK ?
Manz Best Friend
Activity Keyboard Shortcuts ???Keyboard Shortcuts ??? Print Preview Inserting New worksheet Help XL Function SUM
Introduction to Functions
EXCEL TOOLS XL Functions Basic Functions * 損 Sum, count, average 損 SUBTRACTION, DIVISION 損 MIN & MAX 損 ROUNDING 損 IRR & NPV Date Functions * 損 TODAY 損 NOW 損 MONTH 損 YEAR 損 DAY Logical Functions 損 IF, SUMIF, countif 損 AND & OR 損 ISERROR 損 Nesting
Basic Functions ROUNDING + Displayed Precision IRR & NPV MIN & MAX
Activity
Date Functions TODAY NOW MONTH YEAR DAY
Activity
Logical Functions AND + OR IF, SUMIFISERROR Nesting
Activity
EXCEL TOOLS XL FUNCTIONS Basic Functions * Date Functions * Logical Functions * Text Functions * 損 LEFT, RIGHT & MID 損 LENGTH & FIND (T2C) 損 TEXT Reference Functions* 損 VLOOKUP 損 INDEX 損 INDIRECT Activity + Q&A
Text Functions LEFT, RIGHT & MID FIND LENGTH Text to Columns
Activity
Reference Functions VLOOKUP INDEX INDIRECT
Activity + Q&AMIN & MAX ROUNDING IRR & NPV TODAY NOW MONTH YEAR DAY IF, SUMIF AND & OR ISERROR Nesting LEFT, RIGHT & MID LEN & FIND TEXT VLOOKUP INDEX INDIRECT
Financial modelling2a
Financial modelling2a
Basic tools Thousand Formatting Conditional Formatting Filter Transpose
Activity
Sub-Totals Consolidation Pivot Table More tools
Activity Sub-Totals Pivot Table
EXCEL TOOLS Basic Tools More Tools Tools ++ * 損 Goal Seek 損 Solver Tools Reloaded * 損 File Linking 損 Auditing 損 Evaluation Tools Extreme 損 Circular Calculation 損 Data Validation & Import 損 Protection
Tools ++ Scenarios Activity IV
Activity Goal Seek Solver
Tools Reloaded File LinkingFile Linking AuditingAuditing EvaluationEvaluation
Activity File Linking Auditing Evaluation
Tools Extreme Circular Calculation Data Validation Protection
Activity Thousand Formatting Transpose Conditional Formatting Filter Sub-Totals Consolidation Pivot Table Goal Seek Solver File Linking Auditing Evaluation Circular Calculation Data Validation Protection
THANK YOU

More Related Content

Financial modelling2a