Excel formula based

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) For registration ADMISSION OPEN NOW Excel Advanced Financial Modeling SAT/SUN Batches Course Detail: Introduction to SpreadsheetExcel Nuts and Bolts (Basic Concepts)Basic Formulas (60)Advanced Formulas (60)Data AnalyzingBusiness IntelligenceBusiness ModellingStats FunctionsIF FunctionsLookup FunctionsDate/Time FunctionsD FunctionsArray FunctionsAccounting FunctionsText FunctionsPivot, Filter, Sorting, Subtotals, Consolidation Address: E-SHARP Institute of Computerized Accounitng, Momin Square, 2nd Floor, B6, Gulshan e Iqbal NIPA Chowrangi Karachi, Near Nadeem Medical and ICMAP, Opp: SHAN Hospital and Anglophile Institute, Upp: Ghanis Uniform. Class Schedule: Regular Course 3 days per week Fast Track 5 days per week Executive classes only Sat & Sun VISITNG TIMING: 12PM TO 9PM SUNDAY: 2PM TO 6PM FRIDAY: OFF Note: Sir Nadeem Shah's New Book Peachtree in URDU is also available. (Sir Nadeem Shah is the writer of 17 Books), All Computerized Accounting Softwares Training will be given by SIR NADEEM SHAH. For More Details Visit E-SHARP and Meet Sir Nadeem Shah. Forth coming Books by Sir Nadeem Shah: Tally ERPExcel Business ProjectsMS-ProjectPeachtree Sage 2013 Kindly visit for E-SHARP INSTITUTE

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) For registration ADMISSION OPEN NOW Excel Advanced Financial Modeling SAT/SUN Batches Course Detail: Introduction to SpreadsheetExcel Nuts and Bolts (Basic Concepts)Basic Formulas (60)Advanced Formulas (60)Data AnalyzingBusiness IntelligenceBusiness ModellingStats FunctionsIF FunctionsLookup FunctionsDate/Time FunctionsD FunctionsArray FunctionsAccounting FunctionsText FunctionsPivot, Filter, Sorting, Subtotals, Consolidation Address: E-SHARP Institute of Computerized Accounitng, Momin Square, 2nd Floor, B6, Gulshan e Iqbal NIPA Chowrangi Karachi, Near Nadeem Medical and ICMAP, Opp: SHAN Hospital and Anglophile Institute, Upp: Ghanis Uniform. Class Schedule: Regular Course 3 days per week Fast Track 5 days per week Executive classes only Sat & Sun VISITNG TIMING: 12PM TO 9PM SUNDAY: 2PM TO 6PM FRIDAY: OFF Note: Sir Nadeem Shah's New Book Peachtree in URDU is also available. (Sir Nadeem Shah is the writer of 17 Books), All Computerized Accounting Softwares Training will be given by SIR NADEEM SHAH. For More Details Visit E-SHARP and Meet Sir Nadeem Shah. Forth coming Books by Sir Nadeem Shah: Tally ERPExcel Business ProjectsMS-ProjectPeachtree Sage 2013 Kindly visit for E-SHARP INSTITUTE

Excel Advanced Training Advanced Excel formulas and Functions Training Course Outline  Level 1: Data Managing, Sorting & Filtering Tables  Level 2: Conditional Formatting & Proofing Level  3: Using Formulas and Functions Level  4: Working with Pivot Table Level  5: Working with Pivot Chart Level  6: Data Consolidation & Validation Tools Level  7: Working with Drawings & Graphics  Level  8: Using Macros & Auditing Tools  Level  9: Protecting Worksheet & Workbook in Excel Level  10: Shortcuts Excel Tips & Tricks Training Instructor:    RIAZ HUSSAIN  12 Years Experienced Trainer as Trainer

ADVANCED EXCEL PROFESSIONAL TRAINING Individual & Corporate Training Course Outline Level 01: Data Managing, Sorting & Filtering Tables  Level 02: Conditional Formatting & Proofing Level 03: Using Formulas and Functions  Level 04: Working with Pivot Table Level 05: Working with PivotChart Level 06: Data Consolidation & Validation Tools Level 07: Use Group, Ungroup and subtotal Data  Level 08: Working with Drawings & Graphics Level 09: Using Macros Tools and Buttons whit Dynamic Charts   Level 10: Protecting Worksheet & Workbook in Excel  Level 11: Special Tips & Tricks (Keyboard Shortcuts)  Training Instructor: Riaz Hussain Experience: 13 Years Expert Trainer  12 Years Industry Experienced as Senior Accountant P-012, Siddiques Trade Centre Gulberg II, Lahore from Jun 15th

This course is for anyone who has used Excel before to create and alter spreadsheets and perform basic calculations. Learners must have used Excel before and be familiar with using formulae for calculations; for example a multiplication that involves a fixed figure (such as VAT) and requires an absolute cell reference (e.g. $B$4). >What You Will Learn Create formulas using time, time formats Manually create a range name to refer to a cell, for example ‘Vat’ rather than B2 Paste special, Copy part of your Excel spreadsheet to a Word document and have any changes made in Excel updated in the Word document Use functions such as average, minimum and maximum to create statistical information Use Conditional Formatting to automatically change the look of cells depending on their value Create a calculation based on a condition. e.g. add a £10 bonus to all staff who have achieved results above target Count entries IF they meet a condition. e.g. count the number of customers who live in Leeds Create and work on more than one worksheet and group them to make changes simultaneously Use the Consolidate feature to summarise multiple sheets of data. Link formulas across Worksheets Protect your data from deletions or changes Create a basic Pivot Table to summarise large sets of data easily YOuth vision Institute & Academy Islamabad Views: 178

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

MS EXCEL ADVANCED Advanced Excel Formulas Based Training Professional and Practical Training Course Outline Level # 1 Pivot Table & Pivot Chart Level # 2 Formatting and Proofing Level # 3 Basic List Management Level # 4 Database Functions Level # 5 Form Control Button with Dynamic Chart Training Instructor : RIAZ HUSSAIN 11 Years Experienced Trainer 0 3 0 1 – 2 1 2 6 4 2 2 Email: riaz.icbt@gmail.com

MS EXCEL ADVANCED Advanced Excel Formulas Based Training Professional and Practical Training Course Outline Level # 1 Pivot Table & Pivot Chart Level # 2 Formatting and Proofing Level # 3 Basic List Management Level # 4 Database Functions Level # 5 Form Control Button with Dynamic Chart Training Instructor: RIAZ HUSSAIN 11 Years Experienced Trainer 0 3 0 1 – 2 1 2 6 4 2 2 Email: riaz.icbt@gmail.com Views: 163

PRACTICAL COMPUTERIZED ACCOUNTING TRAINING Professional & Practical Job Based Training   We offer (QuickBooks & Peachtree) Consultancy and Staff Training Services For Best Jobs - Pakistan & Abroad: Industry Based Accounting Training as: (Manufacturing, Distribution, Services and Construction Industries) For as under mention Software’s: 01- SAP Business One ERP 02- Tally. ERP 9.2 03- Quick Books Enterprise 04- Quick Books Premier 05- Quick Books Pro. 06- Peachtree Accounting 07- MYOB Accounting 08- Sage Line 50 09- AccPac Accounting 10- Advanced Excel Formulas Based Training 11- UBS Accounting 12- Special Short Course for Non Accountant Persons Learn in Short time Accounting Concept with Practical Training We Provide Accounting & Bookkeeping Services in Lahore and Other Cities in Pakistan. Trainer Instructor and Consultant RIAZ HUSSAIN Experience: 13 Years Experienced Trainer 12 Years Industry Experienced as Senior Accountant Cell: 0 3 4 8-4 4 5 6 4 5 5 /       0 3 0 1-2 1 2 6 4 2 2 Address: P-41, Paradise Floor Siddique Trade Centre Gulberg II Lahore. from Jul 24th

PRACTICAL TRAINING We offer Professional and Practical Computerized Accounting Training Industry Based Accounting Training as: (Manufacturing, Distribution, Services and Construction Industries) We offer Consultancy and Staff Training (Special Individual) Services For as under mention Software’s: 01- SAP Business One ERP 02- Tally. ERP 9.2 03- Quick Books Enterprise 04- Quick Books Premier 05- Quick Books Pro. 06- Peachtree Accounting 07- MYOB Accounting 08- Sage Line 50 09- AccPac Accounting 10- Advanced Excel Formulas Based Training 11- UBS Accounting 12- Special Short Course for Non Accountant Persons Learn in Short time Accounting Concept with Practical Training For Best Jobs: Pakistan, Saudi Arabia, UAE (Dubai), USA, UK, Canada, Malaysia, Australia, Germany. We offer Accounting Training and Software Implementation services. We can upgrade your current accounting data to any accounting software of your need. Training Instructor: 12 Years Experienced Trainer 11 Years Industry Experienced as Senior Accountant  RIAZ HUSSAIN 0 3 0 1-2 1 2 6 4 2 2 0 3 4 8-4 4 5 6 4 5 5

PRACTICAL TRAINING We offer Professional and Practical Computerized Accounting Training Industry Based Accounting Training as: (Manufacturing, Distribution, Services and Construction Industries) We offer Consultancy and Staff Training (Special Individual) Services For as under mention Software’s: 01- SAP Business One ERP 02- Tally. ERP 9.2 03- Quick Books Enterprise 04- Quick Books Premier 05- Quick Books Pro. 06- Peachtree Accounting 07- MYOB Accounting 08- Sage Line 50 09- AccPac Accounting 10- Advanced Excel Formulas Based Training 11- UBS Accounting 12- Special Short Course for Non Accountant Persons Learn in Short time Accounting Concept with Practical Training For Best Jobs: Pakistan, Saudi Arabia, UAE (Dubai), USA, UK, Canada, Malaysia, Australia, Germany. We are offering Accounting Training and Software Implementation services. We can upgrade your current accounting data to any accounting software of your need. Training Instructor: 12 Years Experienced Trainer RIAZ HUSSAIN--0301-2126422

Get Fast Track Computerized Accounting Training For Best jobs: Pakistan,  Saudi  Arabia,  UAE (Dubai) USA, UK, Canada, Malaysia, Australia. We also offer other Accounting Software Training for: SAP Business One ERP, Tally.ERP 9.2 QUICKBOOKS: Enterprise, Premier, Pro. Peachtree Quantum, MYOB Accounting Advanced Excel Formulas Based AccPac  Accounting,  Sage Line  Years  Experienced  Trainer RIAZ HUSSAIN

Online & Home based Excel Tutor / Training / Coaching Available Improve Your chances in Applying Jobs Microsoft Excel is designed to make participants excel skills & their career/business to new heights. - Debtor / Creditors aging on PIVTO TABLE - Linking Sheets - Formatting - Basic Arithmetic Functions - Average, Count, Minimum, Maximum - Extending Formulas - IF Functions, Nesting - Conditional Formatting - Creation of PIVOT Tables - Functions of PIVOT Tables - Slicers of PIVOT Tables - PIVOT charts - Filters - V Lookup - H Lookup - Various Charting Techniques - Goal Seek - Template Designing - SUM IF Formula - SUM PRODUCT - Group - Un Group - Consolidate Data - Data Validation Etc. - And much more Views: 7

IPATS Offer the Office Automation Course Khanna Pul Rawalpindi Govt of Pakistan Course Objectives The program will facilitate the students to: Understand the basic I/O operations and learn to install windows/software Understand and use MS word, MS Excel and MS Power point for office purposes. Learn how to do efficient internet surfing for various purposes. Set-up email accounts and learn various techniques to use them effectively Advance their skills for working effectively in teams and boost their confidence for public communication and presentations Entry Criteria Minimum Qualification: Matric Ability to understand and use simple English Course Outline Topic/Theme Sub Topics/Techniques Class Activities Introductions to Computers Brief History of Computers Introduction to basic parts of computers and its accessories Introducing basic terms and concepts used to describe the specific nature of a computer Diversity of computers available in terms of brands, capacity, function etc. Concept of software and its diversity Students will be facilitated to understand and build skills for the core concept through following ways Discussion and explanation using multi-media Demonstration Hands-on experience and practicing Working on assignments or mini projects Class presentations MS Word Creating Word Document Using different types of fonts and colors Formatting Editing and Review Mail Merging, Page Layouts Printing Preferences, Table Utilities, Hyperlinks, label & Envelope Editing, Inserting Clip art & Word Art, pictures References Using pre-defined templates MS Excels A first look at Excel 2007 Rows & Columns, Text & numbers in a Cell Editing in a Cell Centre text & numbers Formatting Working with Excel sheet Manipulating data through formulas and functions. Applying data fitters Creating Graphs and Charts Organizing data Creating different types of charts. Graphs Editing the graphs and charts Working with Multiple Worksheets Importing Excel Sheets into Word and Power point Using pre-defined templates Printing Printing different types of excel sheets MS Power Point Introduction to power point and its tools and options Creating simple presentations and reviewing, editing and formatting them using proper options Working with objects, videos and images Working with smart art and Clip art Working with charting Hyper linking Applying and customizing Animation Printing Internet use Introduction World Wide Web Introduction and use of various search engines Techniques for effective and efficient Google search Introduction to social media and its web based tools such as Face book, twiter, LinkdIn etc. Ethics of participating in social media at web Emails Creating email accounts Using various options for effective emailing and follow-ups Ethics of emailing Contact Office: 0321-9606785, 0331-5145601, 051-4431886 Views: 63

Course Objectives The program will facilitate the students to: Understand the basic I/O operations and learn to install windows/software Understand and use MS word, MS Excel and MS Power point for office purposes. Learn how to do efficient internet surfing for various purposes. Set-up email accounts and learn various techniques to use them effectively Advance their skills for working effectively in teams and boost their confidence for public communication and presentations Entry Criteria Minimum Qualification: Matric Ability to understand and use simple English Course Outline Topic/Theme Sub Topics/Techniques Class Activities Introductions to Computers Brief History of Computers Introduction to basic parts of computers and its accessories Introducing basic terms and concepts used to describe the specific nature of a computer Diversity of computers available in terms of brands, capacity, function etc. Concept of software and its diversity Students will be facilitated to understand and build skills for the core concept through following ways Discussion and explanation using multi-media Demonstration Hands-on experience and practicing Working on assignments or mini projects Class presentations MS Word Creating Word Document Using different types of fonts and colors Formatting Editing and Review Mail Merging, Page Layouts Printing Preferences, Table Utilities, Hyperlinks, label & Envelope Editing, Inserting Clip art & Word Art, pictures References Using pre-defined templates MS Excels A first look at Excel 2007 Rows & Columns, Text & numbers in a Cell Editing in a Cell Centre text & numbers Formatting Working with Excel sheet Manipulating data through formulas and functions. Applying data fitters Creating Graphs and Charts Organizing data Creating different types of charts. Graphs Editing the graphs and charts Working with Multiple Worksheets Importing Excel Sheets into Word and Power point Using pre-defined templates Printing Printing different types of excel sheets MS Power Point Introduction to power point and its tools and options Creating simple presentations and reviewing, editing and formatting them using proper options Working with objects, videos and images Working with smart art and Clip art Working with charting Hyper linking Applying and customizing Animation Printing Internet use Introduction World Wide Web Introduction and use of various search engines Techniques for effective and efficient Google search Introduction to social media and its web based tools such as Face book, twiter, LinkdIn etc. Ethics of participating in social media at web Emails Creating email accounts Using various options for effective emailing and follow-ups Ethics of emailing Contact Office: 0331-5145601, 03495021336 Views: 6

IPATS Offer the Office Automation Course Khanna Pul Rawalpindi Govt of Pakistan Course Objectives The program will facilitate the students to: Understand the basic I/O operations and learn to install windows/software Understand and use MS word, MS Excel and MS Power point for office purposes. Learn how to do efficient internet surfing for various purposes. Set-up email accounts and learn various techniques to use them effectively Advance their skills for working effectively in teams and boost their confidence for public communication and presentations Entry Criteria Minimum Qualification: Matric Ability to understand and use simple English Course Outline Topic/Theme Sub Topics/Techniques Class Activities Introductions to Computers Brief History of Computers Introduction to basic parts of computers and its accessories Introducing basic terms and concepts used to describe the specific nature of a computer Diversity of computers available in terms of brands, capacity, function etc. Concept of software and its diversity Students will be facilitated to understand and build skills for the core concept through following ways Discussion and explanation using multi-media Demonstration Hands-on experience and practicing Working on assignments or mini projects Class presentations MS Word Creating Word Document Using different types of fonts and colors Formatting Editing and Review Mail Merging, Page Layouts Printing Preferences, Table Utilities, Hyperlinks, label & Envelope Editing, Inserting Clip art & Word Art, pictures References Using pre-defined templates MS Excels A first look at Excel 2007 Rows & Columns, Text & numbers in a Cell Editing in a Cell Centre text & numbers Formatting Working with Excel sheet Manipulating data through formulas and functions. Applying data fitters Creating Graphs and Charts Organizing data Creating different types of charts. Graphs Editing the graphs and charts Working with Multiple Worksheets Importing Excel Sheets into Word and Power point Using pre-defined templates Printing Printing different types of excel sheets MS Power Point Introduction to power point and its tools and options Creating simple presentations and reviewing, editing and formatting them using proper options Working with objects, videos and images Working with smart art and Clip art Working with charting Hyper linking Applying and customizing Animation Printing Internet use Introduction World Wide Web Introduction and use of various search engines Techniques for effective and efficient Google search Introduction to social media and its web based tools such as Face book, twiter, LinkdIn etc. Ethics of participating in social media at web Emails Creating email accounts Using various options for effective emailing and follow-ups Ethics of emailing Contact Office: 0349-5021336, 0331-5145601 Views: 162