The MicroTrain Blog

Entering Functions in Excel 2007

by Scott Coley on April 26th, 2010

This is for the Excel 2007 Newbies! Us old users have discovered this litte trick ages ago.

There are three ways to enter functions in Excel 2007:

1. Type them into the cell or the formular bar

2. Use the Insert Function Wizard

3. Use the new method in Excel 2007 by typing the equal sign, the first few characters of the function name    and follow the syntax.

There is a fourth method, a combination of two and three above.

Type the equal sign and the first few charaters of the function name, the on the Formular Tab click the Insert Function

Icon to bring up the Insert Function dialogue box and enter the needed information in the appropriate rectangle. This method is great for eliminating errors, assuring the correct  punctuation and proper syntax.  One also gets assistance in what to put in each rectangle.

Try this, I think you will like it.  I use it ofter and find it to be speedier and reduces errors.

Cloud Computing with a Chance of Meatballs

by Cecille Ramirez on April 26th, 2010

Cloudy with a Chance of Meatballs, I have not seen that movie really but my topic fits quite well.  Cloud computing, what’s the rage all about? In a gist, it’s virtualization in the Internet.

Virtualization is having a physical box with various services in it being used by the clients. Make that available in the cloud, in the Internet then you have ben doing cloud computing for all you know.

A basic example of cloud computing is when new software needs to be rolled-out to the clients; an organization has to test it first in an environment mirroring the actual computer where it's supposed to run eventually, right? This is a guarantee that it will work well as expected since it was tested in such a platform.

The only drawback however in this above example is there are times new software has to be tested not just in one platform bur rather in different ones which in the end will be costly for the company to recreate. This is when cloud computing will plays a big role. No more worry for software licensing and other related issues in setting up an environment just to test the new software. Cloud computing has different flavors following the industries requirement for it. You just have to know which one you're looking for and go for it.

There is "Software as a Service" or a.k.a. Saas. In Saas, the service resides entirely in the server in the cloud and customers are connecting to it thru the browser.

There is also an Attached Service wherein the service provided is application specific. For example, iTunes which is useful for playing music and more but when attached as a service, it allows buying of audio and video of your favorite artists.

Other type is Cloud Platform wherein the customers are developers and not just simply typical users. This type of cloud is much more powerful since it allows the developers to develop their application using the cloud in different platforms.
 
All these are considered the general categories of cloud computing. In some articles, books, whitepapers, it can be broken down further into different types or extensions of al these flavors. You may have to look for these terminologies when learning and discovering how cloud will work for you.

These are the Utility Computing, Internet Integration, Platform as a Service (PaaS), Managed Service Providers (MSP), Web Services in the Cloud and Service Commerce.

You may also want to look for cloud computing from known vendors which I listed below:
-    Amazon EC2
-    Microsoft Azure
-    ADP Payroll Processing
-    Google Desktop Apps
-    Salesforce.com

Cloud computing is still considered at an infancy stage. But bear in mind, this could be something so big in the next years to come. In my next blog on this, we’ll talk about security in the cloud and a host of different isues concerning it.





Raves & Praise

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top