3 Useful Excel Tips For Dummies – How-To

All of us who use computer at a point of time come across a situation to use Excel due to its efficient way of handling data. Listed are few excel tips for beginners who starts working with excel.

For Newbies :

What is Excel?

Excel is an electronic spreadsheet program used for storing, organizing and manipulating data.

Tip 1 : Wrap the Text

Wrapping a text feature helps to make the content visible in a cell without increasing the width of the cell.

Step 1: Select the text to be wrapped.

excel word wrap

Step 2:  Click Wrap text button (as shown in the image)

Continue reading

Top 10 useful Mozilla tools for developers

Web Developer

https://addons.mozilla.org/en-US/firefox/addon/web-developer

The Web Developer extension adds various web developer tools to the browser.

firebug

https://addons.mozilla.org/en-US/firefox/addon/firebug/

Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse.
You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page

DOM Inspector

https://addons.mozilla.org/en-US/thunderbird/addon/dom-inspector/

Inspect the DOM of HTML, XUL, and XML pages, including the mail…

SQLite Manager

https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager

Manage any SQLite database on your computer.

JavaScript Deobfuscator

https://addons.mozilla.org/en-US/firefox/addon/javascript-deobfuscator

This add-on will show you what JavaScript gets to run on a web page, even if it is obfuscated and generated on the fly.
Simply open JavaScript Deobfuscator from the Tools menu and watch the scripts being compiled/executed.

Continue reading

How to share files between Linux systems

Even for a newbie, the Giver application will be very helpful in sharing files between Linux systems. Giver has been hosted in Google code. Its easy to install and very easy to use. I will explain you how to install and use Giver. I am using the application in Ubuntu 10.04.

Installation

  1. Open the ‘Terminal
  2. Enter the following command. sudo apt-get install giver
  3. This will install the application under Applications -> Internet menu

Use Giver

  • Applications -> Internet -> Giver or enter ‘giver‘ in the terminal
  • Giver application showing the list of Recipients for you

This opens up the Giver and you will see Giver iconGiver Icon in the notification area in the notification area

  • The Giver window will show the list of computers in which Giver is running currently.
  • To send a file to a computer. click on that computer from the list, will popup a menu asking either to send a file or folder.
  • Choose necessary option to show the Open dialog box, [ I am choosing ‘Send a file’ ]Choose the file and click open.
  • The user in the selected computer will be prompted to either accept the file or decline.
  • After ‘Accept’ button is clicked, the file transfer gets started. once transfer is done both the users were notified.

Sender will be intimated with Successful transfer message

  • You can configure ‘Giver’ where to save the files received; by opening up its preferences. Default location is user ‘Desktop’
  • To open the ‘Preferences’, right click on the Giver icon in the notification area and select ‘Preferences’ Open Giver Preferences
  • The Preferences dialog box will open. You can change your giver name to be displayed for all your recipients, your profile picture and the location where all your received files/ folders are to be stored. After configuring click ‘Close’

How to Verify an Email address is valid Or Check if an Email address is available?

At times you would want to verify the sender is valid or not of the mail received.And also you may want to check an email address is available or already taken.VerifyEmailAddress helps us to do them.

Just go http://www.verifyemailaddress.org and type an email address you want to check.

It Verifies the email id and gives the result as valid or invalid email address.

Invalid Check Result

Valid Check Result

Lighttpd Web Server

lhttpd logoLIGHTTPD (pronounced by Lighty) is an opensource webserver for Security, Speed, compliance and flexibility. Its been optimized for high performance environments. With a small memory footprint, effective management of CPU load and advanced features like FastCGI, SCGI, Auth, Output compression and URL rewriting; lighttpd is the perfect solution for servers suffering from load problems.

lighttpd powers several popular Web 2.0 sites like YouTube, Wikipedia and Meebo. Its high speed io-infrastructure allows them to scale several times better with the same hardware than with alternative web-servers. Its event-driven architecture is optimized for a large number of parallel connections (keep-alive) which is important for high performance AJAX applications.

You can check the Lighty benchmark here.

You may be interested in some of the Lighty extension projects,

Lighty2Go – Portable Lighty webserver configured with MySQL and PHP stack.

yPortableWS – Portable Lighty Webserver with MySQL and PHP stack.

WLMP Project – Windows based Lighty with MySQL database server and PHP support.

Apache Open Source Projects – Part 2

This post is a continuation of the previous post ‘Apache Open Source Projects – Part 1 ‘. In this post we will look into other cool projects of ASF (Apache Software Foundation).

James

james-project-logoApache James is a Enterprise mailing Server which integrates emailing protocols such as SMTP, LMTP (from V3), POP3, IMAP (from V3) and Sieve filtering funtioality. Apache James is 100% pure Java application based on the Java 2 platform and the JavaMail 1.3 API. It works alone without the need for any other server or solution. James Server uses Mailets to process emails. There are Mailets APIs available so that user can write their own mail handling code, such as creating archives, filtering mails, update database.

 

mod_perl

mod perlIt embeds Perl interpreter into Apache HTTP server, so that dynamic content produced by Perl can be provided as response to the incoming requests. mod_perl can emulate a CGI (Common Gateway Interface). It provides complete access to the Apache API, allowing developers to write handlers for all phases of Apache Http server. Everything from virtual hosts to authentication settings can be configured via Perl.

 

Pivot

Apache PivotApache Pivot is an open-source platform for building RIA (Rich Internet Applications) in Java. It combines the enhanced productivity and usability features of a modern RIA toolkit with the robustness of the Java platform. It provides a comprehensive set of foundation classes that together comprise a framework. These classes form the building blocks upon which more complex and sophisticated applications can be built.

Continue reading

Apache Open Source Projects – Part 1

The Apache Software Foundation is not only famous for its Open source Web Server, it has more open source projects. In this post we will look into some of its cool projects.

HTTP Server

Its a widely used and most popular web server; supports differentoperating systems. Since it is an open source software, hosting your web site in this web server will cost you less. This web server supports several server side programing languages which includes PHP, Perl, Python, .Net and Ruby.

Ant

Apache AntAnt is a tool to build Java applications. Its is similar to the Make, theonly difference between these is Ant uses XML to describe the build process where Make uses make file. Ant supplies a number of built-in tasks allowing to compile, assemble, test and run Java applications.

 

 

Directory

Apache Directory Server LogoThis project provides Directory solutions which includes a LDAPv3 compatible Directory Server and a Directory Studio. The Directory Server supports Kerberos 5 and Change Password Protocol. The Directory Studio contains LDAP tools which can be used with any LDAP servers.

Continue reading