Excel Tips (Freeze Panes)

In this video i am going to teach you how to use freeze panes in excel worksheet. We can make our headings visible while working in very long data.

Excel Tips (Transpose Data Row to Column)

In this video i am going to teach you how to transpose data from row to column in excel worksheet. Most of people don't know this technique while they are working and do this work manually.

Word Tips (Screenshot Option)

In this video i am going to teach you screenshot option which is available in word 2010. You will be able to take any screenshot very quickly. You will not have to capture any screen by using third party software any more.

Word Tips (Find & Replace Options)

In this video i am going to teach you how to use find & replace option in word 2010. You will be able to find any text and replace it to your desire text. You can also find text by formatting and replace it too. 

Word Tips (watermark option)

In this video i am going to teach you how to keep document confidential. You will be able to quick insert a watermark in text format as well as picture format. 

Word Tips (best selection techniques with mouse)

In this video i am going to teach you how to do selection with mouse in word 2010. You will learn different selection techniques with mouse. You will be able to do any work very quickly & professionally in office environment.

Word Tips (Superscript & Subscript)

In this video i am going to teach you how to use superscript and subscript in word 2010. You will be able to write chemistry equations by using subscript and math equations by using superscript. You will learn shortcut keys of superscript & subscript as well.

1.       Superscript    Ctrl+Shift+=

2.       Subscript       Ctrl+=

Word Tips (Navigation Pane)

In this video i am going to teach you how to use navigation panes in word 2010. You will be able to jump any heading by using navigation panes. You will also be able to search any word by using navigation panes.

Word Tips (Bullets & Numbering)

In this video i am going to teach you how to use bullets & numbering in word 2010. You will be able to insert bullets & numbering quickly & professionally. You will learn different techniques of bullets & numbering.

Word Tips (AutoCorrect Option)

Windows Tips (Backup of Device Drivers)

In this video I am going to teach you how to keep backup of your device drivers in your system. You can use this backup after fresh window installation. You don’t need to install driver from CD’s and any other sources.

Windows Tips (Disk Cleanup)

Word Tips (Add Horizontal Lines)

In this video I am going to teach you how to add horizontal lines with shortcut in Microsoft word. You will be able to insert different types of lines in document. You can make your work easy and proficient with these tips.

Internet Tips (Add & Export Favorites List)

In this video I am going to teach you how to add any website in your favorite list. After that you can export these lists and import them to any computer which you want. It is very useful tips which help you to keep your favorites in your USB as well.

Word tips (Create a pdf)

In this video I am going to teach you how to create a PDF of your document. In PDF format nobody will be able to edit your file and PDF file would be a secure file. PDF format support all operating system and user will be able to open PDF file to any operating system.

Word tips (Protect Document)

In this video I am going to teach you how to protect your document in Microsoft word 2010. You will be able to protect your document in two different ways.

1. Encrypt with password  (It will ask you password to open)
2. Restrict editing (It will ask you password to modification)

Windows tips (print screen & alt print screen)

In this video I am going to teach you how to use print screen button in your keyboard. You will be able to capture any screen by using this key. If you press only print screen button it will take a screen shot of your all screen including window screen and if you press alt+print screen button it will take screen shot of only current active window. This is very useful technique to capture any screen without using third party software.

Word tips (Create a Business Card)

In this video I am going to teach you how to make business cards in Microsoft word 2010. You will be able to make any business card professionally in a minute. It is very useful tips for those who don’t have any idea to make business card.

Word tips (Create a Letterhead)

In this video I am going to teach you how to make letterhead of any company in Microsoft word 2010. You will be able to make any letterhead of company professionally in a minute. It is very useful tips for those who don’t have any idea to make a letterhead.

Excel tips (Create a Hyperlink)

In this video I am going to teach you how to create a hyperlink in Microsoft excel 2010. You will be able to make links between sheets. It is very useful technique to manage your work by hyperlinks. You can jump any sheet in a second by using hyperlinks.

Word tips (How to make a paragraph setting)

Windows Tips (alternative mouse & keyboard)

In this video I am going to teach you how to use mouse with keyboard and how to use keyboard with mouse. You will be able to use of alternative keyboard and mouse. These are very useful techniques if you facing any problem in your keyboard key and mouse button.

Windows Tips (Protect from autoplay virus)

In this video I am going to teach you how to protect your system from auto play virus. You will be able to protect your system from virus. Auto play virus comes from USB most of the time. You will need to disable auto play option in your computer for safety.

Excel Tips (Create a chart)

In this video I am going to teach you how to create a chart in Microsoft excel 2010. You will be able to create graphical chart professionally. Chart presentation is very useful tips to understanding data which are complicated. You can analyze data with percentage and different options of chart.

Excel Tips (Convert Text into Columns)

Word Tips (Columns Break and Drop Caps)

Word Tips (How can we select text vertically)

Windows Tips (How to increase your computer speed)

Excel Tips (Quickly Insert Formula)

Welcome to Virtual Office

Virtual Office is a place where you can learn office techniques which will help you in the office environment. In my Virtual Office Training Blog, You will get up to date information on Topics related to Computer Training, Microsoft Office Tips, etc. You will be able to work in office very efficiently.  You can also find office jobs and other useful information in this blog. You will get a custom course to your needs in the virtual office so you won’t waste time learning this course. Just like classroom based training virtual office will provide you virtual environment of office, you can put your hand up and ask a question by sending an email. If you have any questions please feel free to contact me. I will be happy to help you out.