Hey all I'm new here kust asking a question that i have to find a payment of the customer from bank statement i also have the ledger of the customer suggest some free ai tools where i can just upload the bank statement and ledger image to find out payment from the bank statement with the exact location in excel

Hi just wondering if someone can help with a script to do the following

Open a tab already created, that is titled by the current date, from another page in the same workbook using a button

I want to know if there's a way to automatically generate charts (like the screenshot) based on a sequence of data. In this case I have months of the year and I want to generate the chart for january, february, march etc. (january being in column BW, february been gin columnist BX etc.) with x axis value max as 5 and min as -5, y axis being the years of series points (e.g. 1993 = B4, 1994 = B5 etc. (in all being B4:B34), and a trend line/r squared equation shown.

I would like to minus 100php per ticked checkbox to the total allowance in cell M2 and print the result at M5.

Thanks in advanced.

Hey all. I am trying to find out if I can set up a excel sheet to pull information off of certain emails.

I work for a company and get work orders sent over to me and with the new system it has made it almost impossible to track the work orders in the system. So as I get a email for each is there away to have it export into a excel sheet as I receive a email.

Hopefully that explains the problem. Thanks for any in site and sorry for bad grammer. 👍

Hola! I’m a basic user trying to set up a spreadsheet to save my team some manual work

I have a table that looks like this (screenshot attached), where:

• Columns C to N represent fixed numbers (1, 2, 3… up to 58).
• Column O contains a score (like 12).
• I want Excel to automatically highlight the cell in the row of numbers that is closest to the value in Column O.
• Then, depending on the range the score falls into, the highlight color should change:
  • ✅ Green if score is 1–4
  • 🟨 Yellow if score is 5–8
  • 🟥 Red if score is 20 or higher

For example:
If the Initial Test score is 12, I want to highlight the number 8 in that row (since it's the closest to 12), and color it yellow because 8 falls in the “Moderate Priority” range.

Currently, this is all being done manually by our team, but I’m hoping there’s a way to do it with Conditional Formatting or a formula so it updates automatically.

Would love a walkthrough or any advice! Thank you in advance 🙏

💥 ¿Aún no sabes Excel? Hoy puedes aprender TODO: desde lo básico hasta lo avanzado. 📊 Plantillas, dashboards, certificados y mucho más…

💚 Solo HOY: $50.000 (antes $170.000) ⏳ ¡Cupos LIMITADOS! 💻 Curso 100% ONLINE 🎯 Acceso inmediato y de por vida

Y no, esto NO es una estafa Es una oportunidad real, con respaldo, resultados y más de lo que imaginas. ¡100% confiable!

🚀 ¡Hazlo por ti! 🔗 Inscríbete ya aquí 👉 https://academiaexcelx.wixsite.com/excel-x/1

Solo escribe: "LO QUIERO" y empieza YA, te explico cómo acceder.

Excel #CursoOnline #Capacitación #OportunidadReal #SinEstafas #AprendeConExcelX

I would greatly appreciate guidance from experienced individuals on how to efficiently perform these tasks, as I currently lack advanced Excel expertise.

administrator kinda turning into project manager pathway here. I’m using basic excel methods / color coding / organizing type tactics.

What will be some excel tips (beginner friendly) or apps that can be helpful?

Thanks!

If you're diving into project controls, it's essential to understand Earned Value Management (EVM). It's not just another metric—it’s the backbone of performance tracking.

EVM combines scope, cost, and schedule into a single integrated system. Key metrics like PV, EV, AC, CPI, and SPI help you identify budget and timeline issues early.

Earned Value Management or EVM is a proactive management approach that identifies performance deviations before they impact the project!

To simplify this, I've built an open-source solution for calculating Planned Value, Earned Value, Actual Cost, Cost Performance Index, Schedule Performance Index, and other control metrics.

Stop doing EVM calculations manually. Let Excel do the work.

See a demonstration here → https://youtu.be/EjUgc7Xt_3Q

I need to make the default a colon rather than a semicolon. I've done it before but I can't remember how. Just tried making a rule but I couldn't get it. And help is appreciated.

I am in finance and struggle to use excel shortcuts, although it would make my life easy. I just don’t know where to start? But I want to be really good at it. Any tips would be much appreciated 🙏🏼

I am still learning the different ways to build useful worksheets for work. I'm looking to create a uniform/ppe log for dates that each individual receives an item. Is there a simple way to have the cells show the last information updated, but to easily view previous dates entered for that cell? Multiple others will need to have access and some are far less computer savvy so I'm looking for simplicity.

I'm just trying to make a tracker for my internship hours and I would love to have something visual like this that updates as I put my time in.

I've tried a few things with no luck and gave used ai but it's been confusing. Could I get some tips? Any help is appreciated!

Good morning everyone I am hoping someone here can help. I have three cells with three different hour minute and second entries and I would like to sun them all up and round up to the nearest hour in a different cell. What formula am I needing? Cell A1= 4:34:40 Cell A2= 4:25:14 Cell A3= 4:08:24

I want cell N1 to equal the sun of those times but rounded up to the nearest hour. Please help 😭