Creating a Table
Using OFFSET and COUNTA Functions
PEMDAS Rule
Parenthesis
Exponentiation
Multiplication/Division
Addition
Subtraction
FORMULA – is a statement which written by the user for calculations. Ex: =1+2+3
FUNCTION – is a built-in formula by Excel. Ex: =SUM(1+2+3)
Slicer – is used to filter the Table, Pivot Table data visually.
Timeline – is used to filter the dates interactively by Year, Month, Quarter, and Day.
COUNT – Counts the number of cells that contain only numbers except for blank cells.
COUNTA – Counts the number of cells which contains alpha-numeric except blank cells.
Q9)Is it possible to make a single Pivot Table for multiple data sources? Yes, it is possible. Using the Pivot Table Data Modeling technique.


Description
new sample description here