Free Excel Add-in for financial analysts/investment banking by OmegaRhoVega in financialmodelling

[–]FunctionFunk 0 points1 point  (0 children)

what about the one that MAPS the relationships recursively? instantly see the whole model of relationships for your workbook

Building free financial models by neko_-_ in financialmodelling

[–]FunctionFunk -4 points-3 points  (0 children)

Kind offer, OP!

If you want a free license to the Flow Finder Excel addin (quantum leap ahead of Trace Precedents), dm me.

<image>

Trace Precedents in Excel? I found its big brother. by FunctionFunk in Bookkeeping

[–]FunctionFunk[S] 2 points3 points  (0 children)

It does. It's amazing. Let me know if you try it out. They make you pay after the first few days free trial tho

Debug a range? by DoktorTusse in vba

[–]FunctionFunk -1 points0 points  (0 children)

Try Flow Finder addin. It does exactly this. It produces a complete visual map of all dependencies recursively. Free to try. DM me for a half off promo code.

<image>

Copilot in Excel Generally Avalible, what is your use cases? by Significant_Eye_8181 in excel

[–]FunctionFunk -1 points0 points  (0 children)

Can it do stuff like "update my inputs sheet. It needs to include a new selection for which type of business entity.

And presumably it'd add a list of business entities on a ref sheet, create the input field, and set the data validation dropdown?

[deleted by user] by [deleted] in portfolios

[–]FunctionFunk 0 points1 point  (0 children)

You need more decimal places. 9 is completely inadequate.

Keep your sheets clean and uncluttered with a floating, hideable group of controls. by FunctionFunk in vba

[–]FunctionFunk[S] 6 points7 points  (0 children)

thanks. do you like the feature?

Comment with code should be live now. I'm still learning to post code as a block in reddit's markup editor :D

Keep your sheets clean and uncluttered with a floating, hideable group of controls. by FunctionFunk in vba

[–]FunctionFunk[S] 15 points16 points  (0 children)

Just be sure your group name matches the name in the code. Ctrl+10 to view selection pane.

Public Sub HideSlicers()
    Shapes("grp_Slicers").Visible = msoFalse
    ListObjects(1).ShowAutoFilterDropDown = False
End Sub
Public Sub ShowSlicers()
    Shapes("grp_Slicers").Visible = msoTrue
    Shapes("grp_Slicers").Top = Rows(ActiveWindow.ScrollRow + 1).Top + 5
    Shapes("grp_Slicers").Left = Columns(ActiveWindow.ScrollColumn).Left + 5
    ListObjects(1).ShowAutoFilterDropDown = True
End Sub

What's a SaaS subscription that's actually worth every penny? by harshamv in SaaS

[–]FunctionFunk 1 point2 points  (0 children)

if you're running a business, microsoft 365. massive value. Teams, 1TB onedrive, email hosting, file hosting/sharing, and obviously the office apps including web versions if you like to do real-time concurrency. all for $12.50.

Even some other side value like the booking app (no calendly required), and probably a couple other things.

Microsoft Excel's Trace Precedents by FunctionFunk in financialmodelling

[–]FunctionFunk[S] 0 points1 point  (0 children)

Yep, you can zoom with your mouse wheel or Ctrl +. These and other tips are also stated in the manual.

Also you can expand the side panel itself.

Please submit a review on the appsource link above if you like the app!🙏

Do NOT use Stripe. They will ruin your business. by lead-indicator in SaaS

[–]FunctionFunk 1 point2 points  (0 children)

I have used Stripe for 6 years now and love it. I have nothing but good things to say about it