Тёмный

Bank Balances - Record and Reconcile using Excel Spreadsheets 

Mr.SpreadSheet
Подписаться 37 тыс.
Просмотров 2,7 тыс.
50% 1

Опубликовано:

 

12 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@ashachase2010
@ashachase2010 8 месяцев назад
Your videos have been of great help to me, so thank you. But this one has a mix-up around timestamp 7:13. The narrator says = +I2+J2+K2, but it's actually +H3+J3+K3 like what's being typed into the spreadsheet. No?
@MrSpreadSheet
@MrSpreadSheet 8 месяцев назад
Hi, Why not download the file, you can then check your work against the original. Just follow the guide set out in the video :-)
@raptorscrest9239
@raptorscrest9239 7 месяцев назад
Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up.
@user-xo8nx2vx9p
@user-xo8nx2vx9p 8 месяцев назад
Hi, when attempting to copy the formula from the Receipts column (J3) into (K5) the payments column and updating the "Receipts" to "Payments" within the formula, the result i get is zero rather than the -215. The formula only works when "receipt" is within the formula and not "payment". I would say im rather good with excel however this problem has me stumped. Your assitance would be greatly appreciated.
@MrSpreadSheet
@MrSpreadSheet 8 месяцев назад
Hi, Why not download the file, you can then check your work against the original. Downloads are available at www.MrSpreadSheet.com :-)
@raptorscrest9239
@raptorscrest9239 7 месяцев назад
Hi, I had the same issue. I then Filled D7 With "Payment" and Magic! Hope it helps
@chimbakatongo6649
@chimbakatongo6649 7 месяцев назад
Hi, did you finally get it? I'm getting 0 aswell
@raptorscrest9239
@raptorscrest9239 7 месяцев назад
Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up@@chimbakatongo6649
@user-xo8nx2vx9p
@user-xo8nx2vx9p 2 месяца назад
@@raptorscrest9239 - thanks, that worked wonders!!
@patriciadarling3242
@patriciadarling3242 5 месяцев назад
Would it be possible to incorporate credit cards also for reconciliation?
@MrSpreadSheet
@MrSpreadSheet 5 месяцев назад
Yes, our 'Paid For' products incorporate 4 Bank/Card Accounts :-)
Далее
Gross Profit  - Calculated and explained using Excel
14:25
Новый уровень твоей сосиски
00:33
Cute
00:16
Просмотров 6 млн
Error handling in Excel - Basic techniques
13:37
Chart of Accounts   Created Using Excel
13:50
Просмотров 6 тыс.
Excel Macros learn at your own pace - Extended Tutorial
27:18
Bookkeeping With Excel/Spreadsheets
13:41
Просмотров 36 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн