AI is no longer a nice-to-have; it’s transforming how businesses work today. Microsoft 365 Copilot brings artificial intelligence directly into the apps your teams already rely on: Teams, Outlook, Word, PowerPoint, and Excel. For executives and decision-makers, Copilot isn’t just another tool. It’s a strategic partner that drives measurable results: reduced time spent on routine…
The Spreadsheet Trap Excel is everywhere. For small and mid-sized businesses (SMBs), it often feels like the glue holding everything together. Need to track inventory? Someone builds a spreadsheet. Need a customer list? Spreadsheet. Project budgets? Timesheets? Reporting? You guessed it: another spreadsheet. The problem is that while Excel offers flexibility, it never serves as…
Most of us have a love–hate relationship with Excel. It’s where budgets are created, forecasts are tested, and performance is evaluated. But it’s also where hours can be lost to formula errors, cluttered data, and charts that never quite tell the full story. This is exactly the kind of work Copilot in Excel can simplify.…
Microsoft Excel is a useful tool for just about every business. Being able to easily use Excel alongside Microsoft Dynamics 365 Business Central further streamlines your workflow. Business Central includes an add-in that allows for edits made in Excel to be published in Business Central. It’s called Edit in Excel and differs from Open in…
Microsoft designed its various productivity platforms to bring out the best in each other. For example, Microsoft Dynamics 365 becomes a much more powerful resource when connected to Microsoft Excel, Word, Outlook, SharePoint, OneNote, Power BI, and Teams. Here are some ways that you can combine Microsoft 365 (formerly Office 365) with Dynamics 365 for…
Who wears the data chief crown at your organization? There’s something of a debate about who rightfully owns that title. Some advocate for the CIO, while others side with the CTO. Yet, an emerging trend among mid-market enterprises, especially those with limited IT resources, highlights a different contender: the CFO. That’s right. You—the CFO—are your…
When working with greenhouse growers, I often find that they are making their jobs much harder than necessary by operating in siloed environments. I’ve said this before, but do you find yourself pulling off “daily acts of heroism” to gather the information needed to make business decisions? It doesn’t have to be so hard. More…
The Microsoft 365 suite includes some of the most famous productivity apps on the planet: Word, Excel, PowerPoint, Outlook, and more recently, Teams. It’s easy to write these guys off – because, hey, we all know what Outlook and Excel are supposed to do. But it’s important to let go of what you think you…
If you’ve spent any time poking around Microsoft’s various blogs in recent months, you’ve probably noticed they’ve been talking a lot about “activating the flow of work,” streamlining collaboration, and well, making it easier to get work done from anywhere. The Dynamics 365 Business Central and Microsoft Teams integration is central to this effort. Teams…
Cube Functions inside Excel are really powerful tools for cube reporting, especially when you realize that you can leverage MDX within the functions to make some very useful calculations. Today, I will describe how you can use the CUBESET function to calculate Month To Date values, even when there are no MTD defined measures. First, let’s…
