This tutorial teaches you how to create an excel forms with Macros with step-by-step approaches. Step1 : Open MS Excel Application and then click on “Developer” Tab then click on “Visual Basic” option as shown in following screen shots. Step2: Click on “Insert” menu then select “UserForm” as shown in below image Step3: Drag and […]
Creating an Excel form with Macros Read More »
Pivot table is used to sort, count or give the average of the data stored in a spreadsheet, Pivot tables are also useful for converting rows to columns etc. Here are the steps to create a pivot table. Step 1: Start MS Excel Application Step 2: Enter some data as following screen shot. Step 3:
Pivot Table using Excel Read More »
1. COBOL program on Arithmetic Operation *PROGRAM TO PERFRM ARITHMATIC OPERATIONS USING COMPUTE VERB. IDENTIFICATION DIVISION. PROGRAM-ID. AOP. ENVIRONMENT DIVISION. DATA DIVISION. WORKING-STORAGE SECTION. 01 A PIC 9(4). 01 B PIC 9(4). 01 SUM PIC 9(4). 01 SUB PIC 9(4). 01 MUL PIC 9(4). 01 DIV PIC 9(4).99. PROCEDURE DIVISION. START-PARA. DISPLAY “ENTER THE VALUES
To speed up your windows XP/7/8/8.1/8.2 PC, Just follow the below steps to make your PC running faster and reliable. 1. Defragment your hard drive: After accessing and storing lots of files on your computer hard drive it is common that files or folders get scattered in memory. Click->Start->Accessories->System tools->Disk Defragmenter [follow below image] 2. Uninstall
To clear the entered data in the current sheet of MS-Excel application follow the below simple steps. 1. Click on ” Developer” tab in MS-Excel as shown in below image. 2. Click on “insert” and select “command Button”, follow image. 3. Drag the button on the sheet and right click on it, select properties->Caption->Enter text
Clear Excel Sheet using VBA Read More »
Data Validation with MS – Excel Data validation is an important for entering specific values in the column with size or length. Here are the steps. 1. Prepare the sheet as shown in following screen shot. 2. Select the cloumn “Employee code” then Go to “Data” menu tab in the excel. 3. Select Data validation.
Data validation in Excel Read More »
This example shows a simple marks calculation using MS-Excel. Here are the steps for calculating total, average, minimum and maximum marks. 1. First of all, create a sheet with following data in it. 2. Place cursor next to “Total Marks” column and type the formula [while writing a formula in excel it is mandatory to
Simple Marks Calculation using Excel Read More »
To search images using PHP from MySQL Database, follow the examples. First of all create a table in MySQL database with following fields. Now, insert some images by clicking on “insert” tab in MySQL. Now, create a HTML page as following tags. <html> <body> <h1> Image searching………</h1> <form name=f1 action=”image.php” method=”GET”> Enter image Id: <input
Searching Images using PHP Read More »
The following example shows that how to upload and download images / files [.jpeg/.png/.bmp/ .txt/.doc etc] to web server [localhost or remote server] 1. Create a HTML web page as following screen with code. <html> <head> <title>Image/File Uploading Form</title> </head> <body background=bg.jpg> <h2>File Upload:</h2> Select a file to upload: <form action=”file_uploader.php” method=”post” enctype=”multipart/form-data”> <input type=”file” name=”file”
Upload images to web server using php Read More »
1. Java program to find number of lines. import java.io.*; public class NOL { public static void main(String[] args) { try { System.out.println(“Getting line number of a paritcular file example!”); BufferedReader bf = new BufferedReader(new InputStreamReader(System.in)); System.out.println(“Please enter file name with extension:”); String str = bf.readLine(); File file = new File(str); if (file.exists()) { FileReader
In this tutorial you’ll able to create a css [cascading style sheet] blocks for your web site. Below are the some of examples you can refer . Creating beautiful hyperlink buttons with CSS blocks. Example 1. <html> <head> <style> #corner1{ border-radius: 15px 50px 30px 5px; background: skyblue; padding: 20px; width: 100px; height: 25px; } #corner2{
CSS blocks-and-menus Read More »
