Posts

Showing posts from November, 2022
By Uma Bakshi -
Image
B.Com Business Analytics Business Applications For Emerging Technologies 2025-26 Q1. Use Microsoft Excel to solve the following: Use Microsoft Excel to solve the following. Download a company’s (TATAMOTORS.NS) financial statements like P&L, Balance Sheet, Cash flow etc for the past 10 years  to solve the following questions.  Download TATAMOTORS.NS financial statements calculate the year-on-year growth rate of revenue.  Create a bar chart to visualize the growth.  Forecast the revenue for next three years. Step 1: Download 10 Years of Financial Statements Best source (free): Yahoo Finance 1. Go to Yahoo Finance and search: TATAMOTORS.NS 2. Open the Financials tab → Income Statement 3. Switch to Annual 4. Copy the Total Revenue for the last 10 years 5. Paste into Excel like this:   Step 2: Calculate Year-on-Year (YoY) Revenue Growth Add a new column: =(B3-B2)/B2 Format as Percentage: • Select column C • Home → % (Percentage format)   Step 3...
Post a Comment
Read more
By Uma Bakshi -
Image
  Data Analytics Modelling Lab Notes (2022-23)(Q26-Q30) B.Com ( Business Analytics) Sem III V. Table for questions 26 to 30:           26.From the above table, remove the invalid phone number   which                are not in the proper format of having 10 digits, no characters                     and the phone numbers which are starting with 9/8/7/6           Step1: Copy the contents of phone number in a new sheet.           Step2: Copy the contents of phone number in another column.           Step3: Select the contents and go to conditional formatting.           Step4: In the drop down box , select Between.           Step5: In the dialogue box, fill it with 5999999...
Post a Comment
Read more
By Uma Bakshi -
Image
                                                                        Data Analytics Modelling Lab Notes (2022-23)(Q21-Q25) IV .  Table for Question No. 20-25           Q21:   From the above data in Excel, Concatenate the Headers.           Step1: Select the two rows in the header and copy the cells in a new               S heet ( in cells 2 nd and 3 rd rows)           Step2: Select Cell A6, right click and select paste special,           Step3: Select Transpose.           Step4: Select the cell C6, write the syntax           ...
Post a Comment
Read more
By Uma Bakshi -
Image
Data Analytics Modelling Lab Notes (2022-23)(Q16-Q20) B. Com ( Business Analytics) Sem III            III Table for Questions 16 to 20:                Q16:  Concatenate columns Street name and City.                Step1: Copy Street name and City columns in a new Sheet.                Step2: In C2 Cell write the syntax                               =PROPER(CONCATENATE (A2, “ , ”, B2))                Step3: Select C2 and drag down.                Step4: All the cells get concatenated.           Q17: Insert "C-" in the left side of the customer Id in customer name       ...
Post a Comment
Read more
By Uma Bakshi -
Image
  Data Analytics Modelling Lab Notes (2022-23)(Q11-Q15) B.Com ( Business Analytics) Sem III          I.  Table for 11-15 Questions           Q11: Remove blank Rows:           Step1: Select the table.           Step2: Click on Data Tab.           Step3: Click on Filter (Symbol)           Step4: Click on the Down Arrow next to Employee ID           Step5: Deselect all except the Blanks           Step6: Blank Rows will be displayed.           Step7: Select them and delete them           Step8: Click again on the down arrow of EmpID and select all.           Step9: Blank rows are removed.           Q12: Highlight...
Post a Comment
Read more