Recent table

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

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

Air Ticketing & MS office course in Gujar Khan 03335671497 Diploma in Air Ticketing Course This training program offers an all-round introduction for newcomers to Travel and Tourism Industry. The course covers all the different areas of skills involved and uses real examples to make learning fun, practical and realistic. It also covers understand IATA terms & definitions, Know IATA areas, be able to select and construct fares using the mileage system.The students will be able to know baggage allowances, taxes, fees, charges and be able to interpret air travel documentation.Airline ticketing professionals cater to the needs of the increasingly mobile population of the globe. There are excellent career prospects in Air Ticketing in Pakistan.However, to excel in this field, training must be taken from reputed institutes. Successful completion of Airline Ticketing courses enables a person get into jobs which concern booking and confirming reservation for passengers on scheduled flights.This Diploma program provides the essential skills and qualifications required when working in today’s travel industry.Inspire Institute of Technologies Pakistan (Pvt) Ltd is affiliated with RCCI, SECP, SDA, TTB, TTPC, SDC & PSSC Government of Pakistan. Diploma in Air Ticketing Course Contents: 1:How to use the software 2:GDS format 3:Governing carrier/fare selection criteria 4:Currency rounding rules 5:Class of service codes 6:Fare basis codes 7:The three general limitations on indirect travel 8:Global indicators 9:Journey global indicators 10:Iata areas 11:Iata fare formula 12:Minimum fare rule checks 13:Descriptive table for linear fare calculation 14:Fare determination flow chart 15:Fare construction worksheet 16:World map 17:Regional maps 18:Analyzing Itineraries PGDIT (Post Graduate Diploma in Information Technology) Course Postgraduate Diploma in Information Technology will be able to: work effectively in multicultural teams and exercise leadership as required, engage in rigorous intellectual analysis, critique and problem-solving.The course will suit candidates looking to extend and update their knowledge in advanced computing subject areas, and provides an excellent retraining opportunity for professionals who wish to move to a new IT speciality.The graduate diploma builds on the foundation of the graduate certificate and coursework undertaken from the graduate diploma may be counted towards the requirements for the Master of Information Technology.The Postgraduate Diploma in Information Technology is aimed at IT professionals and recent graduates (domestic and international) wishing to undertake a longer programme of study that covers a wider range of subject areas, in order to prepare for further study or to assist with obtaining a more senior position in an IT or IT business related place of employment.Inspire Institute of Technologies Pakistan (Pvt) Ltd is affiliated with RCCI, SECP, SDA, TTB, TTPC, SDC & PSSC Government. PGDIT Course Contents: 1:A sound knowledge of the IT environment and its effective management 2:The ability to analyse the needs of business and make recommendations for IT services and systems 3:The ability to advise on, develop and implement innovations leading to a more efficient use of resources within a dynamic IT environment 4:The ability to relate to and communicate effectively with personnel and clients having diverse backgrounds 5:The motivation for continued learning and self-development to cope effectively with change 6:An understanding of the legal, regulatory and ethical frameworks of the IT sector 7:Managing ICT Projects and Systems 8:Business Analysis 9:Web Application Development 10:Special Topic 11:Software Development 12:Database Design and Implementation 13:Human Computer Interaction 14:Systems Administration 15:Information Systems in Management 16:Advanced Networking 17:Professional Skills for Information Technology One Year Fee: 28000 PKR