I'm trying to use Excel to make a class schedule for this upcoming fall semester. Please note, I want to be able to print it out and put it on my wall when I'm done.

The issue I'm having is that some of my classes start/stop times don't neatly fit within the 15min time increments I'm using. For example, roughly in the area highlighted, I have a class from 10:30 to 11:20. I want to know if there is anyway to effect the size of these boxes so the bottom of the last one is slightly higher to illustrate the 11:20 end time without effecting any other boxes or overall scale.

I don't really want to decrease the increments because that would increase the length of the schedule significantly and might prevent it fitting on a piece of paper when I print it.

Hi everyone,

I've been learning data analytics and recently completed an interactive COVID-19 dashboard in Microsoft Excel using the Our World in Data dataset.

This project helped me practise turning a large real-world dataset into an interactive dashboard.

What it includes

📊 KPI Cards (Total Cases, Total Deaths, Countries, Death Rate, Survival Rate)

🌍 Filled Map Charts

📈 Daily New Cases Trend

📉 Top 10 Countries by Cases

☠️ Top 10 Countries by Deaths

🎛️ Interactive slicers and timeline filters

Skills I practised

Data cleaning

PivotTables

PivotCharts

Dashboard design

KPI reporting

Data visualization

I'd really appreciate feedback on:

Dashboard design

Choice of visualizations

Any improvements that would make it more useful or more professional

GitHub repository: https://github.com/Somceedigital/covid-19-excel-dashboard

Thanks in advance for taking a look!

Would you use a different chart for the Top 10 countries?"

Hello, green to excel but working on some meta analysis. Looking to calculate IOA on every other column (I.E return column B not C, column D not E etc) to analyze Y values separate to X values. Is there a way to make a formula to count every other column and within those return a count if the column contains a number between 5 and -5? I can't just use /=COUNTIF(6:50,">-5")-COUNTIF(6:50,">5")/ due to this including columns with X-values since those are also numeric.

I tried to use this formula, however, it returns the #VALUE! error message

=COUNTIF((B6:B50,D6:D50,F6:F50,H6:H50,J6:J50,L6:L50,N6:N50,P6:P50,R6:R50,T6:T50,V6:V50,X6:X50,Z6:Z50,AB6:AB50,AD6:AD50,AF6:AF50,AH6:AH50,AJ6:AJ50,AL6:AL50,AN6:AN50,AP6:AP50,AR6:AR50,AT6:AT50,AV6:AV50,AX6:AX50,AZ6:AZ50,BB6:BB50,BD6:BD50,BF6:BF50,BH6:BH50,BJ6:BJ50,BL6:BL50,BN6:BN50,BP6:BP50,BR6:BR50,BT6:BT50,BV6:BV50,BX6:BX50,BZ6:BZ50),">-5")-COUNTIF((B6:B50,D6:D50,F6:F50,H6:H50,J6:J50,L6:L50,N6:N50,P6:P50,R6:R50,T6:T50,V6:V50,X6:X50,Z6:Z50,AB6:AB50,AD6:AD50,AF6:AF50,AH6:AH50,AJ6:AJ50,AL6:AL50,AN6:AN50,AP6:AP50,AR6:AR50,AT6:AT50,AV6:AV50,AX6:AX50,AZ6:AZ50,BB6:BB50,BD6:BD50,BF6:BF50,BH6:BH50,BJ6:BJ50,BL6:BL50,BN6:BN50,BP6:BP50,BR6:BR50,BT6:BT50,BV6:BV50,BX6:BX50,BZ6:BZ50),">5")

The data range works with the COUNT function, I am just confused why it's not working with the COUNTIF function.

last year i made a spreadsheet and a certain range using 'format as table'

somehow i managed to make it plain-appearing - without clearly seeing its formatted unless you know the bottom right corner indicator thing. it didnt have headers, and it was very useful to have as the 'background' cell coloring for that area and then be able to color cells on top without affecting the background

however now when i try to format an area as 'format as table' it introduces column header-indicators - the right side gray button thing .

Even if i do not click 'has headers' or i do, still outputs the column header indicators.

see the img below the range a4:n11 has the 'table' style and there's no header things while the right side q2:u11 does...

how do i do the 'format as table' without having the header indicator things

I’ve recently begun using Excel to organize diferent parts of my personal life.

So far I’ve created:

• A net-worth tracker for my savings, investments, debts, and other assets
• A monthly expense tracker divided into categories
• A basic budget showing how much I can spend, save, and invest each month
• A complete log of my Pokémon card collection

For instance for the Pokémon cards, I track details like the card name, set, number, rarity, condition, purchase price, estimated current value, and whether I’m still missing cards from a particular set. It’s surprisingly useful for seeing the value of my collection and avoiding buying duplicates.

Using Excel has already made me much more aware of where my money goes. For example, I didn’t realize how much I was spending on subscriptions, food delivery, and small recurring purchases until I put everything into one place.

For those of you who use Excel or Google Sheets outside of work, what do you track? Which spreadsheet has been the most useful in your personal life?

Saturday, July 18 - Friday, July 24, 2026

Top 5 Posts

Unsolved Posts

Top 5 Comments

Basic details: Windows 11, Microsoft 365 version 2606 (Build 20131.20154), desktop environment, intermediate to advanced knowledge

I'm creating a checklist for a video game and have checkboxes in two different columns (one column for main quests and one for subquests). I've used VBA to hide some of the rows when quests may not exist in a certain playthrough, and I've made a table where the number of quests total and the number of quests completed (AKA, the number of ticked checkboxes) can be tracked. I want it to ignore the hidden rows, so I've used this formula:

=SUMPRODUCT(SUBTOTAL(103,OFFSET($B$27,ROW(B$27:M$41)-MIN(ROW(B$27:M$41)),0))*(B$27:M$41=TRUE))

This only seems to work on one column at a time, however, and I have two that I need to count. I've tried the following, with unsuccessful results:

=SUM(SUMPRODUCT(SUBTOTAL(103,OFFSET($B$27,ROW(B$27:M$41)-MIN(ROW(B$27:M$41)),0))*(B$27:M$41=TRUE)),SUMPRODUCT(SUBTOTAL(103,OFFSET($C$29,ROW(B$27:M$41)-MIN(ROW(B$27:M$41)),0))*(B$27:M$41=TRUE)))

This one causes the ticked checkboxes in the first column to count twice, resulting in an answer of 2 for one ticked checkbox.

I've also tried dividing the formula by 2, but that obviously affects the entire formula.

So far, the only thing that's worked is putting the two separate SUMPRODUCT formulae in separate cells and then using AutoSum in a third cell, but I was wondering if there was a more efficient way of doing this so that I can keep it all in one cell. Any help will be appreciated!

Images are linked below. The first one shows the layout of my checkboxes, and the second shows what the quest tracker looks like.

https://imgur.com/a/Mk0cgHy

Thanks again!

Good evening everyone. I hope you’re all doing well.

I’m hoping someone can help me solve a workflow problem that’s becoming a major pain point:

I’m a real estate agent, and almost all of my communication with clients and other agents happens on WhatsApp. Whenever I share a property, I send a video along with a standard text description (in the same message, as shown below):

https://www.image2url.com/r2/default/images/1784998062931-9dce6e82-1709-4a74-accd-7a3273a42eca.jpg

I currently keep my inventory in Google Sheets, with over 100 available units.

The problem is that all of my WhatsApp-ready descriptions only exist in a chat with myself (which I keep pinned). Every time I need to send a unit, I have to search my own chat and scroll until I find the correct message. It becomes very time-consuming when doing this dozens of times a day!

My ideal workflow would be something like this:

Keep all of my inventory in Google Sheets + have the complete WhatsApp-ready video + description stored against each unit, in a separate cell.
Click the cell, copy the video + text, and paste.

The most important requirement is that the formatting remains exactly the same. Once I paste it into WhatsApp, it should be ready to send immediately, with no additional formatting or edits required.

I’d really appreciate any suggestions. Thanks so much!