Thursday, 28 June 2018

USMLE Visa: Requirements of getting H1 B Visa for IMGs and FMGs

Every IMGS and FMGs must apply for a state license in the state/s they intend to practice. The initial State Licensure requirements will vary depending on the state and will require the applicants to have completed step 3 either before or during the 1-3 year residency training in the US.
International Medical Graduates who wish to enter the US for Residency training/graduate medical education must obtain a visa that permits clinical training. IMGs who do not hold a legal status in the US usually apply for a J-1 or H1B visa for residency training.
H-1 B Temporary Worker The H-1B visa is for temporary workers in specialty occupations who hold professional degrees. The H-1B visa has been extended to IMGs for residency training in the US. The individual must be able to meet all the specified criteria which includes appropriate authorization by the concerned state medical board, ECMFG certification and should have passed the USMLE Step 3 exam. The advantage of the H-1B visa that it does not have the two-year home residency requirement as the J-1 visa.
EduPristine is a leading educational service provider for professionals and students - in the area of test preparation and professional education. It has been founded by industry experts with its headquarters in Mumbai and have office across India. EduPristine has partnered with Becker Healthcare to provide the resources you need to score high on the USMLE exams and move ahead in your journey to residency training in the US. The team of experts at EduPristine will guide you throughout your journey from USMLE exams, USMLE Visa applications, to Medical residency training in the US. It is your one stop shop for all the services you need to successfully enter medical residency training in the US.

To get a complete guide for IMGs and FMGs to get H-1B Visa, click here: https://www.edupristine.com/blog/usmle-h1b-visa


Friday, 22 June 2018

Global Temporary Tables

(Oracle 8i) is considered to be vital for DBAs and developers.
What are Global Temporary Tables:
Data in this table is stored as long as the session or transaction gets over and is private for each session. eventually, after disconnection, the data is lost but the definition of the table remains. Performing ddl operations is not necessary, however.
The synonyms, or views and other structures related to the temporary table don’t disappear after transaction or session. Indexes will be created likewise. The features of Temporary tables have triggers and all the statistics related to table access cost, information of rows and blocks, join cardinality, etc. Foreign keys cannot be integrated into temporary tables.
Examples of usage involves replicated data manipulation from remote tables, it is also useful in temporarily storing a set of rows to be processed against other tables.
There is no denying that Oracle database has evolved over the years. Some redundant features have paved way for ingenious additions to which Oracle Global Temporary Tables (GTT) is one of the latest.

To read more on Global Temporary table in Oracle, read here: https://www.edupristine.com/blog/oracle-global-temporary-tables

Thursday, 21 June 2018

Google Logo Change

Has it ever happened to you that you came to know about the new Google’s tool or other news after a month it was announced?? That would not have been the case, if you were updated with latest developments and happenings about Google. How can you stay updated?? Simple, by following the below mentioned Google blogs.
1.            Google Research Blog
Know what is happening in Google and what the new researches are. Google Research Blog gives you latest news from Research at Google. Various researches are carried out for various products of Google like search algorithms, systems infrastructure, machine learning, and programming languages. Through this blog stay updated with all the news
2.            Google Official Blog
Follow Google’s Official Blog to stay updated with news and updates on Google’s products, technology and more. On this blog page you will find product announcements and news, company updates, glimpses into what it’s like to work at Google, discussions on technology and the web, and much more.
3.            Google Inside Adwords Blog
Google Inside Adwords Blog is a must follow for all those who run the Google Adwords campaigns. Through this blog you can stay updated with the news, tips and information on Adwords. The blog page is a central place for you to learn how Google can help make the web work for you and drive your customers from intent to action. So don’t wait more and follow this blog for the latest product and feature announcements, best practices, and case studies, as well as expert recommendations on Google ads products.
4.            Google Webmasters Central Blog
Google Webmasters is a free toolset provided by Google that helps you to know what is going on with your website. By following the Google Webmasters Central Blog you can know about every news on crawling and indexing sites for Google index. If any new feature is to be introduced, you can know it immediately through Google Webmasters Central Blog. So follow this blog and make your website user friendly and easy to find on Google.
5.            Google Apps Update
If you love to know about the new app and their upgrades then I am sure that you would be following the Google Apps Update Blog if not, then its not too late, follow it now. This page is an official feed from the Google Apps team that provides essential information about the new features and improvements in the apps by Google.
6.            Blogger
If you blog constantly on your personal blog at blogger. Com then you will love to read this blog page since it gives you all the latest information on the developments in the new features of blogger. Whether it is inclusion of new templates or custom domains, you can get all the information through their blogs.

7.            Google Analytics Blog
Google Analytics is the enterprise-class web analytics solution that gives one rich insights into the website traffic and marketing effectiveness. By following this Google Analytics Blog, you can stay updated with the newly introduced features and developments. It also provides tutorials to the new features of Google Analytics.
8.            Google and your business Blog
Expand your business by following the tips on blog page of Google and your Business. With the importance of online marketing increasing day by day, this blog page is like a blessing in disguise for all those who are struggling with their web marketing. This blog gives out amazing tips and tricks and other useful information to manage your business with Google solutions.
9.            Google Ads Developer Blog
Through the Google Ads Developer Blog, you can stay updated with news of Adwords, AdSense, DoubleClick, AdMob APIs and SDKs. Follow this blog for latest Ads developer product and feature announcements, case studies, and best practices, as well as opportunities to interact with and learn from the Google’s Ads Developer Relations team and other members of the developer community.


To know more on ideas behind Google strategies, and reasons behind Google logo change, along with other major brands, read this: https://www.edupristine.com/blog/whats-in-a-logo

Wednesday, 20 June 2018

Analysis of Facebook’s Acquisition of Whatsapp

The Irrational Rationale behind Facebook’s Acquisition of WhatsApp:
Defying all the theories of Corporate Finance and principles of equity valuation, Facebook recently announced acquisition of WhatsApp at a whopping valuation of $ 16 bn…yeah…you heard it right…it’s billion and not million. Add to that shares of Facebook worth $ 3 bn to be issued as restrictive share units to the employees of WhatsApp, the valuation hits the rooftop of $ 19 bn. In terms of magnitude, let’s look at the table below to get a hang of the valuation quoted for WhatsApp.
Facebook Buys WhatsappWhile we are still gasping for breath after going through the table above, let’s try to be rational and figure out what might have led Facebook price WhatsApp so high.
Irrational Rationale behind WhatsApp Acquisition
Even after spending some 10 hours and flipping through almost all the news articles, reports and analysts’ opinions, I could not figure out any rationale behind such a high valuation. However, I could think of various reasons behind this acquisition. Before we get into the shoes of Facebook’s CEO and start thinking (rationally or irrationally) like him, let’s understand a little bit about the two companies involved here. None of them needs any introduction. And almost all of us would have used / continue to use platform offered by one or both of them.
While these are the statistics that place Facebook as a very strong buyer in comparison to the Target, let’s look at the facts below as well to figure out the reasons behind this acquisition:
1. Highly Active Users Base
The users on WhatsApp are highly active given the level of activity reported in the exhibit above. Facebook in comparison, is losing its shine – this is what I feel after interacting with the many around me.
2. Fast Growing User Base
WhatsApp has demonstrated extraordinary growth in its user base probably unparalleled in history.
3. Complementarity offered by WhatsApp users base
WhatsApp user base is exactly what Facebook is looking for:
WhatsApp has a strong presence internationally and particularly in Europe, India and Latin America. These are also the regions where Facebook is trying to grow its base of users.
WhatsApp and other mobile messaging services are used by all age groups alike. They are widely used by teens and tweens, a group that has recently started dissociating itself from Facebook.
WhatsApp offers a very personalized one on one interaction platform which probably users of Facebook never got and always complained about.
The success factor behind WhatsApp is probably an early embracing of mobile technology. And this is probably the only factor behind Facebook’s struggle. They went public without any revenue from mobile devices. It is still looking to expand its mobile reach.
Although WhatsApp is more limited in its scope and capabilities to Facebook and Twitter, mobile messaging services are becoming competitors to traditional social networks.
4. Threat from Google
Facebook is a relatively new entrant in the internet technology / social media business ecosystem. It needed support / platform to fight the existing and stable players in the ecosystem like Google, Apple, Microsoft and Yahoo. Informal articles on internet suggest that Google attempted acquisition of WhatsApp in the past, even attempted to outbid Facebook after the deal was announced and ultimately even suggested WhatsApp to stay independent as it had been always in the past.
5. Attempt to become a diversified social media player
Facebook may be attempting to emerge as a social media conglomerate. It can aspire to become a dominant player with different tools like Instagram and WhatsApp in its arsenal. Each one does things that the other property can’t.
Intriguing, isn’t it? If you wish to add anything further to the blog, go ahead and post your thoughts in the comments section below!
To know the Business Model of Whatsapp, and the reasons behind why facebook buys whatsapp, read the blog: https://www.edupristine.com/blog/analysis-facebook-acquisition-whatsapp-part-2

Monday, 18 June 2018

career options after 12th

Now that you have cleared your class 12 examinations, have you given any thoughts on what you want to do next? If you are thinking of choosing a career in Commerce then we would say it’s a great choice. In India, Commerce has grown tremendously and is known for providing a wide scope of career options to pursue after class 12. It further gets wider with students realizing the importance of Commerce and the specialization courses associated with it. These courses not only give you an opportunity to grow and make an illustrious career but also help you become the top-notch in your professional career. But the question which troubles you is ‘What will be my career options after 12th?
It is not a compulsion that you need to have completed your Higher Secondary from Commerce only. A Science or an Arts’ student can also pursue these specialized courses after class 12. As it is rightly said “It’s not what you achieve, it’s what you overcome. That’s what defines your career”. All you need is dedication, hard-working spirit and self-confidence to face all the hurdles coming your way. Now let me throw some light on some of the most prestigious and industry respected career options you can opt for after class 12.

It’s no hidden truth that the present economy has tanked, besides this; the possibility for you to get your dream job in Commerce stream can be less due to the ever-increasing competition. As a matter of fact, companies do not entertain a fresher who’s just out of the college with minimalistic experience at hand, leaving your future and career options after 12th look bleak. Although you have ventured into the Commerce Stream expecting for a bright career and decent career prospects, the tough job market can be a stumbling block in the paths of your success.

Jobs in Commerce have seen a considerable increase in India, however qualifying for a particular job is anyway different. Undoubtedly, Commerce stream offers myriad of jobs in Accounting and Taxes, but qualifying for these sectors requires one to have good experience under one’s belt. Which is why if you are thinking to be an Accountant or a Compliance Manager, a graduation is just not enough. If you wish to pursue jobs after 12th, then you have to go beyond just bookish knowledge. For this, job-oriented commerce courses have sprung up in the recent times.

To know what are the courses after 12th, read this: https://www.edupristine.com/blog/courses-after-12

Sunday, 17 June 2018

How to Use the AutoSum Function in Microsoft Excel

Let excel do math for you regardless of whatever condition you are in. From planning the monthly budget of a common man to balance sheet of an organization, Autosum in excel is a one-click tool in Microsoft Excel that runs functions on a list of data. A handy yet powerful function in Microsoft Excel that can automatically add up a range of cells quickly by saving your time. It’s often faster than creating a formula when you have large sets of data to add up.
I prepared a list of data that I want to add up and let us see, how to do that.

  1. In the below scenario, we need to know how much sales we have done at the end of the year for individual location and let’s look how we shall use this AutoSum function.
  2. Instead of typing the sum formula, on the right hand side of the home tab, you will be able to find the option AutoSum. Now, click on the dropdown and you shall find several options such as sum, average, count, max, and mind. As we are looking up for the total, select the sum option
  3. When you chose the option of Autosum from the ribbon, it automatically guess the range of cells to be added. You can even change the range, it is mutable.
  4. Hit enter and you shall receive the sum of the entire column you have selected. There you go.

Likewise, you can perform other operations by selecting the respective option in the AutoSum dropdown.

Whether you are a multi millionaire sitting in your air conditioned cabin or a regular housewife doing her daily grocery shopping, one of the common task that is performed by both is adding the numbers. Yes, in one case we are talking about millions and in other a few hundreds but the point is, you require the adding functions irrespective of your position. AutoSum is one of the most commonly used functions Excel. Along with AutoSum you can also use the functions like Average, Max, Min etc. you can avoid using the formula by using the AutoSum function.

Things to remember while using AutsoSum function in Excel:

     Autosum can only go up or left, not right or down.
     You can also press ALT+= (on Windows) or Option+Command+= (on Mac) as an alternative to clicking the Autosum button on the toolbar.
     Autosum stops when it encounter an empty cell or a cell that doesn't contain a number.

     Autosum stops functioning when it hits any non-numeric value in your range. Strictly speaking, the Autosum formula will work but the error will stop it calculating the result

Wednesday, 13 June 2018

Explain Balance Sheet: Define Assets, Liabilities, and Net Worth

A Sample balance sheet is a financial statement which provides an idea of a company’s financial position. The ultimate purpose of the balance sheet is to disclose the financial position of the company at a given time. A balance sheet is mostly prepared at the end of accounting period like a month, quarter or year-end depends on the organization. For larger organizations, a balance sheet must be filled once in a year as a part of company’s statutory accounts. It does by outlining the total assets that a company owns and any amounts that it owes to lenders or banks. A standard company balance sheet has three parts as assets, liabilities, and owner’s equity. Let us discuss in detail as follows.

  1. Assets: Asset is anything that a company owns in order to generate income. This could be cash, property, equipment, inventory and so on. As asset is expected to be converted into cash. In a simple balance sheet, assets are indicators of company’s holdings. Assets are further classified into tangible and intangible assets. The tangible assets are further divided into current, long-term and other assets. On the other hand, the intangible assets could be trademark, copyrights etcetera. In a balance sheet, assets having alike properties are usually grouped together. A widely known approach is to bifurcate the assets into current assets and non-current assets.
      Current Assets: Current assets can be defined as the assets which include cash and the assets that could be converted into cash. Current assets are expected to be consumed within a year. Cash, cash equivalents, accounts receivable, prepaid expenses are some examples to mention.
      Non-Current Assets: Non-current assets are also often referred as long-term assets. Here, investments are known as the accounting year. Examples of non-current assets are buildings, land, machinery and all intangible assets.
While preparing a balance sheet, the currents assets are mentioned first and non-current assets later.
  2.     Liabilities: Liabilities can be defined as the amount that an organization holds. Liabilities are further divided into current and long-term liabilities on the balance sheet. Let us discuss them in detail.
      Current Liabilities: Current liabilities are the claims that are expected to meet within a year. These are accounts payable, accrued expenses, taxes payable, or by the provision of goods or services.
      Long-Term Liabilities: All liabilities that are not current liabilities are considered as long-term liabilities. These are the debts that must be repaid in more than a year from the date on the balance sheet.
  3.     Owner’s Equity: In the balance sheet, owner’s equity is often referred as a shareholder equity. This is also known as a book value. Owner’s equity can be considered as the net assets. It is the assets minus the liabilities. Any remaining value in assets can be attributed to owner’s equity.


The formula of the balance sheet can be defined as:

Assets = Liabilities + Owner’s Equity


How to prepare a simple Balance Sheet?

There are two formats to represent the balance sheet. In the account format the items are presented horizontally whereas, in the report format, the asset items are listed vertically.

Why is the Balance Sheet important?


A simple balance sheet provides a whole picture of the financial health of an organization at a given period of time. The balance sheet tells you the current value of your assets and the complete view of your business. A balance sheet could also serve as an indicator before any disaster occurs in the business. With the help of a balance sheet, you can analyze the following things such as, the general financial position of the business, productivity, and growth of the business and Warning signs that there is a threat ahead. 

Components of the Balance Sheet
The three major components of the balance-sheet that indicate what the company owns and owes are Assets, Liabilities and Owner’s Equity.

Assets:

Assets can be defined as the valuables that the company owns to benefit from or are used to generate income. They are the resources of the company that has future economic value. These are categorized into tangible and intangible assets. The tangible assets are further bifurcated into current, long-term and other assets. The non-tangible assets are the trademark, copyrights, goodwill to mention a few.

Current assets include the cash, accounts receivable, prepaid expenses and all that can be converted into cash within a year.

Long-term assets are also called fixed assets. They are distinguished from the current assets due to their longevity in generating revenues. All fixed assets except for land are shown on the balance-sheet at original cost less depreciation.

Liabilities:

Liabilities are debts owed by the business. These are claims of the creditors against the assets of the business. These are claims or obligations that arise out of past or current transactions. Liabilities are classified into current and long-term liabilities.

Current liabilities are accounts payable, accrued expenses, taxes payable, the current due within one year portion of long-term debt and any other obligations due within a year.

Long-term liabilities are debts that must be repaid by the business in more than one year from the date of the balance sheet.

Net worth (Owner’s Equity): Owner’s equity (called when it’s sole proprietorship) sometimes is also referred to as the book value of the company because owner’s equity is equal to the reported asset minus the reported liability.

Assets = Liabilities + Net worth, this can be reposed to yield the definition of net worth, which is the balance after the liabilities are subtracted from the assets of the business.