Up and Running with Basecamp

Project Management is a field where extensive communication and collaboration with the team comes in handy to deliver projects as good as masterpieces. To outshine as a successful Project Manager, use the Basecamp—a cloud-based online project management tool. You can set up a project in Basecamp and track tasks. Since communication is an important part, one can level-up by adding people to the project for communication and manage the message board. File storage, as part of data maintenance, forms another vital part of the aides provided by Basecamp. While these are all that Basecamp enables the users at, we would now learn about the features or advantages of the Basecamp tool.

Basecamp comes in very handy, as project creation becomes a cakewalk using this tool. It helps you create a notepad sheet is created when you create a project. Since project management is about team management as well, one can add team members and their details, while keeping them informed about every progress. This also keeps the process and status transparent. It is easy to be a manager when you have time to look at other details and using the feature of Basecamp, you can add administrators for the projects; keep it on rotation to keep it fair. Keeping and then maintaining a To-do List is also very necessary and for this Basecamp allows you to even send progress enquiry mails to the team members, allocate due dates, and assign tasks. Discussions keep is handy so using the Basecamp you can hold fruitful discussions and brainstorming session which will show up on the home page. The project information or follow-up mails also become an easy task. 

There must be times when project managers wish to create project related documents that can be simultaneously be worked on by multiple users, and for this, Basecamp is the go-to name. Not only can the user create documents, but having issued rights, these very documents can become easy trackers. And the cherry on the cake, you can use these sheets on your mobile device with equal ease. Then the next worry is maintaining a calendar. A true cumbersome task it is! But not if you use Basecamp. Not only does it remind of timelines and deadlines that you feed it keeps all event-related information unforgettable too. Since you have been able to take care of deadlines and events using the Basecamp, time for us to tell you that each milestone you touch or aspire for (through the To-do list) is also made easy by the online tool. To achieve these milestones, Basecamp keeps you informed about the tasks they are working on, the dates and timelines they have, and the open and closed tasks; all of this, using a viewer-friendly calendar view mode.

There is a few more advantage, like the Everyone tab to check status and role of people involved in a project, and Everything tab gives a summary of the project work. It is Apple-friendly, and Basecamp comes with 3rd party integrations enabled and a strong security system that includes firewalls, daily backups for major systems, data encryption, and surveillance. But is it all hunky-dory about Basecamp and no flaws? We will not be dishonest and admit there are a few. These flaws are like no creation of Gantt charts and task interdependencies, not many accounting related features, and an ever-preventing security issue with storing data on the cloud.

These are a few, hence the Basecamp is a huge hit and a must-go-to. There are, however, a few pricing details that you need to look at and pay for the active programs.

How to use the Excel HLOOKUP function

HLOOKUP in excel expectations scans for an incentive in the main line of a table. At the match segment, it recovers an incentive from the predefined push. Utilize HLOOKUP when query esteems are situated in the main line of a table. Utilize VLOOKUP when query esteems are situated in the principal segment of a table.

Summary

HLOOKUP is an Excel capacity to query and recover information from a particular line in table. The "H" in HLOOKUP remains for "level", where query esteems show up in the primary line of the table, moving on a level plane to one side. HLOOKUP bolsters inexact and correct coordinating, and special cases (* ?) for discovering incomplete matches.

Purpose

Query an incentive in a table by coordinating on the main column

Return value

The coordinated an incentive from a table.

Syntax

=HLOOKUP (esteem, table, row_index, [range_lookup])

Arguments 

esteem - The incentive to gaze upward.

table - The table from which to recover information.

row_index - The line number from which to recover information.

range_lookup - [optional] A boolean to demonstrate correct match or inexact match. Default = TRUE = rough match.

Utilization notes

HLOOKUP scans for an incentive in the primary column of a table. At the match segment, it recovers an incentive from the predefined push. Utilize HLOOKUP when query esteems are situated in the principal column of a table. Utilize VLOOKUP when query esteems are situated in the principal section of a table.

Range_lookup controls whether esteem needs to coordinate precisely or not. The default is TRUE = permit non-correct match.

Set range_lookup to FALSE to require a correct match.

On the off chance that range_lookup is TRUE (the default setting), a non-correct match will cause the HLOOKUP capacity to coordinate the closest incentive in the table that is still not as much as esteem.

At the point when range_lookup is excluded, the HLOOKUP capacity will permit a non-correct match, yet it will utilize a correct match on the off chance that one exists.

In the event that range_lookup is TRUE (the default setting) ensure that query esteems in the main line of the table are arranged in climbing request. Something else, HLOOKUP may restore a mistaken or surprising worth.

In the event that range_lookup is FALSE (require correct match), values in the main line of table don't should be arranged.

Top 10 Business Analyst Job Interview Questions

A Business Analyst job interview Question is a person who investigations and attempts the assignment of understanding changing business needs, surveying the effect of those progressions on business, breaking down and archiving prerequisites, supporting the correspondence procedure and conveyance of necessities with applicable partners. The part of a Business Analyst is frequently observed as a correspondence connects amongst IT and the business partners. The International Institute of Business Analysis (IIBA) depicts the part as "a contact among partners so as to comprehend the structure, arrangements, and activities of an association, and to prescribe arrangements that empower the association to accomplish its objectives."

Presently on the off chance that you have a Business Analyst Interview arranged for yourself, by what means will you plan for it? Simply robbing up the ideas of Analytics and a satisfying identity will push you to a specific degree. In any case, imagine a scenario where you know a portion of the inquiries that you can expect in the meeting. Won't that be cool? So ease your pressure, comprehend the inquiries and know the responses to it and tune yourself up for the enormous day.

1) What is a flowchart and why it is more important?

A Flowchart demonstrates the entire stream of a framework through images and outlines. It is essential since it makes the framework straightforward for engineers and also nontechnical partners.

2) Define Use Case Model?

Utilize case display demonstrates an arrangement of occasions and stream of activities with respect to any procedure performed by a performer.

3) What does UML remain for?

It remains for Unified Modelling Language.

4) Do you think Activity Diagram is imperative and how?

As the name infers, an action graph is about framework exercises. The principal reason for movement outline is to demonstrate different occasions occurring in an association in various offices.

5) Can you name the two sorts of charts intensely utilized as a part of your field?

The two outlines are Use Case Diagram and Collaboration Diagram

6) Do you know what is implied by a substitute stream in a utilization case?

It is the elective arrangement or movement in a utilization case that ought to be followed if there should arise an occurrence of any disappointment in the framework.

7) What are exemptions?

These are the unforeseen circumstances or results in an application.

8) What are expands?

Expands are moves that must make put in a utilization case.

9) Name the two archives identified with a utilization case?

The two archives are FRD (Functional Requirement Document) and SDD (System Design Document).

10) What is the distinction between Business Analyst and Business Analysis?

Business Analysis is the procedure performed by the Business Analyst.

FMGE vs USMLE

Most of the medical students are confused about FMGE and USMLE . So here we try to clear their doubts or confusion for the same. FMGE (Foreign Medical Graduates Examination) is also known as Medical Council of India Screening Test. It is a licensure exam conducted by National Board of Examination (NBE) in India. This is a mandatory test for a medical student who has done his medicine from a college outside India to practice medicine in the country. Unlike FMGE USMLE (United States Medical Licensing Examination) is a three-step exam for all IMGs (International Medical Graduates) who wants to pursue their medical career in the United States.

What is FMGE?

FMG is a condensing for a Foreign Medical Graduate, an understudy having an essential medicinal capability granted by any restorative foundation outside India. Though a FMGE – Screening test is shortened for outside medicinal graduate examination-screening test, which a FMG needs to go for acquiring a temporary or changeless enrolment with Medical Council of India or any State Medical Council.

Benefits of FMGE:

The 5 – 6 years that understudies avoid their family and nation to seek after the fantasy of turning into a medicinal graduate is fragmented until the point when they qualify the FMGE-Screening test. The FMGE empowers them to rehearse in India, following a time of temporary position.

What is USMLE?

The United State Medical Licensing Examination comprises of three exams; STEP1, STEP 2CK, STEP 2 CS and Step 3. A candidate needs to qualify all these exams for acquiring licensure in United States. For International Medical graduates (IMGs), the Education Commission for outside Medical Graduates (ECFMG) assesses the restorative capability of IMGs, their therapeutic school and furthermore directs USMLE STEP 2CS.

Benefits of USMLE:

In the wake of finishing USMLE you can;

• 1.       Apply for residency and partnership in USA
• 2.       Attain life time legitimacy of ECFMG declaration The Education Commission for outside Medical Graduates")
• 3.       Obtain acknowledgment to work in New Zealand, Canada, Australia, Dubai as well as Qatar
• 4.       Avail better scholastics and research offices
• 5.       Fasten green card handling

Career and Scope After B.Com

Graduation is the most important step in your career. But if you have a little bit idea about the what’s going on in the market, then only graduation is not all in your career. Yes, we’re talking about your B.Com. You chose B.Com because you feel that you have inclination toward business and commerce and to be precise, for accounting. Just completing your B.Com even with a great score will not ensure success in accounting career. You need to think farther and you need to be on your edge.

The Most Common Choices

Chartered Accountant (CA)

Most demanded careers that cross every commerce student’s mind is CA. CA exams are conducted by Institute of Chartered Accountants (ICAI) and require one to clear 3 Examinations over the period that are CPT, IPCC and Final CA. Since you are done with your graduation, you are eligible to directly appear for IPCC which consists of two groups. A student is required to register for articles with experienced CA’s for a period of two and a half years after clearing one of the groups. Later, clearing both groups of IPCC and successfully completing your articles you can appear for Final CA. Final CA again has two groups and after clearing both the groups, you will be ready to affix the words CA before your name.

Master of Commerce (M. Com)

Wondering the next step after the B.Com? I am sure most of you go for M.Com. It is most common for students going for the master’s degree in commerce after completing B.Com. It is a two-year program and you can pursue it from any of the recognized institutes. M.Com is a program that focuses on systematic study of Accounting, Business, Finance, Economics, Statistics, Taxation, Marketing and Management and therefore it gives insights about all the fields.

Master of Business Administration (MBA in Finance)

There are individuals who will encourage you to seek after MBA. A decent profession in MBA thoroughly relies upon the validity of the organization that you are seeking after from. On the off chance that you are an IIM understudy then achievement will tail you to your doorsteps yet doing MBA from a common and very little prestigious foundation will just add numbers to the rundown of jobless MBAs. The aftereffects of your CAT exams decide the organization where you can seek after the MBA program. It is a two-year program on finishing of which you can without much of a stretch land position in budgetary administration division. Let’s go International.

Certified Management Accountant (CMA)

In the event that you have plans of going worldwide or working in the Top MNCs at that point going for global accreditations is the correct decision for you. The CMA is offered by the Institute of Management Accountants (IMA) USA and the substance is consistently inspected by the Institute of Certified Management Accountants (ICMA). To end up a CMA, an understudy is required to clear two examinations. CMA shows your expert mastery in monetary arranging, examination, control, choice help, and expert morals – settling on you the favored decision of the potential managers.’More Details about CMA course

Certified Public Accounting (CPA)

A Certified Public Accountant (CPA) is the most astounding standard of skill in the field of Accountancy over the globe. The exam is managed by the American Institute of Certified Public Accountants (AICPA), which is the world's biggest bookkeeping body. A CPA capability is like the Indian CA capability. Notwithstanding the CA capability, a CPA will know about US Generally Accepted Accounting Principles (GAAP), IFRS (International Financial Reporting Standards), Generally Accepted Accounting Standards (GAAS), US government tax assessment and business laws. This gives awesome favorable position to a CPA when working with US Based Financial firms or Indian firms working for US customers. This exam comprises of 4 exams which can be finished inside a time of not as much as a year. Seeking after CPA in the wake of finishing CA, M. Com, CS, MBA in fund, ICWA can likewise push your vocation as it were.

All you need to know about IPO?

What is IPO?

Initial Public Offering (IPO) is the stock of a private company is offered to the general  public and IPOs are often issued by younger, small companies seeking capital to expand, but they can be also be done by large privately owned companies looking to become public traded.

How a company offer IPO?

Company before it becomes public hires an investment bank to handle the IPO. Later, along with the underwriting agreement they use, they file the registration statement with SEC. SEC scrutinizes the disclosed information and if found right, it allots a date to be announce the IPO.

Why a company offer an IPO?

Offering an IPO is a money-making exercise. Every company needs money to invest there business, it maybe to expand, to improve their business goal, to better the infrastructure, to repay loans, etc.

Company going public means that can be brand has gained through success to get the name flashed in the stock exchange. It is a matter of credibility of a company.

Should you invest in IPO?

We are deciding whether to put your money into an IPO of a relatively Start-up company is indeed a investment to grow their business. Being a sceptic is a positive attitude to have in the stock market.

The Background checks

Obviously, company does not have an enough data to back your decision, because it is just going public now. you need to scrutinize it. fund management team and their plans of IPO generated fund utilization.

Who is underwriting

The process of underwriting is raising investments by issuing new securities. Be cagey of the underwriting of small investment banks Usually, an IPO with a success potential is backed by big brokerages that can endorse a new issue well.

Lockup periods

Often IPO takes a deep downtrend after the IPO goes public. The reason behind this fall of the share price is the lockup period. After the lock-up period ends, the share price experiences a drop in its price.    

Flipping

Flipping is reselling a hot IPO stock in the first few days to earn quick profit. The reason behind this is that companies want long-term investors who hold their stock, not traders.

What are various career opportunities after M.com?

1. Career opportunities available in private sector : Lots of career opportunities are available for m.com graduates in the Finance and Account section of Fast Moving Consumer Goods (FMCG) companies like Hindustan Unilever Ltd, Nestlé India, Cadbury India, Procter & Gamble Hygiene and Health Care, Asian Paints (India) etc. M.Com graduates can take up any of the following job roles available in these companies and earn a salary between Rs. 1,00, 000/- and Rs. 6,00,000/- per annum. Post that can be held are:

Assistant Manager

Company Law Assistant

Junior Accountant

Relationship Manager

Sales Officer (Accounts)

With experience, they can move up to the position of Senior Accounts Executive, Senior Executive of Corporate Sales or even ERP Functional Executive.

2.) They can also find following lucrative career opportunities in Insurance companies like Bajaj Allianz Life Insurance Company Limited, SBI Life Insurance Company Limited, HDFC Life Insurance Company Limited etc.

Accountant

Book Keeper

Cashier

Financial Analyst

Mutual Fund Broker

Budget Analyst

Internal Auditor

Securities Analyst

Salary offered to mcom graduates in these jobs are between Rs.1, 00, 000/- to Rs.7, 00, 000/- depending on the type of company. Private Banks like HSBC, Max New York Life, HDFC etc. also recruit these postgraduates for the post of credit officer, loan officer or accounts officer with a salary up to Rs. 5, 00, 000/- per annum.

3. After Clearing UGC NET exam you are eligible for becoming professor in any university. Your experience will make you future more glorious.

4. PHD is another option after which one can pursue you research and even you can go abroad based on your research.

5 Business Intelligence Tool Attributes to Look for in Effectively Drill Into Big Data

Back in the day, when technology wasn’t very advanced, almost every business leader relied on basic scientific studies and statistics to predict trends about consumer behavior. However, Internet has gained traction, and business has become more and more global. Every day, wealth of information is derived from social media, and mobile phones. Data has begun to surge and enter the business lexicon. It was, therefore, important for every business leader to keep pace with new technology and understand the importance of the new medium, Big Data. To keep a track on Terabytes, Petabytes, Exabytes of data, and ascertain predictive information, Data Scientists are winning favor from the best employers of the world.

Why Big Data Is The Next Big Thing?

Recent research states that business that utilize Big Data analytics perform 26% better than their counterparts. Big Data analytics can help enterprises take concrete decisions to actually experience best business results. Following are the key areas where Big Data is profoundly being used.

Stock Market:

Big Data is now proving to be fruitful for companies that are forecasting with stock market applications. Data extracted can help in identifying new challenges and opportunities in the market.

Health Care Industry:

Large quantities of data help the Health Care Industry to identify drug interactions, social and economic factors that impact the outcome of treatments. Big Data can help doctors in detection of the onset of a disease before time that would lead to reduced mortality rates and better quality of life.

Retail:

Big Data can lead to better customer experience and enhance productivity in business.

Banking, Finance and Insurance:

By using Big Data it is easy to detect fraud and eliminates wrong actions during online financial transactions.

Telecom Industry:

Big Data can help Telecom companies to study subscriber persona and their usage patterns, which can help in devising marketing campaigns to find favor with them.

Politics:

Big data revolutionized the way American politicians win elections. This allows campaigns to identify their most likely voters and target them with ads and favorable content.
 
Read how Cambridge Analytica has been using Big Data for many political parties all over the world. Click here.

Here are some exam guidelines for CFA from EduPristine.

Exam Marking Strategy

To increase your chances to pass the exam it is very important that you get more than 70% marks in the high weighted subjects namely FRA, Ethics, Fixed Income, Economics; Corporate Finance. The CFA Institute gives very high priority to Ethics so a more than 70% score can give you an edge.

Last Day Tips

·         Go through your revision Notes or Formula Charts, and Summarize Recordings

·         Don’t try to discuss new topics with friends. Instead, focus on the material that you have referred

·         Be calm on the last day before the exam. Don’t take too much stress on the last day by working late in the night. The exam is very long and requires stamina and energy. So on the last day take it easy. Revise the formulae; see a few questions (especially those in the mock test). But sleep for a comfortable duration so that you don’t feel tired on the D-Day.

Before the exam, check

·         Take your Financial Calculator

·         You have at least 4 pencils, 1 Eraser & 1 sharpener with you

·         You have the Exam Admission Ticket on clean, unused paper and Passport.

CFA Level I Exam Day Strategy

·         Morning Exam Time 9 am to 12pm: 120 questions are given subject wise i.e. 1.5 minutes for each question

·         Afternoon Time 2pm to 5pm: 120 questions are given subject wise i.e. 1.5 minutes for each question

·         Allocate time to questions and make sure that you maintain the pace. Don’t get stuck on a particular question and since all questions have equal weight, so give equal importance to all questions

·         Make sure that you mark the questions as soon as you do it. Don’t keep this till the last moment. There are few problems in keeping it till the end. What if you mark 1 of the questions not in the right manner? It would change the sequence of filling for all questions. Also, during the last 10-15 minutes, you have the maximum efficiency. So if you waste that time in marking, it reduces the overall attempt percentage by at least 3-4%. In short, keep marking the answers as soon as you have done it. Don’t wait for marking till the end

·         Submit your Test on Time, don’t get into an argument with the Invigilator (Proctor), he/she can report misbehavior to the CFA Institute and your Exam results can be delayed or canceled

·         Don’t get involved in cheating or copying from fellow students, There are more than 300 such cases every year when the CFA institute either delay your result or cancel your exam or debar you from writing the Exam in future

·         In practical questions, they might give a lot of numerical values and information, wherein few are given just to confuse you and will not be used in solving the question

·         Make sure that you go through the complete paper. Sometimes the easy questions are given towards the end

·         Remember that sometimes the choice can be calculated using elimination. Try to see the choices and figure out the choices that would clearly not be the solution.

One point to note is that this is a relative examination. So if you are finding it difficult (and assuming you had prepared it to the best of your satisfaction), then rest assured everybody would be finding it difficult! So the key is now to best achieve whatever is possible. You have to do better than your peer.
 
Read last minute strategy for CFA Level 1 Paper. Click here.