A 7
B 2
C 3
D 4
E 5
F 6
A B C D E F
7 2 3 4 5 6
0
Blue Small 5
Green SMALL 6 This shape represents a table This shape represents a table
slicer. Table slicers are not slicer. Table slicers are not
supported in this version of supported in this version of
Excel. Excel.
If the shape was modified in If the shape was modified in an
an earlier version of Excel, earlier version of Excel, or if
or if the workbook was the workbook was saved in
saved in Excel 2007 or Excel 2007 or earlier, the slicer
earlier, the slicer can't be can't be used.
used.
STEPS
1. First select data range
2. clt + T, Check Table must have headers
3. Now click anywhere in Data table
4. Go to insert & click slicer
5. Done
hape represents a table This shape represents a table
Table slicers are not slicer. Table slicers are not
rted in this version of supported in this version of
. Excel.
shape was modified in an If the shape was modified in
r version of Excel, or if an earlier version of Excel,
orkbook was saved in or if the workbook was saved
2007 or earlier, the slicer in Excel 2007 or earlier, the
be used. slicer can't be used.
Scenario Summary
Current Values: Best Worst Likely
Changing Cells:
$B$7 4% 3% 8% 4%
$B$8 60 36 60 60
$B$9 35000 32000 35000 35000
Result Cells:
$B$11 40598 40598 40598 40598
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
SE
Rate 4%
Term 60
Principal 35000
Payment 676
Total 40598
Steps
1. Select first three cells of column 2
2. Go to data , then what if analysis and select scenario manager
3. click add & add best, worst, and likely scenerio and click summary
4. Choose result cell and click ok
5. Done
Region Item
Pen
Region Item Name Total
East pen Asd 56
West Pencil sdf 67
North pen dfg 87
South frony fgh 34
East Gh ff 45
West dfjf jk 56 Region
Centre pen yu 67 East
West pen gjj 89 West
North
West
Centre
West
Name Total
>60
Item Name Total
pen Asd 56
Pencil sdf 67
pen dfg 87
dfjf jk 56
pen yu 67
pen gjj 89
Steps
Select cell under thr item u insert
Go to data then advance, check on copy to ....
Select rage table, then criteria table in where u insert the item
Select any location then click ok
Region Item Name Total
West Pencil sdf 67
North pen dfg 87
Centre pen yu 67
West pen gjj 89
Start 7/1/2018 Holidays
End 7/22/2018 7/4/2018
Working day 14
Region Item Name Total
East pen Asd 56
West Pencil sdf 70
North pen dfg 87
South frony fgh 34
East Gh ff 45
West dfjf jk 56
Centre pen yu 67
West pen gjj 89
Total 504
STEPS
Make a data table and save it
close the excel sheet
go to word. Then insert, then object and click object
click on create from file, select the excel file u made earlier
click on link on table and ok
if u want to change anything in that excell file, change and save it
then close it. Then go to word file, Right click on table and select update link
Word file will automatically update as per the excel file
Done
Region Item Name Total
East pen Asd 56
West Pencil sdf 70
North pen dfg 87
South frony fgh 34
East Gh ff 45
West dfjf jk 56
Centre pen yu 67
West pen gjj 89
STEPS
Go to find and search
type what u want to start
click find all
click control + A, then close it
