Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

c. Using a pivot table is one convenient way to make a categorical frequency table in Excel. Especially, if you don’t want to go into formulas. With this in mind, follow these steps to make a categorical frequency table from our dataset.

d.See how to customize Excel ribbon with your own tabs and commands, hide and show tabs, rename and rearrange groups, restore the ribbon to the default settings, back up and share your custom ribbon with other users.

f. On the home tab, in the Styles subgroup, click on Conditional Formatting→New Rule. Now select Use a formula to determine which cells to format option, and in the box type the formula: D3>5; then select Format button to select green as the fill color.

g.

• Converting Dates in Serial Format to Month-Day-Year Format
• Converting Dates in Month-Day-Year Format to Serial Format
• Obtaining Today's Date
• Finding a Workday after specified Days
• Customizing the Definition of a Weekend

h.

• If you use the SUM() function in a SELECT statement that returns no row, the SUM() function returns NULL, not zero.
• The DISTINCT option instructs the SUM() function to calculate the sum of only distinct values in a set.
• The SUM() function ignores the NULL values in the calculation.

i. =Text(Value, format_text)