Day 22 - Ideas in Excel !!! Ideas in Excel will analyze your data, and return interesting visuals about it in a task pane.

Simply click a cell in a data range, and then click the Ideas button on the Home tab.

Ideas in Excel will analyze your data, and return interesting visuals about it in a task pane.

These visuals can then be inserted into the workbook



Ideas in Excel



#RR #Day22 #Microsoft365 #Excel #Ideas #NewFeature #HappyLearning #WeLearnEveryday

Comments

Post a Comment

Popular posts from this blog

DAY 31 - Organize a Secret Santa Game in your organization using a Python Script

Image
 The script will  perform below mentioned activities: 1.      Assign a Secret Santa randomly to each participant 2.      Save the final extract into an excel file 3.      Send an automated mail to each Secret Santa with a complete address details of his/her Secret Santa Child   Sample final extract file: Sample Mail Format: Prerequisite: 1.       Collect information of participants in an excel file as shown below. 2.  Click on “Manage your Google Account” > Security > Less secure app access Turn ON access for less secure app Note - This setup is required to send a mail from Gmail using Python script   Python Script: # -*- coding: utf-8 -*- """ Created on Wed Dec 2 12:15:58 2020 @author: Rakesh.Ranjan """ import random import pandas as pd import numpy as np import os import string  ss_keys = [] ssc_values = [] input_file_name = "Secret Santa - Information needed-Tes...
Read more

DAY 10 - Python Program to Print the Pascal’s triangle for n number of rows given by the user

DAY 10 - Python Program to Print the Pascal’s triangle for n number of rows given by the user It's the very basic problem statement in python. Following is an 5 level Pascal's triangle: Sample Input: 5 Sample Output: [1] [1, 1] [1, 2, 1] [1, 3, 3, 1] [1, 4, 6, 4, 1] Solution: import pandas as pd import numpy as np n=int(input("Enter number of rows: ")) nested_list = [] for i in range(n):     k = 0     nested_list.append([]) # keep on adding a new list in each iteration of i     for j in range(i+1):         #keep on appending list[i]         if i <=1: # logic for 1st and 2nd list            nested_list[i].append(1)         else: # logic for 3rd list onwards             if j == 0: # fisrt element of list[i]                 nested_list[i].append(1)      ...
Read more

Day 24 - Use ODBC driver to connect to Oracle/SQL Server DB from POWER BI Desktop

Image
Open Database Connectivity (ODBC)  The ODBC Driver for Oracle enables an application to access data in an Oracle database through the ODBC interface. Step 1 : Install ODBC Driver  Step 2 : Open ODBC App and Navigate to 'User DSN' > 'Add' to add a new connection Step 3:  Select option - 'Oracle in OraClient.......'  to add a new oracle DB connection. Please enter details as shown below. Click on Test Connection and enter DB password to test DB connection. You would get below message if connection is successful . Step 4: Launch Power BI Desktop and Navigate to Get Data > ODBC > Connect  Select DSN  which you have just configured in above step. To avoid extra delay, it's a good practice to enter SQL statement to fetch relevant data from DB. Click on OK Step 5 : Enter user name and password to fetch data from Oracle DB Step 6 : Tada    🎉   🎉 Able to access Oracle DB successfully from POWER BI Desk...
Read more