ykcpa.com | Home

ykcpa.com

Welcome to ykcpa.com

Notes on Excel, accounting, AI, and other topics of interest.

Browse my notes →

Topics

  • Excel & VBA
  • Accounting
  • AI & LLMs
  • Prompting
  • Software

About

This site is where I stash notes on Excel, accounting, software and other topics of personal interest. Feel free to browse around... enjoy!

Recent Blogposts

to blog

  • Markdown Symbols - The key to speaking LLM-ese

    A guide to using Markdown formatting effectively when prompting LLMs, based on how models were trained on structured text.

    Read post →

  • How Do I Find Which Period a Check or Other Item Cleared the Bank

    A workaround to find which reconciliation period a check cleared in QuickBooks when the audit report doesn't show it.

    Read post →

  • How to reset the last cell in an Excel worksheet

    A quick VBA trick to reset Excel's "last cell" when Ctrl+End jumps too far away from your actual data.

    Read post →