Yearly Archives: 2010

Excel 2010: Create Pivot Table & Chart

by on
7
Excel 2010 has an option of creating pivot table, as name implies it pivots down the existing data table and tries to make user understand the crux of it. It has been extensively used to summarize and glean up the data. Contrasting to Excel 2007, Excel 2010 provides very easy way to create pivot tables and pivot charts. Read More

PowerPoint 2010: Convert PPT to PPTX Instantly

by on
1
When Office 2007 was released, many third-party developers started creating tools to convert PowerPoint 2003 compatible PPT presentation format into the PPTX format, so that users could easily use PowerPoint 2007 supported features and apply new effects on their presentations. Just like the previous version, PowerPoint 2010 supports PPTX as well as PPT presentation formats, and also offers a built-in converter to quickly convert PPT format into PPTX without requiring users to use any third-party converters. Unlike most third-party PPTX conversion utilities, it doesn't allow you to batch convert PPT files, and requires opening the PPT file to manually convert it into the PPTX format. Although you can change the output format of your presentation file from the Save As dialog (accessible from F12 function key), it is recommended to use the PowerPoint 2010 native Convert feature to perform the conversion process. The reason being that when you choose PPT from Save As dialog, it attempts to forcibly save the presentation format in the PPTX format, and doesn't convert the slide elements to make them compatible with the new format, whereas, the PowerPoint converter applies all the required tweaks to make it fully compatible with the new file format structure. In this post we will look at a simple way to covert PPT format into PPTX (PowerPoint 2007 and PowerPoint 2010 compatible format). Read More

GeoHot Hints Working Exploit To Unlock Baseband 05.12.01

by on
13
With the release of iPhone OS 3.1.3, Apple pushed the baseband to version 05.12.01 which remained unlockable and hence created woes for lots of jailbreakers who had accidentally upgraded to the latest firmware. Then, a few days back, @sherif_hashim tweeted he had crashed baseband 05.12.01, which he handed over to the iPhone dev-team. However, no ETA was announced as to when the new unlock would be released, since it would serve better to have it out in the open with the release of the next-gen iPhone OS 4.0, or perhaps OS 3.2. Update: The unlock for all basebands, including baseband 05.12.01 is out. Check it out here. Read More

MS Access 2010 Relationship & Query Interconnect

by on
1
Access 2010 is very useful tool for designing database and provides intermediate-level data mining. It has done and continues to do wonders especially when it comes to managing, creating and most importantly making use of Relational Database up to its acme. This post will cover how relationships and queries interconnect to make database more dynamic. Read More

MS Access 2010: Analyzing Reports With Excel

by on
2
Undoubtedly Excel is one of the best tool that features; calculations, graphing tools, pivot tables and much more. Analyzing reports with Excel 2010 would be very beneficial, if you want to perform different calculations over Access generated reports. Analyzing report data requires a very simple process to follow. Read More

MS Access 2010: Query With IFF Function

by on
3
In MS Access, the IIF function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE. IIF function returns one of two arguments depending on the evaluation of an expression just like as we use logic in IF-ELSE structure. It evaluates both true part and false part, even though it returns only one of them. This post covers creating a simple query with IFF function. Read More

MS Access 2010: Create Simple Forms

by on
8
Access 2010 Form provides an easier way to navigate, create and modify the database records. It makes database look fascinating with different colors, charts, themes and fonts and increase navigability by providing buttons, hyperlinks, tab controls and web controls. Read More

Orbit Social Phonebook iPhone/iPod Touch Application Review

by on
9
Orbit Social Phonebook is a great iPhone/iPod Touch application bringing together your phonebook with your Facebook and Twitter accounts, matching contacts between them, and making it possible to have a one-stop solution for all your social needs. Orbit organizes your communication needs (Facebook, Twitter, SMS, email etc) under one hub, and puts you in control of what you want to know about whom through its unique ‘Social Volume’ feature. Read More

Real Alternative Is An Alternate Codec For Real Player

by on
Leave a comment
RealMedia format has numerous advantages, but one of the main downsides of RealPlayer is the large memory footprint, giving rise to considerable slowness in older PCs. Also, RealMedia formats are propriety, where you cannot play them on any player (VLC, KMPlayer etc) other than the RealPlayer itself. Real Alternative is a free substitute for RealPlayer and Real One Player that allows playback of all RealMedia files without needing to install any of the software from Real Networks. It adds the necessary playback codecs, enabling you to play RealMedia files on any video player of your choosing. Read More

The Complete Guide On Outlook 2010 PST File

by on
6
We showed you how to create a new data file in Outlook 2010, but there is more to that. Data File has a format PST and is used to store all emails, new emails are downloaded and stored in this file. As more and more emails clutter your inbox, PST file can become rather large, in some cases more than 2GB in size. Read More

Reset All Changes In PowerPoint 2010 Presentation Slide

by on
Leave a comment
Formatting PowerPoint's presentation slide is easy, and you have a lot of text and style formatting tools at your disposal to quickly customize the outlook of all the slides included in the presentation. However, when you want to revert back to original formatting or default formatting, it requires pressing Ctrl+Z for a couple of times to undo all the changes made to the presentation slides. While Ctrl+Z/Undo function offers an easy way to choose the best formatting applied to content boxes and text, it becomes quite tedious in a situation where one needs to revert all changes made to slides. PowerPoint 2010 offers a one-click solution for this very problem; it includes a Reset button that is programmed to restore the default context placeholder and text formatting without making any changes to text, rich content (images, videos, animation) and other embedded objects. In this post we will look at a simple way of restoring default formatting style. Read More