Training and Certification

Rubel Khan's Blog

Archive for May, 2010

Make better decisions with Microsoft Excel 2010‏

Posted by Rubel Khan on May 29, 2010

When trying to track how much money your business has spent on a project in the past year, sometimes a large graph isn’t the best way to see the big picture. Sparklines—miniature charts that fit into a single Excel cell—can help you see individual trends quickly and make better decisions.

Set off your figures with Sparklines:

On the Insert tab on the Ribbon, locate the Sparklines group.
Select the type of Sparklines you want to insert, such as Line, Column, or Win/Loss.
In the Create Sparklines dialog box, define your Data Range and Location Range, and then click OK.
To discover more great ways to use Sparklines, see Getting Started: Use Sparklines to Show Data Trends.

Draw attention to variances with Conditional Formatting.
Conditional formatting lets you set rules for how Excel cells look, based upon the information the cell contains. For example, if a department is meeting its revenue quota, the result is highlighted in green; if they are over budget, it will automatically be highlighted in red. It’s easy to set up:

Select the data you want to conditionally format.
On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Color Scales.
Click Manage Rules to manually set your rules and formatting options.
To find out more about applying Conditional Formatting, check out the Quick Start Guide.

Analyze massive amounts of data in a flash with PowerPivot.
PowerPivot, an add-in for Excel 2010, enables you to easily load and manipulate even the largest data sets from multiple sources. Download the add-in now.

After installing the add-in, on the Ribbon select the PowerPivot tab and then click PowerPivot Window.
Select the appropriate data source from the Get External Data box.
Once you complete your analysis, you can get further insights by using Excel Pivot Tables under the View box.
Dig into your data with Slicers.
Slicers are the easy way to quickly filter data in a PivotTable report, without having to open drop-down lists to select the items that you want to filter. Here’s how:
Select a PivotTable report.
On the Options tab, in the Sort & Filter group, click Insert Slicer.
In the Insert Slicers dialog box, select the PivotTable fields you want to add Slicer to, and click OK.
In each Slicer, click the items on which you want to filter.
For additional insights on using Slicers, be sure to see Use Slicers to Filter PivotTable Data.

Posted in Microsoft | Tagged: | Leave a Comment »

Oracle acquired Sun. What happens to the certification program? Check the FAQ’s

Posted by Rubel Khan on May 29, 2010

Will Oracle University support the Sun Certification Program?
Oracle plans to migrate and offer Sun certification offerings to Oracle certification offerings. Changes in the program will be communicated to candidates on the Sun and/or Oracle Certification Program Web pages. Please check these sites frequently if you have questions or concerns.

Will my Sun certification continue to be valid?
Any Sun certifications that you have earned will continue to be recognized by Oracle and remain valid for the version specified by your credential. Retirement or decommissioning of any certification track will be announced on the Oracle Certification Program Web page.

Will I be required to recertify as a result of Oracle’s acquisition of Sun?
Credential holders will not need to retake exams in order to keep their current Sun credentials. Future certification offerings may require candidates to take an exam if they wish to upgrade. All program requirements will be explained on the Oracle Certification Program Web page.

Can I still get Sun certified? What should I do?
Yes. Sun certification is still available. Follow the paths and instructions that are posted on the Oracle Certification Program Web page. Any updates or changes in requirements will be posted there.

Will the Sun certification tracks or requirements change?
Sun certification tracks will be modified to follow Oracle’s certification model: Associate, Professional, Master, and Expert. All changes to the Sun certification credential names, tracks, and requirements will be available on the Oracle Certification Program Web page.

What is the exam registration process?
Currently, Sun exams are administered at Authorized Prometric Testing Centers. Candidates who wish to take Sun exams should register for those exams under “Sun Microsystems” on Prometric’s Web site.

How can I learn more about Sun certification?
Visit the Oracle Certification Program Web page for information about the Sun Certification Program. This site includes information on available tracks, requirements, and training.

Will my credential be branded Oracle or Sun?
For now, the credential will remain a Sun certification. In the future, Sun certification credentials will be fulfilled through the Oracle Certification Program. Any branding changes will be posted on the Oracle Certification Web page.

Will Oracle continue to sell individual and bundled ePractices?
Yes. ePractice exams will be available for individual purchase and also available within Classroom Value Packages.

How do I obtain vouchers for Sun exams through Oracle University?
Candidates will no longer need to obtain an exam voucher prior to registering for Sun exams at Prometric. Simply go to and pay the exam fee with your credit card during the registration process. If you already have an exam voucher, this can still be used as payment at Prometric when you register.

Will Oracle continue to offer the Certification Re-take Promotion?
Certification re-takes will be exclusive to Certification Value Packages. At this time, there are no plans to offer re-take promotions or re-take vouchers on a stand-alone basis.

Whom do I contact for Sun certification customer service inquiries?
Contact with Sun certification questions.

Posted in Certifications, Oracle | Leave a Comment »

Database Administration One of the Fastest Growing Occupations

Posted by Rubel Khan on May 29, 2010

There is an interesting new article in Certification Magazine that reports that database administrator is one of the fastest-growing occupations. It also provides a good ‘day in the life of a DBA’ narrative. If you are either considering a career as a DBA or are seeking to move your career forward as a DBA, you should definitely take a look at this article.

If you’re familiar with our Global Salary Survey (conducted in 2009) you might remember that on average – certified DBAs earn more than $8,000 more per year than non-certified DBAs. Also from our Global Salary Survey, we found that database administrators who have a lot of experience are earning just under $100,000 per year. So even in a tough economy it’s a great time to be a database administrator, and if you are not Oracle-certified – it’s a great time to consider certification as a way to (1) build your credibility, (2) increase your marketability and (3) improve your career.

Read the article here: “Database Administration One of the Fastest Growing Occupations” (Certification Magazine)


Posted in Microsoft Learning | Tagged: , | Leave a Comment »

Value of Certification

Posted by Rubel Khan on May 29, 2010

A recent article in Certification Magazine spells out the value of certification for IT professionals. The article provides some detailed insight on the state of the economy and what it means to IT professionals. A few of the key findings (among many) by Certification Magazine:

  • Even in this tough economy, IT worker salaries grew at about 9%.
  • Many respondents reported that they received raises after earning a new certification.
  • Many people reported that they had earned one or two new credentials within the last year.
  • Salaries for more entry-level certifications were stagnant over the last year or so.

We encourage you to take a look at the article. It is very encouraging to see that companies and individuals still recognize and value the hard work that goes in to getting certified.


Posted in Certifications | Leave a Comment »

7 IT Cloud Certification Programs Worth the Cash – Careers news from Channel Insider

Posted by Rubel Khan on May 29, 2010

IT professionals and services teams aiming to advance cloud-computing programs and sales might want to investigate seven cloud-certification programs that promise to boost knowledge around virtualization, utility computing and cloud-architecture development. 7 IT Cloud Certification Programs Worth the Cash – Careers news from Channel Insider.


Posted in Certifications | Leave a Comment »

Top 10 IT Networking Certifications – Careers news from Channel Insider

Posted by Rubel Khan on May 20, 2010

IT network professionals who want to advance their career, and compensation levels, would be wise to consider attaining certification. The top two, on a top 10 list, are CompTia’s A+ and Microsoft Certified Systems Engineer programs.Top 10 IT Networking Certifications – Careers news from Channel Insider.

Posted in Certifications | Tagged: | Leave a Comment »

Google Partners With VMware — InformationWeek

Posted by Rubel Khan on May 20, 2010

Google and VMware plan to jointly launch Google App Engine for Business, a cloud-based infrastructure to support enterprise Web applications. Google Partners With VMware — InformationWeek.

Posted in Education | Tagged: | Leave a Comment »

Snack Time: Office 2010

Posted by Rubel Khan on May 13, 2010

In honor of oMicrosoft’s brand spanking new Office 2010, here’s a new free Learning Snack for your noshing pleasure: Introducing Common Features Across Microsoft Office 2010 Programs.


Source: Born to Learn

Posted in Microsoft | Leave a Comment »

MCAS changing its name to MOS (That’s what we used to call it)

Posted by Rubel Khan on May 12, 2010

Certiport just announced that as of June 2nd 2010, MCAS program will be formally renamed Microsoft Office Specialist 2007 (MOS 2007). Bellow is their announcement:

“In the coming months, the Microsoft Certified Application Specialist (MCAS) program will undergo a branding change. As an ongoing commitment to you, we share this information in advance of our official public announcement to enable you to get started making necessary preparations and adjustments at your testing center. Please bear in mind that today’s message is intended only for Certiport Testing Centers.

Starting June 2, 2010, the MCAS program will be formally renamed Microsoft Office Specialist 2007 (MOS 2007) in the following countries:

  •     United States
  •     Australia
  •     Canada
  •     India
  •     Japan
  •     Korea
  •     Puerto Rico
  •     United Kingdom

To help clarify this change, please review the following documentation: 

The decision to re-brand MCAS to MOS came only after careful and lengthy consideration at Microsoft and Certiport, primarily because MOS has proven to have stronger branding equity and visible alignment with the Microsoft Office Products. We strongly believe MOS represents a more recognizable message for customers and provides a simpler marketing effort for Certiport, Microsoft and all business partners.

Please bear in mind that we have made every effort to ensure this branding transition is as simple and painless as possible. We acknowledge the change may present short-term business and operational challenges, however we are also very confident the long-term benefits will significantly outweigh these challenges. We sincerely appreciate your support and cooperation through the transition, and wish you great success with the newly branded MOS 2007 program!

Best Regards,

Neill Hopkins

Vice President, Global Channel Operations”

Posted in Microsoft | Tagged: , , | 2 Comments »

SharePoint in Plain English

Posted by Rubel Khan on May 12, 2010

I have found some great YouTube videos about SharePoint. Watch these videos if you still not clear about the function of SharePoint or what’s new in SharePoint 2010:

Thank you

Posted in Microsoft | Leave a Comment »

%d bloggers like this: