Excel Help and Problems

[aygart]

How do I copy a sheet (tab on the bottom) from one file to another?

Open the file you want to copy it to, Right click on the tab you want to copy and click move or copy. To copy make sure to check that option otherwise it will move.

[ChaimMoskowitz]

OK, need both files open. 

[etech0]

OK, need both files open. 

yup

[myi]

Is there any way to split one cell in two, meaning a line in the middle?
Aside for putting a shape or drawing with art.
Any standard button to split one cell?

[Zubda]

Merge the cells above and below it

[skyguy918]

Is there any way to split one cell in two, meaning a line in the middle?
Aside for putting a shape or drawing with art.
Any standard button to split one cell?

You just want the line to show up, or you want to be able to split the cell for all purposes?

[myi]

You just want the line to show up, or you want to be able to split the cell for all purposes?

Just a line, nothing to do with the text, as a graph want another line in-between.

[churnbabychurn]

Just a line, nothing to do with the text, as a graph want another line in-between.

Do a left border

[myi]

Do a left border

Will try after and report back. Thanks.

[etech0]

You should be able to do a middle "border" too, if that's what you need

[skyguy918]

Came across something interesting that I had never used before, thought it might be interesting to some here.

My brother asked for help with a data set. There are 50 columns representing the last 50 years. For each row, there may be data in each row for some, all, or none of the 50 years. What's more, the data is not necessarily continuous (ie it can skip years). The ask was to do conditional formatting on the data set to color each row based on the number of years that have data - easy enough. But a secondary goal was to format based on the largest number of years with continuous data in each row. I ended up coming up with various relatively messy solutions, but my brother-in-law found this, which worked beautifully:

https://exceljet.net/formula/count-consecutive-monthly-orders

Code: [Select]

{=MAX(FREQUENCY(IF(rng>0,COLUMN(rng)),IF(rng=0,COLUMN(rng))))}
Gorgeous bit of code, using the FREQUENCY function, which I had never used before.

[jose34]

Can anyone recommend a quality free course that teaches how to do basic accounting using Excel?

[churnbabychurn]

Can anyone recommend a quality free course that teaches how to do basic accounting using Excel?

Like running a gl ? Try you tube.. it's not conventional

[yitzf]

Can anyone recommend a quality free course that teaches how to do basic accounting using Excel?

The excelisfun YouTube channel should have an accounting playlist, but it's focused more on Excel than accounting.

[Centurion]

I can use help figuring out how much money in mortgage loans we need to cover our overhead.
how many months and how many dollars needed to cover ourselves

when will the payments be able to match the loans we give out to be self sustained

i.e. if we give out 1m in loans @7%  we would only make x per year /12 is y per month
if our overhead is 20k a month - how many loans need to be out etc.

willing to pay - feel free to dm