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 companys 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 employees 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 Its 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 its 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 theyre 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 todays 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