![The Bookkeeping Channel](/img/default-banner.jpg)
- 284
- 2 446 010
The Bookkeeping Channel
Australia
Registrace 29. 01. 2019
Hi there! And thank you for checking out my CZcams channel.
As a small business owner, I know how frustrating it can be to spend hours searching for answers to things that should be easy to do or understand. That's why I love creating videos about how to make the most out of business and personal finance tools such as Xero, Excel, Google Sheets and concepts such as bookkeeping and accounting.
I will add more vidoes over time so do yourself a favour and subscribe to my channel to be notified of new videos.
Also, feel free to contact me any time or leave a comment on my videos.
Thanks again and I'll see you on my CZcams channel :)
As a small business owner, I know how frustrating it can be to spend hours searching for answers to things that should be easy to do or understand. That's why I love creating videos about how to make the most out of business and personal finance tools such as Xero, Excel, Google Sheets and concepts such as bookkeeping and accounting.
I will add more vidoes over time so do yourself a favour and subscribe to my channel to be notified of new videos.
Also, feel free to contact me any time or leave a comment on my videos.
Thanks again and I'll see you on my CZcams channel :)
5 BASIC Excel Functions You MUST LEARN First
Click here to download the Excel template: bit.ly/4cRpby2
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
When you’re first learning Excel, there are a few basic functions you can start with that won’t leave you feeling overwhelmed. And they are: SUM, AVERAGE, COUNT, MAX and MIN.
You will learn all of those Excel functions from this video so download a copy of the template and let's get started!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such. The owners of this channel are not liable or responsible for any financial, tax, legal, business or other decisions you make. If you are looking for advice, you should seek a suitable and qualified adviser.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
When you’re first learning Excel, there are a few basic functions you can start with that won’t leave you feeling overwhelmed. And they are: SUM, AVERAGE, COUNT, MAX and MIN.
You will learn all of those Excel functions from this video so download a copy of the template and let's get started!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such. The owners of this channel are not liable or responsible for any financial, tax, legal, business or other decisions you make. If you are looking for advice, you should seek a suitable and qualified adviser.
zhlédnutí: 65
Video
Change Text CASE in Excel | WITH and WITHOUT Functions | Lower, Upper and Proper Case
zhlédnutí 122Před 14 hodinami
Click here to download the Excel template: bit.ly/3W3fKVa ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Find out how to change text from uppercase to lowercase and vice versa in Excel with or without using functions and formulas. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. ...
How to Use The Excel SUBSTITUTE Function for Numbers and Letters
zhlédnutí 124Před 16 hodinami
Click here to download the Excel template: bit.ly/4eTx0ob ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Find out how to use the SUBSTITUTE function in Excel to substitute any charatcters you like such as numbers and letters. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our v...
Excel INDEX MATCH With Multiple Lookup Criteria | Multiple Columns or Rows
zhlédnutí 360Před 19 hodinami
Click here to download the Excel template: bit.ly/45ZqIQ4 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Find out how to use INDEX MATCH in Excel when the values you need to look up in your MATCH function are not unique. I’ll show you how to do this when you need to match values vertically - or in columns - and also how to do this both vertically and horizontally - or by columns and rows - at the same time. And at the ...
Excel MAX Function - How to Find the Largest or Maximum Value
zhlédnutí 43Před 21 hodinou
Click here to download the Excel template: bit.ly/3XS56Tw ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Find out how to use the MAX function in Excel to find the maximum - or largest - value from a set of numbers. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are h...
Excel MIN Function - How to Find the Smallest or Minimum Value
zhlédnutí 74Před dnem
Click here to download the Excel template: bit.ly/4ctDiJA ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Find out how to use the MIN function in Excel to find the minimum - or lowest - value from a set of numbers. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are he...
Excel How to Use INDEX and MATCH Functions Together for BEGINNERS
zhlédnutí 272Před dnem
Click here to download the Excel template: bit.ly/3XO9nr2 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video you’re going to learn how to use the INDEX/MATCH function combination in Excel and a few reasons why it’s much better than VLOOKUP. We’re going to start with how to use INDEX/MATCH vertically - or using columns. Then we’ll see how to use INDEX/MATCH horizontally - or using rows. Then we’ll do a combina...
How to EASILY Count Blank Cells in Excel With The COUNTBLANK Function
zhlédnutí 82Před 14 dny
Find out how to use the COUNTBLANK function in Excel to count the number of cells in a range that do not contain anything at all. Click here to download the Excel template: bit.ly/4cnprV3 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are her...
Excel COUNTIFS Function with Multiple Criteria | Beginners Tutorial
zhlédnutí 82Před 14 dny
Find out how to use the COUNTIFS function in Microsoft Excel to count the number of cells in a range that meet more than one criteria. Click here to download the Excel template: bit.ly/4cJl5Yl ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos ar...
How to Use The Excel COUNTIF Function | Beginners Tutorial
zhlédnutí 72Před 14 dny
Find out how to use the COUNTIF function in Microsoft Excel to count the number of cells in a range that meet a certain criteria. Click here to download the Excel template: bit.ly/3RQTgp8 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are her...
How to Use The Excel COUNTA Function | Beginners Tutorial
zhlédnutí 88Před 14 dny
Find out how to use the COUNTA function in Microsoft Excel to count the number of cells that contain information of any kind - or in other words are not blank. Click here to download the Excel template: bit.ly/3XMaebW ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or ta...
How to Use The Excel COUNT Function | Beginners Tutorial
zhlédnutí 39Před 14 dny
Find out how to use the COUNT function in Microsoft Excel to count the number of cells that contain numbers. Click here to download the Excel template: bit.ly/3L8JA5t Check out our video on the COUNTA function here: czcams.com/video/cAP0eM_ebsc/video.html ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and ...
Excel SUMIFS Function with Multiple Criteria - Beginners Tutorial
zhlédnutí 88Před 14 dny
Learn how to add up data in Microsoft Excel based on multiple criteria with the SUMIFS function. Click here to download the Excel template: bit.ly/4cFE46L ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are here to inform you and the informati...
How to Use The Excel SUMIF Function - Beginners Tutorial
zhlédnutí 154Před 21 dnem
Find out how to use the SUMIF function in Microsoft Excel to add up values in your spreadsheet based on one criteria. Click here to download the Excel template: bit.ly/3PKCtmy ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are here to inform ...
Excel SUM Function - Explained for BEGINNERS
zhlédnutí 201Před 21 dnem
Find out how to use the SUM function in Microsoft Excel to add up the values in several different cells. Click here to download the Excel template: bit.ly/3RLK1pR ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that the owners of this CZcams channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are here to inform you and the i...
Excel Formulas and Functions for Beginners - FREE COURSE
zhlédnutí 306Před 21 dnem
Excel Formulas and Functions for Beginners - FREE COURSE
How to Do Your Bookkeeping in Excel | EASY to Use Template for SMALL BUSINESS
zhlédnutí 811Před měsícem
How to Do Your Bookkeeping in Excel | EASY to Use Template for SMALL BUSINESS
How to SUM a Row or a Column in Excel QUICKLY
zhlédnutí 602Před 3 měsíci
How to SUM a Row or a Column in Excel QUICKLY
Excel - How to Merge and Unmerge Cells
zhlédnutí 182Před 3 měsíci
Excel - How to Merge and Unmerge Cells
How to Freeze Multiple Rows and Columns in Excel | Freeze Panes
zhlédnutí 181Před 3 měsíci
How to Freeze Multiple Rows and Columns in Excel | Freeze Panes
Excel - How to Change, Adjust or Resize Row Height & Column Width
zhlédnutí 185Před 4 měsíci
Excel - How to Change, Adjust or Resize Row Height & Column Width
Learn Xero in 27 Minutes | Crash Course for Beginners
zhlédnutí 7KPřed 4 měsíci
Learn Xero in 27 Minutes | Crash Course for Beginners
Excel - How to Hide and Unhide Rows and Columns
zhlédnutí 210Před 4 měsíci
Excel - How to Hide and Unhide Rows and Columns
Excel - How to Insert a Row or Multiple Rows
zhlédnutí 169Před 4 měsíci
Excel - How to Insert a Row or Multiple Rows
Excel - How to Insert a Column or Multiple Columns
zhlédnutí 163Před 4 měsíci
Excel - How to Insert a Column or Multiple Columns
Excel - How to Delete a Row or Multiple Rows
zhlédnutí 127Před 4 měsíci
Excel - How to Delete a Row or Multiple Rows
Excel - How to AutoFit Columns & Rows & Tables | Auto Fit Cell Size to Text
zhlédnutí 541Před 4 měsíci
Excel - How to AutoFit Columns & Rows & Tables | Auto Fit Cell Size to Text
Excel - How to Delete a Column or Multiple Columns
zhlédnutí 308Před 4 měsíci
Excel - How to Delete a Column or Multiple Columns
Excel - How to Copy and Paste Multiple Rows or Columns
zhlédnutí 1,4KPřed 4 měsíci
Excel - How to Copy and Paste Multiple Rows or Columns
I just changed my job to commission only, and my employer wants me to get an ABN number. People are telling me I’m getting exploited. Is that true
This is really educating. Learned a lot from your explanation. So precise. God bless you
Hi Mark, great video. Silly question near the 2:12 time stamp in the video, why is it safe to hit ok to reconcile button even when the status of actual invoice was 'awaiting payment'?
I'm looking at doing a online course via Swinburne. Any advice?
Good day, why is it projects on my end instead of Payrolls?
Great video!
Good info 👍🏾
Would love some behind the scenes of how the template is built using the features in excel?
Hi was wondering if you have ever come across a issue where you are unable to click on the cake a payment/batch payment and the button/tab doesn’t work ? Doesn’t take you to the next step or even show an error just unable to move forward?
It is useful, I would like to know if there are add-in tabs of fixed asset register and rows to pick up multi-currency in the transaction tab. thanks
Great work! Can you also customize colors with the advanced version?
This video along with the one on accounts receivable job, are one of the best videos I’ve seen recently. The way you’ve presented the information in a simple way is amazing!! Thank you ❤❤
Hi Mark' Is it possible to add an image to a job/project as it is say with ServiceM8 and then be able to send that to the client? (Example: Aircon Trade)
Thanks a lot :) Awesome!
Thank you for sharing. If I am doing a Monthly Bookkeeping is there a way to have it on one file?
The advanced version comes with a monthly Income Statement www.thebookkeepingchannel.com/excel-advanced-bookkeeping-template
Thank you!
Thank you!...
Fixed assets settings is not showing Anyone knw the reson
Thank you for this guide. How do we set up super for contractors that don't earn a regular salary or standard hourly rate of pay in Xero?
Thank you, Sir.
Please can you create a new video on the Payroll correction after it has been filed to ATO? I love your videos so much, you are a strong 'Expert in the Industry' thank you! :)
Fantastic video. Perfectly explained. Thank you!
Thank you for your amazing videos. Is there a tutorial on how to make and code a Director’s Loan for a P/L company? I have watched this video but it is the sole trader advice but I can’t find anything about the Director’s Loan instructions. Thank you!
1:07 Index/Match Vertically, 7:38 Index/Match Horizontally, 9:25 Index/Match vertically and horizontally.
what course do I need to learn these things ?
Great Information Thank you. Do you know if you can make the Project Estimate amount to default to Including GST/Tax ?
VIDEO is WAY TOO fuzzy...TRY AGAIN.
.... You know you can increase the video quality mate. Maybe you should try again.
All videos are shot in 1080p HD my friend. If it's fuzzy it's yout internet speed or CZcams settings that are to blame.
Actually I can see what you mean. Looks like I have some re-recording to do. Thanks for your feedback.
Great video so easily explained
Thank you so much for taking the time and sharing this.
Hello. Can you help me? I want to become a bookkeeper. But I'm a totally fresher for bookkeeping services. Can you teach me Like an intern? like practical work.
I just signed up for a 3 day free series via Instagram that uses the Skool app. skool.com/virtualbookkeepingseries
Thank you!
Awesome 👍🏾
is it possible to import the transaction if the transaction has more than one description detail/item description in 1 transaction ?
I watch 2024....
Thank you
I am from India. Your videos are excellent bro
Thanks for saying that. I really appreciate it.
worked perfect thank you.
Very nice explanation. Thanks.
Sir, you have nicely explained the difference between current and non-current assets. Thanks a lot.
thank you
Thanks
Great video to learn excel. More excel videos please. Thanks!!
Thanks and there's many many many more coming :)
@@TheBookkeepingChannel Great stuff!! Thank you!! :))
Is GST payable on Paypal sales?
My version does not have Manual Journal under Accounting or anywhere
I found it... I had to change my role to "Advisor" vs standard... not easy to find but I did ...
Wow, I love it
excellent video, thank you!
WHICH field do you use for the addresses? There are way too many address fields to consider in the example
Thank you! Just what I needed!
Can I add a second tax. I collect and pay PST on sales but I also pay and retain some GST on expenses
Cheers mate