Secret to Professional Excellence

5 New Function needs to learn 1.Sort formula  when you sort salary and any data in the excel so we can do it by formal  Sort Function  =Sort(Table ) enter 2. Unique formula for data combination If have big data and some unique data you need to do separate  =Unique(area column ) Unique(area column, False,thue) enter 3 Xlookup formula  by Xolookup you can pull data as per as per requirement like Xlookup(subject,first column, Second column) enter Example - Candidate -ABCD, amount is 1,2,3,4 Requirement is need as what is C amount  C : Xlookup(Subject(C), First column ABCD, Second column Amount) enter=3 4 Filter Formula You have big data and you need candidate details specially salary  Like who's salary is above 50000 that list you can filter easy by formula =Filter(Select Table, Salary column>50000) enter if you need less then 50000 choose <50000 5 Sequence formula you need to update sequence in excel so you and update easy sequence number in the da...

 Macros - is excel technology where we can update big data, calculation, set formula etc  within time with accuracy. We need to understand what you need to work as per requirement. You can work by coding and macros recording. Macros recording -  1. On view tab, in the macros group, click on macros command. 2. Click on record macros  3.  In the record macros  dialog box:b Enter a macros name. Choose a name that clearly identifies the macro. You may not use spaces. Enter a macros name. You will be able to run the macro using this shortcut key. Choose where to store the macro. You will normally accept the default. Enter a description. Briefly explain what the macro does. 4. Click on ok After clicking ok, every keystroke us recorded 5. To stop recording and view macros  tab Coding-  1 create macros-  With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple  macro. 2. The MsgBox...

MSME Product as per new Budget  We are proposing certain changes to benefit MSMEs. We are increasing duty from 10% to 15% on steel screws and plastic builder wares. On prawn feed we increase it from 5% to 15%. We are rationalizing exemption on import of duty-free items as an incentive to exporters of garments, leather, and handicraft items. Almost all these items are made domestically by our MSMEs. We are withdrawing exemption on imports of certain kind of leathers as they are domestically produced in good quantity and quality, mostly by MSMEs. Agriculture Products To benefit farmers, we are raising customs duty on cotton from nil to 10% and on raw silk and silk yarn from 10% to 15%. We are also withdrawing end-use based concession on denatured ethyl alcohol. Currently, rates are being uniformly calibrated to 15% on items like maize bran, rice bran oil cake, and animal feed additives.  There is an immediate need to improve agricultural infrastructure so that we produce mo...

  An additional tool within the Pivot Tables feature set are ‘Slicers’. Slicers are graphical filters ideal for analysts or customers who like to examine data from many different perspectives. Timeline Slicer -   1. Open the AirlineParts.xlsx spreadsheet and highlight cells A1:F3889 2. From the Ribbon select INSERT : PivotTable 3. Verify the ‘New Worksheet’ radio button is selected 4. Click the ‘OK’ button Advanced Filtering In the first part of this chapter we reviewed how Slicers may be used for quick filtering. In this section we’ll demonstrate how to employ additional Pivot Table features which allow us to extend our analysis by specifying conditions. Please find below types  1. The top 10 airplane parts sold by category? 2. The bottom 10 airplane parts sold by category? 3. The top 10 airplane parts sold by Quarter? 4. How many parts sold more than 800 in quantity? Similarly we may change to show the bottom 10. 9. Click the drop-down arrow of ‘Row Labels’ 10. Fro...

Who contribute over 20833 a month  to PF Will be taxed encluding valuntory PF. including taxing interest earned by provident fund contributions above Rs 2.5 lakh a year at normal rates. This will only apply to the employee's contribution and not that of the employer. "In order to rationalise tax exemption for the income earned by high income employees, it is proposed to restrict tax exemption for the interest income earned on the employees' contribution to various provident funds to the annual contribution of Rs 2.5 lakh. This restriction shall be applicable only for the contribution made on or after 01.04.2021," said the Finance Minister.

  MACRO-ECONOMIC FRAMEWORK STATEMENT 2021-22 Overview of the Economy The Indian economy was negatively impacted by an unprecedented health crisis in  2020-21 with the highly contagious corona virus (Covid-19) spreading across the  country. In response to the pandemic, Government has taken several proactive preventive  and mitigating measures starting with progressive tightening of international travel, issue  of advisories for the members of the public, setting up quarantine facilities, contact  tracing of persons infected by the virus and various social distancing  measures. Government imposed a strict 21 days nationwide lockdown from 25th March,  2020, under the Disaster Management Act, 2005, with subsequent extensions and  relaxations, to contain the spread of Covid-19 while ramping up the health infrastructure  in the country. The lockdown measures, imposed to contain the spread of Covid-19  pandemic in India, ubiquitously affec...

  Dash Board designing - We can  show big data's information simply and important bullets which details will be in excel sheet.  Dash board explains simply and clear  understanding about professional details/ information to our senior  or Management department, massive help to acquire relevant details or data to present professionally, It is important and becoming successful career. Dashboard we can make as per help of Pivot table, Please find below whole knowledge for Pivot and dashboard Regarding. What is Pivot Table- Pivot Tables are a feature within Microsoft Excel that takes individual cells or pieces of data and lets you arrange them into numerous types of calculated views. These snapshots of summarized data require minimal effort to create and can be changed by simply clicking or dragging which fields are included in your report.  By using built-in functions and filters, Pivot Tables allow you to quickly organize and summarize large amounts of data. ...