Entries by Admin

Creating Icon

One of the most fascinating fields in visual design is icon design. Nowadays we’re invaded and bombarded by icons everywhere: on products, printed materials, packaging, the web and overall in software. Designing icon sets presents some challenges, of course, but it’s also a very interesting exercise that allows you to learn new things and develop […]

Lensa Flare Effect

1. Grab the logo and put it on a black canvas. 2. Make a rectangle and set its fill to radial gradient with blue (#0066CC) on both ends. Set its outer edge to 0% opacity. Put it underneath the logo and you will get a blue glow.   3. Now draw a white shape with […]

Design website with Fireworks CS5

This tutorial is on how you can design a full website using Fireworks CS5. If you care for this skill, kindly watch the tutorial step by step. Should you have any comment, please drop your comment below.

Formulas and Functions

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. For example, cell A3 below contains the SUM function which calculates the […]

Protect Excell Work

Encrypt an Excel file with a password so that it requires a password to open it. 1. Open a workbook. 2. On the green File tab, click Save As. | 3. Click on the Tools button and click General Options. 4. In the Password to open box, enter a password and click OK. 5. Reenter […]

How to Share Excel Work

Learn how to share Excel data with Word documents and other files. Paste Most of the time, you’ll simply need to paste static Excel data in a Word document. 1. Select the Excel data. 2. Right click, and then click Copy (or press CTRL + c). 3. Open a Word document. 4. On the Home […]

Print in Excel

This chapter teaches you how to print a worksheet and how to change some important print settings in Excel. Print a Worksheet To print a worksheet in Excel 2010, execute the following steps. 1. On the File tab, click Print. 2. To preview the other pages that will be printed, click ‘Next Page’ or ‘Previous […]

Keyboard Shortcuts in Excel

Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed. Basic Select cell B2. 1. To select the entire range, press CTRL + a (if you press CTRL + a one more time Excel selects the entire sheet). 2. To copy the range, press CTRL + c […]

Templates in Excel

Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used. Existing Templates To create a workbook based on an existing template, execute the following steps. 1. On the green File tab, click New. 2. To choose a template […]

Find & Select in Excel

You can use Excel’s Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel’s Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. Find To quickly find specific text, execute the following steps. 1. On the Home […]