Category Archives: Basics

Basics

How to Set Keyboard Language in Windows 7

Windows 7 provides its users flexibility to customize their computer according to their needs and requirements. Keyboard layout and the language change option is one of its ‘Advanced’ features. With the help of Region and Language Settings, you can change the language of your keyboard as per your preferences. For instance, changing the keyboard language doesn’t require any high expertise or additional features.
Follow this step by step guide to learn how to set keyboard languages in Windows 7.


read more »

Basics

How to Reinstall Windows 7

In this tutorial, we will show you how to reinstall windows 7.There can be very few scenarios in which we can be dealing reinstalling windows. If you have installed windows 7 on your computer and it is creating some problems, you can carry out windows 7 reinstallation very easily.


read more »

Basics

How to Change Default Fonts in Windows 7

Windows applications can easily blend in and customize according to your requirement. In windows 7, you can easily set defaut fonts, change apperance and display, adjust various settings and alter other stuff in order to customize according to your style.
Follow this step by step guide to learn how to change default fonts in windows 7 in a very easy way.


read more »

Basics

How to Install Windows 7 From USB

Windows 7 is an operating system offered by Microsoft. It has a dynamic and user friendly interface. In this tutorial we will show you how to install windows 7 from usb.
USB drives tend to be higher in storage capacity than disc media Not only is it faster to copy data such as setup files from a USB drive but during usage the access times are also significantly faster.


read more »

Basics PC

How to Add Numbers in Excel

Excel allows you to do various kinds of calculations. There are various formulas and functions that you can use for calculations. In order to add the number you can use the “SUM” function. In this tutorial we will not use the add formula in Excel, instead we will add the numbers manually and excel will recognize the pattern and do the calculations for rest of the cells itself.


read more »

Basics PC

How to Change and Add an Excel Worksheet

Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. You can change your Excel Worksheet and add in Excel sheets. To learn how to change and add in an Excel Worksheet, follow this step by step tutorial.


read more »

Basics PC

How to maintain Excel Compatibility

Microsoft Excel is a commercial spreadsheet application through which we can calculate, use graphing tools, add pivot tables and do a lot more. Over time, new versions of Microsoft Excel have come which have added some new features in the newer versions and these features are sometimes not supported by the older versions. If you want to open your new version file in another computer which does not have the newer version of Microsoft Excel then you will have to save it in the older format so that you can work around the Excel Compatibility Mode.
Follow this step by step tutorial to learn how to maintain Excel compatibility.


read more »

Basics

How to Delete every other Row in Excel

In this video tutorial we will show you how to delete every other row in excel.
Open the excel document you want to edit. In blank column besides original data, enter 1,0,1,0,1,0,1,0…1,0.


read more »

Basics

How to Delete Duplicates in Excel

In this video tutorial we will show you how to delete duplicates in excel.
Open the excel document you want to edit. Select the part of the text where you want to find duplicates. Go to “Data” tab, click on “Remove Duplicates” button.


read more »

Basics

How to Delete Blank rows in Excel

In this video tutorial we will show you how to delete blank rows in excel.
Open the excel document you want to edit. Select the part of the text where the blank rows are and you want to delete. Now click “Find & Select”, in popup menu choose “Go To Special…”.


read more »