Search This Blog

office automation course

Tuesday, 24 May 2011



Duration 2 month
Classes 1 hour daily,5 Days in a Week
Timings are available morning afternoon evening
Course fee 3000/=
For further details
CONTACT:
email onlincompteacher@gmail.com
phone +92
-333-3725280
Read more ...

Basic computer classes is about to be started

Saturday, 21 May 2011

computer course
for beignners

Computer basic course for beginners i am starting classes conform your timing and admission in my classes
course outline
  • Learning the Basics
  • Exploring Window Features
  • Background and Appearance Settings
  • Arranging icons, resizing and moving windows
  • Using Programs
  • Working with Views and Toolbars
  • Organizing Files and Folders
  • Creating, Moving, Copying and Deleting Files and Folders
  • Working with Multimedia Files
  • Working with Multiple Windows
  • Using the Search Companion
  • Using the Desktop and Recycle Bin
  • Working with Storage Devices
  • Formatting and Managing Disks
  • Using the Control Panel
  • Working with Printers and Hardware
  • Customizing the Display
  • Using the Start Menu
  • Using the Taskbar
  • Using Accessories
  • Using the Help and Support Center
  • Getting Started with Internet Explorer
  • Using Accounts and Shutting Down
DURATION
7 Days
CLASS DURATION
1 hour ,3 Days in a Week
TIMINGS
Morning, Evening
For further details
CONTACT :
email onlincompteacher@gmail.com
phone +92-333-3725280
Read more ...

Computer Course for beginners in Urdu

Wednesday, 4 May 2011
Basics computer free
 online videos
beginners tutorial
 download

Getting Started
 with The Internet Explorer

keyboard monitor
 ms dos windows

Managing Disks
the Control Panel

Multiple Windows
 Files Working

Toolbars Organizing
 and  Files and Folders

Features Background
 and Appearance Settings

re sizing and moving
windows Using Programs

course outline
  • Learning the Basics
  • Exploring Window Features
  • Background and Appearance Settings
  • Arranging icons, resizing and moving windows
  • Using Programs
  • Working with Views and Toolbars
  • Organizing Files and Folders
  • Creating, Moving, Copying and Deleting Files and Folders
  • Working with Multimedia Files
  • Working with Multiple Windows
  • Using the Search Companion
  • Using the Desktop and Recycle Bin
  • Working with Storage Devices
  • Formatting and Managing Disks
  • Using the Control Panel
  • Working with Printers and Hardware
  • Customizing the Display
  • Using the Start Menu
  • Using the Taskbar
  • Using Accessories
  • Using the Help and Support Center
  • Getting Started with Internet Explorer
  • Using Accounts and Shutting Down
DURATION
7 Days
CLASS DURATION
1 hour ,3 Days in a Week
TIMINGS
Morning, Evening
For further details
CONTACT :
email onlincompteacher@gmail.com
phone +92-333-3725280
Read more ...

Differences Between Microsoft Word 2003 and Microsoft Word 2007 An Overview

Monday, 2 May 2011

Microsoft Word 2010
and Microsoft Word 2013
Microsoft Word being one among the most widely used Microsoft applications allows users to write and create, view, copy, paste, save, edit, share, and print text documents etc. Microsoft Word application rules the word-processing market as it allows users to beautify their text documents by inserting pictures and animated images, charts, diagrams, tables, figures, and shapes etc.; and by using text in different styles, fonts, colors, and languages etc. at the same time. Since its launch, Microsoft Word has greatly reduced users' burden of creating multiple documents at a time, copying them to another word file, and running grammar & spell check function etc. With the time, Microsoft Word (MS-Word) also progressed to new versions such as MS-Word 2003 and 2007. Below are some of the significant features that distinguish MS-Word 2007 and MS-Word 2007:
Interface:
Microsoft-Word 2003 - It comprises several menu tabs as well as toolbars that include lots of buttons. These buttons/features can be customized to give command access.
Microsoft-Word 2007 - It uses a user-friendly interface known as 'Ribbon'. It comprises 7 menu tabs viz. 'Home', 'Page Layout', 'References', 'Mailings', 'Review', and 'View'. There is an 8th tab also called 'Developer' that is however turned off by the default settings. Every Ribbon tab contains different buttons along with drop down menus. However, compared to MS-Word 2003, the Ribbon interface in MS-Word 2007 is not customizable.
File Format:
MS-Word 2003 - It uses DOC file format for saving text documents. However, users will have to download a compatibility pack for opening DOCX files.
MS-Word 2007 - It uses DOCX file format, which is an open XML standard format. It is the widely used file format for opening XML files. The users also have the choice of saving their documents/files in DOC format.
Document Inspector:
MS-Word 2003 -It comprises 'Remove Hidden Data' add-in, which is a tool to remove document's hidden or visible information including personal etc. However, the add-in does not a user make changes to document's properties.
MS-Word 2007 - It comprises 'Inspect Document' command that is when executed gives a list of options including versions, comments, annotations, document properties, customized XML data, personal information, or revisions among others. The Inspect Document feature allows users to delete above mentioned options as per their requirements.
Quick Parts:
MS-Word 2003 - It comprises 'AutoText' function that enables users to define, edit, insert, and save text.
MS-Word 2007 - It comprises 'Quick Parts' that allows users to remain its text plain or add formatting or graphics. The feature will be available in 'Insert' tab.
Quick Access Toolbar:
Word 2003 - It comprises no such feature and a user has to go through the entire menu tab to get access to its frequently-used commands such as save, edit, or undo etc.
Word 2007 - It comprises 'Quick Access Toolbar' that is designed to save the commands used again and again overly by a user while creating a text document. Such commands or features could be anything from undoing, repeat, clip art, or to save etc. You can get instant access to such commands or features by customizing your 'Quick Access Toolbar'. You only need to add/insert your frequently used commands/features to the toolbar by just right clicking on them and then clicking on 'Add to Quick Access Toolbar'.
Mail Merge Wizard:
MS-Word 2003 - It comprises 'Mail Merge Wizard' that does allow a user to send personalized messages. However, the wizard has serious issues with Microsoft Excel attachments. It means you will not be able to import your data for emailing from Microsoft Excel documents.
MS-Word 2007 - It has an improved 'Mail Merge Wizard' that allows a user to type and send personalized messages to all the recipients without requiring to go through the process of CC and BCC in the mail account. After you have typed your mail to all the recipients, the wizard would forward them to your Microsoft Outlook or Outlook Express outbox. Whenever you go online in your Microsoft Outlook, your Outlook will automatically send all the personalized messages to each of the addresses. Therefore, the wizard wonderfully saves you from typing letter or documents to each and every recipient with their individual information.
The comparison of features has brought us to the conclusion that MS-Word 2007 being the advanced word processor has a clear edge over MS-Word 2003. However, no matter which of the two software applications you have, you may experience the problem with them anytime. For that matter, you can look for a Microsoft-certified technical support that resolves your issues online.

Article Source: http://EzineArticles.com/5989625

Read more ...

Spreadsheets A Brief History of Spreadsheets and How Excel Got To Be No 1

Monday, 2 May 2011

spreadsheets
in ms office
Spreadsheets have been around for hundreds of years. They were originally manually compiled on large sheets of paper by clerks and accountants to summarize financial or other data in columns and rows for business managers. So how did they get to where they are today?
The first computerized spreadsheet is attributed to Professor Richard Mattesich who, in 1961 developed an "electronic spreadsheet" for use in business accounting. Personal computers (PC's) had not yet been invented, so the Mattesich spreadsheet ran on huge (and hugely expensive) mainframe computers installed by large corporations like AT&T, Bell and General Motors in Canada and the US.
In the early 1970's, microprocessors began to replace the cabinets circuitry and valves in mainframe computers and the first micro-computers (later called personal computers) came onto the scene. The earliest were in kit form and used by hobbyists and technicians who had to write their own programs in low-level machine code or assembly language. Although the revolution had begun, there was no "easy" interface between a human and a computer, but that was soon to come.
In 1975, two young computer enthusiasts, Paul Allen, and Bill Gates, had an extremely ambitious vision, a computer on every desktop and in every home. This duo formed a company named Microsoft (from microcomputer and software) and their plan was to write software that would make micro-computers accessible to the masses.
In 1978, another young computer enthusiast, Dan Bricklin, came up with the idea for a "visible interactive calculator". His first prototype "spreadsheet" contained only five columns and 20 rows, so Dan recruited Bob Franklin to make the program more powerful and hence, more useful. Franklin did just that and compressed the code enough to make it practical for the "visible calculator" to run on a microcomputer. And so was born VisiCalc, the first spreadsheet program for a PC.
In the third quarter of 1978, Bricklin and Franklin were joined by Daniel Fylstra whose marketing skills saw VisiCalc achieve success in the marketplace and gave incentive to many businesses to invest in what at the time, were expensive micro-computers. During its lifetime, VisiCalc sold about a million copies.
In 1980, IBM contracted Microsoft to write an operating system for its IBM PC. The result was MS-DOS (Microsoft Disk Operating System) that interfaced between a human and a computer (without having to use machine code) or enabled software like spreadsheets to run. The first IBM PC running MS-DOS was shipped in 1981 and a number of IBM clones, or compatibles, appeared on the market soon after.
VisiCalc was slow to respond to the introduction of the IBM PC with its Intel computer chips and a new, more powerful spreadsheet, Lotus 1-2-3, came onto the market in 1983. 1-2-3 related to the (1) spreadsheet, (2) integrated charting and (3) database capabilities of the program. As well as being powerful and relatively easy to use the calculating tool, Lotus was a data presentation package. Consequently, it became a very popular and very successful spreadsheet application in the business world. In 1985, the Lotus Development Corporation, founded by Mitchell Kapor and Jonathan Sachs acquired and discontinued the use of VisiCalc.
Microsoft released a spreadsheet program called MultiPlan in 1982 for the CP/M operating system and it was subsequently modified to run on Apple, XENIX, and MS-DOS operating systems. However, it never gained the popularity or market share of Lotus 1-2-3. In the meantime, Microsoft was working on a new disk operating system and in November 1985, released Windows Version 1.0. Instead of typing MS-DOS commands, a mouse could be used to point and click on drop-down menus, icons and scroll bars and the now familiar "windows" and dialogue boxes made their first appearance.
The first version of Excel was also released in 1985, but it was for the Apple Mac running Mac OS, not for MS-DOS or the new Windows operating system -- a smart move by Microsoft, because it did not put Excel into direct competition with Lotus 1-2-3 and gave it an advantage. Excel 1.0 running on the Mackintosh with a GUI (Graphical User Interface) had point and click capability, unlike the keyboard drove Lotus 1-2-3 and MultiPlan, and many businesses purchased Macs to take advantage of the easy to use graphics based Excel.
Windows 2.0 was released in December 1987 and at about the same time the first Windows-based version of Excel (v2.0) for PC's was released. It was another three years before Lotus and a spate of other vendors released spreadsheet programs for the Windows operating system and Excel, as Microsoft's flagship program during that period gained popularity. During 1988 Microsoft became the world's leading PC software company based on sales and PC's were beginning to take a serious step towards achieving the Allen/Gates "computer on every desk" vision. Spreadsheets were largely responsible for the rapidly increasing use of desktop computers as a business tool.
Windows 3.0 (1990) and Windows 3.1 (1992) sold 10 million copies in their first two years and Excel 3.0 (for Windows), also released in 1990 proved popular. Although Lotus 1-2-3 maintained a reasonable market share, it had missed the boat by not launching a Windows version and was comprehensively overhauled by Excel 4.0 (1992) which was the first version of Excel to be bundled with Word and PowerPoint under the banner of "Microsoft Office".
Excel 5.0 (1993) was a major upgrade and included multiple worksheets and support for VBA (Visual Basic for Applications, i.e. macros).
1995 saw some significant improvements with the highly publicized release of the 32 bit Windows 95 operating system which sold seven million copies in the first five weeks. Windows 95 was an upgrade to MS-DOS and earlier versions of Windows that between them were running on about 80% of the world's PCs. It featured the first appearance of the Start menu, taskbar and minimize, maximize and close buttons on each window, had built-in Internet support, dial-up networking and plug-and-play capability that made it easy to install new hardware and software. 1995 was also the year the Internet really took off with the widespread use of electronic mail (e-mail) and the World Wide Web (information on any subject available at the fingertips of anyone with a connected PC).
Excel, along with other Office 95 programs, was released in a 32-bit version and re-branded as Excel for Windows 95 or simply Excel 95 (this was actually version 7. There was no version 6).
Excel 8.0, known as Excel 97, included a new VBA interface and introduced some new features like user forms and data validation. Versions 9.0 to 11, known as Excel 2000, Excel 2002 and Excel 2003 introduced relatively minor improvements and during this period Windows also went through various evolutionary upgrades with Windows 98, Windows 2000, Windows Me (for home computers) and the new look Windows XP (2001). The 64 bit XP version was the first Microsoft 64 bit operating system and offered considerable operating improvements over previous versions.
Windows Vista, released in 2006 and Excel 2007 (version 12) both introduced major changes in both appearance and functionality.
The drop-down text menus from earlier versions of Excel were replaced by icon-studded ribbons in Excel 2007, the number of columns increased from 256 to 16,384, the number of rows increased from 65,536 to 1,048,576 (there were only 16,384 rows up to and including Excel 95). Considerable enhancements were made to features like sorting, filtering and conditional formatting and files were saved in a new file format, the Open Office XML format. Enter "new file formats" into the search field of the Excel 2007 Help window for details about the new file format.
In spite of all the changes to Excel 2007, it maintained backward compatibility to previous versions of Excel, i.e. Excel 2007 can be used to open, edit and save.xls files created in earlier versions of Excel.


Read more ...

OFFICE AUTOMATION COURSE details

Monday, 2 May 2011
office automation
course

OFFICE AUTOMATION COURSE helps you in office documentation such as write applications, letters, make office sheets and much more.
Make presentations and backup you retain work save into your computer.
Duration 2 month
Classes 1 hour daily,5 Days in a Week
Timings are available morning afternoon evening
For further details
CONTACT:
Email onlincompteacher@gmail.com
Phone +92-312-2906096



Read more ...

Basics of Web Designing

Monday, 2 May 2011

Web Designing
course tutorials
Web style is made up of some primary residence, and if you comprehend them you can style web pages that will make an impression on and light up your visitors.
Basic Tips of Web Designing
The following guidelines can help you to make great web styles that work with your visitors.
Use little pictures like 10-15 kb per picture, yes it relies on the resource, but slowly web pages are really frustrating and large pictures are the main cause of slow web pages. It's easy to improve your pictures.
Always use the design that fit the material. Just because you have a lovely picture of your dog does not mean you should have it on your web page about web style.
Stick with conventional templates. The 3-column structure is so well-known on sites and magazines because it performs. You might think it's tedious, but you will keep more visitors if you keep with something easy that they can comprehend.
A white area should be more than the CSS property; it is a operate of your structure. You should be conscious of the white-colored area on your web pages and how it impacts the material considered. The White area is essential in a web structure as it is a document structure.
Fonts
Serif for news and sans-serif for written text. Sans-serif make styles are much simpler to study on PC watches because the display quality is not as high as it makes. If you use serif make styles for regular written text, the serif can cloud together on display making it difficult to read
Limit the variety of different make styles. 2 or probably 3 conventional typeface family members are simpler to study and look more expert.

Use conventional typeface family members, for example, You can select "Rockwood LT standard" as this typeface on your web page, but the possibilities that one of your visitors will have that typeface as well is fairly low. Keeping typeface like Verdana, Geneva, Arial, and Helvetica may seem tedious, but your web pages will look better and the styles will look appropriate on more internet explorer.

Remember Your Readers
Test your web pages in several internet explorer.

Write the material as they want. Unless you are composing a website simply for yourself, make sure that your material should include subjects that your visitors want to study.
Read more ...

Why Computer Accounting Software is Important to You

Monday, 2 May 2011

Computer Accounting Software
 is Important
The universe of popular financial management has been completely customized by the addition PC bookkeeping system. The greatest benefits PC bookkeeping system is that these programs bring about a much higher degree of perfection and speed than was ever seen before. Combine this with the new ability to watch where an organization appears and their production, all instantly, and PC bookkeeping system is remarkable.
Even the most old-school bookkeeping companies have been very easily affected towards these new methods once they've interacted with PC bookkeeping programs, never returning to the pen and papers methods that they'd been using all of their lives.
Usually, a PC bookkeeping system program has a few basic things:
- An income publication which instantly updates customer accounts
- Sales details which can be produced and printed from an on-screen display
- Computerized generation of payroll
- Easy, complete development of your current databases and the bookkeeping software
- Computerized improving your general ledger
- Capture of bank receipts
- Computerized improving the buy publication to indicate suppliers accounts
A majority PC bookkeeping programs will also be permitted to send faxes and mail appropriate details (such as details and receipts), all natively within the system. These programs also allow you to instantly have availability change management opinions, changing details like:
- Research of payroll
- Budget research and difference analysis
- Reviews of stock valuation
- Records for loss and trading, and balance sheets
- A show of late amounts on the details of your clients
Modern PC bookkeeping system will also be easy to use and ergonomic office, and include features like an obvious and obvious and easy to understand reviews show. These PC bookkeeping system methods also have the benefits of helping you to enter your transactions only once into the system, in contrast to several details in several locations - which pen and papers methods often require.
The following is a list of how PC bookkeeping system can benefit you.
- Computerized development of documents: This contains income, buy buys, publishing claims, credit realizes and details.
- Information in actual time: You can see customer details and bookkeeping details as they change and are customized.
- Quick restoration of information: The bookkeeping system will have immediate availability all of the details that you need, and can share this details with users in several locations.
- Efficient management of information: It should be easy to generate opinions with bookkeeping system, so you can effectively manage and notice your organization.
Ultimately, you should change to a PC accountings system as soon as possible if you find your organization still working with a pen and papers bookkeeping system.
Read more ...

Manual Vs Computerized Accounting

Monday, 2 May 2011

Computerized Accounting
economic
If you own your small business, most likely you've considered more than once whether an automated accounting program would be better for your company than a guide one. Well, in all honesty, there are advantages and drawbacks for both the guide and the automated accounting techniques. And because tracking all economic dealings of a company is essential, the accounting program should be reliable and efficient.
Manual accounting techniques employ several document ledgers in order to record and keep a record of all economic dealings. For each part of the accounting program an individual journal is necessary, so generally businesses using guide techniques have one journal for records due, one for a / r and one for sales. From these individual ledgers, accounting firms negotiate all details into one common journal, providing the end balance for each individual journal. Maintaining guide accounting is far a longer period intensive than using an automated program, however, guide accounting does have its own advantages. You can quickly evaluation all ledgers, make simple changes at any time, the details is requested consistently and you can later make notices, clarifications or improvements on any customer account. Still, you can do this with an automated program as well, and it may be simpler.
Computerized accounting is based on an accounting application. Accountants must enter economical data into the accounting program, and the application will use statistical methods to determine and estimate the details into ledgers and fiscal reports. You will have simpler accessibility all economic details, and everything will be more organized. You can accessibility dealings from any company department, make popular research or report differences.
Computerized accounting techniques offer more advantages than guide ones, allowing for more precise computations, in the shorter period. Compared to guide accounting, with an automated program mistakes are far less common, removing the human mistake. And with accounting programs that are industry-specific, you can benefit from various predetermined layouts for your common journal, saving a longer period. You can store virtually limitless details, without any trouble at all. And if you later want to evaluation economical details from several years ago, with an automated accounting program you can do it quickly, while with a guide one you would have to sort through loads of document ledgers.
Bottom line, both techniques may be useful to some extent. But for more precise accounting and increased performance, an automated accounting program seems to have more advantages. You can find several free editions on the internet, as well as more efficient accounting application available for purchase. Search on the internet for such accounting techniques, read about their features and decide which one would be better for your particular company needs. Although they will not allow you to physically handle the ledgers, it will offer a better accounting solution.
Read more ...

Comparison of Microsoft Office 2003 with Microsoft Office 2007

Monday, 2 May 2011

Microsoft Office 2003 and Microsoft Office 2007
 Microsoft Office 
Many individuals have Microsoft company Workplace 2003 and are interested in improving to Microsoft company Workplace 2007. However, there are plenty of variations between the two although they are the same program with different edition years. As a result, anyone with Microsoft company Workplace 2003 should keep on reading to understand about some of the variations of Microsoft company Workplace 2007.
One of the changes is the electronic trademark. For example, if you are in Microsoft company Workplace 2007 coaching you will understand that with this edition the electronic trademark is arranged with XMLD Sig, which is different than what you discovered in Microsoft company Workplace 2003 coaching. Also, the Microsoft company 'office' coaching programs will educate you that in Workplace 2007 you will discover the electronic trademark under Computer file, Complete Papers, Signatures rather than in Resources, Choices, Protection, and Digital Signatures. The electronic signatures were modified to be more user-friendly and more readily found.
Another modify that you will understand about in all of your Microsoft company 'office' coaching programs is that the add-in tool for Workplace 2003 was eliminated. It was modified by a document examiner that can run many times at once which makes it easier to clean up records.
In Microsoft company Workplace 2007, there is now some versioning provided. Before in Microsoft company Workplace 2003 you could only allow or turn off versioning, but now versioning figures are included and figures such as 3.3 may be used as well as whole figures like 3.
Another modify that prevails in Microsoft company Workplace 2007 that is different from Microsoft company Workplace 2003 is that Microsoft windows Privileges Control Customer v. 1.0 is no longer reinforced. A new client edition of Microsoft windows Privileges Control Customer SP1 is used in Microsoft company Workplace 2007 and the new edition is easy to set up and no modify is seen when the new edition is set up.
Yet another modify that happened is the Deliver for Evaluation feature that could be found in Microsoft company Workplace 2003 under Computer file, Deliver to, Mail Receiver (for review). These access points do not are available in Microsoft company Workplace 2007.
There are of course many other changes that happen in Microsoft company Workplace 2007 that Microsoft company Workplace 2003 customers must understand and get acquainted with. However, there are not so many that customers who update will have too difficult of a time transforming.
Caitlin a Bigger is an independent author. One of the changes is the electronic trademark. For example, if you are in Microsoft company Workplace 2007 coaching you will understand that with this edition the electronic trademark is arranged with XMLD Sig, which is different than what you discovered in Microsoft company Workplace 2003 coaching. Also, the Microsoft company 'office' coaching programs will educate you that in Workplace 2007 you will discover the electronic trademark under Computer file, Complete Papers, and Signatures rather than in Resources, Choices, Protection and Digital Signatures.

Read more ...

Excel Shortcuts keys

Sunday, 1 May 2011

NOTE: These key assignments are for standard US-English keyboards.

FUNCTION KEYS SHORTCUTS:


F1        Help      What's This Help                       Insert Chart Sheet         
F2        Edit Mode         Edit Comment              Save As           
F3        Paste Name Formula     Paste Function  Define Name                 Names From Labels
F4        Repeat Action    Find Again         Close Window   Quit Excel         Find Previous
F5        Goto     Find      Restore Window Size                 
F6        Next Pane         Prev Pane         Next Window     Previous Window           Prev Workbook
F7        Spell Check                  Move Window                
F8        Extend Selection           Add To Selection           Resize Window  Macro List        
F9        Calculate All      Calculate Worksheet      Minimize Workbook                   
F10       Activate Menu    Context Menu    Maximize Window                      
F11       New Chart         New Worksheet New Macro Sheet          VB Editor         
F12       Save As            Save     Open               Print

KEYS SHORTCUTS WITH CONTROL:


A                                 Select All                      Formula Arguments
B                                 Bold                  
C                                 Copy                 
D                                 Fill down           Data Menu       
E                                 Edit Menu        
F                                 Find                  File Menu          Font Name
G                                 Go to                
H                                 Replace            Help Menu        
I                                  Italics                Insert Menu      
J                                                           
K                                 Insert Hyperlink              
L                                                          
M                                                         
N                                 New Workbook              
O                                 Open Workbook Format Menu     Select Comments
P                                 Print                Font Size
Q                                                          
R                                 Fill Right                       
S                                 Save                 
T                                 Tools Menu      
U                                 Underline                       
V                                 Paste                
W                                Close Workbook            Window Menu   
X                                 Cut                   
Y                                 Repeat Active                
Z                                 Undo                 

NUMERIC KEYS SHORTCUTS:


` (~)                             Toggle Formula View                 General Format
1 (!)                              Cell Format                              Number Format
2 (@)                           Toggle Bold                              Time Format
3 (#)                             Toggle Italics                            Date Format
4 ($)                             Toggle Underline                       Currency Format
5 (%)                           Toggle Strikethru                       Percent Format
6 (^)                             Toggle Object Display               Exponent Format
7 (&)                            Show/Hide Standard Toolbar       Apply Border
8 (*)                             Outline                                     Select Region
9 (()                             Hide Rows                                Unhide Rows
0 ())                             Hide Columns                           Unhide Columns
-                                  Delete Selection                        Control Menu     No Border
= (+)                             Formula                                   Calculate All      Auto Sum, Insert Cells
[                                  Direct Precedents                     All Precedents
]                                  Direct Dependents                    All Dependents
; (semicolon)                 Insert Date                               Select Visible Cells        Insert Time
' (apostrophe)                 Copy Formula From Above         Style     Copy Value Above
: (colon)                        Insert Time                   
/                                  Select Array                             Select Array
\                                  Select Differences                     Select Unequal Cells

KEYS SHORTCUTS:

Insert               Insert Mode       Copy                 
Delete              Clear                Delete To End Of Line                
Home               Begin Row         Start Of Worksheet                    
End                 End Row           End Of Worksheet                     
Page up            Page up            Previous Worksheet       Left 1 screen    
Page Down        Page Down                   Next Worksheet Right 1 screen  
Left Arrow          Move Left          Select Left         Move Left Area               
Right Arrow       Move Right        Select Right      Move Right Area                        
Up Arrow           Move Up            Select Up          Move Up Area                
Down Arrow       Move Down        Select down      Move down Area            Drop down list   
Space Bar         Space  
Tab                   Move Right        Move Left          Next Window     Next Application
Enter               Move Up            Fill Selection With Active Cell     Insert Row        
Backspace        Collapse Selection To
Active Cell         Go to Active Cell                        
Read more ...

What is Onlinecompteacher?

Sunday, 1 May 2011

Established in 2011, Onlinecompteacher is an accredited online Computer Tutor built on a simple philosophy:
  • The Classes are based online & course fee will be pay in advance.
  •  After the successful completion of Courses his/her received certificate at home.
  • To take admission you mail us your bio data and course contents
Read more ...

Services

Sunday, 1 May 2011


Computer course learning at Home

The number of computers and I.T Education is increasing every day, making it difficult for students and their families to sort through the options and choose the best computer course learning on their location. Onlinecompteacher is the perfect choice for learn computer courses online.

Computer information & Education online

 As you may have already noticed, finding helpful information on the Internet about computer courses. This Blog has been created so that visitors can get free computer information & Education online around the world with internet access.

Learn computer courses online anywhere in the world.

Using the information located on this Blog, students and anyone can learn computer courses online anywhere in the world with internet access

Read more ...

Computer Courses Free Classes in Urdu

Sunday, 1 May 2011

I make this blog for online information and education of Computers & Computer courses

  • I am teaching Computer courses since 2003 in different institute Affiliated with S.B.T.E, S.D.C & P.C.I in Karachi Pakistan
  • Now you can learn Computer courses online in urdu with onlinecompteacher
  • I am teaching online with the help of my videos tutorials and other staff like animation presentations,images,PDF files & my e-book
  • So conform your admission in my online Computer course free classes in Urdu
Read more ...