Excel 3

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

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

MS Office - Advanced Excel Courses in Karachi Advanced Excel [2 months] Are you interested to know what the Advanced Excel Skills for better job are? Omni Academy specially designed Advance Excel program to cover all professional / business needs - a best and most affordable advanced excel training in Karachi. Advanced Excel Course • ADVANCED FORMULAS • TABLES & FORMATTING • CONDITIONAL FORMATTING • ADVANCED CHARTING • PIVOT TABLES & PIVOT REPORTING • MACROS • USING EXCEL PRODUCTIVELY • DATA TABLES • INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL • BECOME AN ADVANCED EXCEL USER Duration: One Month Morning Classes 10:00AM - 12:00PM (MON-TUE) Evening Classes 06:00PM - 08:00PM (THU-SAT) Weekend Classes For Professionals SAT | SUN Trainer: Mr. Kashif uddin Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student Trainer profile: Kashif is Microsoft certified trainer, specialist & system engineer Experience: IT trainer IBA, Sr. learning technology facilitator at Agha khan education service For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: info@omni-academy.com I www.omni-academy.com

Advanced Excel Are you interested to know what the Advanced Excel Skills for better job are? Omni Academy specially designed Advance Excel program to cover all professional / business needs - a best and most affordable advanced excel training in Karachi. Advanced Excel Course • ADVANCED FORMULAS • TABLES & FORMATTING • CONDITIONAL FORMATTING • ADVANCED CHARTING • PIVOT TABLES & PIVOT REPORTING • MACROS • USING EXCEL PRODUCTIVELY • DATA TABLES • INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL • BECOME AN ADVANCED EXCEL USER Duration: Two Months Morning Classes 10:00AM - 12:00PM (MON-TUE) Evening Classes 06:00PM - 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: info@omni-academy.com I www.omni-academy.com

Advanced Excel Are you interested to know what the Advanced Excel Skills for better job are? Omni Academy specially designed Advance Excel program to cover all professional / business needs – a best and most affordable advanced excel training in Karachi. Advanced Excel Course • ADVANCED FORMULAS • TABLES & FORMATTING • CONDITIONAL FORMATTING • ADVANCED CHARTING • PIVOT TABLES & PIVOT REPORTING • MACROS • USING EXCEL PRODUCTIVELY • DATA TABLES • INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL • BECOME AN ADVANCED EXCEL USER Duration: Two Months Morning Classes 10:00AM – 12:00PM (MON-TUE) Evening Classes 06:00PM – 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: [email protected] I www.omni-academy.com

MS Office – Advanced Excel Courses in Karachi Advanced Excel [2 months] Are you interested to know what the Advanced Excel Skills for better job are? Omni Academy specially designed Advance Excel program to cover all professional / business needs – a best and most affordable advanced excel training in Karachi. Advanced Excel Course • ADVANCED FORMULAS • TABLES & FORMATTING • CONDITIONAL FORMATTING • ADVANCED CHARTING • PIVOT TABLES & PIVOT REPORTING • MACROS • USING EXCEL PRODUCTIVELY • DATA TABLES • INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL • BECOME AN ADVANCED EXCEL USER Duration: One Month Morning Classes 10:00AM – 12:00PM (MON-TUE) Evening Classes 06:00PM – 08:00PM (THU-SAT) Weekend Classes For Professionals SAT | SUN Trainer: Mr. Kashif uddin Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student Trainer profile: Kashif is Microsoft certified trainer, specialist & system engineer Experience: IT trainer IBA, Sr. learning technology facilitator at Agha khan education service For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: [email protected] I www.omni-academy.com

Advanced Excel Are you interested to know what the Advanced Excel Skills for better job are? Omni Academy specially designed Advance Excel program to cover all professional / business needs - a best and most affordable advanced excel training in Karachi. Advanced Excel Course • ADVANCED FORMULAS • TABLES & FORMATTING • CONDITIONAL FORMATTING • ADVANCED CHARTING • PIVOT TABLES & PIVOT REPORTING • MACROS • USING EXCEL PRODUCTIVELY • DATA TABLES • INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL • BECOME AN ADVANCED EXCEL USER Duration: Two Months Morning Classes 10:00AM - 12:00PM (MON-TUE) Evening Classes 06:00PM - 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: info@omni-academy.com I www.omni-academy.com Views: 8

Ms Office – Advanced Excel Advanced Excel [2 months] Are you interested to know what are the Advanced Excel Skills for better job? Omni Academy specially designed Advance Excel program to cover all professional / business needs – a best and most affordable advanced excel training in Karachi. Advanced Excel Course ? ADVANCED FORMULAS ? TABLES & FORMATTING ? CONDITIONAL FORMATTING ? ADVANCED CHARTING ? PIVOT TABLES & PIVOT REPORTING ? MACROS ? USING EXCEL PRODUCTIVELY ? DATA TABLES ? INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL ? BECOME AN ADVANCED EXCEL USER Duration: One Month Morning Classes 10:00AM – 12:00PM (MON-TUE) Evening Classes 06:00PM – 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Trainer: Mr. Kashif uddin Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite: Continental Bakers/ Faysal Bank Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Call us: 0337-7222191, 0312-2169-325 info@omni-academy.com I Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Views: 8

Ms Office – Advanced Excel Advanced Excel [2 months] Are you interested to know what are the Advanced Excel Skills for better job? Omni Academy specially designed Advance Excel program to cover all professional / business needs – a best and most affordable advanced excel training in Karachi. Advanced Excel Course ? ADVANCED FORMULAS ? TABLES & FORMATTING ? CONDITIONAL FORMATTING ? ADVANCED CHARTING ? PIVOT TABLES & PIVOT REPORTING ? MACROS ? USING EXCEL PRODUCTIVELY ? DATA TABLES ? INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL ? BECOME AN ADVANCED EXCEL USER Duration: One Month Morning Classes 10:00AM – 12:00PM (MON-TUE) Evening Classes 06:00PM – 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Trainer: Mr. Kashif uddin Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student Trainer profile: Kashif is Microsoft certified trainer, specialist & system engineer Experience: IT trainer IBA, Sr. learning technology facilitator at Agha khan education service. A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite: Continental Bakers/ Faysal Bank Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Call us: 0337-7222191, 0312-2169-325 info@omni-academy.com I Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Views: 5

Ms Office – Advanced Excel [2 months] Are you interested to know what are the Advanced Excel Skills for better job? Omni Academy specially designed Advance Excel program to cover all professional / business needs – a best and most affordable advanced excel training in Karachi. Advanced Excel Course ? ADVANCED FORMULAS ? TABLES & FORMATTING ? CONDITIONAL FORMATTING ? ADVANCED CHARTING ? PIVOT TABLES & PIVOT REPORTING ? MACROS ? USING EXCEL PRODUCTIVELY ? DATA TABLES ? INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL ? BECOME AN ADVANCED EXCEL USER Duration: One Month Morning Classes 10:00AM – 12:00PM (MON-TUE) Evening Classes 06:00PM – 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Trainer: Mr. Kashif uddin Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student Trainer profile: Kashif is Microsoft certified trainer, specialist & system engineer Experience: IT trainer IBA, Sr. learning technology facilitator at Agha khan education service. A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite: Continental bakers/ Faysal Bank Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Call us: 0337-7222191, 0312-2169-325 info@omni-academy.com I Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Views: 4

Ms Office – Advanced Excel [2 months] Are you interested to know what are the Advanced Excel Skills for better job? Omni Academy specially designed Advance Excel program to cover all professional / business needs – a best and most affordable advanced excel training in Karachi. Advanced Excel Course ADVANCED FORMULAS TABLES & FORMATTING CONDITIONAL FORMATTING ADVANCED CHARTING PIVOT TABLES & PIVOT REPORTING MACROS USING EXCEL PRODUCTIVELY DATA TABLES INTEGRATING EXCEL WITH OTHER TOOLS & OPTIMIZING EXCEL BECOME AN ADVANCED EXCEL USER Duration: One Month Morning Classes 10:00AM – 12:00PM (MON-TUE) Evening Classes 06:00PM – 08:00PM (THU-SAT) WeekEnd Classes For Professionals SAT | SUN Trainer: Mr. Kashif uddin Investment: Rs. 3,000/- -30% Discount on group of 5 -20% discount for Omni student Trainer profile: Kashif is Microsoft certified trainer, specialist & system engineer Experience: IT trainer IBA, Sr. learning technology facilitator at Agha khan education service. A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite: Continental bakers/ Faysal Bank  Friday CLOSED Sat - Thu 9.30 am - 08.00 pm Call us: 0337-7222191, 0312-2169-325 info@omni-academy.com I www.omni-academy.com Friday CLOSED Sat - Thu 9.30 am - 08.00 pm from Jun 1st

Learn Excel Advanced in Karachi by the writer of 5 Excel Books SIR NADEEM SHAH... 0 3 4 5 2 2 4 6 5 3 7 . Add: E-SHARP Institute Gulshan Nipa Karachi.

SPSS, Excel Advanced, Excel FM, Peachtree, Tally, MYOB, Access at Esharp Karachi Nipa Gulshan.Venue: E-SHARP Institute Gulshan-E-Iqbal Nipa Karachi, Near Berlitz. CALL/SMS NOW: 0 3 4 5 2 2 4 6 5 3 7 .

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 Institute of Computerized Accounting offers J-C-A (Job Computerized Accounting) 3 Months Course by SIR NADEEM SHAH (Teacher & writer of Peachtree, Tally, QuickBooks, Excel Advanced, Excel Financial Modeling, MS-Office Books) for a Professional Job in Pakistan/UAE Course Detail: Manual Accounting Peachtree Basic to Advanced Tally Basic to Advanced Excel Basic to Advanced MS-Access (DBMS) QuickBooks Basic to Advanced Address: E-SHARP Institute of Computerized Accounitng, Momin Square, 2nd Floor, B6, Gulshan e Iqbal NIPA Chowrangi Karachi, NearNadeem Medical and ICMAP, Opp: SHANHospital andAnglophile Institute, Upp: GhanisUniform. Class Schedule: Regular Course 3 days per week Fast Track 5 days per week Executive classes only Sat & Sun VISIT TIMING: 12PM TO 9PM SUNDAY: 2PM TO 6PM FRIDAY: OFF THANKS. THANKS TO VISIT THIS ADD.

Become a Good Accountant and Improve your Salary package... Join Computerized Accounting Training. Learn Advance Excel, QuickBooks & Tally ERP from IPATS Training to secure a better future in UAE, Middle East, Dubai & Pakistan. We provide Practical one to one base trainings. Flexible timing according to your convenience. Free Interview Preperation & consultation for Jobs in UK, UAE, Saudia, Dubai & Pakistan. Highly Trained Professional Trainers Guaranteed Work Placements you can book you free demo session for up coming Every Tuesday. symbiosis post graduate courses fast track trivandrum postgraduate diploma in information technology mtnl intranet post graduate diploma meaning diploma in information technology syllabus pdf post graduate diploma courses in dhaka university post graduate diploma in information security pgd course in dhaka university iit education information dde IPATS (Qadeer Road KRL Near Alfalah Bakers Khanna Pul Rawalpindi Cell: 3 3 1 5 1 4 5 6 0 1, 0 3 4 9 5 0 2 1 3 3 6 Whatsapp: + 923315145601 www.ipatsedu.com We have experienced trainers with more than 14 year’s of experience and also undertakes accounting projects for Dubai, Saudia, US, Australia, & UK. 3 3 1 5 1 4 5 6 0 1 3 4 9 5 0 2 1 3 3 6 IPATS Govt recognized education Khanna Pul Rawalpindi Yasir Plaza Khanna Pul Qadeer Khan Road KRL Road Near Alfalah Bakers - Govt Recognized Education Institute www.ipatsedu.com 3 3 1 51 4 5 6 0 1 || 3 4 9 5 0 2 1 3 3 6 || Whats app || 3 0 3 5 5 3 0 8 6 5 IPATS Govt recognized education Khanna Pul Rawalpindi

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

BASIC COMPUTER COURSE IN GULRAIZ PHASE 3, DHA, SCHEME THREE, BASIC COMPUTER COURSE IN GULRAIZ PHASE 3, DHA, SCHEME THREE, BASIC COMPUTER COURSE IN GULRAIZ PHASE 3, DHA, SCHEME THREE, BASIC COMPUTER COURSE IN GULRAIZ PHASE 3, DHA, SCHEME THREE, The course is designed to aim at imparting a basic level programme for the individual. After completing the course the individual is able to the use the computer for basic purposes of preparing his personnel/business letters. This allows a common individual to be also a part of computer users list by making them digitally literate. This helps the small business communities, to maintain their small account using the computers and enjoy in the world of Information Technology. Nowadays, learning the basics of the computer is necessary in this technology world, because some works can't be done without a computer. We offer the basic computer courses for beginners and gives the best support for non-technical persons. It helps you to be expert in using computers. If you don't go along with technology means, you are losing your career growth. There are many experts have proved that it is an excellent course to obtain a broad knowledge of computers. As we know, now it is a common thing for children and youngsters, yet some people are not well trained in using computers even for performing small activities. Particularly people like homemakers, senior citizens and those who are from the rural background, feels hard to cope-up with others in operating the system efficiently. So, our Institute decided to offer basic computer course to assist those people to understand and build their skills with computers surely. Learn everything you need to know to use a computer like a pro with this basic computer training online. Students will learn the inner-workings of computers, word processing, spreadsheet and presentation skills, as well as email etiquette and managing computer files. You get everything you need to know in easy-to-understand lessons that take you step by step from the basics through advanced capabilities. Here's an overview of all of the custom learning materials and bonus items you'll receive in your course. This Basic computer classes provided by our center will enhance your basic computer skills in the best way. We will train from the introduction, parts of the computer such as hardware to software and also how to use it completely for your daily works. In this course, we will cover the fundamental skills. Also, the advanced skills to make you a better PC user. After completing Basic Computer Training you will be able to use any PC, Laptop or Tablet devices without hesitation. Join now and improve your computer skills to become an expert in using computers! Why should take Computer Basics Course? Knowing basic computers has become as necessary. The study includes Basic Computer Operations and uses. Whatever may be your field of interest, learning of Computer Basics is a must. Each person feels the need to use computers in their jobs. Operating Computers: Helps you learn necessary know-how & working on computers. MS-Paint: Gets you introduced with mouse controls like left click, right click, double click, drag & drop, etc.. Notepad & Wordpad: Helps you know various keyboard keys & it’s controls. Lessons 1. Welcome to the World of Computers 2. The Nuts and Bolts: Computer Hardware 3. The Tools: Computer Software 4. Microsoft® Operating System: Computer Connections 5. Navigating in Microsoft® Windows 8: Basic Operations Unit 2 Lessons 1. Create Documents in Microsoft® Word: Part I 2. Create Documents in Microsoft® Word: Part II 3. Desktop Publish in Microsoft® Word: Part I 4. Desktop Publish in Microsoft® Word: Part II 5. Microsoft® Excel Basics Unit 3 Lessons 1. Work with Data in Excel 2. Microsoft® PowerPoint: The Anatomy of a Presentation 3. Put Microsoft® PowerPoint to Work Unit 4 Lessons 1. The Internet and the World Wide Web 2. Research Using the Internet and the World Wide Web 3. Security in the Information Age 4. Email Etiquette Unit 5 Lessons 1. Organize with Microsoft® Outlook 2. Put Outlook to Work 3. Put It All Together

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

SIR NADEEM SHAH's Classes of: - Excel Advanced - Excel FM - Peachtree - Tally - SPSS - Sage - MYOB Venue: E-SHARP Institute Gulshan-E-Iqbal Nipa Karachi, Near Berlitz. CALL/SMS NOW: 0 3 4 5 2 2 4 6 5 3 7. Views: 49

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

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: SHORTHAND, SPSS, EXCEL, PEACHTREE, TALLY, QUICKBOOKS, EXCEL FM, ACCESS. E-SHARP Institute of Business Computerized Accounting Gulshan Nipa. Near Berlitz Language Center & Computer Collegiate Above Total Travel. For More Details Please Call, SMS on cell no. 0 3 4 5 2 2 4 6 5 3 7. Views: 32

QuickBooks 2010: New Features Course details New Features in QuickBooks 2010 will introduce you to the significant changes in this latest version of the software. In this course you’ll learn about a variety of time-saving task and data entry features, learn how to easily customize professional, elegant forms, be introduced to the completely revised Report Centre, as well as discover a variety of connected services available at your fingertips. Course outline: This course consists of the following: 1. Saving time in Quickbooks 2010 2. Optimizing data entry 3. Improving form functionality 4. The Redesigned report center 5. The new Document Management System 6. Capitalizing on connected services Whatsapp: +923035530865, 03219606785,3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad Quickbooks-PT,Talley ERP Business Accounting Diploma We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at any time. So, why not improve your chances of gaining professional skills and better earning potential. COURSE CURRICULUM • Professional Bookkeeper Introduction • Introduction to Accounting and Business • The Accounting Equation • Analyzing Transactions • Entering Information - Posting Entries • Adjusting Process • Adjusting Entries • Adjustment Summary • Preparing a Worksheet • Financial Statements • Completing the Accounting Cycle • The Accounting Cycle Illustrated • Fiscal Year • Spreadsheet Exercise Whatsapp: +923035530865, 03219606785,3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad Quickbooks-PT,Talley ERP Advance Accounting & Bookkeeping Diploma training course is comprehensive and is designed to cover the following key topics are listed under the curriculum. This course has been designed for 40 guided learning hours. COURSE CURRICULUM UNIT 01. ADVANCED ACCOUNTING • Type of Business Ownership • Accounting Concepts • Accounting Journals and Ledgers • Formulas & Equations • Financial Statements • Analysing of Financial Statements • Inventory Management • Accounting for Depreciation • Accounting for Compensation, Taxes & Liabilities • Closing and Adjusting Entries • Corporate Accounts UNIT 02. FINANCIAL ACCOUNTING • Introduction to Accounting • What are Financial Statements in Accounting • The Accounting Cycles • Preparing Financial Statements • Control in Accounting • Inventory Management in Accounting • Accounts Receivable • Operating Cycle in Accounting • Asset Management Section 02 • Liabilities in Accounting • Equity in Accounting- Section 2 • Cash Flow Statement Patterns • Analysing Financial Statements in Accounting UNIT 03. BOOKKEEPING TRAINING MANUAL • Bookkeeping Training Manual UNIT 04. ADDITIONAL STUDY MATERIALS • Additional Study Materials- Advance Accounting Certification: Successful candidates will be awarded certificate for “Diploma in Advance Accounting & Bookkeeping”. Whatsapp: +923035530865, 03219606785,3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad Quickbooks-PT,Talley ERP Accounting and Bookkeeping Diploma Level 3 offers quality online, professional qualifications to individuals worldwide, catered to the way in which those looking to progress within their careers and business are wanting to learn. And, because the training is online – at times and locations that best suit your lifestyle. The learning you’ll acquire from this course will equip you for senior roles within professional accounting and bookkeeping, or enable you to establish your own practice within this field. COURSE CURRICULUM 1. Accounting fundamentals 2. Different forms of accounting 3. Understanding of your accounts 4. Inventory control & sales tracking 5. How to control and manage expenses 6. How to avoid illegal accounting 7. Fundamentals of bookkeeping 8. Accurate bookkeeping and uses 9. Tax accounting 10. Process of audit Whatsapp: +923035530865, 03219606785,3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad Quickbooks-PT,Talley ERP Payroll Management Level 3 Payroll Management Training Diploma Level 3 has been given SPTTC Punjab Board accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you’re an individual looking to excel within this field then Payroll Management Training Diploma Level 3 is for you. We’ve taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept – from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 3 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full SPTTC accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. COURSE CURRICULUM • Diploma in Payroll Management Whatsapp: +923035530865, 03219606785,3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad Quickbooks-PT,Talley ERP Investment Analyst/Portfolio Manager Diploma Course details Overview Upon completion of this diploma course including having understood the entire study material you will be able to work successfully as an Investment Analyst and/or Portfolio Manager. Description Content: • The Investment Setting • The Asset Allocation Decision • Efficient Capital Markets • Portfolio Management • Stock Market Analysis • Technical Analysis • Equity Portfolio Management Strategies • Bond Portfolio Management Strategies • Swap Contracts, Convertible Securities, and Other Embedded Derivatives etc. Whatsapp: +923035530865, 03219606785,3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Complete Award-Winning Training Courses. It includes 1. Total Training Microsoft Word 2010 2. Total Training Microsoft Excel 2010 ESSENTIALS 3. Total Training Microsoft Excel 2010 ADVANCED 4. Total Training Microsoft Power Point 2010 Project Files are Included. Price = Rs. 350/= If you are interested to buy, plz call or sms me on 03342874489 Views: 261

MS Excel Advance Course in 1 month Notes will be provided to students. 1. BASIC OPERATION OF EXCEL 2. BASIC FORMULAS 3. ADVANCE FORMULAS 4. PIVOT TABLE 5. VLOOKUP Course Duration:1month Orbit Learning Center Office # s137, 2nd floor malkabad plaza, 6th road rawalpindi. Views: 36

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

FOR BEST JOBS IN UAE (Dubai) Tally. ERP 9.2 QuickBooks Enterprise Advanced Excel  Consultant & Trainer RIAZ HUSSAIN Cell: 0 3 0 1-2 1 2 6 4 2 2 0 3 4 8-4 4 5 6 4 5 5 Email: riazicbt@yahoo.com Experience 13 Years Experienced Trainer 12 Years Industry Experienced as Senior Accountant from Sep 2nd