Data sir

Ms Office Course Outline: Introduction to Word:  Setting Up Your Word Environment  Text Basics  Saving Documents  Proofing Features  Working with Hyperlinks  Printing Word Basics:  Creating a New Document  Formatting Text  Working with Text boxes  Inserting Clip Art  Working with Shapes  Using a Template  Working with Lists  Line and Paragraph Spacing Doing More With Word:  Modifying Page Layout  Working with Pictures  Columns and Ordering  Working with Headers and Footers  Working with Tables  Using SmartArt Graphics  Using Indents and Tabs  Applying Styles and Themes Advanced Word:  Using Mail Merge Extras:  New Features in Word  Word Illustrations – Worth More Than a Thousand Words Ms Excel Tutorial: Introduction to Excell:  Setting Up Your Excel Environment  Starting a Workbook  Modifying Columns, Rows, and Cells  Formatting Text  Creating Simple Formulas  Working with Cells  Printing Workbooks Exell Basics:  Creating Complex Formulas  Working with Basic Functions  Sorting, Grouping, and Filtering Cells  Formatting Tables  Aligning Text  Working with Worksheets Doing More with Excel:  Using Templates  Using What-If Analysis  Working with Charts  Using Conditional Formatting  Creating Pivot Tables Extras:  What are Reference Styles  What's New in Excel Ms Access: Understanding Database Concepts:  Why Do I Need a Database  Exploring an Access Database  Thinking about Database Design Building the Database:  Setting up Tables and Fields  Building Table Relationships  Entering and Editing Data in Tables  Creating and Using Forms  Making Forms More Usable with Controls  Making Forms Attractive Analyzing and Reporting Data:  Sorting Records  Using Queries to Make Data Meaningful - Part 1  Using Queries to Make Data Meaningful - Part 2  Using Reports to Make Data Meaningful to Others

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: A First Look at SPSS Launching SPSS Entering data into the data editor Saving a Data File Creating a bar chart Saving an output file Getting help Printing in SPSS Tables and Graphs For One Variables Opening a Date File Exploring the Data Creating a Histogram Frequency Distributions Another Bar Chart Printing Session Output Moving On Table and Graphs For Two Variable Cross- Tabulating Data Editing A Recent Dialog More on Bar Charts Comparing Two Distributions Scatter plots to Detect Relationships Variance Moving on And More... Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: A First Look at SPSS Launching SPSS Entering data into the data editor Saving a Data File Creating a bar chart Saving an output file Getting help Printing in SPSS Tables and Graphs For One Variables Opening a Date File Exploring the Data Creating a Histogram Frequency Distributions Another Bar Chart Printing Session Output Moving On Table and Graphs For Two Variable Cross- Tabulating Data Editing A Recent Dialog More on Bar Charts Comparing Two Distributions Scatter plots to Detect Relationships Variance Moving on Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Admission Open Classes Will Be Start 4 Dec Course Detail: A First Look at SPSS Launching SPSS Entering data into the data editor Saving a Data File Creating a bar chart Saving an output file Getting help Printing in SPSS Tables and Graphs For One Variables Opening a Date File Exploring the Data Creating a Histogram Frequency Distributions Another Bar Chart Printing Session Output Moving On Table and Graphs For Two Variable Cross- Tabulating Data Editing A Recent Dialog More on Bar Charts Comparing Two Distributions Scatter plots to Detect Relationships Variance Moving on Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: An Overview Of Spss Spss Window Process Creating & Editing Mean,Standard, Deviation Graphs & Charts Frequencies Descriptive Statistics Managing Data Select Case Weight Case Split File Cross Tabulation General Tables Analysis Of Variance (ANOVA) Sample Project Hypothesis Test Chi Square Test Intro To Probability Intro to Regression Spss With Excel Creating & Editing a Date File Managing Data Graphs & Charts Frequencies Descriptive Statistics Cross Tabulation Correlation final test Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Get: SPSS Notes & Projects of Sir Nadeem Shah Free With Course. Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Admission Open: Classes Will be Start 4 Dec Course Detail: A First Look at SPSS Launching SPSS Entering data into the data editor Saving a Data File Creating a bar chart Saving an output file Getting help Printing in SPSS Tables and Graphs For One Variables Opening a Date File Exploring the Data Creating a Histogram Frequency Distributions Another Bar Chart Printing Session Output Moving On Table and Graphs For Two Variable Cross- Tabulating Data Editing A Recent Dialog More on Bar Charts Comparing Two Distributions Scatter plots to Detect Relationships Variance Moving on And More... Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: An Overview Of Spss Spss Window Process Creating & Editing a Date File Managing Data Graphs & Charts Frequencies Descriptive Statistics Cross Tabulation The Mean Procedure Correlation T Test Procedure Simple Linear Regression Multiple Regression Analysis Non parametric Procedures Reliability Analysis Multidimensional Scaling Factor Analysis Logistic Regression Introduction To Probability Tha One way ANOVA The Two way ANOVA The Three way ANOVA Import/Export Printing Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Get: SPSS Notes & Projects of Sir Nadeem Shah Free With Course. Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: An Overview Of Spss Spss Window Process Creating & Editing a Date File Managing Data Graphs & Charts Frequencies Descriptive Statistics Cross Tabulation The Mean Procedure Correlation T Test Procedure Simple Linear Regression Multiple Regression Analysis Non parametric Procedures Reliability Analysis Multidimensional Scaling Factor Analysis Logistic Regression Introduction To Probability Tha One way ANOVA The Two way ANOVA The Three way ANOVA Import/Export Printing Address: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. NOTE: Teacher of This course is SIR NADEEM SHAH (The writer of 17 computerized accounting and I.T. Books). Get: SPSS Notes & Projects of Sir Nadeem Shah Free With Course. Learn more by SIR NADEEM SHAH: 1. Peachtree 2. Tally 3. QuickBooks 4. Sage 6. MYOB 7. Simply 8. AccPac 9. Ms-Accounting 10. Excel Advanced 11. Excel FM 12. SPSS 13. MS-Access 14. MS-Office Advanced 15. Quicken 16. Busy

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

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

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: An Overview Of Spss Spss Window Process Creating & Editing a Date File Managing Data Graphs & Charts Frequencies Descriptive Statistics Cross Tabulation The Mean Procedure Correlation T Test Procedure Simple Linear Regression Multiple Regression Analysis Non parametric Procedures Reliability Analysis Multidimensional Scaling Factor Analysis Logistic Regression A NOV A EXCEL Introduction to Excel Math Formulas Stats Formulas Charts And more about Statistics ddress: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. get SPSS Notes & Projects of Sir Nadeem Shah Free With Course.

Learn -SPSS Data Analysis- at E-SHARP Institute of Computerized Accounting & I.T. By SIR NADEEM SHAH (Writer of 17 I.T. Books) Course Detail: An Overview Of Spss Spss Window Process Creating & Editing a Date File Managing Data Graphs & Charts Frequencies Descriptive Statistics Cross Tabulation The Mean Procedure Correlation T Test Procedure Simple Linear Regression Multiple Regression Analysis Non parametric Procedures Reliability Analysis Multidimensional Scaling Factor Analysis Logistic Regression A NOV A EXCEL Introduction to Excel Math Formulas Stats Formulas Charts And more about Statistics ddress: E-SHARP Institute, NIPA Chowrangi, Gulshan-e-Iqbal, Momin Square, 2nd Floor, Office No. B6, Opp: Shan Hospital and Anglophile, Near Nijlas Beauty Parlor, Up: Ghanis Uniform, Karachi. Visit Timing: 12pm to 9pm, Friday OFF, Sun: 2pm to 6pm. get SPSS Notes & Projects of Sir Nadeem Shah Free With Course.

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

Get SPSS Statistics & Excel ADVANCED Data Analysis Training, by SIR NADEEM SHAH (Writer of 13 Computerized Accounting and 6 Excel Advanced Books).Address: E-SHARP Institute Gulshan-E-Iqbal Nipa Karachi, Near Berlitz, Above Total Travel. CALL/SMS NOW: 0 3 4 5 2 2 4 6 5 3 7 .

Excel Data Analysis Statistics Training WITH FORMULAS, MACROS, AND PIVOT. Duration: 30 Hours. Trainer: SIR NADEEM SHAH (Writer of 6 Excel Advanced Books). Address: E-SHARP, “IBCA” Institute of Business Computerized Accounting and Excel Academy, Gulshan-E-Iqbal Nipa Karachi, Near Berlitz, Above Total Travel. CALL/SMS NOW: 0 3 4 5 2 2 4 6 5 3 7. Views: 220

EXCEL ADVANCED BUSINESS SOLUTION TRAINING! Join the Best Teacher for Excel Basic to Advanced Business Financial Modeling Dashboard KPI Training. Duration: 2 Months (60 Credit Hours) Trainer is SIR NADEEM SHAH, (Note Sir Nadeem Shah is 20 Years Experienced in Excel Training, Ex Teacher of ICMAP, Corporate Trainer and Best Writer of Five “5” Advance Excel Financial Modeling Books & Thirteen “13” Computerized Accounting Books). Main Contents of this training : Financial Planning Theory, How to Build Models, Pivot Table with 10 Tricks to Create a Business Model, VBA Macros with Pivot, Filter, Sorting, Subtotal, Consolidation, Validation, Conditional Formatting, VBA Macros for Formulas, Active X System of Excel. Logical Test with IF, IF AND, IF OR, IF NOT, IF WITH other Formulas, SUMIF, SUMIFS, COUNTIF, COUNTIFS, VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, OFFEST, Financial Calculation with PV, PMT, IPMT, PPMT, FV, DDB, SYD, SLN, IRR, XIRR, MIRR, Amortization Schedule, Sensitivity with Goal Seek Solver, What Ifs with Data Table Scenarios, 10 Dashboard KPI Tricks, Data Analysis, Data Analyzing, Dynamic Charts, Pareto Chart, Import Export, Linking, Protection, Advance use of Formulas, Array Formulas, Typical Date Time Calculations with 1904 System, Professional Reporting Techniques, Balance Sheet, Cash Flow, P & L, Creating Accounting Software on Excel, Tips & Tricks of Excel with Shortcut Keys and Many More Commands of Excel. Visit E-SHARP to collect detailed course outline. Get Free Excel Advanced FM Book, Projects File & Practice CD of Sir Nadeem Shah with Course. SAT, SUN Special classes for busy persons.

Type Computer How participants will benefit after the course: It is widely agreed that close to 50% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excels built-in utilities. In this course we will explore those uncovered area on such fine manner that attendees can readily imply them in their regular work just after attending the program. Contents of Training: Part 1 Beginners Excel Session 1 Chapter 1: Getting Familiar with the Excel Interface • Ribbon, QAT, Mini Toolbar, Live Preview, Finding Icons • Customizing the Ribbon • Backstage View, Recent Documents • Zoom Slider and Page Layout Chapter 2 Handling Text with Formulas and Built in Tools • Drag the Fill Handle • Create Your Own Series • Joining Text • Rapid Formula Copy • Convert to Proper Case • Formulas to Values • Breaking Apart Text • Parsing Fixed Width Tips of the session 1 • Navigate Fast through Range workbooks and Worksheets • Removing Duplicates • Number Format Shortcut Session 2 Chapter 3 Sorting & Filtering • Data Preparation • One-Click Sorting • Sorting by Color • Sorting by Weekday • Rearranging Columns • Filter by Selection • Other ways to Filter • Remove Duplicates Chapter 4 Formulas Begins • AutoSum Tricks • Formula Auditing • Three Ways of Entering Formulas • Relative Versus Absolute Formulas • Tables and Table Formulas • Discovering Functions • Goal Seek Tips of the session 2 • Shrink Text • Transposing Tricks • Hide Data • Important Sheet Part 2 Intermediate Excel Session 3 Chapter 5 Advance Formulas • IF Formulas • Sumifs • VLOOKUP • Date and Time Tips of the Session 3 • Data Validation • Fill up in the sideways • Switch Column Trick • Fill Blank Trick Session 4 Part 8 Charting and SmartArt • Creating and Formatting a Chart • Adding or Removing Chart Data • Saving Favorite Chart Settings • Charting Differing Orders of Magnitude • Pie Chart Tricks • Sparkline • Creating SmartArt • Smart Art Formulas Part 9 Visual Impact • Color Scales, Icon Sets, Data Bars • Icons for Only a Subset • Paired Bar Charts with Negative Data Bars Tips of the Session 4 • Formula to Value • F4 trick • Format Part of Cell • Copying Sheets Part 3 Advance Excel Session 5 Part 6 Pivot Tables • Creating a Pivot Table • Changing a Pivot Table • Pivot Gotchas • Pivot Formatting • Drill Down • Pivot Calculations • Summarizing Dates • Pivot Sorting • Filtering Row Fields • Top 10 Report • Filtering a Pivot Table with Slicers • Slicers on Two Pivot Tables • 50 Reports in 5 Seconds Tips of the Session 5 • Insert Blank Rows • Text Box Trick • Pick from List • Working In Group Mode Session 6 Part 10 Recording Macros • Displaying the Developer Tab • Recording a Simple Macro • Simplifying the Macro • Keys to Successful Recording Part 11 Solver • Understand Solver • Using Solver to Solve your Business Problem Tips of the Session 6 • Print Small Selection • Fit to One Page Trick • Speak Cells • Excel as word processor Venue:- Thinkers Overseas Education 1/6 -j (first floor) block -6 PECHS Near Dehli sweets, Advance Hair Center, Nursery, Main Shah rah-e-Faisal Contact: Sir Abdul Rehman Saturday and Sunday Open

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

E-SHARP OFFERS! DISCOUNTED COURSE OF 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 Address E-SHARP Institute of Computerized Accounting Momin Square 2nd Floor B6 Main Nipa Chowrangi, Gulshan e Iqbal Near Karachi NADEEM Medical Opposite SHAN Hospital and Anglophile Institute Up Ghanis Uniform Near Nijlas Beauti Parlor Visit Timing : 12pm to 9pm Sunday 2pm to 6pm Friday Off GET FRE Book of SIR NADEEM SHAH (Excellent Excel Advanced Financial Modelling Practice CD Course Material & Certificate with course

Learn quicksBooks Peach tree Tally erp 09 sage line 50 UK & Myob Australia Software in one roof Expert in accounting concept and accounting software such as bookkeeping Ledger maintaining and financial Reporting Get job after successful completion of this software in Pakistan as well as gulf sector Dubai Oman & UAE COURSE OUTLINE Introduction Details of Debit & Credit Accounting Concept Basic & Advance Need of Accounting Software Details of Opening Balance Company Create Voucher Details Group Create Inventory Detail Sub-Group Create Inventory Entry Ledger Create Ledger Posting Entries Suppler Customer Ledger Charts of Accounts Detail review of Class to Inventory Details Reports Final Accounts Review All & Revised All Topics Project We also give home Tuition and also online training on Skype all over Pakistan& WE GIVE TRAINING ON ALL INDUSTRY RETAIL SERVICE AND MANUFACTURING WITH LIVE COMPANIES DATA Deal NO 1 Quicks Book & Peachtree Course Fees =5000 Per Course Only Deal NO 2 Tally & Quicks Books Course Fees = 6000 Per Course Only Deal NO 3 Tally & Quicks Books & Advance Excel Course Fees = 4000 Per Course Only Feel Free to contacts NEW ERRA INSTITUTE OF IT SkypeId:targetsys_nw WhatsApp:+923238549230 FaceBook Page:New Erra Instiute Of It Sir Nouman wasi MS & CIMA(Accounting & Finance)

Microsoft project training step by step for office and commercial purpose.with project and certificate. sindh board recognize. sir shahzad waiz 10 years experience teacher (BCS and ACCP APTECH California) sunday classes available for job employees. short courses also available • The importance of project management and creating a Project plan • Managing and configuring tasks in Project • Understanding and managing resources • Integrating data with other Microsoft applications • Tracking costs in Microsoft Project • Viewing project information visually

EducationCT sindh board affiliated .. provide online training in all Pakistan and abroad Computer Microsoft Access / designing your company / shops / office data base / How to design Table / queries / relationship / Forms / report / switchboards in database.. short courses …..Step by Step training .. with projects and certification... Sir shahzad waiz ..03112218922

Learn Adv. Excel withe Data Analysis and Macros, by SIR NADEEM SHAH (Writer of 20 Books). Career E-SHARP GULSHAN NIPA KARACHI. 0 3 4 5 2 2 4 6 5 3 7