Today's Question:  What are you most afraid of as a programmer?        GIVE A SHOUT

SEARCH KEYWORD -- Excel



  Macro to change text color conditionally in Excel


Macros are small but very powerful VBA programs in Microsoft Office software. They can help us complete some repeated tasks automatically. Today, I will show you one macro example which is to change the text color conditionally. The excel file has a work sheet which contains some records of request. I want to check the status of each request, if the status of a request is approved, the text color of the status should be green; if the status of a request is rejected, the text color of the status ...

   Macro,Excel,Text color,Conditionally     2012-07-07 12:53:28


  Automatically Updating Charts for Additional Data in Excel


Excel shines at turning your data into charts—graphical representations of your data. You can easily create a chart based on a range of data in a worksheet. Normally, if you add additional data to your range, you will need to once again create the chart or at best change the range of cells on which the chart is based. If you get tired of modifying charts to refer to new data ranges, there are a couple of shortcuts you can try out. The first shortcut works fine if you simply need to "fin...

   Excel,Graph,Auto update,New data,Automat     2011-08-13 04:36:53


  Learn these technical skills within one day


It takes days and days reading books, practicing and involving in real project if you want to learn a programming language well. It's just like a marathon, you will get more if you can insist longer. During this long and boring period, there are always something you can learn within a short period of time, like within one day. These skills can bring your big satisfaction. Below are a list of technical skills which you can pick up within one single day, they are advocated by Jacob Jensen, a Googl...

   Technical skill     2014-06-12 09:33:15


  Microsoft is to release Office for iPad and Android


Microsoft plans to release Office series software on iPad and Android based tablets this November. This application's loading screen shows "Office for iOS" on iPad, this may indicate that it may also be compatible with iPhone and iPod Touch. The Office series software will also be available on Android at the same time. Some details about this application are still unknown, such as price and features. Last November there was news showed that Microsoft was developing Office for iOS. Micr...

   Microsoft,iPad,Office,Android,iOS     2012-05-24 03:33:28


  Office 2013 RT for Windows RT tablets may rule out macros and VBA


Office 2013 RT is the office suite optimized for Windows RT system running on ARM tablet PC, Microsoft plans to release a preview version later this year. However, according to TheVerge, Microsoft may remove some features in this version of the Office suite.The so-called optimization, certainly require some changes to Office based on ARM tablet architecture. To remove some features may be because of battery life and machine reliability considerations. Macrso, third-party add-ons, and VBA will be...

   Office 2013,Macro,Window RT     2012-08-07 14:17:53


  Office will finally be on iOS and Android in 2013


It was confirmed that Office would land on iOS and Android platforms by Microsoft in October. Microsoft claims that Office will be on these two platforms in some way. Now many sources indicated that Office will be officially launched at the beginning of 2013. It is reported that the mobile version of Office will be free on Android and iOS, it allows users to view Office documents. Mobile version of Office also requires a Microsoft account just like SkyDrive and OneNote App. After login, users c...

   Office,Android,iOS,Office 365     2012-11-07 11:57:50


  It Should Only Take You a Few Hours...


It sure seems easy to make a table. Anyone can do it, right? Get 1 large flat rectangular piece of wood, 4 equally tall wooden poles, 4 nails and a hammer. Nail the 4 poles to each corner of the flat rectangular bit, and you have a table. Ta daaa! Now ask a carpenter to craft you a table. First they will spend time discussing the purpose and function of the table - indoor or outdoor, kitchen or dining room, for show or heavy use, what load does it need to bear. Then they will determine th...

   Programming,software,Craft     2012-03-01 05:09:10


  Computer skills one can learn within one day


Computer related technical skills are usually thought as complicated and difficult to understand. It's very difficult for one to get hands on one skill or master one skill. But if you really do want to learn something useful within one day, there are some good choices which will not take too long to get to know and use.. Version control:- Git, GitHub and SVN Regular expressions AWK sed Grep Learn how to do things with Vim that you never knew could be done. Set up a crawler that can scrape some ...

   Computer skills,Learn     2013-09-16 08:51:35


  What Level Programmer Are You?


Everybody's talking about how programming is the skill that we all are going to need. [Except those folks who might feel that most programming could be turned into wizard-like tools. Insert long discussion about Strong AI.] But what's a programmer? Is the guy who set up his own Apache Web Server a programmer? How about the guy who created a complex Excel spreadsheet? The guy who made his own RPG level? Minecraft players? When we say "Everybody is going to have to know programming" what, e...

   Programmer,Skill,Level,Criteria     2012-02-08 10:07:41


  Announcing the Windows 8 Editions


Today I would like to share information with you on the editions that will be available for "Windows 8" when it is released to market. We have talked about Windows 8 as Windows reimagined, from the chipset to the user experience. This also applies to the editions available – we have worked to make it easier for customers to know what edition will work best for them when they purchase a new Windows 8 PC or upgrade their existing PC. Windows 8 has the flexibility you need - whether youâ...

   Windows 8,Windows RT,New version     2012-04-17 06:19:16