Thursday, April 22, 2010

Insert New Sheet in MS Excell

0 comments
basic tricks in using MS Excel. this time will discuss about how to add new sheets to the excel document.

There are a few to add a new sheet, let's discuss whether any of these ways:

First
In the workbook / document our active first way that we use is via the Menu.

Click on the Insert menu, Sheet. (See the figure)


Figure 1 - Menu Insert


Figure 2 - New sheet added

Tuesday, April 13, 2010

Square root function Excel

0 comments
Getting a root of a number is the same as raising that number to the power of 1/root.

Example:
The square root of x is x^(1/2).
The square root of A1 is: =A1^(1/2).
You can also use the built-in worksheet function SQRT: =SQRT(A1)

The cube root of x is x^(1/3).

The cube root of A1 is: =A1^(1/3).

You can also use the built-in worksheet function POWER: =POWER(A1;1/3)

Sunday, April 11, 2010

Prevent Seemingly Unnecessary Prompts

0 comments

Prevent Seemingly Unnecessary Prompts



The types of prompts we are talking about are those that ask you whether you
want to enable macros (when you do not have any), or whether you are sure you
want to delete a worksheet. Here is how to get rid of the most common prompts
once and for all.


Enabling Macros When You Don’t Have Any


Excel’s memory is like a steel trap when it comes to remembering that you recorded a macro in your workbook. Unfortunately, its memory of macros persists even though you might have since deleted one or more macros via Tools -> Macro -> Macros (Alt/Option-F8). Reopen the workbook and you’ll still be prompted to enable macros, even though there are none to enable.



You’ll be prompted to enable macros only if your security level is set to Medium. If it’s set to Low, macros are enabled without a peep; if it’s set to High, macros are disabled automatically for your protection.


Open the VBE by selecting Tools -> Macro -> Visual Basic Editor (or by pressing Alt/Option-F11) and select View -> Project Explorer. (On the Macintosh, the Projects window is always open, so you don’t need to open the Project Explorer.)

Thursday, April 8, 2010

Excel Help and Tutorial

0 comments

Excel Help and Tutorial


excel excellent exceptional fortunate good spectacular microsoft excel excelsior college excelsior excel energy excel tutorial excellent excel formula free microsoft excel download free excel download cana excellence punta secret excellence secret excel template excel energy center excellence excel training microsoft excel download excel spreadsheet microsoft excel tutorial download excel


free microsoft excel excel macro excel help excelsior hotel excel viewer excel saga secret excellence riviera cancun ms excel cancun excellence riviera secret free excel excel vba excel rim free excel template excel center free excel tutorial how to use excel learn excel excel sports excel program excellence standard excelon airway excel excel airway microsoft excel help microsoft excel excel tip adventure bill excellent teds bill and teds excellent adventure excel 2002 training excel xp training excel 2003 gano excel free excel spreadsheet free download ms excel excel 2003 training excel function microsoft excel template kenwood excelon excel home center excellence excellence maya riviera secret secret excellence riviera maya dummy excel excel for dummy excel software excel communication excelsior henderson excel pivot table excel password box cell dialog excel format window excel pdf to excel excel visual basic excellus blue cross blue shield excel recovery word excel microsoft excel training

References

Other Tutorial
  Windows Wisper
  Excel Tutorial
  BlackBerry
  asal-usul
 

Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com