Skip to content

Latest commit

 

History

History
67 lines (23 loc) · 1.62 KB

Function.md

File metadata and controls

67 lines (23 loc) · 1.62 KB

I studied many function such as :

  • If statment with ISBLANK Condition.

  • Concatenate

  • Convert for data type.

  • F2 : rename the cell

  • Copy data: When work in data in Excel , we just make copy for our original work by using ...copy and move OR ctl+ grag + drop

  • Make subdata for treemap

Lesson 7.1 Building basic charts visual

image

.

.

image

  • Make the replace window to show the impact in the other application programe

  • Make some pivote tables

  • Make Pivote table and modify it by using ( cell format)

  • Make Slicer: to give them nice filter ....From Analyze tab we use slicer for all available field (( sure when use ctl key we can have multp;e fields)).

  • Use Frame time with slicer --- analyze tab ..insert timelines so we can have time filter as below

time filter

Name and Selecting my data :

  • Formula tab.. Name manager : so we have a list of all names in table

  • split text with delimiters : copy and paste required column then from Data tab we use text to columns then use the required delimiter

  • Removing duplicate : Data tab .. remove duplicate

  • Transposing data