Geeky Gadgets

How to use Python in Excel spreadsheets for data analytics

The recent announcement from Microsoft that they have now integrated Python into it’s Excel spreadsheet software has opened up a wealth of new applications for data analytics, automation and number ...
Geeky Gadgets

Using Excel PowerPivot for data modeling in spreadsheets

If your are wondering how to handle large datasets and complex calculations in your spreadsheets. This is where MS Excel PowerPivot comes into play. PowerPivot is an advanced feature in Excel that ...
JournalofAccountancy

Using Excel’s What-If Analysis with Data Table for data analysis

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...
PCMag Australia

I Used ChatGPT to Build Complex Spreadsheets Fast. Here’s How You Can, Too

Struggling with Excel or Google Sheets? My game-changing AI tips will save you hours on data entry and formula writing.
TechCrunch

Coefficient wants to bring live data into your existing spreadsheets

With the explosive adoption of software-as-a-service (SaaS) apps, the average company now has more than 100 SaaS apps to manage — leading to data being siloed across countless different systems. That ...
TechCrunch

Actiondesk is a spreadsheet tool that works with live data

Actiondesk is a new spreadsheet solution for the software-as-a-service era. It connects with the databases, CRMs and SaaS tools that you already use so that you can build dashboards and generate ...
JournalofAccountancy

Data mining your general ledger with Excel

The general ledger is a vast historical data archive of your company’s financial activities, including revenue, expenses, adjustments, account balances, and often much more. The detailed transactions ...