不動產天王

  樞紐分析，把股票報酬率分成五組， 大漲超過6% 小漲超過2% 平盤2%到-2% 小跌超過-2% 大跌超過-6% =IF($G2>6%,"大漲",IF($G2>2%,"小漲",IF($G2>-2%,"平盤",IF($G2>-6%,"小跌","大跌")))) 含全與樞紐分析 老師示範樞紐分析 先從範圍建立名稱 樞紐分析表欄位選單 EXCEL函數 =F230/F229-1 =IF($G230>6%,"大漲",IF($G230>2%,"小漲",IF($G230>-2%,"平盤",IF($G230>-6%,"小跌","大跌")))) =WEEKDAY(A230,2) IF巢狀函數 Rank PercentRank Min Max Median Match Index Count 以及過去學的Left, Mid, Right, Len。 資料表Table是連續範圍的儲存格資料。將格標放在資料表任何地方，Ctrl往上箭、Ctrl往下箭、Ctrl往右箭，格標跑到資料表的邊緣。 122影片樞紐分析

劉任昌Scalable Vector Graph可縮放向量圖形 ...

維基百科SVG EXCEL VBA繪圖 EXCEL VBA繪圖程式碼 Sub 劉任昌() For i = 0 To 4 ActiveSheet.Shapes.AddShape(msoShapeOval, i * 200, 0, 200, 200).Fill.ForeColor.RGB = RGB(255, 255, 0) ActiveSheet.Shapes.AddShape(msoShapeOval, i * 200 + 50, 50, 30, 20).Fill.ForeColor.RGB = RGB(0, 0, 0) ActiveSheet.Shapes.AddShape(msoShapeOval, i * 200 + 120, 50, 30, 20).Fill.ForeColor.RGB = RGB(0, 0, 0) ActiveSheet.Shapes.AddShape(msoShapeRectangle, i * 200 + 90, 80, 20, 50).Fill.ForeColor.RGB = RGB(0, 0, 255) ActiveSheet.Shapes.AddShape(msoShapeRectangle, i * 200 + 70, 150, 60, 15).Fill.ForeColor.RGB = RGB(255, 0, 0) Next End Sub