Excel data

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

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 .

Learn to convert any excel data to access application... The access application can be any scenario that you can come up with where you feel difficulty in dealing data in excel. After this crash course you'll be able to make full fledged application in Access which can also generate reports for you and data import to access will also be taught. Contact today for details. Thanks

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.

Excel Advanced Training this week on Thu, Fri, Sun @ 11am-3pm. International standard training leading to Microsoft USA Certification, includes Data Management, Data Analysis & Business Analytics Skills in Office 2016 & Office 365. Fee Rs 3000. Views: 1

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

We have about again 3000 records for creating directory and need to be entered into an excel sheet for print. The fields in the spreadsheet are: Person Name / Telephone Number Address (City, Post Code) / E-mail We will provide you a format and you have to enter the data in to that format. And we will give you $1000 for enter these 3000 data in excel sheet. Please contact us as soon as if you are interested. Go here for more detail about jobs: http://www.homebasework.net Or send us an email: homebasework.email@gmail.com Website: www.homebasework.net Contact us in website contact page or send us direct email so that we can go further. from Jan 31st

MS Excel 2007 Level 1 This course is for anyone who has never used Excel before (or any other spreadsheet package) or those who have some experience editing data but are not confident creating calculations (including ones that use fixed figures like VAT) and charts. >What You Will Learn Create, save, close, open and print spreadsheets Insert and delete rows or columns in your spreadsheet Get Excel to add up numbers automatically Copy formulae in your spreadsheet whilst keeping one of the cell references constant Sort large databases into order and filter to show only the data you need Alter the look of the numbers and text, add comments, lay out text with merged cells and wrapped text, use cell styles, change the layout for printing. Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand Views: 183

I am working in computer field since last 10 years and have done many data entry / Book Typing Projects. If you are looking for a competent persons to work with you on your projects in part time online / offline, then contact me for working in under mentioned fields: - * Book Typing * Data Conversion (PDF/JPEG to WORD, Excel) * Creation of PowerPoint Presentations * Inpage * Corel Draw * Adobe Photoshop 7.0 * Image Editing * Resume Composing Regards

covering practical tools and tricks to make you powerful in Data Analysis, HR & Admin Dashboards, KPIs, etc. using Microsoft Office / Excel 2016 & 365. Fee Rs 1000 only per workshop including Certificate. Training by Mr. Shahzad Anwar - USA Certified & Experienced. Training @ New Castle Training Center Pakistan, Views: 8

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

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 course in rawalpindiMicrosoft excel course 2010 is the latest version of Microsoft’s famous spreadsheet application. In a general sense, excel course is a very powerful and flexible tool for organising and analysing data. Excel provides a wealth of financial, mathematical, and statistical functions that you can apply to your data. excel course also offers numerous formatting and presentation options that will help you create slick, professional looking reports. You can use excel course as a database, a graphing and charting tool, a means of evaluating complex formulas, and as a way of sharing data and collaborating with others. When you change data in an excel course spreadsheet, Excel will recalculate your totals, functions, and formulas accordingly. Although excel course is often used for managing financial information, it is just as well suited to scientific data, sports statistics, or practically any other kind of information you need to work with Microsoft excel course is one of the most widely used spreadsheet applications available today. excel course functionality and popularity have made it an essential component on computers in countless organisations, businesses, and other institutions throughout the world. excel course is comprehensive enough to meet the needs of beginners and experienced users alike. With excel course you can perform a wide range of tasks, from building basic spreadsheets to performing advanced data analysis. Excel can help you process, interpret, and extract meaningful conclusions from your information. If you start at the beginning and work your way up, it won’t be difficult to learn and work with Excel at any level you want. excel course in Rawalpindi. If you are new to Excel, the extensive array of features and capabilities that it provides may seem daunting at first, but don’t worry. The keys to becoming proficient with Excel are patience, practice, and a solid foundation built on the basics.

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

In advance excel course you can learn 150+ modules which is very important and relevant your business after this course you can get the best jobs in this field. After completed you will be a make advance level users. Advanced Excel Course in Rawalpindi 6th road Rawalpindi. advanced excel training in islamabad Advanced Excel Course Outline Essential Functions: Mathematical, Logical, Date & Time, Text. Database Using Excel Power Functions Working With Arrays & Multi-sheet Formulas What-If Analysis with Goal Seek. Data Table, Solver,& Scenario Manager Data Analysis & reporting with Pivot Tables Charts & Reports Data Visualization with Charts, Sparkline & Conditional Formatting Subtotaling & Data Filtering Automating Recurring Tasks with Macros Protecting Worksheets & Workbooks and Lots of Excel Master Tips & Tricks Advanced excel course Duration: 1 Month Advanced excel course 5 days a week class Advanced excel course in Rawalpindi for more information call Now: 0311-5559404 Who Should Attend? from Feb 28th

Microsoft Excel is one such application which does not require any preaching to be used. It is the choice of billions of corporate users due to its power, speed & simplicity of use. Most people have a basic understanding of Excel but a few really know where to find the Excel’s most effective & efficient power features. This course contains everything you need to know & learn about Excel. It is designed to fill the void by providing a comprehensive training on Excel’s most powerful features. LIT promising 18 hours training in 5 days, the course is aimed to train participants from Basic to an Expert! COURSE CONTENTS Essential Functions: Mathematical, Logical, Date & Time, Text. Database Using Excel Power Functions Working With Arrays & Multi-sheet Formulas What-If Analysis with Goal Seek. Data Table, Solver,& Scenario Manager Data Analysis & reporting with Pivot Tables Charts & Reports Data Visualization with Charts, Sparkline & Conditional Formatting Subtotaling & Data Filtering Automating Recurring Tasks with Macros Protecting Worksheets & Workbooks and Lots of Excel Master Tips & Tricks Views: 11

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

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 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) 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 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) 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

Admission Open 5 in 1 Comprehensive Training Course - DASHBOARD REPORTING, DATA ANALYSIS & ADVANCED REPORT DEVELOPMENT With Excel Course Agenda: 1. Advanced Report Development 2. Data Visualization with Excel Tools & Charts 3. Dashboards Reporting with Excel 4. Excel beyond Spreadsheet - Working with Macros 5. Microsoft SQL Server Power Pivot for Excel Course Duration: 03 Month Fee: 15,000 PKR * Special Discount For A Group Of Students For Further Detail Call Or Visit: Omesol Education (Pakistan Campus) Plot# A-685(Ground Floor), Street-12, Block-H, North Nazimabad, Karachi. (Near Five Star Chorangi, Opp. Mah Rose Beauty Parlor) Call: 0343-2628122, 0334-3462269 E-mail: omesoleducation@gmail.com Web: www.omesoleducation.com FB Page: www.facebook.com/omesoleducation

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

MS EXCEL ADVANCED Professional & Practical 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 0348-4456455 0301-2126422 from Sep 2nd

MS EXCEL ADVANCED Professional & Practical 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) Course Schedule and Fee: Course Duration: 4 Weeks (Weekly 5 Classes) Class Schedule: 1 Hrs. Course Fee: Rs: 11,000 Training Instructor: RIAZ HUSSAIN Experience: 13 Years Experienced Trainer 12 Years Industry Experienced as Senior Accountant Views: 9

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