Which are the Important Excel Functions and Formulas Needed for Business Analytics

Published on :

As a business analyst, you must know the Excel functions and formula thoroughly. After working on something for hours, if you choose an incorrect formula, data analysis fails. It might seem easier to do a manual calculation than falling into the trap again.

Excel has over hundreds of formulas and functions. It is overwhelming to find the right match for correct analysis. However, if you get the basics right, it shouldn’t be a problem.

#1: SUMIF

In an Excel sheet, you can add cells easily. However, if you want additional cells only under certain conditions, SUMIF function can help.

It allows you to get the sum total of a range only after fulfilling certain specific criteria. If you want to add multiple conditions, use SUMIFs.

Simply put, there are many such logic functions in Excel, which you can use according to a requirement. For example, Excel IF, AND, OR, …

How Stock Market News Affects Your Trading Strategy

Published on :

News is an integral part of any financial market. It can tell the buying or selling of shares, signal when interest rates will rise or fall and even effect the behavior of investors in general. The role of the stock market is further explored further by looking at what kinds of news the marketplace provides. News related to companies in the manufacturing, construction, oil and gas, financial services and technology sectors are very critical to investors overall health. While the importance of the market for overall economic stability cannot be disputed, specific news is relevant to each sector’s ability to respond to its shifts in the environment.

In today’s financial markets technical analysis relies on watching stock market news to attempt and determine what direction that a particular stocks’ stock is moving in. Technical analysts spend long periods of time charting stock prices and noting trends and movements. The role …

CBSE Appointed Manoj Ahuja as New Chairman

Published on :

The Central Board of Secondary Education (CBSE) has got a new Chairman for the board. Manoj Ahuja, IAS was appointed as the new chairman as a part of a major bureaucratic reshuffle effected by the Centre on 12th May 2020. Manoj Ahuja has replaced his successor Anita Karwal.

CBSE has made this announcement by officially releasing the statement, “CBSE gets new Chairman Manoj Ahuja, IAS (OR:90), Special Director, Lal Bahadur Shastri National Academy of Administration, Department of Personnel and Training.” The Board has also shared this information through a tweet.

From now onwards, Manoj Ahuja will take charge of class 10 and 12 board exams. He will also look towards the remaining board exams which will commence between 1 to 15 July 2020. You can learn more about with CBSE here. In this article, you will know all about the organisational structure of CBSE.

Organisation Setup of the