Biz_Excel

Do you know you can insert a row in Excel sheet automatically by pressing ALT-H-I-R in an Excel sheet

Digging into Olympic history datasets.
The female and male participant across the Summer and winter.
The records of the country with highest successful participant in all categories of the events schedule by the Olympics.
The most successful Athletics based on the country represented.
All the task being analyzed and visualized on a Dashboard.

Scatter and bubble plots
SCATTER and BUBBLE charts display two or more data dimension simultaneously. it can be used to help to identify correlation between two variables.
SCATTER chart is a plot of individual points that display the relationship between two sets of BUBBLE chart is a scatter with the addition of size data for the points depicted. Dimensions for bubble charts include the point label, the X-axis position, the Y-axis position and point sizes.

We all tossed a dice untill the outcome turn 6-6.
God bless us all
Keep believing

Line charts/graph are used to track changes over short & long periods of time, when smaller changes exist, line graphs are better to use than bar graphs.
It can also be used to compare changes over the same period of time for more than one group.
Ex: Average price by hour, profit by quarter.
Note: Line and column charts can be used to trend two variables over time.

Bar and column chart are used for comparing numerical data across categories or to track changes over time between different groups. E.g Sales by product, Income by Age etc.
The difference between bar and column chart, bar chart is oriented horizontally, where as a column chart is oriented vertically.
BAR CHART are suitable for displaying long data labels while COLUMN CHART are good for displaying large number of DATA sets on category axis or data sets with Negative/inverted.
Note: BAR CHART used when the DATA labels are long or so many DATASETS to display.

Do you know that formatting a data structure as table helps a lot?
👉 It helps to field up new more figure/data to the data structure formatted as table before.
👉There won't be any need to stress or build the calcs in the analysis from scratch again

Wow 😲 Am happy to close first deal with the client.
He asked me to help him dig deep on data comprises of 4 agents across the region in the state stating he wish to know how the agents drive in sales in respect to each of the year from 2015-2018 knowing the type of products and how the customer which to pay for the product.

.

Quick tips on Sumifs/sum-if function in Excel?
Sum-if allow to sum a value/measure on a single category while Sumifs allow to sum in multiple categories.
The syntax is
Sum-if =(Sum-range, Criteria-range,range)
Sumifs =(Sum-range, Criteria-range, range1,...., Criteria-range (n), range (n) ).
Sumif/Sumifs it's like calculate in Dax function.