Category Archives: Excel Tips

Microsoft Excel NEW Informations

Posted on by
Reply

Scovetta Labs » Blog Archive » Microsoft Excel – “Windows Cannnot …
Under 2007, sometimes you’ll click on a file within Windows Explorer, and when Excel opens, you’ll receive an error message “Windows cannot find <file>. Make sure you typed the name correctly, and then try again. …

Apple iPod touch 8 GB (1st Generation) | The Electronics Central
Open PDF, Microsoft Word, and Microsoft Excel attachments. With Maps, find your location and get directions from there. See where you are on a map, a satellite image, or a combination of both. Make Web Clips for your Home screen so you …

Manage My Kennel Pro by SoftwareScripts – Free Vista Files
XLReportGen is a report generator for Microsoft Excel that outputs reports in Microsoft Excel spreadsheet format. If you know how to use Microsoft Excel and write SQL statements, you can use XLReportGen to create all kinds of reports as …

Chronicles of Christoph J.: My Resume as of January 02, 2009
By Christoph Jenkins
Uses office automation systems and various Microsoft software packages to include (Word, Excel, Access, PowerPoint, Publisher and Outlook), to accomplish, implement and maintain major executive level reports, presentations and …

FreeAgent: Accounting for freelancers | Web Applications Blog
Data import and export: 1. Export: in Microsoft Excel 2. Import: not provided for accounts and expenses. One has to rely on just setting starting balances. Contacts can be imported from. 1. Microsoft Outlook 2. GoogleMail / Gmail …

Business Canada » Microsoft Excel 2007 Number Formats
Microsoft Excel 2007 Number Formats. by Lynne Kramer. Often, when you enter numbers into a spreadsheet, you need to ensure that the number format is consistent. For example, if these numbers are prices, you may want to display the …

Financial Accounting Books: Understanding Business Strategy or …
By Review TextBoks
By utilizing Microsoft Excel to perform statistical analyses, this text will the business professional to have a better understanding of how to use statistics to make better business decisions. …

cheap and best shop » WordPerfect Office X3 Standard [OLD VERSION]
Improved compatibility with Microsoft Excel ensures that you can smoothly exchange information with Excel users. Quattro Pro X3 also includes outstanding for creating tables, financial forms, lists, databases, charts, reports, …

Downloads OLMixedFolders 1.33 – Synchronize Outlook folders with …
ConnectCode Deluxe Add-In for Microsoft Excel is a collection of commonly used add ins for improving the productivity of an Excel user. The collection is derived from the accumulation of many years of experience from Excel experts and …

Ecxel export to csv double quotes · PcTechBlog
January 3, 2009 in Excel | No comments. Microsoft Excel has limited or no options regarding the export to csv feature. For example, you can not select that exported values will be included inside double quotes. …

latest Tech and SEO Information | Dexter Panganiban’s Site

Another Excel Control Hot Keys Part 2 of 3

Posted on by
Reply

Below are additional Function keys which I consider an another Hot Keys. If you love my first part definitely this part will be of interest to you also.

Key Description

F1 Displays the task pane.
CTRL+F1 closes and reopens the current task pane.
ALT+F1 creates a chart of the data in the current range.
ALT+SHIFT+F1 inserts a new worksheet.
F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
SHIFT+F2 edits a cell comment.
F3 Pastes a defined name into a formula.

SHIFT+F3

displays the Insert Function dialog box.

F4 Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window.
F5 Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6 Switches to the next pane in a worksheet that has been split (Window menu, Split command).
SHIFT+F6 switches to the previous pane in a worksheet that has been split.
CTRL+F6 switches to the next workbook window when more Excel Control Keys Part 1 of 3than one workbook window is open.
Note   When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ESC.
F8 Turns extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.
SHIFT+F8 enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
ALT+F8 displays the Macro dialog box to run, edit, or delete a macro.
F9 Calculates all worksheets in all open workbooks.
F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.
SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
F10 Selects the menu bar or closes an open menu and submenu at the same time.
SHIFT+F10 displays the shortcut menu for a selected item.
ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message
CTRL+F10 maximizes or restores the selected workbook window.
F11 Creates a chart of the data in the current range.
SHIFT+F11 . inserts a new worksheet
ALT+F11 opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
ALT+SHIFT+F11 opens the Script Editor, where you can add text, edit HTML tags, and modify any script code.

F12

Displays the Save As dialog box.

Hope You like it.. Check for the Part 1 and Part 3.

latest Tech and SEO Information | Dexter Panganiban’s Site

Another Excel Control Hot Keys Part 1 of 3

Posted on by
3

The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality. For more extensive reference information on all available shortcuts and their specific uses

Note  If an action you use often does not have a shortcut key, you can record a macro to create one.

Key Description

CTRL+( Unhides any hidden rows within the selection.
CTRL+) Unhides any hidden columns within the selection
CTRL+& Applies the outline border to the selected cells.
CTRL+_ Removes the outline border from the selected cells.
CTRL+~ Applies the General number format.
CTRL+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+% Applies the Percentage format with no decimal places
CTRL+^ Applies the Exponential number format with two decimal places.
CTRL+# Applies the Date format with the day, month, and year.
CTRL+@ Applies the Time format with the hour and minute, and AM or PM.
CTRL+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+- Displays the Delete dialog box to delete the selected cells.
CTRL+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
CTRL+: Enters the current time.
CTRL+; Enters the current date.
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+’ Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+” Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++ Displays the Insert dialog box to insert blank cells.

 

Hope you like this.. There are lots to come.. Wait for Part 2 and Part 3.

 

latest Tech and SEO Information | Dexter Panganiban’s Site

CTRL combination shortcut keys for Microsoft Excel

Posted on by
Reply

If you like my previous post about the Microsoft Excel Hot key, I think you will also like this one.

The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality.

Key Description

CTRL+( Unhides any hidden rows within the selection
CTRL+) Unhides any hidden columns within the selection
CTRL+& Applies the outline border to the selected cells.
CTRL+_ Removes the outline border from the selected cells.
CTRL+~ Applies the General number format.
CTRL+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+% Applies the Percentage format with no decimal places.
CTRL+^ Applies the Exponential number format with two decimal places.
CTRL+# Applies the Date format with the day, month, and year.
CTRL+@ Applies the Time format with the hour and minute, and AM or PM.
CTRL+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative Values
CTRL+- Displays the Delete dialog box to delete the selected cells.
CTRL+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).  In a PivotTable, it selects the entire PivotTable report.
CTRL+: Enters the current time
CTRL+; Enters the current date
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+’ Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+” Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++ Displays the Insert dialog box to insert blank cells.

I have been using in almost 6 Years. And really helps me a lot on various calculation. Hope it will you also.

latest Tech and SEO Information | Dexter Panganiban’s Site

Commonly Used Alt Keys in Microsoft Excel

Posted on by
1

google_ad_section_start–>

Below are some useful Alt Keys that could be used in that you usually don’t know how to do.

Instruction : You have to press Alt key while pressing the numbers.

Alt Keys Results Remarks
     
Alt+0177 ± Mathematical Sign 
Alt+0178 ² Squared
Alt+0179 ³ Cubic
Alt+0216 Ø Diameter
Alt+0186 º Degrees
Alt+0187 » Arrow
Alt+0188 ¼ One Fourth 
Alt+0189 ½ Obe Half
Alt+0190 ¾ Three Fourth
 
Above Alt keys is very helpful if you are working with forms in . There is another way of locating this symbols by going to Character Map.
Start » Programs » Accessories » System Tool » Character Map
In Character map it will you with hundreds of symbol you want put in your work. If you like this post you may want to visit the archives regarding .
 

latest Tech and SEO Information | Dexter Panganiban’s Site

Microsoft Excel and Microsoft Word Hot Keys

Posted on by
Reply

google_ad_section_start–>

Below is the Table that I would like to share regarding the hot keys or Control keys used in Microsoft Excel and .

Ctrl Keys

 

 

 

A

Select All

Select All

B

Bold

Bold

C

Copy

Copy

D

Same as above

Font

E

 -

Center

F

Find

Find and Replace

G

Go To

Go To

H

 -

Replace

I

Italized

Italized

J

 -

Left Aligned

K

Insert Hyperlink

Insert Hyperlink

L

 -

Home @ Left

M

 -

Tab

N

New Sheet

New Sheet

O

Open File

Open File

P

Print

Print

Q

 -

- 

S

Save

Save

T

 -

Tab Show

U

Underlined

Underlined

V

Paste

Paste

W

Close

Close

X

Cut

Cut

Y

- 

- 

Z

Undo

Undo

 

 

 

1

Format Cells

- 

2

Bold

-

3

Italized

-

4

Underlined

- 

5

Cross Out

- 

6

- 

- 

7

Close the Icons

-

8

 

- 

9

Row Hide

-

0

Column Hide

- 
     

 

How will I use this Table?

The first column shows the Ctrl Key, it means you have to Press Ctrl+( letter/numbers ) and the right Column will show the results when you press those control keys. The second column is for Microsoft Excel and the Third column is for Microsoft Word.

If you like this post perhaps you will also like my other post regarding Excel Tips.

Thanks to I am able to put my very first table in my blog post.

latest Tech and SEO Information | Dexter Panganiban’s Site

Excel Trick : What is the use of $ sign?

Posted on by
3

Did you know “$” sign is an important part of formula? I would try to teach how you could use this sign.

Problem : How can I fix the pick up point in one Excel Cell reference only? ( For this example it is Cell reference A1 )

See it here

Related Topics :

Excel Tricks : Hide Those %&@# Formula Errors

How to join Excel data in Cell

Site Search Tags: , ,

latest Tech and SEO Information | Dexter Panganiban’s Site

Excel Tricks : Hide Those %&@# Formula Errors

Posted on by
Reply

google_ad_section_start–>

 Below is another Tricks

Problem : You are making a calculation on Your Excel Sheet and suddenly when you remove your Fixed Values, Your calculated answers returns the value ( #VALUE or #DIV/0 ). This is because a certain number ort any number has been divided by Zero.

Solution : You have to use the function ISERROR

ISERROR Returns TRUE if the value is any error value

Syntax : =IF(ISERROR(Original Formula),”",(Original Formula))

Sample : =if(iserror(B4*C4),”",(B4*C4))

Conclusion : This means that if B4*C4 will result to an invalid mathematical Calculation the answer will be null ( or blank )

Hope this Tricks Helps You. If you have some question in excel email me at Techathand [at] gmail [dot] com

Technorati tags:

latest Tech and SEO Information | Dexter Panganiban’s Site