金諭慧

發表文章

金諭慧EXCEL樞紐分析weekday函數

12月 27, 2021

樞紐分析Pivot Table Analysis 樞紐分析，把股票報酬率分成五組，大漲超過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影片樞紐分析

閱讀完整內容

金諭慧SVG,EXCEL資料表

12月 13, 2021

Scalable Vevtor Graph可縮放向量圖形老虎頭 ...

閱讀完整內容

EXCEL VBA 雙迴圈 Java Script 雙迴圈

11月 23, 2021

VBA迴圈畫圖 VBA迴圈畫圖程式碼 'https://excelatfinance.com/xlf19/xlf-qg-add-blue-circle.php Option Explicit Const topleft As String = "C5" ' anchor cell Const diam As Integer = 100 ' 宣告常數constant diam 100 Dim Shp As Shape ' =========================== Sub 金諭慧() Dim TLCleft As Double Dim TLCtop As Double Dim i As Integer '宣告整數integer i For i = 1 To 20 'write a loop單引號註解 TLCleft = 20 * i '距離左邊left TLCtop = 20 * i '距離上面top '使用中的試算表active sheet.AddShape(type, left, top, height) Set Shp = ActiveSheet.Shapes.AddShape(msoShapeOval, TLCleft, TLCtop, diam, diam) With Shp .Fill.Visible = msoFalse .Line.Weight = 10 .Line.ForeColor.Brightness = 0.4 .ThreeD.BevelTopType = msoBevelCircle End With Next With Cells(1, 1) .Value = "金諭慧" .Interior.Color = RGB(0, 0, 225) .Columns.AutoFit With .Font .Size = 30 .Color = RGB(255, 255, 255) E...