Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Zapier
What if every new journal entry posted in QuickBooks Online landed in an Excel table automatically, no copy-paste required? In this tutorial we walk through exactly that workflow. We use Zapier to connect QuickBooks Online to an Excel workbook stored in OneDrive, loop through each journal entry line so it lands on its own row,…
When it comes to automation, Excel users can certainly streamline tasks within the grid. But sometimes, we need to automate tasks outside of Excel—especially when it comes to integrating external tools and triggering actions automatically. That’s where Zapier comes in. In this post, we’ll take a beginner-friendly dive into Zapier’s AI automation capabilities by creating…