spreadsheets Community | Digg

Excel: Workers cling to the software despite shift to AI

Despite efforts to centralize data control, many companies are still heavily reliant on Excel spreadsheets. Excel, a Microsoft product, has been in use for 40 years and is deeply embedded in business practices. However, tech leaders view it as an obstacle to more efficient digital workflows and AI. The persistence of Excel is partly due to its integration into technology education and its effectiveness for quick data analysis. However, its widespread use can lead to data management issues, as seen in the Health New Zealand financial performance case. Transitioning to more centralized data systems can lead to significant benefits, such as smoother workflows, cost savings, and improved data security.

@kites

3 Ways to Count Colored Cells in Google Sheets

This guide explains how to count colored cells in Google Sheets using three methods: a custom script, a manual filter, or a third-party add-on. It provides detailed instructions and examples for each method.

@midi002

You can download an updated CSV of all known Digg communities

File: tables.csv You can download historic data pulls, also. So if you really know what you're doing, you can make differential charts on growth of all communities, and the growth of each community by member count and post count.Courtesy of /digglist

@kites

My lazy way to pull the Top 3 rows in Sheets and keep them sorted

I needed a quick Top 3 list for a weekly update. I used FILTER + LARGE, then SORT on top. I grabbed anything >= the 3rd largest value, then sort the result descending. This is the first time nesting formulas felt like it actually reduced work. And now if someone updates the sales

@kites

Best time-saving formula?

What formula saves you the most time in your spreadsheets? For me, it might be some of the more boring ones. AVERAGE, SUM, etc

@kites

10d

"Agent Mode" in Excel

Anyone using this regularly?

@kites

10d

Multi-Selection Dropdowns in Google Sheets

Google Sheets drop-downs are single-pick by default, which is annoying when the real world wants multi-pick (skills, tags, colors, statuses). One practical workaround is an onEdit(e) Apps Script that watches a specific drop-down cell, then appends each new selection to the existi

You’ve reached the end of the feed.

Roll credits.

Excel: Workers cling to the software despite shift to AI

3 Ways to Count Colored Cells in Google Sheets

You can download an updated CSV of all known Digg communities

My lazy way to pull the Top 3 rows in Sheets and keep them sorted

Best time-saving formula?

"Agent Mode" in Excel

Multi-Selection Dropdowns in Google Sheets

You’ve reached the end of the feed.

/spreadsheets

About

Community Guidelines

Founded by

Top Contributors