VLOOKUP Function Beginner to Advanced 26 Examples

VLOOKUP function stands for vertical lookup, can help you find specific information in large data tables

0 අදහස් හා මතවාද:

Microsoft Office 2013 Review

Microsoft Office 2013 is an outstanding package that allows you to write documents, create presentations, manage your emails and analyze data. Its latest version brings many more features and improves all of its existing functions. Microsoft has made major changes to all the popular programs within Office 2013 including Word, Excel, PowerPoint and Outlook.



0 අදහස් හා මතවාද:

Write a .bat file to clear Mozilla Firefox cache, cookies and history


If You want to clear cache, cookies and history from Firefox web browser  can be used Shift+ Ctrl+ Delete Keys together. Once you press the short cut keys you can see list of items that you want to be cleared. From that window you can select the items and press Clear Now button to clear the selected data.


Normally Firefox stores cookies, cache and history in two places. The first is per-user AppData directory C:\Users\\AppData\Local\Mozilla\Firefox\Profiles and the second place is roaming profile data directory C:\Users\\AppData\Roaming\Mozilla\Firefox\Profiles. To get rid of all the private data, delete the local data directory and delete all SQLite databases from the roaming data directory.

Copy below commands to Notepad and save the file as .bat extension. If you want to Run this file you can double click it. if u want to run and clear all history form fire fox within given time  period you can write a program for this.

@echo off

set DataDir=C:\Users\%USERNAME%\AppData\Local\Mozilla\Firefox\Profiles
del /q /s /f "%DataDir%"
rd /s /q "%DataDir%"
for /d %%x in (C:\Users\%USERNAME%\AppData\Roaming\Mozilla\Firefox\Profiles\*) do del /q /s /f %%x\*sqlite

Just create this Bat file. Will write a program to clear  cookies, cache and history by given time period Join next article.



3 අදහස් හා මතවාද:

The 2014 Worldwide Competition on Microsoft Office


Overview
The Microsoft Office Worldwide Competition Will be held in Disneyland, Anaheim, California, USA between July 27th and July 30th 2014. Students from around the world will demonstrate their abilities in Microsoft Word, PowerPoint and Excel from now till June 15th 2014 in their respective countries. Skilled students will win some serious prizes, and the best will fly to California to do their school and country proud!
The 2014 Worldwide Competition on Microsoft Office is conducted by Certiport. Prizes include cash grants, medallions, Certificates of Commendation, a range of exciting products from Certiport as well as Microsoft and of course recognition and public acknowledgement for the individual and the school. National winners will receive an all-expenses paid trip to the USA to compete in the Worldwide Competition finals.
To qualify, students must achieve their Microsoft Office Specialist Certification in Microsoft Word, Excel or PowerPoint 2007 or 2010 before June 15th 2014. The Microsoft Office Specialist (MOS) certification is a globally recognized credential validating the students' skills in Microsoft applications, demonstrating job readiness, improving employability or preparedness for further study.
While all participants successfully passing the exam will achieve an MOS certification, students achieving the highest scores and fastest times have the chance of progressing to the national and the international championships.

Eligibility
Eligibility
Participation in Certiport's 2014 Microsoft Office Specialist World Championship (hereafter referred to as "Championship") will offer the Championship on both Microsoft Office 2007 and 2010 Productivity Applications.
To participate, a student must submit a passing score on any of the following certification exams:
·       Microsoft Office Specialist – Word 2007
·       Microsoft Office Specialist – Excel 2007
·       Microsoft Office Specialist – PowerPoint 2007
·       Microsoft Office Specialist – Word 2010
·       Microsoft Office Specialist – Excel 2010
·       Microsoft Office Specialist – PowerPoint 2010
(Hereafter, these certification exams will be collectively referred to as "Exam(s)"). All qualifying Exam(s) must be uploaded into the Certiport exam administration system by an approved Certiport Authorized Testing Center.
Although the Championship is available worldwide, the rules of participation and dates vary slightly by country. Final round Championship exams are available in a limited number of languages. Please visit www.MOSchampionship.com for a complete list of participating countries, worldwide rules, exam languages supported, and Championship dates. All dates for the Championship begin at 7:00 a.m. Greenwich Mean Time and end at 6:59 a.m. Greenwich Mean Time.
Employees of Microsoft, Inc., Certiport, Inc., the Sponsoring Certiport Authorized Partner, their affiliates, subsidiaries, parents and related companies and agencies and those individuals living in the same household as employees are not eligible. All federal, state, local laws and regulations apply. Void where prohibited or restricted by law. By taking an eligible Exam and entering this Championship, student, solution provider and distributor participants agree to abide by all terms of these Official Rules.
Participants in the Championship must be students currently enrolled in an approved academic institution recognized by the state or country in which it operates. To compete in the final round of the Championship, students must be between the ages of 13 and 22 (as of June 15, 2014). Verification of student status and student identification is required.
Previous championship competitors are eligible to participate in the 2014 Championship in any exam EXCEPT for the application they previously competed on. For example, a student who participated in the 2013 World Championship competing on MOS 2007 Excel can compete in a Microsoft Word or PowerPoint track, but can NOT compete in the Microsoft Excel 2007 or 2010 track in the World Championship.

Entry
Entry
Participating competitors may enter the Championship (Qualifying Round) in either of two ways:
1.     Register Eligible Exam Immediately Prior to Testing: If the eligible Exam is taken at an ACADEMIC Certiport Authorized Testing Center, the iQsystem exam delivery tool will prompt the student to register his/her score into the Championship immediately prior to taking the exam. If the candidate chooses to submit his/her score to the Championship, the results of that exam will be automatically entered into the Championship.
2.     Register Eligible Exam(s) Following Testing: Students may also register any eligible Exam(s) after taking the exam(s) by logging onto their Candidate Home Page at www.certiport.com, clicking on the Microsoft Office World Championship link, and following the registration instructions. Eligible Exams registered using this tool must be registered during the official Championship dates of the country in which the eligible Exam(s) was taken. Please visit www.MOSchampionship.com for a list of dates for various countries. Eligible Exams taken by students at any COMMERCIAL Certiport Authorized Testing Center may also be registered using this tool.
There is no limit to the number of times a student may sit for any particular eligible exam as long as he/she is not in violation of the Certiport exam retake policy. Students who fail to abide by the Certiport exam retake policy will be disqualified from the Championship.
Each Exam score registered for the Championship during the official date range period (the Qualifying Round ends June 15th, 2014) receives one entry into the Championship. Standard test-taking terms and conditions apply.
During the Qualifying Round, a Student can participate in MULTIPLE Exam tracks. For example, they can submit an Excel 2007 and Excel 2010 Exam. However, if they qualify to participate in a Regional/Country Round or the Final Round in Anaheim, California, they can only compete in only ONE Exam track. Certiport retains the right to disqualify students for appropriate cause.
Qualifying Round – Regional/Country Champion Selection:
Regional/Country Champions will be selected from among all eligible entries received in each country during the Qualifying Round of the Championship. The Qualifying Round determines the winners of the Championship in each region or country of the world.
Each sponsoring Partner must be an approved reseller of MOS exams with a Certiport Authorized Partner ID#. Only one student per partner, per exam category will be eligible to compete in the final round Championship in Anaheim, California, USA. For example, a partner could bring a regional finalist for both Microsoft Word 2007 and Microsoft Word 2010. They would not be able to bring more than one participant for any single exam, such as Microsoft Word 2007.
Students will be representing their sponsoring Certiport Authorized Partner in the final round of the Championship. In countries where there are multiple partners, each partner may bring up to 6 finalists, one per exam category. Certiport reserves the right to implement a limit of students per country, if necessary.
Students will only be allowed to participate in the Championship if they are the qualified, designated representative, sponsored by a specific partner, for a single exam. Additional students will not be allowed to attend the Championship and/or participate simply for the "experience."
Partners must identify which test categories, and which exam language(s) they will have sponsored student competitors participating in by January 31, 2014. Any exam languages not requested by this date will NOT be created.
Regional/Country Champions will be selected in one of two ways by the sponsoring Certiport Authorized Partner (Competition Operator) and/or a regional championship in each country*:
1.     Top Score Method: Competition Operator reviews the exam results for the country and selects the student with the top score for Word, the student with the top score for Excel®, and the student with the top score for PowerPoint® per version. These students represent the partner at the World Championship Event. Certiport retains the right to review local Competition Operator selections.
2.     Country Final Method: Competition Operator reviews the championship results for the country and invites several top students, to compete at a country finals event. The winners of the country finals event (in Word, Excel® and PowerPoint) represent the country at the Worldwide Event. Certiport retains the right to review Competition Operator selections.
*Individual partners/countries may have additional published rules. Please contact your specific partner or refer to your specific regional competition rules for details.

Final Round – Worldwide Champion Selection:
All Country Champions will be invited to compete in the 2014 Microsoft Office Specialist World Championship to compete to become:
·        2014 Worldwide Champion for Microsoft Office on Word (2007 or 2010)
·        2014 Worldwide Champion for Microsoft Office on Excel® (2007 or 2010)
·        2014 Worldwide Champion for Microsoft Office on PowerPoint (2007 or 2010)
All Country Champions will be responsible for preparing themselves to compete on Microsoft Office software suite version 2007 OR 2010 at the 2014 World Championship Event. Certiport and/or Certiport's partners may provide Country Champions with preparation materials to help facilitate each student's training on Microsoft Office 2007/2010 software.
Candidates may take qualifying Exams in the Qualifying Round of the Championship in whatever language is available at that time. However, Regional/Country Champions will be required to test in one of the available languages listed above at the World Championship Event in Anaheim, California, USA, regardless of native or first language.
In the event two Regional/Country Champions at the World Championship Event have the same high exam score on the Microsoft Office Specialist competition exam, the Country Champion who completed the exam in the least amount of time will be the winner. Decisions of judges are final. Winners will be notified during the student awards ceremony. Odds of winning will depend on the number of Regional/Country Champions present at the 2014 Microsoft Office Specialist World Championship Event.

Exam Elements
During the Final Round, contestants will be given a high-resolution copy of a Word document, an Excel workbook, or a PowerPoint presentation to recreate. Competition participants will receive a printed set of guidelines containing specifications for the document, workbook, or presentation, and data files that can be used as building blocks to speed up the recreation of the document, workbook, or presentation. Students will be allowed up to 50 minutes to recreate the document, workbook, or presentation they are provided. To ensure a fair and quality testing experience among all candidates, the new scenario-based exams have undergone the same rigors and standards of test development as traditional online Microsoft Office certification exams.

General Rules
No substitution/transfer/assignment of prize by any winner is permitted. Reporting and payment of all federal/state/local or other taxes are responsibility of each winner. All federal/state/local laws apply.
All materials submitted become the sole property of Certiport, Inc. and will not be returned. False and/or deceptive entries or similar acts shall render entrants ineligible to continue to participate or win the Championship.
Except where prohibited, and at the sole discretion of Certiport, student participation in the Championship constitutes entrant's consent to publication of his/her name, Exam score(s), and city/state/country location on the Championship website and other Championship publicity without limitation or compensation. Potential winners may be required to sign and return an Affidavit of Eligibility/Release of Liability/Prize Acceptance Form within 10 days of attempted notification. Noncompliance may result in disqualification and selection of an alternate winner. Acceptance of any prize constitutes permission for Certiport, Inc. and/or their agencies to use winner's name/likeness/visage, Exam score(s), and city/state/country location for purposes of advertising and promotion without further compensation, unless, but only to the extent, prohibited by law.
Championship awards and/or prizes consist of only those items specifically listed on the Championship website located at www.MOSchampionship.com. Winner may decline to accept a prize, in which case Certiport, Inc. may select an alternate winner. If necessary due to unavailability, a prize of equal or greater value will be awarded at the discretion of Certiport, Inc. Return of any prize or prize notification as undeliverable may result in disqualification and the naming of an alternate winner. Prizes sent to winners will only be available in the fashion selected by Certiport, Inc.
Regional/Country Champions must be available to travel to and attend the 2014 Microsoft Office Specialist World Championship on July 27 – 30, 2014 in Anaheim, California, USA. All travelers must execute a Release of Liability prior to ticketing and must possess required travel documents (e.g. valid photo I.D., passport, visa, etc.) prior to trip.

Frequently Asked Questions
Q. How do I participate in the Championship?
A. Participating competitors may enter the Championship (Qualifying Round) in either of two ways:
1.     Register Eligible Exam Immediately Prior to Testing: If the eligible Exam is taken at an ACADEMIC Certiport Authorized Testing Center, the iQSystem exam delivery tool will prompt the student to register his/her score into the Championship immediately prior to taking the exam. If the candidate chooses to submit his/her score to the Championship, the results of that exam will be automatically entered into the Championship.
2.     Register Eligible Exam(s) Following Testing: Students may also register any eligible Exam(s) after taking the exam(s) by logging onto their Candidate Home Page at www.certiport.com, clicking on the Championship link, and following the registration instructions. Eligible Exams registered using this tool must be registered during the official Championship dates of the country in which the eligible Exam(s) was taken. Eligible Exams taken by students at any COMMERCIAL Certiport Authorized Testing Center may also be registered using this tool.
Q. What is Certiport's Microsoft Office Specialist World Championship?
A. The 2014 Microsoft Office Specialist World Championship presented by Certiport, Inc. is a global competition that tests students' skills on Microsoft Office Word, Excel® and PowerPoint. Top students are invited to represent their respective countries at the World Championship. At the World Championship, each student competes for World Champion in his or her category (Microsoft Word 2007, Microsoft Word 2010, Microsoft Excel® 2007, Microsoft Excel® 2010, Microsoft Office PowerPoint 2007). In some countries or regions, students are required to participate in a regional test event as well, and the winners of that event continue on to the World Championship.
*Individual partners/countries may have additional published rules. Please contact your specific partner or refer to your specific regional competition rules for details.
Q. Who can participate in the Championship?
A. Anyone may participate in the qualification round of testing, but to participate in the World Championship, candidates must be students that are enrolled in an approved, degree-seeking academic institution recognized by the state or country in which it operates. Students must also be between the ages of 13 and 22 (as of June 15, 2014). Students participating in the World Championship must be able to provide proof of age and student status upon request. Employees of Certiport, Inc., the sponsoring Certiport Authorized Partner, their affiliates, subsidiaries, parent and related companies and agencies and those individuals living in the same household as employees are not eligible. All federal, state and local laws and regulations apply. Void where prohibited or restricted by law. By taking an eligible Exam and entering this Championship, participants agree to abide by all terms of these Official Rules.
Previous participants of the World Championship Round ARE eligible for the 2014 Championship. However, they cannot compete in the Exam they previously competed in during a World Championship Round. For example, a student who competed in Microsoft Excel® (2007 or 2010) during a previous year's World Championship Round, can compete in Microsoft Word or PowerPoint® in the Qualifying Round and the World Championship Round of this year's competition.
Q. What versions of Microsoft Office will the 2014 Microsoft Office Specialist World Championship cover?
A. The 2014 World Championship will include the following six (6) tracks:
Microsoft Office Specialist Word 2007
Microsoft Office Specialist Excel® 2007
Microsoft Office Specialist PowerPoint® 2007
Microsoft Office Specialist Word 2010
Microsoft Office Specialist Excel® 2010
Microsoft Office Specialist PowerPoint® 2010
Q. When is the Championship taking place in my country?
A. Although this Championship is available worldwide, availability, rules, and dates vary by country. During the Qualifying Round, countries all around the world are hosting local competitions to determine Regional/Country Champions. Contact your local testing center to find out more.
Q. How are the Word, Excel® and PowerPoint Country Champions selected?
A. Country Champions will be selected in one of two ways by the Certiport competition operator in each country*:
Top Score Method: Competition Operator reviews the competition results for the country and selects the student with the top score for Word, the student with the top score for Excel® per track and the student with the top score for PowerPoint per track (version 2007 or 2010). These students represent the country at the Worldwide Event. Certiport retains the right to review local Competition Operator selections.
Country Final Method: Competition Operator reviews the competition results for the country and invites several top students, to compete at a country finals event. The winners of the country finals event (in Word, Excel® and PowerPoint) represent the country at the Worldwide Event. Certiport retains the right to review Competition Operator selections.
In the event two participants in the same country have the same high Exam score, the participant who completed the Exam in the least amount of time will be the winner. Decisions of Competition Operators and judges are final.
*Individual partners/countries may have additional published rules. Please contact your specific partner or refer to your specific regional competition rules for details.
Q. How are the World Champions in Word, Excel® and PowerPoint selected?
A. All Regional/Country Champions will be invited to the World Championship to compete for the title of the World Champion in Word 2007 or 2010, Excel® 2007 or 2010 and PowerPoint 2007 or 2010. At the World Championship Event, all Regional/Country Champions will be tested in a proctored lab on their respective exams. Generally, students will only be asked to complete their exams one time, however, in rare instances Certiport may require a second round of testing.
All participants in the World Championship will be responsible for preparing themselves to compete in their respective exams. Certiport and/or Certiport's partners may provide students with preparation materials to help facilitate each student's training on the software.
Q. How does Certiport select the winning score?
A. If two Country Champions at the World Championship Event have the same high exam score on the unique comprehensive exams, the finalist who completed the exam in the least amount of time will be the winner. Decisions of judges are final. Winners will be notified during the student awards ceremony. Odds of winning will depend on the number of students competing in each exam division.
Q. Where can I take an eligible exam?
A. Eligible exams can be taken at any Academic Certiport Authorized Testing Center.
Q. Can I take an exam in any language?
A. Yes. During the Qualifying Round of the Championship, students may participate in any of the eligible exam regardless of the language. However, during the World Championship all finalists will be required to test using a specially designed version of Microsoft Office Specialist Word 2007, Word 2010, Excel® 2007, Excel® 2010 or PowerPoint 2007, PowerPoint 2010. The final championship exams are available in a limited number of languages. All Country Champions will be required to test in one of these languages at the Worldwide Event regardless of native or first language. Please visit the Exam Languages page to view a matrix of Exams and Languages offered at the 2014 World Championship.
Q. How many times can I take an eligible exam for the Championship?
A. There is no limit to the number of times a student may sit for any particular eligible exam as long as he/she is not in violation of the Microsoft Office Specialist exam retake policy. Students who fail to abide by the Microsoft Office Specialist exam retake policy will be immediately disqualified from the Championship. Certiport retains the right to disqualify students for appropriate cause.
Q. How many different types of eligible exams can I submit into the Competition?
A. During the Qualifying Round, a Student can participate in MULTIPLE Exam tracks. For example, they can submit an Excel 2007 and Excel 2010 Exam. However, if they qualify to participate in a Regional/Country Round or the Final Round in Anaheim, California, USA, they can only compete in only ONE Exam track

0 අදහස් හා මතවාද:

Copyright © 2013 kotuwegedara.com