Category Archives: Training

Become an Excel Wizard With These 5 Tips

All upgrades past the Excel 2010 versions are packed with interesting surprises. Excel is indispensable when it comes to handling and organizing large data. Regardless of a user’s familiarity with Excel, there remains tricks and hacks that are still unknown to many. Microsoft Excel training offers basic guidelines in order to perform basic excel functions. Here are 5 tips that will transform a user from a spreadsheet organizer to an Excel Jedi.

#1 Select the entire sheet with just a click: Ever wondered what this button —   does? Click on it to select the entire sheet.

#2 The function of Data validation: A handy tool while creating a survey form is the data validation function. This enforces a restriction on the value entered. Consider a form that needs to be filled out only by those who are in the age bracket of 25-35. To achieve this, Data → Data validation → setting → add restriction→ move to input message to label the restriction→ OK. When the cursor is on the defined cell, the input message is displayed to notify the user of the condition. If the entered value doesn’t conform to the restriction, an error message appears.

#3 Customize the shortcut menu: Stock Excel comes with three shortcuts – Undo Typing, Save and Repeat typing. When more shortcuts are needed like copy, paste, etc., addition of new shortcuts is done by clicking on this drop down button  . Check the shortcut you wish to add. Click on More commands to explore more options.

#4 Instantly add new columns or row: Instead of taking the long route and repeating the procedure n times to add n rows, select the number of rows or columns that need to be added. Right click→ Insert→ entire row /column (depending on the user’s need). New rows or columns similar in number, as per selection are added.

#5 Transpose Row to Column and vice versa: You do not have to retype the data to shift from row to column. There is a special function Transpose as an option in Paste. This option works off the data copied prior to choosing the transpose option.

Other useful excel hacks include toggling between multiple sheets by pressing Cntrl + Tab, shifting rows or columns from one location to another by selecting the row and hovering the curser around the edges till this icon appears  , then moving unrestricted in the spreadsheet and repeat the same while holding Cntrl to copy the selected values.

The Image Editing Craze Has Caught On

Overexposure of photographs can take the beauty out of the construct. By adjusting the exposure, you can pretty up a photo in an instant. In fact, with photo editing software, you can make the image more nuanced. Tweaking a snap actually brightens the fore. The right contrast brings clarity to an image. White clarity magnifies an image but when it comes to editing of faces, it is necessary to exercise caution. You would not want to make someone look bizarre.

Digital photography captures those special moments. The right resolution and enhancement gives you exquisite pictures with proper layering, brush strokes, shutter velocity and photo editing. In fact, a simple picture can be transformed into a masterpiece. If this gets you in the zone, sign up for the Photoshop course in Singapore at itbmcomat.com.sg and learn everything that you wanted to know and more about image editing. The best part about learning something creative that you have set your eye on is that you can do wonderful things with an image.

We have seen celebrities on magazine covers who look stunning. A nip and a tuck here and there make for good imagery. People who are heavy appear toned, not necessarily because they have been hitting the gym, but because of their pictures being Photoshopped. The software gives you the power to produce havoc and surreal selfies. Share the love across social networking sites or with a select group and achieve that aha moment. The ability to sharpen images on Photoshop makes this a coveted graphic software to learn.

A montage of images from the past interfaced with the present can change the tone of an image in an instant. For instance, strike a pose and position this in a very proper setting. With the right brush strokes and layering, the portrait will be unlike any other. It does take time to hone the craft, that is a given, but creating something that is different from the rest sets the tone. Interpreting artistry with the use of editing software can be made into a series as you blend art in a variety of forms.

The Photoshop course in Singapore covers basic tools in addition to framing and correction, layering techniques in a photographer’s workflow, contrast and brightness, color contours and the use of curves and histograms. Over the years, post processing has evolved. The virtual methodology with editing software ensures clarity in images. To master the art, it requires constant practice until you get the image right.