Home

Basic to Professional Advance MS Excel Trainings Course03035530865

Basic to Professional Advance MS Excel Trainings Course03035530865(Rawalpindi, 03035530865)

Institute of Professional and Technical Studies (IPATS)

COURSE DETAILS


Basic to Professional Excel Trainings Course There is a need for businesses to operate smoothly on a daily basis in order to find success. Successful companies are efficient and have extremely productive employees through technology. One way to greatly increase a company’s productivity and efficiency is through Microsoft Excel. Most business are already using Microsoft Excel; however the full potential of this software is not usually completely utilized without Microsoft Excel training. When you offer your staff education, you will see more perks than you originally expected. At many companies, most of the IT employee’s time is used for resolving software issues for other staff members. If your staff have received the proper Microsoft Excel Training, then they will be able to fix their own issues. This will also free up the IT department so that they can dedicate their time to complete their own projects. The Taskbar;The Start Menu;Familiarize Yourself with the Mouse;Understand the Keyboard;User Log On; A Few Basic Typing Rules. Whatsapp: +923035530865, 03219606785, 3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel Course Contents 2007

CHAPTER 1- GETTING ACQUAINTED WITH EXCEL 1.1 About Excel 1.2 The Excel Environment 1.3 The Title Bar 1.4 The Ribbon 1.5 Scroll Bars 1.6 The Microsoft Office Button 1.7 The Quick Access Toolbar 1.8 The Formula Bar 1.9 The Workbook Window 1.10 The Status Bar 1.11 The Workbook View Buttons 1.12 The Zoom Slider 1.13 The Mini Toolbar 1.14 Keyboard Shortcuts

CHAPTER 2 CREATING BASIC WORKBOOKS 2.1 Creating New Workbooks 2.2 Saving Workbooks 2.3 Closing Workbooks 2.4 Opening Workbooks 2.5 Selecting Cells 2.6 Entering Text into Cells 2.7 Entering Numbers into Cells 2.8 AutoComplete 2.9 Pick from DropDown List 2.10 Using the “Window” Command Group 2.11 Switching to Full Screen View 2.12 Renaming Workbooks 2.13 Working with Excel File Formats

CHAPTER 3 USING RANGES 3.1 Selecting Ranges 3.2 Ranged Data Entry 3.3 Using AutoFill

CHAPTER 4 CREATING FORMULAS 4.1 Ranged Formula Syntax 4.2 Simple Formula Syntax 4.3 Writing Formulas 4.4 Using AutoSum 4.5 Inserting Functions 4.6 Editing a Range 4.7 Formula AutoCorrect 4.8 Auto Calculate

CHAPTER 5 COPYING & PASTING FORMULAS 5.1 Relative References and Absolute References 5.2 Cutting, Copying & Pasting Data 5.3 Auto Filling Cells 5.4 The Undo Button 5.5 The Redo Button

CHAPTER 6 COLUMNS & ROWS 6.1 Selecting Columns and Rows 6.2 Adjusting Column Width and Row Height 6.3 Hiding and Unhiding Columns and Rows 6.4 Inserting and Deleting Columns and Rows

CHAPTER 7 FORMATTING WORKSHEETS 7.1 Formatting Cells 7.2 The Format Cells Dialog Box 7.3 Clearing All Formatting from Cells 7.4 Copying All Formatting from Cells to Another Area

CHAPTER 8 WORKSHEET TOOLS 8.1 Moving between Worksheets 8.2 Selecting Multiple Worksheets 8.3 Inserting and Deleting Worksheets 8.4 Renaming Worksheets 8.5 Coloring Worksheet Tabs 8.6 Copying or Moving Worksheets

CHAPTER 9 SETTING WORKSHEET LAYOUT 9.1 Using Page Break Preview 9.2 Using the Page Layout View 9.3 The Page Setup Dialog Box

CHAPTER 10 PRINTING WORKSHEETS 10.1 Using Print Preview 10.2 Printing Worksheets

CHAPTER 11 HELPING YOURSELF 11.1 Using Excel Help

CHAPTER 12 3D FORMULAS 12.1 Creating 3D Formulas 12.2 3D Formula Syntax 12.3 Creating 3D Range References

CHAPTER 13 NAMED RANGES 13.1 Naming Ranges 13.2 Creating Names from Headings 13.3 Moving to a Named Range 13.4 Using Named Ranges in Formulas 13.5 Naming 3D Ranges 13.6 Managing Named Ranges

CHAPTER 14 CONDITIONAL FORMATTING AND CELL STYLES 14.1 Conditional Formatting 14.2 Finding Cells with Conditional Formatting 14.3 Clearing Conditional Formatting 14.4 Using Table and Cell Styles

CHAPTER 15 PASTE SPECIAL 15.1 Using Paste Special 15.2 Pasting Linked Formulas

CHAPTER 16 SHARING WORKBOOKS 16.1 Sharing Workbooks 16.2 Highlighting Changes 16.3 Reviewing Changes 16.4 Using Comments 16.5 Compare and Merge Workbooks

CHAPTER 17 AUDITING WORKSHEETS 17.1 Auditing Worksheets 17.2 Tracing Precedent and Dependent Cells 17.3 Tracing Errors 17.4 Error Checking 17.5 Using the Watch Window 17.6 Cell Validation

CHAPTER 18 OUTLINING WORKSHEETS 18.1 Using Outlines 18.2 Applying and Removing Outlines

CHAPTER 19 CONSOLIDATING WORKSHEETS 19.1 Consolidating Data

CHAPTER 20 CREATING WORKSHEET CHARTS 20.1 Creating Charts 20.2 Selecting Charts and Chart Elements 20.3 Moving and Resizing Charts 20.4 Changing the Chart Type 20.5 Changing the Data Range 20.6 Switching Column and Row Data 20.7 Choosing a Chart Layout 20.8 Choosing a Chart Style 20.9 Printing Charts 20.10 Deleting Charts

CHAPTER 21 EDITING AND FORMATTING CHARTS 21.1 Formatting Chart Objects 21.2 Inserting Objects into a Chart 21.3 Changing Chart Labels 21.4 Changing Axes Display 21.5 Changing the Chart Background 21.6 Applying Chart Analysis Lines 21.7 Naming Charts 21.8 Applying Shape Styles to Chart Elements 21.9 Applying WordArt Styles to Chart Elements 21.10 Saving Custom Chart Templates

CHAPTER 22 PIVOTTABLES 22.1 Creating PivotTables and Pivot Charts 22.2 Manipulating a PivotTable 22.3 Changing Calculated Value Fields 22.4 Applying PivotTable Styles

22.5 Creating a PivotChart 22.6 Setting PivotTable Options 22.7 Sorting and Filtering PivotTable Data

CHAPTER 23 TABLES 23.1 Creating a Table 23.2 Adding and Editing Records 23.3 Inserting Records and Fields 23.4 Deleting Records and Fields

CHAPTER 24 SORTING DATA 24.1 Sorting Data 24.2 Custom Sort Orders

CHAPTER 25 FILTERING DATA 25.1 Using AutoFilters 25.2 Using the Top 10 AutoFilter 25.3 Applying a Custom AutoFilter 25.4 Creating Advanced Filters 25.5 Applying Multiple Criteria 25.6 Using Complex Criteria 25.7 Copying Filtered Results to a New Location 25.8 Using Database Functions

CHAPTER 26 USING WHATIF ANALYSIS 26.1 Using Data Tables 26.2 Using Scenario Manager 26.3 Using Goal Seek

CHAPTER 27 TABLERELATED FUNCTIONS 27.1 The Hlookup and Vlookup Functions 27.2 Using the IF, AND, and OR Functions

CHAPTER 28 SECURITY FEATURES 28.1 Unlocking Cells 28.2 Worksheet Protection 28.3 Workbook Protection 28.4 Password Protecting Excel Files

CHAPTER 29 MAKING MACROS 29.1 Recording Macros 29.2 Running and Deleting Recorded Macros 29.3 The Personal Macro Workbook

Advance Excel with One Project 20Unit Syllabus Design and risk 1. Templates Get a head start with templates Set up an Excel template that will save you an hour each time you create a new workbook Create new default workbook and worksheet templates Learn how modular templates can make your spreadsheets more consistent and much quicker to set up Your Excel, your way: customise the Excel interface to put the tools that you need at your fingertips.

2. Efficiency and Risk Make spreadsheets more efficient and less risky How to build in checks and controls from the outset Key techniques that reduce risk and increase automation and efficiency Introduce standards to help your team Documentation and review tools

3. Data Validation Extended uses of Data Validation Working with validation formulae Lists and lists that depend on other list selections Other methods of tracking down invalid entries Advanced techniques and problem solving

4. Functions and Superpowers Functions with superpowers Finding the right functions and how they work Functions with hidden powers – MOD() for patterns, OFFSET() for simple choices, INDIRECT() to manipulate formulae Making references to ranges of cells adapt automatically for new data

5. Array Formulae Array formulae One formula, one million calculations SUMPRODUCT() all the gain of an array formula with less of the pain

6. Tables Tables – structure comes to Excel Why Tables are so much more than just a new format Make your spreadsheets more automatic with a single command Table formulae – instant readability Data tools in Tables It’s not all good

7. Advanced Range Names Advanced Range Names Use the same name on different sheets Using the Name Manager Names in formulae – efficient inclusion of Names, the use of intersections Formulae in Names – how to allocate a formula directly to a Range Name and why you might need to

8. What if? Using Excel to help you make decisions Use Goal Seek to find where you need to start to get where you need to go Use an Excel Data Table to calculate dozens of possible outcomes Create and manage alternative scenarios Make more profit or incur less expense by using Excel Solver to identify the best solution

9. Problem solving Problem solving Calculations that make decisions – understanding TRUE ad FALSE What Boolean Logic is and why it’s useful in practice combining logic and arrays to solve complex problems Practical examples Spreadsheets that talk back – Excel interactivity

10. Form Controls Use Form controls to make life easier for users Use a Spin Button to choose a value easily Use an Option Button to choose with a single click Choosing from lists

11. Visual Basic and Macros Create macros by writing Visual Basic code A macro that performs one or more actions on selected cells Write your own Excel functions with VB code Understanding volatile functions Trigger a macro when a particular cell is changed Handling errors elegantly Give your spreadsheets impact with graphics

12. Practical Interactivity with VBA Exchanging information with VB code Displaying a Message box Asking for user input using an Input box Create an Excel form with a List box containing values from a range of cells Sample VB projects: an automatic index to sheets, printing selected ranges Avoiding macros when they’re not really necessary

13. Conditional Formatting Conditional Formatting – beyond simple Conditional Formats Basing conditions on a formula and deciding whether a batsman is out or not Choose currency symbols for a whole sheet by changing a single cell Getting your rules in the right order and knowing when to stop Graphical Conditional Formats – the detailed options Using invisibility to your advantage

14. Charts that Inspire Create charts to inspire What makes a good chart – is it really a 6.5 cucumbers? Simple steps to make your charts clearer Why small can be better than large Are pie charts evil? Why 3D charts can be 50% worse Mixed chart types, trendlines and projections Advanced chart techniques: breakeven lines and waterfall charts Pictures in chart columns

15. Sparklines Incell charts – showing 12 times as much information in the same amount of space Careful with that Axis The different types of Sparkline: lines, columns and win loss Sparklines based on a dynamic data range

16. Graphics Tricks and Techniques Further graphics tips and techniques Taking dynamic pictures with the Excel camera Use the Excel camera to combine areas from multiple sheets on the same sheet of paper Formatting Excel Camera pictures Power View – using the Excel 2013 data visualisation addin including plotting values on maps and ‘playing’ bubble charts Turning data into decisions

17. Working with External Data Getting at your data using the Get External Data tools Understand relational databases in 10 minutes and liberate your data Excel 2013 Data Model create relationships within Excel

18. Advanced Uses of PivotTables Use advanced PivotTable techniques to do more with your data Calculated Fields and Calculated items Using PivotTables as the calculation engine behind management reports Using GETPIVOTDATA() and CUBE formulae to create flexible reports Excel 2010 and 2013 Slicers and Timelines make your PivotTables more interactive Working with Pivot Charts Building and interactive dashboard using PivotTables and Slicers

19. PowerPivot The Excel 2010 and 2013 Power Pivot addin PowerPivot data tools Calculations in Power Pivot – an introduction to Data Analysis Expressions (DAX) DAX in table columns DAX to create new measures and calculated fields Understanding advanced DAX expressions – functions that combine calculations and database techniques the Time Intelligence DAX functions – why you need a table containing all possible dates

20. Reporting with PowerPivot Creating powerful reports with PowerPivot Hierarchies, Perspectives and Sets Adding Key Performance Indicators (KPIs) to a Power Pivot report Creating CUBE formulae to report on your data in just the way you want to Use all these techniques to turn millions of rows of data into a dashboard that supports better decisions

Ms Excel Advance in IPATS institute in Rawalpindi – Rawalpindi3035530865 Advanced Excel Course Overview of the Basics of Excel Customizing common options in Excel Absolute and relative cells Protecting and unprotecting worksheets and cells Advanced Excel Course Working with Functions Writing conditional expressions (using IF Using logical functions (AND, OR, NOT Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX VlookUP with Exact Match, Approximate Match Nested VlookUP with Exact Match VlookUP with Tables, Dynamic Ranges Nested VlookUP with Exact Match Using VLookUP to consolidate Data from Multiple Sheets Computer Operator CC02 4 Database & Web Page Basics Computer Technician Web Designing Web Development Client Side Scripting Server Configuration Programming Languages Advance Programming Languages Graphics Designing Computerized Accounting Animation Web Development Server Side Scripting Databases Networking PGDIT (Post Graduate Diploma In Information Technology PGDCS (Post Graduate Diploma In Computer Sciences DIT (Diploma In Information Technology DCS (Diploma In Computer Sciences Whatsapp: +923035530865, 03219606785, 3315145601, 03495021336 IPATS Government Recognized Education ZoneKhanna Pul RawalpindiIslamabad

IT Training programs for Professionals and Beginners – Rawalpindi3035530865 Professionals and students need training in technology for most jobs in today’s world. The IT Training Academy offers programs and certification courses in multiple areas of the IT field at subsidized rates to give trainees the skills and knowledge to gain a competitive advantage in the workplace. This will also help to promote the culture of entrepreneurship and create a more skilled workforce in the province. These trainings will be especially beneficial for Graduates, IT Students & Faculty, Professionals and Government Officials. Whatsapp: +923035530865, 03219606785, 3315145601, 03495021336 IPATS Government Recognized Education ZoneKhanna Pul RawalpindiIslamabad

MS Office Advance IT Course 3035530865 Offering Courses for Boys/Girls – Baghisb Shorthand Professional Course Bagh, Shorthand Professional Course Bhimber, Shorthand Professional Course Khuiratta, Shorthand Professional Course Kotli, Shorthand Professional Course Mangla, Shorthand Professional Course Mirpur, Shorthand Professional Course Muzaffarabad, Shorthand Professional Course Plandri, Shorthand Professional Course Rawalakot, Shorthand Professional Course Punch, Amir Chah, Bazdar, Bela, Shorthand Professional Course Bellpat, Bagh, Burj, Chagai, Chah Sandan, Chakku, Chaman, Shorthand Professional Course Chhatr, Shorthand Professional Course Dalbandin, Shorthand Professional Course Dera Bugti, Dhana Sar, Diwana, Duki, Dushi, Duzab, Gajar, Shorthand Professional Course Gandava, Shorthand Professional Course Garhi Khairo, Shorthand Professional Course Garruck, Shorthand Professional Course Ghazluna, Girdan, Gulistan, Gwadar, Shorthand Professional Course Gwash, Shorthand Professional Course Hab Chauki, Shorthand Professional Course Hameedabad, Shorthand Professional Course Harnai, Shorthand Professional Course Hinglaj, Shorthand Professional Course Hoshab, Shorthand Professional Course Ispikan, Shorthand Professional Course Jhal, Shorthand Professional Course Jhal Jhao, Shorthand Professional Course Jhatpat, Shorthand Professional Course Jiwani, Shorthand Professional Course Kalandi, Kalat, Shorthand Professional Course Kamararod, Shorthand Professional Course Kanak, Kandi, Kanpur, Kapip, Kappar, Karodi, Katuri, Kharan, Khuzdar, Kikki, Kohan, Kohlu, Korak, Lahri, Lasbela, Liari, Loralai, Mach, Mand, Manguchar, Mashki Chah, Maslti, Mastung, Mekhtar, Merui, Mianez, Murgha Kibzai, Musa Khel Bazar, Nagha Kalat, Nal, Naseerabad, Nauroz Kalat, Nur Gamma, Nushki, Nuttal, Ormara, Palantuk, Panjgur, Pasni, Piharak, Pishin, Qamruddin Karez, Qila Abdullah, Qila Ladgasht, Qila Safed, Qila Saifullah, Quetta, Rakhni, Robat Thana, Rodkhan, Saindak, Sanjawi, Saruna, Shabaz Kalat, Shahpur, Sharam Jogizai, Shingar, Shorap, Sibi, Sonmiani, Spezand, Spintangi, Sui, Suntsar, Surab, Thalo, Tump, Turbat, Umarao, Pir Mahal, Uthal, Vitakri, Wadh, Washap, Wasjuk, Yakmach, Zhob, Astor, Baramula, Hunza, Gilgit, Nagar, Skardu, Shangrila, Shandur, Bajaur, Hangu, Malakand, Miran Shah, Mohmand, Khyber, Kurram, North Waziristan, South Waziristan, Wana, Abbottabad, Ayubia, Adezai, Banda Daud Shah, Bannu, Batagram, Birote, Buner, Chakdara, Charsadda, Chitral, Dargai, Darya Khan, Dera Ismail Khan, Drasan, Drosh, Hangu, Haipur, Kalam, Karak, Khanspur, Shorthand Professional Course Kohat, Shorthand Professional Course Kohistan, Lakki Marwat, Latamber, Lower Dir, Madyan, Malakand, Mansehra, Shorthand Professional Course Mardan, Shorthand Professional Course Mastuj, Mongora, Shorthand Professional Course Nowshera, Shorthand Professional Course Paharpur, Shorthand Professional Course Peshawar, Shorthand Professional Course Saidu Sharif, Shangla, Shorthand Professional Course Sakesar, Shorthand Professional Course Swabi, Shorthand Professional Course Swat, Shorthand Professional Course Tangi, Shorthand Professional Course Tank, Shorthand Professional Course Tahll, Shorthand Professional Course Tordher, Shorthand Professional Course Upper Dir, Shorthand Professional Course Ahmedpur East, Shorthand Professional Course Ahmed Nager Chatha, Shorthand Professional Course Ali Pur, Arifwala, Shorthand Professional Course Attock, Shorthand Professional Course Basti Malook, Shorthand Professional Course Bahgalchur, Shorthand Professional Course Bhalwal, Shorthand Professional Course Bahawalnagar, Shorthand Professional Course Bahawalpur, Shorthand Professional Course Bhaipheru, Shorthand Professional Course Bhakkar, Shorthand Professional Course Burewala, Shorthand Professional Course Chailianwala, Shorthand Professional Course Chakwal, Shorthand Professional Course Chichawatni, Shorthand Professional Course Chiniot, Shorthand Professional Course Chowk Azam, Shorthand Professional Course Chowk Sarwar Shaheed, Shorthand Professional Course Daska, Shorthand Professional Course Darya Khan, Shorthand Professional Course Dera Ghazi Khan, Shorthand Professional Course Derawar Fort, Shorthand Professional Course Dhaular, Shorthand Professional Course Dina City, Dinga, Dipalpur, Faisalabad, Fateh Jang, Gadar, Shorthand Professional Course Ghakhar Mandi, Shorthand Professional Course Gujranwala, Shorthand Professional Course Gujrat, Shorthand Professional Course Gujar Khan, Shorthand Professional Course Hafizabad, Shorthand Professional Course Haroonabad, Shorthand Professional Course Hasilpur, Shorthand Professional Course Haveli Lakha, Shorthand Professional Course Jampur, Shorthand Professional Course Jhang, Shorthand Professional Course Jhelum, Shorthand Professional Course Kalabagh, Shorthand Professional Course Karok Lal Esan, Shorthand Professional Course Kasur, Shorthand Professional Course Kamalia, Shorthand Professional Course Kamoke, Shorthand Professional Course Khanewal, Shorthand Professional Course Khanpur, Shorthand Professional Course Kharian, Shorthand Professional Course Khushab, Shorthand Professional Course Kot Addu, Jahania, Jalla Araain, Jauharabad, Laar, Lahore, Lalamusa, Layyah, Shorthand Professional Course Lodhran, Mamoori, Mandi Bahauddin, Makhdoom Ali, Mandi Warburton, Mailsi, Mian Channu, Minawala, Mianwali, Multan, Murree, Mughal Pura, Muridike, Muzaffargarh, Narowal, Okara, Renala Khurd, Rajanpur, Pak Pattan, Panjgar, Pattoki, Pir Mahal, Qila Didar Singh, Rabwah, Raiwind, Rajan Pur, Rahim Yar Khan, Rawalpindi, Rohri, Sadiqabad, Safdar Abad, Sahiwal, Sangla Hill, Samberial, Sarai Alamgir, Sargodha, Shakargarh, Shafaqat Shaheed Chowk, Sheikhu Pura, Sialkot, Sohawa, Sooianwala, Sundar, Talagang, Tarbela, Takhtbai, Taxila, Toba Tek Singh, Vehari, Wah Cantonment, Wazirabad, Ali Bander, Baden, Chachro, Dadu, Digri, Diplo, Dokri, Gadra, Ghanian, Ghauspur, Ghotki, Hala, Hyderabad, Islamkot, Jacobabad, Jamesabad, Jamshoro, Janghar, Jati Mughabhim, Jhudo, Junghahi, Kandiaro, Karachi, Kashmir, Keti Bander, Khairpur, Khora, Khupro, Khokhopur, Korangi, Kotri, Kot Sarae, Larkana, Lund, Mathi, Matiari, Mehar, Mirpur Batoro, Mirpur Khas, Mirpur Sakro, Mithi, Mithani, Moro, Nagar Parkar, Naushara, Naudero, Noushero Feroz, Nawabshah, Nazimabad, Naokot, Pendoo, Pokran, Qambar, Qazi Ahmad, Ranipur, Ratodero, Rohri, Saidu Sharif, Sakrand, Sanghar, Shanankhot, Shahbander, Shorthand Professional Course Shahdadpur, Shorthand Professional Course Shahpur, Shorthand Professional Course Chakar, Shorthand Professional Course Shikarpur, Shorthand Professional Course Sujawal, Shorthand Professional Course Sukkar, Shorthand Professional Course Tando Adam, Shorthand Professional Course Tando Allah Yar, Shorthand Professional Course Tando Bago, Shorthand Professional Course Tar Ahmed Rind, Shorthand Professional Course Thatta, Tujal, Shorthand Professional Course Umarkot, Shorthand Professional Course Veirwaro, Shorthand Professional Course Warah, Zaffarwal. (M) For Details Please Contact Us: O3O3553O865. Whatsapp: +923035530865, 03219606785, 3315145601, 03495021336 IPATS Government Recognized Education ZoneKhanna Pul RawalpindiIslamabad Professional Shorthand Typing Course O3035530865 for Boys & Girls – Rawalpindi Personal Shorthand, originally known as Briefhand in the 1950s, is a completely alphabetic shorthand. There are three basic categories of written shorthand. Best known are puresymbol (stenographic) shorthand systems (e.g., Gregg, Pitman). Because the complexity of symbol shorthands made them timeconsuming to learn, a variety of newer, alphabetic shorthands were created, with the goal of being easier to learn– e.g., Speedwriting, Stenoscript, Stenospeed, and Forkner shorthand. These systems used normally written letters of the alphabet, but also some number of symbols, alphabetic characters changed in shape or position, or special marks for punctuation; and so they are more accurately described as hybrid shorthand systems. In contrast, Personal Shorthand uses only the 26 letters of the alphabet, without any special symbols, positioning, or punctuation, and it can therefore be written cursively, printed, typed, or even entered in a computer without special typefaces or graphics. Given years of practice, symbol shorthand writers could sometimes acquire skills of 150 or even 200 words per minute, which might have qualified them for demanding positions such as court reporting, typically dominated today by machine shorthands. Due to the extensive time necessary, few achieved such a level. Most symbol shorthand writers in secretarial positions wrote between 80 and 140 words per minute. Hybrid shorthand systems with higher symbol content generally could be written faster than those with fewer symbols. In common with most hybrid shorthands, Personal Shorthand cannot be written as fast as symbol shorthands. However, like some hybrids, learning time is drastically reduced. Students of Personal Shorthand can acquire a useful shorthand skill (50 to 60 wpm) in a single school term, compared to the year or more for symbol system students to reach that same level. Without the complexity of symbols to memorize and practice writing, Personal Shorthand theory is relatively simple. There are six Theory Rules. Slightly more than a hundred highfrequency business vocabulary words are represented by a single written letter known as a Brief Form ("a" for "about", "t" for "time", "v" for "very", etc.). Highfrequency letter groupings within words ("g" for "ing", "s" for "tion", etc.), known as Phonetic Abbreviations, are also written with a single letter. In most Personal Shorthand textbooks, the entire Theory is presented in just ten lessons, after which review and practice can lead to writing speeds of 60 to 100 words per minute. Shorthand Professional Course Bagh, Shorthand Professional Course Bhimber, Shorthand Professional Course Khuiratta, Shorthand Professional Course Kotli, Shorthand Professional Course Mangla, Shorthand Professional Course Mirpur, Shorthand Professional Course Muzaffarabad, Shorthand Professional Course Plandri, Shorthand Professional Course Rawalakot, Shorthand Professional Course Punch, Amir Chah, Bazdar, Bela, Shorthand Professional Course Bellpat, Bagh, Burj, Chagai, Chah Sandan, Chakku, Chaman, Shorthand Professional Course Chhatr, Shorthand Professional Course Dalbandin, Shorthand Professional Course Dera Bugti, Dhana Sar, Diwana, Duki, Dushi, Duzab, Gajar, Shorthand Professional Course Gandava, Shorthand Professional Course Garhi Khairo, Shorthand Professional Course Garruck, Shorthand Professional Course Ghazluna, Girdan, Gulistan, Gwadar, Shorthand Professional Course Gwash, Shorthand Professional Course Hab Chauki, Shorthand Professional Course Hameedabad, Shorthand Professional Course Harnai, Shorthand Professional Course Hinglaj, Shorthand Professional Course Hoshab, Shorthand Professional Course Ispikan, Shorthand Professional Course Jhal, Shorthand Professional Course Jhal Jhao, Shorthand Professional Course Jhatpat, Shorthand Professional Course Jiwani, Shorthand Professional Course Kalandi, Kalat, Shorthand Professional Course Kamararod, Shorthand Professional Course Kanak, Kandi, Kanpur, Kapip, Kappar, Karodi, Katuri, Kharan, Khuzdar, Kikki, Kohan, Kohlu, Korak, Lahri, Lasbela, Liari, Loralai, Mach, Mand, Manguchar, Mashki Chah, Maslti, Mastung, Mekhtar, Merui, Mianez, Murgha Kibzai, Musa Khel Bazar, Nagha Kalat, Nal, Naseerabad, Nauroz Kalat, Nur Gamma, Nushki, Nuttal, Ormara, Palantuk, Panjgur, Pasni, Piharak, Pishin, Qamruddin Karez, Qila Abdullah, Qila Ladgasht, Qila Safed, Qila Saifullah, Quetta, Rakhni, Robat Thana, Rodkhan, Saindak, Sanjawi, Saruna, Shabaz Kalat, Shahpur, Sharam Jogizai, Shingar, Shorap, Sibi, Sonmiani, Spezand, Spintangi, Sui, Suntsar, Surab, Thalo, Tump, Turbat, Umarao, Pir Mahal, Uthal, Vitakri, Wadh, Washap, Wasjuk, Yakmach, Zhob, Astor, Baramula, Hunza, Gilgit, Nagar, Skardu, Shangrila, Shandur, Bajaur, Hangu, Malakand, Miran Shah, Mohmand, Khyber, Kurram, North Waziristan, South Waziristan, Wana, Abbottabad, Ayubia, Adezai, Banda Daud Shah, Bannu, Batagram, Birote, Buner, Chakdara, Charsadda, Chitral, Dargai, Darya Khan, Dera Ismail Khan, Drasan, Drosh, Hangu, Haipur, Kalam, Karak, Khanspur, Shorthand Professional Course Kohat, Shorthand Professional Course Kohistan, Lakki Marwat, Latamber, Lower Dir, Madyan, Malakand, Mansehra, Shorthand Professional Course Mardan, Shorthand Professional Course Mastuj, Mongora, Shorthand Professional Course Nowshera, Shorthand Professional Course Paharpur, Shorthand Professional Course Peshawar, Shorthand Professional Course Saidu Sharif, Shangla, Shorthand Professional Course Sakesar, Shorthand Professional Course Swabi, Shorthand Professional Course Swat, Shorthand Professional Course Tangi, Shorthand Professional Course Tank, Shorthand Professional Course Tahll, Shorthand Professional Course Tordher, Shorthand Professional Course Upper Dir, Shorthand Professional Course Ahmedpur East, Shorthand Professional Course Ahmed Nager Chatha, Shorthand Professional Course Ali Pur, Arifwala, Shorthand Professional Course Attock, Shorthand Professional Course Basti Malook, Shorthand Professional Course Bahgalchur, Shorthand Professional Course Bhalwal, Shorthand Professional Course Bahawalnagar, Shorthand Professional Course Bahawalpur, Shorthand Professional Course Bhaipheru, Shorthand Professional Course Bhakkar, Shorthand Professional Course Burewala, Shorthand Professional Course Chailianwala, Shorthand Professional Course Chakwal, Shorthand Professional Course Chichawatni, Shorthand Professional Course Chiniot, Shorthand Professional Course Chowk Azam, Shorthand Professional Course Chowk Sarwar Shaheed, Shorthand Professional Course Daska, Shorthand Professional Course Darya Khan, Shorthand Professional Course Dera Ghazi Khan, Shorthand Professional Course Derawar Fort, Shorthand Professional Course Dhaular, Shorthand Professional Course Dina City, Dinga, Dipalpur, Faisalabad, Fateh Jang, Gadar, Shorthand Professional Course Ghakhar Mandi, Shorthand Professional Course Gujranwala, Shorthand Professional Course Gujrat, Shorthand Professional Course Gujar Khan, Shorthand Professional Course Hafizabad, Shorthand Professional Course Haroonabad, Shorthand Professional Course Hasilpur, Shorthand Professional Course Haveli Lakha, Shorthand Professional Course Jampur, Shorthand Professional Course Jhang, Shorthand Professional Course Jhelum, Shorthand Professional Course Kalabagh, Shorthand Professional Course Karok Lal Esan, Shorthand Professional Course Kasur, Shorthand Professional Course Kamalia, Shorthand Professional Course Kamoke, Shorthand Professional Course Khanewal, Shorthand Professional Course Khanpur, Shorthand Professional Course Kharian, Shorthand Professional Course Khushab, Shorthand Professional Course Kot Addu, Jahania, Jalla Araain, Jauharabad, Laar, Lahore, Lalamusa, Layyah, Shorthand Professional Course Lodhran, Mamoori, Mandi Bahauddin, Makhdoom Ali, Mandi Warburton, Mailsi, Mian Channu, Minawala, Mianwali, Multan, Murree, Mughal Pura, Muridike, Muzaffargarh, Narowal, Okara, Renala Khurd, Rajanpur, Pak Pattan, Panjgar, Pattoki, Pir Mahal, Qila Didar Singh, Rabwah, Raiwind, Rajan Pur, Rahim Yar Khan, Rawalpindi, Rohri, Sadiqabad, Safdar Abad, Sahiwal, Sangla Hill, Samberial, Sarai Alamgir, Sargodha, Shakargarh, Shafaqat Shaheed Chowk, Sheikhu Pura, Sialkot, Sohawa, Sooianwala, Sundar, Talagang, Tarbela, Takhtbai, Taxila, Toba Tek Singh, Vehari, Wah Cantonment, Wazirabad, Ali Bander, Baden, Chachro, Dadu, Digri, Diplo, Dokri, Gadra, Ghanian, Ghauspur, Ghotki, Hala, Hyderabad, Islamkot, Jacobabad, Jamesabad, Jamshoro, Janghar, Jati Mughabhim, Jhudo, Junghahi, Kandiaro, Karachi, Kashmir, Keti Bander, Khairpur, Khora, Khupro, Khokhopur, Korangi, Kotri, Kot Sarae, Larkana, Lund, Mathi, Matiari, Mehar, Mirpur Batoro, Mirpur Khas, Mirpur Sakro, Mithi, Mithani, Moro, Nagar Parkar, Naushara, Naudero, Noushero Feroz, Nawabshah, Nazimabad, Naokot, Pendoo, Pokran, Qambar, Qazi Ahmad, Ranipur, Ratodero, Rohri, Saidu Sharif, Sakrand, Sanghar, Shanankhot, Shahbander, Shorthand Professional Course Shahdadpur, Shorthand Professional Course Shahpur, Shorthand Professional Course Chakar, Shorthand Professional Course Shikarpur, Shorthand Professional Course Sujawal, Shorthand Professional Course Sukkar, Shorthand Professional Course Tando Adam, Shorthand Professional Course Tando Allah Yar, Shorthand Professional Course Tando Bago, Shorthand Professional Course Tar Ahmed Rind, Shorthand Professional Course Thatta, Tujal, Shorthand Professional Course Umarkot, Shorthand Professional Course Veirwaro, Shorthand Professional Course Warah, Zaffarwal. Whatsapp: +923035530865, 03219606785, 3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Basic & Advance IT Course Pakistan 3035530865 Offering Courses for Boys & Girls – Muzaffarabad originally known as Brief hand in the 1950s, is a completely alphabetic shorthand. Top Leading Institute offer Basic IT Professional Training Course. Professional Male & Female Instructors. For Boys & Girls. Individual Training. professional, but we also ensure that our candidates have fun and enjoy their time learning One & Two Years Diploma Courses Regular & Distance learning Based.What is Computer?Computer is an advanced electronic device that takes raw data as input from the user and processes these data under the control of set of instructions (called program) and gives the result (output) and saves output for the future use. It can process both numerical and non-numerical (arithmetic and logical) calculations.A computer has four functions:a. accepts data Input b. processes data Processing c. produces output Output d. stores results StorageInput (Data): Input is the raw information entered into a computer from the input devices. It is the collection of letters, numbers, images etc. Process: Process is the operation of data as per given instruction. It is totally internal process of the computer system. Output: Output is the processed data given by computer after data processing. Output is also called as Result. We can save these results in the storage devices for the future use. Computer System All of the components of a computer system can be summarized with the simple equations. COMPUTER SYSTEM = HARDWARE + SOFTWARE+ USER Hardware = Internal Devices + Peripheral Devices All physical parts of the computer (or everything that we can touch) are known as Hardware. Software = Programs Software gives "intelligence" to the computer. USER = Person, who operates computer. Basic & Advance Professional Course Bagh, Basic & Advance Professional Course Bhimber, Basic & Advance Professional Course Khuiratta, Basic & Advance Professional Course Kotli, Basic & Advance Professional Course Mangla, Basic & Advance Professional Course Mirpur, Basic & Advance Professional Course Muzaffarabad, Basic & Advance Professional Course Plandri, Basic & Advance Professional Course Rawalakot, Basic & Advance Professional Course Punch, Amir Chah, Bazdar, Bela, Basic & Advance Professional Course Bellpat, Bagh, Burj, Chagai, Chah Sandan, Chakku, Chaman, Basic & Advance Professional Course Chhatr, Basic & Advance Professional Course Dalbandin, Basic & Advance Professional Course Dera Bugti, Dhana Sar, Diwana, Duki, Dushi, Duzab, Gajar, Basic & Advance Professional Course Gandava, Basic & Advance Professional Course Garhi Khairo, Basic & Advance Professional Course Garruck, Basic & Advance Professional Course Ghazluna, Girdan, Gulistan, Gwadar, Basic & Advance Professional Course Gwash, Basic & Advance Professional Course Hab Chauki, Basic & Advance Professional Course Hameedabad, Basic & Advance Professional Course Harnai, Basic & Advance Professional Course Hinglaj, Basic & Advance Professional Course Hoshab, Basic & Advance Professional Course Ispikan, Basic & Advance Professional Course Jhal, Basic & Advance Professional Course Jhal Jhao, Basic & Advance Professional Course Jhatpat, Basic & Advance Professional Course Jiwani, Basic & Advance Professional Course Kalandi, Kalat, Basic & Advance Professional Course Kamararod, Basic & Advance Professional Course Kanak, Kandi, Kanpur, Kapip, Kappar, Karodi, Katuri, Kharan, Khuzdar, Kikki, Kohan, Kohlu, Korak, Lahri, Lasbela, Liari, Loralai, Mach, Mand, Manguchar, Mashki Chah, Maslti, Mastung, Mekhtar, Merui, Mianez, Murgha Kibzai, Musa Khel Bazar, Nagha Kalat, Nal, Naseerabad, Nauroz Kalat, Nur Gamma, Nushki, Nuttal, Ormara, Palantuk, Panjgur, Pasni, Piharak, Pishin, Qamruddin Karez, Qila Abdullah, Qila Ladgasht, Qila Safed, Qila Saifullah, Quetta, Rakhni, Robat Thana, Rodkhan, Saindak, Sanjawi, Saruna, Shabaz Kalat, Shahpur, Sharam Jogizai, Shingar, Shorap, Sibi, Sonmiani, Spezand, Spintangi, Sui, Suntsar, Surab, Thalo, Tump, Turbat, Umarao, Pir Mahal, Uthal, Vitakri, Wadh, Washap, Wasjuk, Yakmach, Zhob, Astor, Baramula, Hunza, Gilgit, Nagar, Skardu, Shangrila, Shandur, Bajaur, Hangu, Malakand, Miran Shah, Mohmand, Khyber, Kurram, North Waziristan, South Waziristan, Wana, Abbottabad, Ayubia, Adezai, Banda Daud Shah, Bannu, Batagram, Birote, Buner, Chakdara, Charsadda, Chitral, Dargai, Darya Khan, Dera Ismail Khan, Drasan, Drosh, Hangu, Haipur, Kalam, Karak, Khanspur, Basic & Advance Professional Course Kohat, Basic & Advance Professional Course Kohistan, Lakki Marwat, Latamber, Lower Dir, Madyan, Malakand, Mansehra, Basic & Advance Professional Course Mardan, Basic & Advance Professional Course Mastuj, Mongora, Basic & Advance Professional Course Nowshera, Basic & Advance Professional Course Paharpur, Basic & Advance Professional Course Peshawar, Basic & Advance Professional Course Saidu Sharif, Shangla, Basic & Advance Professional Course Sakesar, Basic & Advance Professional Course Swabi, Basic & Advance Professional Course Swat, Basic & Advance Professional Course Tangi, Basic & Advance Professional Course Tank, Basic & Advance Professional Course Tahll, Basic & Advance Professional Course Tordher, Basic & Advance Professional Course Upper Dir, Basic & Advance Professional Course Ahmedpur East, Basic & Advance Professional Course Ahmed Nager Chatha, Basic & Advance Professional Course Ali Pur, Arifwala, Basic & Advance Professional Course Attock, Basic & Advance Professional Course Basti Malook, Basic & Advance Professional Course Bahgalchur, Basic & Advance Professional Course Bhalwal, Basic & Advance Professional Course Bahawalnagar, Basic & Advance Professional Course Bahawalpur, Basic & Advance Professional Course Bhaipheru, Basic & Advance Professional Course Bhakkar, Basic & Advance Professional Course Burewala, Basic & Advance Professional Course Chailianwala, Basic & Advance Professional Course Chakwal, Basic & Advance Professional Course Chichawatni, Basic & Advance Professional Course Chiniot, Basic & Advance Professional Course Chowk Azam, Basic & Advance Professional Course Chowk Sarwar Shaheed, Basic & Advance Professional Course Daska, Basic & Advance Professional Course Darya Khan, Basic & Advance Professional Course Dera Ghazi Khan, Basic & Advance Professional Course Derawar Fort, Basic & Advance Professional Course Dhaular, Basic & Advance Professional Course Dina City, Dinga, Dipalpur, Faisalabad, Fateh Jang, Gadar, Basic & Advance Professional Course Ghakhar Mandi, Basic & Advance Professional Course Gujranwala, Basic & Advance Professional Course Gujrat, Basic & Advance Professional Course Gujar Khan, Basic & Advance Professional Course Hafizabad, Basic & Advance Professional Course Haroonabad, Basic & Advance Professional Course Hasilpur, Basic & Advance Professional Course Haveli Lakha, Basic & Advance Professional Course Jampur, Basic & Advance Professional Course Jhang, Basic & Advance Professional Course Jhelum, Basic & Advance Professional Course Kalabagh, Basic & Advance Professional Course Karok Lal Esan, Basic & Advance Professional Course Kasur, Basic & Advance Professional Course Kamalia, Basic & Advance Professional Course Kamoke, Basic & Advance Professional Course Khanewal, Basic & Advance Professional Course Khanpur, Basic & Advance Professional Course Kharian, Basic & Advance Professional Course Khushab, Basic & Advance Professional Course Kot Addu, Jahania, Jalla Araain, Jauharabad, Laar, Lahore, Lalamusa, Layyah, Basic & Advance Professional Course Lodhran, Mamoori, Mandi Bahauddin, Makhdoom Ali, Mandi Warburton, Mailsi, Mian Channu, Minawala, Mianwali, Multan, Murree, Mughal Pura, Muridike, Muzaffargarh, Narowal, Okara, Renala Khurd, Rajanpur, Pak Pattan, Panjgar, Pattoki, Pir Mahal, Qila Didar Singh, Rabwah, Raiwind, Rajan Pur, Rahim Yar Khan, Rawalpindi, Rohri, Sadiqabad, Safdar Abad, Sahiwal, Sangla Hill, Samberial, Sarai Alamgir, Sargodha, Shakargarh, Shafaqat Shaheed Chowk, Sheikhu Pura, Sialkot, Sohawa, Sooianwala, Sundar, Talagang, Tarbela, Takhtbai, Taxila, Toba Tek Singh, Vehari, Wah Cantonment, Wazirabad, Ali Bander, Baden, Chachro, Dadu, Digri, Diplo, Dokri, Gadra, Ghanian, Ghauspur, Ghotki, Hala, Hyderabad, Islamkot, Jacobabad, Jamesabad, Jamshoro, Janghar, Jati Mughabhim, Jhudo, Junghahi, Kandiaro, Karachi, Kashmir, Keti Bander, Khairpur, Khora, Khupro, Khokhopur, Korangi, Kotri, Kot Sarae, Larkana, Lund, Mathi, Matiari, Mehar, Mirpur Batoro, Mirpur Khas, Mirpur Sakro, Mithi, Mithani, Moro, Nagar Parkar, Naushara, Naudero, Noushero Feroz, Nawabshah, Nazimabad, Naokot, Pendoo, Pokran, Qambar, Qazi Ahmad, Ranipur, Ratodero, Rohri, Saidu Sharif, Sakrand, Sanghar, Shanankhot, Shahbander, Basic & Advance Professional Course Shahdadpur, Basic & Advance Professional Course Shahpur, Basic & Advance Professional Course Chakar, Basic & Advance Professional Course Shikarpur, Basic & Advance Professional Course Sujawal, Basic & Advance Professional Course Sukkar, Basic & Advance Professional Course Tando Adam, Basic & Advance Professional Course Tando Allah Yar, Basic & Advance Professional Course Tando Bago, Basic & Advance Professional Course Tar Ahmed Rind, Basic & Advance Professional Course Thatta, Tujal, Basic & Advance Professional Course Umarkot, Basic & Advance Professional Course Veirwaro, Basic & Advance Professional Course Warah, Zaffarwal. (M) For Details Please Contact Us:O3o3553o865 Whatsapp: +923035530865, 03219606785, 3315145601, 03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad


<><><><><>For Registration & Information<><><><><>
INSTITUTE OF PROFESSIONAL AND TECHNICAL STUDIES (IPATS)
Whatsapp: +92 3219606785, 03035530865
Call: +923315145601, 03495021336
Head Office: 2nd Floor, Yasir Plaza, Near Chatri Chowk, Khanna Pull,
Qadeer Road, Rawalpindi, Pakistan
Contact Office: +923219606785, 03035530865, 0331-5145601, 0349-5021336
Email: ipatsedu@gmail.com Website: www.ipatsedu.com