The Bookkeeping Channel
The Bookkeeping Channel
  • 284
  • 2 446 010
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.
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
What are Liabilities in Accounting?
zhlédnutí 406Před 4 měsíci
What are Liabilities in Accounting?

Komentáře

  • @Joe-dz2fl
    @Joe-dz2fl Před 14 minutami

    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

  • @mfonisoGorgeousJohncharles
    @mfonisoGorgeousJohncharles Před 4 hodinami

    This is really educating. Learned a lot from your explanation. So precise. God bless you

  • @Sumbula89
    @Sumbula89 Před 12 hodinami

    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'?

  • @Freedomone153
    @Freedomone153 Před 12 hodinami

    I'm looking at doing a online course via Swinburne. Any advice?

  • @mariahjohannauy
    @mariahjohannauy Před 23 hodinami

    Good day, why is it projects on my end instead of Payrolls?

  • @lee-wood
    @lee-wood Před dnem

    Great video!

  • @donnah5378
    @donnah5378 Před dnem

    Good info 👍🏾

  • @tysont2380
    @tysont2380 Před dnem

    Would love some behind the scenes of how the template is built using the features in excel?

  • @kimdyer6756
    @kimdyer6756 Před 2 dny

    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?

  • @stellawong1797
    @stellawong1797 Před 2 dny

    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

  • @RICKYVSP
    @RICKYVSP Před 2 dny

    Great work! Can you also customize colors with the advanced version?

  • @566johncena
    @566johncena Před 4 dny

    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 ❤❤

  • @SonjaH-b7e
    @SonjaH-b7e Před 5 dny

    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)

  • @MaryRoseSantos-l9w
    @MaryRoseSantos-l9w Před 6 dny

    Thanks a lot :) Awesome!

  • @jasminetineo6594
    @jasminetineo6594 Před 6 dny

    Thank you for sharing. If I am doing a Monthly Bookkeeping is there a way to have it on one file?

    • @TheBookkeepingChannel
      @TheBookkeepingChannel Před 2 dny

      The advanced version comes with a monthly Income Statement www.thebookkeepingchannel.com/excel-advanced-bookkeeping-template

  • @dogestep64
    @dogestep64 Před 6 dny

    Thank you!

  • @silvestrecamposano6317

    Thank you!...

  • @asklimited5396
    @asklimited5396 Před 7 dny

    Fixed assets settings is not showing Anyone knw the reson

  • @redsoda
    @redsoda Před 7 dny

    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?

  • @user-mv3ng9rj2l
    @user-mv3ng9rj2l Před 7 dny

    Thank you, Sir.

  • @lillianhaigh5388
    @lillianhaigh5388 Před 7 dny

    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! :)

  • @yasminibz9270
    @yasminibz9270 Před 9 dny

    Fantastic video. Perfectly explained. Thank you!

  • @helenvosti8543
    @helenvosti8543 Před 9 dny

    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!

  • @CntrlAltUniverse
    @CntrlAltUniverse Před 11 dny

    1:07 Index/Match Vertically, 7:38 Index/Match Horizontally, 9:25 Index/Match vertically and horizontally.

  • @emmanuelmtonga178
    @emmanuelmtonga178 Před 11 dny

    what course do I need to learn these things ?

  • @user-kt3lu7zy4y
    @user-kt3lu7zy4y Před 13 dny

    Great Information Thank you. Do you know if you can make the Project Estimate amount to default to Including GST/Tax ?

  • @romeowhiskey1146
    @romeowhiskey1146 Před 13 dny

    VIDEO is WAY TOO fuzzy...TRY AGAIN.

    • @samanthastark1533
      @samanthastark1533 Před 13 dny

      .... You know you can increase the video quality mate. Maybe you should try again.

    • @TheBookkeepingChannel
      @TheBookkeepingChannel Před 13 dny

      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.

    • @TheBookkeepingChannel
      @TheBookkeepingChannel Před 12 dny

      Actually I can see what you mean. Looks like I have some re-recording to do. Thanks for your feedback.

  • @kevaljoshi7594
    @kevaljoshi7594 Před 14 dny

    Great video so easily explained

  • @LifeOftheOreste
    @LifeOftheOreste Před 14 dny

    Thank you so much for taking the time and sharing this.

  • @woheadchowdhury
    @woheadchowdhury Před 15 dny

    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.

    • @Georgeanne17
      @Georgeanne17 Před 5 dny

      I just signed up for a 3 day free series via Instagram that uses the Skool app. skool.com/virtualbookkeepingseries

  • @user-mv3ng9rj2l
    @user-mv3ng9rj2l Před 15 dny

    Thank you!

  • @ppp0911
    @ppp0911 Před 15 dny

    Awesome 👍🏾

  • @Yuniast_
    @Yuniast_ Před 16 dny

    is it possible to import the transaction if the transaction has more than one description detail/item description in 1 transaction ?

  • @faruonline5079
    @faruonline5079 Před 16 dny

    I watch 2024....

  • @theonetrue1687
    @theonetrue1687 Před 16 dny

    Thank you

  • @SubramanyamGaddam
    @SubramanyamGaddam Před 17 dny

    I am from India. Your videos are excellent bro

  • @stevenessa6029
    @stevenessa6029 Před 17 dny

    worked perfect thank you.

  • @y62782
    @y62782 Před 17 dny

    Very nice explanation. Thanks.

  • @y62782
    @y62782 Před 17 dny

    Sir, you have nicely explained the difference between current and non-current assets. Thanks a lot.

  • @syprix
    @syprix Před 18 dny

    thank you

  • @sayedalaraf134
    @sayedalaraf134 Před 19 dny

    Thanks

  • @Kitty-lj7eg
    @Kitty-lj7eg Před 20 dny

    Great video to learn excel. More excel videos please. Thanks!!

  • @pharkurnell9561
    @pharkurnell9561 Před 21 dnem

    Is GST payable on Paypal sales?

  • @TerryGrier
    @TerryGrier Před 21 dnem

    My version does not have Manual Journal under Accounting or anywhere

    • @TerryGrier
      @TerryGrier Před 21 dnem

      I found it... I had to change my role to "Advisor" vs standard... not easy to find but I did ...

  • @bam2ri
    @bam2ri Před 22 dny

    Wow, I love it

  • @brisafrausto7725
    @brisafrausto7725 Před 23 dny

    excellent video, thank you!

  • @CorleneGreenwood
    @CorleneGreenwood Před 23 dny

    WHICH field do you use for the addresses? There are way too many address fields to consider in the example

  • @ChantelleHills
    @ChantelleHills Před 24 dny

    Thank you! Just what I needed!

  • @easel.butler
    @easel.butler Před 24 dny

    Can I add a second tax. I collect and pay PST on sales but I also pay and retain some GST on expenses

  • @mustasan77
    @mustasan77 Před 24 dny

    Cheers mate