Popular posts from this blog
Assignment of removing duplicate data and if condition formula
Remove duplicate data 1. Go to data option in menu bar. 2. Select the data in which you want to remove duplicate items. 3. select the duplicate remove option which is situated next to the columns. Then dialogue box will appear which is shown following below :- OUTPUT:- If condition formula In Excel, you can use the IF function to perform conditional logic. The basic syntax is: = IF (logical test, value_if_true, value_if_false) logical test: The condition you want to evaluate (e.g., A1 > 10). value_if_true : The value that will be returned if the condition is true. value_if_false : The value that will be returned if the condition is false. Example 1: = IF (A1 > 10 , "Yes" , "No" ) If you want to check if the value in cell A1 is greater than 10, and return "Yes" if it is, or "No" if it isn't: Example 2: If you want to check if the value in A1 is greater than 50, and return "High" if true, or "Low" if false, you can d...
POWER BI
What is Power BI? Power BI is a business intelligence tool of Microsoft that is mainly designed to curate and present data insights that are most intriguing and engaging. It is a versatile tool that can easily derive data origins, including cloud services and Excel spreadsheets. Power BI is used by many businesses to create better visualization of data through charts, graphs, and other data interpretation techniques. Discover the art of Power BI more through the CCSLA exclusive PL-300: Microsoft Power BI Data Analyst course to gain valuable insights from industry leaders. Furthermore, Power BI offers data refinement and structuring to enable the development of reports, presentations, and interactive dashboards. The Power BI works at its total capacity to convert data, clean it, and make it more appealing using visual elements. It facilitates sharing and collaboration using cloud services. It helps them to cooperate reasonably in the team and make data-driven decisions...
Comments
Post a Comment