Anything Tech

Scovetta Labs » Blog Archive » Microsoft Excel – “Windows Cannnot …
Under Microsoft Excel 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 help 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 tools 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. …

After I have blog that Lenovo will launch 10.2-inch IdeaPad S10 and 8.9-inch IdeaPad S9, There is a new Thinkpad that has been launch .

It is what they called ThinkPad W700

ThinkPad W700 specifications

Read the rest of this entry »

I would like to thank selaplana.com for reviewing my site in response to my review on his site. Below are some points that caught my attention as follows

I couldn’t tell when did this blog has started because RexTed decided not to display the monthly archive of this blog

Well actually I have the archive it is just folded down below the  right sidebar, A tick would reveal that I started this blog last January 2007.

However, I want to tell him that the Most Visited Posts and excel Related Posts showed twice on the sidebar.

Now it has been modified.

In general, the blog is satisfactory. But what got my attention is its host and domain which are all hosted by blogspot.com.

Actually I have been thinking to moving on my own domain but the problem , I do not know how I can manages this things since I am at Saudi Arabia. Perhaps I can do this during my vacation.

But just a question how does Amit Agarwal of India managed to get thousand of dollars thru advertiser having a blogspot.com domain.? and also Euleh who is a sucessful blogger in Philippines? This is just a question.

In general It was a really great review and a Thousand thanks to selaplana for having this review.

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

Key Description

Hope You like it.. Check for the Part 1 and Part 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

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

While reading my Windows Magazine I saw a letter from reader pointing to this post about ” The freelancers toolset 100 web apps for everything you will possibly need ”. I think this is worth sharing. The post tackle about the following :

• Organization
• Calendars & To-Do Lists
• Your Money
• Storage
• Project Management & Productivity
• Writing & Design Tools
• Security & Privacy
• Mobility & Contact
• Marketing & Networking
• Business & Legal
• Client Contact & Feedback
• Website Tools
• Printing & Packaging
• Tools to Give & Take
• Miscellaneous

This is a total of 100 links worth of visiting. Enjoy

Below are the most viewed post of June, This came from Direct Referrals and Search Engine Searches.

Microsoft Excel and Microsoft Word Hot Keys

This are post that shows different Microsoft Excel and Microsoft Word Shortcuts which is very useful to the office works

Could Viral Tags increase our PR and Ranking

This will explain why I am now included in the top 10,000 of Technorati.

The Top 10 Emerging Influential Blogs in 2007

This post is my pick for the top 10 Emerging Influence blogs in the net. and serves as my entry to Jeanette’s writing project

Adsense and SEO Tips

This are tips that I am sharing to my readers in order to earn more in adsense and having a higher PR

I-mate to release 30 times more powerful than Apple’s new iPhone

This is an I-mate response to Apple’s new iPhone

Another Tools to Access Blocked Website

If you want to access blocked website not only by you host country but also your server. Checking this post is a must.

CTRL combination shortcut keys for Microsoft Excel

This are post that shows different Microsoft Excel and Microsoft Word Shortcuts which is very useful to the office works

I-mate PDAL Technical Review

This involves my technical review with my newly acquired PDA

Excel Trick : What is the use of $ sign?

This post will teach how to use $ sign in Microsoft excel.

Site with “Do follow” Tag in Comments

This shows my support to the Do follow tag in all my comments. Since then my comments don’t have no follow tag.

This only shows that my post regarding Excel did the best job last month. This site is having a good SERP for topic like Microsoft Excel Tricks and Hot Keys.

I will be doing this kind of post every end of the month to see what blog post is doing great for stats purpose.

Last month was also a great month for me since I was included with Technorati Top 10,000 blogs. Not bad for a newbie like me. I have not yet received my adsense cheque until today. I still ave to wait till 5 before I can request or ask Google why my cheque did not arrived.

Most of the time you are being required to make PDF files output of your work. But what if you don’t have an adobe Program in your computer. An option will be to print it in a printer and they will scan it in a scanner.

I may suggest that a very good tools for office or at home is the Primo PDF. This is a free software that could be downloaded here . Primo PDF converts any Computer generated documents into a PDF format file.

This tool could also be used in printing file Autocad or any other program. It will serves as your printer but the only difference is it will gives a pdf output.

I am doing this review not because they pay me to do so but as a way of thank you for helping me in doing my job well done.

Below is download.com definition of Primo PDF.

PrimoPDF is a free tool for high-quality PDF creation, comprising a user-friendly interface that enables printing to PDF from virtually any Windows application. Additionally, PrimoPDF provides the ability to optimize PDF output for screen, print, ebook, and prepress, secure PDF files with 40- or 128-bit encryption, and add document information (e.g. title, author, subject, keywords) to converted PDF files. Full support for 64-bit machines, double byte character and non-TrueType font support, enhanced support for Microsoft Windows 98, ME, NT, and Vista and improved PDF output also now available. Please note that this download is for 32-bit machines only. A 64-bit installer is available at the developer’s Web site.

Version 3.1 introduces the ability to merge and append PDF files.

Comparing speed of converting Word or excel document to PDF vs Adobe , I will go with Primo as per my experience it is much faster to convert thru Primo rather than from Adobe. I am using Adobe 7.1 Professional.

In Conclusion having this tool is a must to have in your computer. I just hope this tool will help my readers. What about you do you have any other program being use for this type of application? Let us know by your comments.

I have been trying almost everyday searching my blogs keyword at google but always I can not see my blog at Page 1 or 2, Until today when searching some keywords it is surprising to see my site show up at First Page. an I think this is some reason for a blogger to be happy. Below are example of keywords as of today.

• “Philippine Technology Blogger” I am next to Abe Olandares of Yugatech.com ( A prominent Pinoy ProBlogger )
• “Technology at Hand” – I am also at the first page
• “Microsoft Excel Hot Keys” – I am also at the first page.

What is the importance on Ranking high SERP ?

It is very important for blogs to be noticed by the Search Engine, It is because we all know that among millions of Internet User, Most of them rely on Search Engine Result in finding what they need. And if your site will be having a good relationship with those Search Engine It will surely drive more traffic for your site.

What will be my next step ?

My next step will be to write good post which will really benefit my readers. I think I have succeed with my objective this month, To increase SERP and Page Rank ( We still have to wait for sometime for the next updates of PR ) . You may check my experiments at my archived labeled as Experiments.

I also want to be known with the following keywords :

” Technology Blogger “, ” Pinoy Technology Blogger “, ” Philippine Blogs ” , ” Technology at Hand ” , ” Philippine Tech Blogs “

What is my current Stat ?

Alexa – 468,758 ( It is still very, very far far )

Technorati – 10,963 ( A good Rank )

Ratified.org – 35 ( A good Rank )

Actually because of my membership with ratified.org, My blog was mention by Janette at her Philippine Internet Review Blog as one of the Philippine Blogs that was made this year.

A challenge for my reader

And so I would like to thank my readers as well as my would be readers for visiting and roaming around this blog. It will be appreciated if you will review this blog for improvement. You may say whatever you want. It is your blog. In exchange I will also review your blog. and for your information this is a PR 3 Blog. and Please use one of the above mentioned keywords.

This post has been transferred to my Main Tech Site Check it here :  Microsoft Excel Hot Keys Using Numbers

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 Microsoft Excel in almost 6 Years. And Excel really helps me a lot on various calculation. Hope it will help you also.

One of the features the reason why I bought my I-mate PDAL is because of it’s Microsoft excel and Microsoft Word feature which is really a big help on my day to day activities. Although there are some problems that I have mentioned on my review, Still up to now I think this is still suited for me.

But suddenly upon reading the news that iphone will support Microsoft excel and Microsoft word on its platform it is now become one of my wish list.

Gizmodo had shown a recent video of iphone. I have seen also some news here and here .

Really I can’t wait for the availability of the Iphone in the market. But the question, How much will it worth? Is it affordable? I think this are the question need to be answered since we all know that electronic product is very easy to depreciate.

If I will ask you a question, Will you invest for this phone or not?

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

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

Start » Programs » Accessories » System Tool » Character Map

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

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 Windows Live Writer I am able to put my very first table in my blog post.

How much time do you spend searching in google? And then after your searches it result to nothing. So I suggest be smart on searching the net. Below syntax is very useful in finding information in the internet.

intitle: 

This syntax restricts a search to titles of Web sites; it can be effectively combined with other syntaxes to customize a search.  An alternative syntax, allintitle: looks for all the words in the title of a Web site; allintitle: does not mix well with other syntaxes.

Example: intitle:”bob marley” “popular music”

inurl: 

This syntax restricts a search to the URLs of Web sites.  It can be an effective way to find sites from within a domain, directory or path; it can also be effectively combined with other syntaxes to customize a search. See site: below.

Example: intitle:”civil liberties” terrorism inurl:cnn
Example: intitle:turkey intitle:carve inurl:help
Example: inurl:butterflygardening

site: 

This syntax allows you to limit a search to a site or a top level domain.  It is similar to inurl: but will not search for a site within a subdirectory (i.e., anything beyond the /).  Some advantages to using inurl: over site: are:
      You can use inurl: by itself without using any other search terms or
      syntaxes. 
      You can use inurl: to search subdirectories.

Example:  intitle:”hate crimes” site:gov
Example:  intitle:”hate crimes” OR “gay bashing” site:org
Example: intitle:”binge drinking” site:edu

intext: 

This syntax searches for words in only the text of a Web site.  It ignores link text, URLs and titles which makes it a useful syntax for finding search words that are commonly used in URLs or links.  It can be effectively combined with other syntaxes to customize a search.

Example: intext:html site:edu
Example: intext:google.com inurl:help

inanchor:

This syntax searches for text in a Web site’s link anchors (i.e., the text you click on get to a Web site).  Since the anchor text for a link is usually descriptive of the page it links to, the inanchor: syntax can be a useful way to limit a search to relevant sites.  It can be effectively combined with other syntaxes to customize a search.

Example:  inanchor:”Google Help”
Example:  inanchor:AIDS inanchor:grants site:gov

For a fun experiment, try typing your name as a phrase with the inanchor: syntax! 

link: 

This syntax returns a list of Web sites linking to a specific URL.  The link: syntax can not be combined with another syntax.

Example: link:www.linccweb.org

daterange: 

This syntax allows you to limit a search to a specific date or range of dates that a site was indexed by Google (this is not the same as the date the site was created.) The only drawback to this syntax is that it works with the Julian Calendar, not the Gregorian Calendar (the one we use).  To use daterange: first go to the Julian Date Converter at the U.S. Naval Observatory (http://aa.usno.navy.mil/data/docs/JulianDate.html).

Example: intitle:”george bush” daterange:2452389-2452389 (this would search for April 24, 2002)

filetype: 

This syntax searches for specific filename extensions.  Google searches for PowerPoint (.ppt), Excel (.xls), and Word (.doc) documents as well as Adobe Acrobat (.pdf), Adobe Postscript (.ps) and Rich Text Format (.rtf). 

Example: intitle:”hate crimes” filetype:pdf
Example: intitle:google filetype:doc
Example: intitle:”date rape” site:edu filetype:ppt

related: 

This syntax searches for Web sites related or similar to a specified URL.  This is a good way to retrieve categories or types of Web sites.

Example:  related:google.com
Example:  related:www.linccweb.org

info: 

This syntax provides a page of links to more information about a specified URL including a link to the page’s cache, a list of Web sites that link to the specified URL, a list of Web sites related to the specified URL and Web sites that contain the specified URL.

Example:  info:cnn.com

I do believe that this techniques will ease your life in finding what you want in google and not just putting the “words+words” and then pressing Search Button.