Excel Formulas and Functions for Beginners - FREE COURSE

Поделиться
HTML-код
  • Опубликовано: 13 июл 2024
  • Download the Excel workbook by clicking here: bit.ly/4cjMAbf
    Download the Excel workbook with answers here: bit.ly/45N1Jiw
    Learn how to use formulas and functions in Microsoft Excel with this full length tutorial. Designed to be like a free course, you will learn step-by-step the basics of functions and formulas in Excel before finding out how to use about 30 of the most popular functions in Excel.
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Timestamps:
    Excel Formulas and Functions for Beginners - FREE COURSE 00:00:00
    Formulas vs Functions 00:00:55
    Creating Formulas and Functions 00:03:30
    Editing Formulas or Functions 00:07:32
    Referencing Cells 00:09:38
    FORMULATEXT 00:19:19
    Order of Operators 00:21:22
    SUM 00:28:02
    COUNT 00:32:52
    AVERAGE 00:35:42
    MIN 00:38:00
    MAX 00:40:05
    SUMIF 00:41:49
    SUMIFS 00:45:43
    COUNTIF 00:48:22
    COUNTIFS 00:51:44
    COUNTBLANK 00:53:48
    CONACT and ampersand 00:56:49
    UPPER 00:59:28
    LOWER 01:00:14
    PROPER 01:01:03
    RIGHT 01:02:38
    LEFT 01:04:10
    MID 01:05:23
    LEN 01:07:14
    Logical Operators 01:08:48
    IF 01:16:51
    IF with AND 01:21:44
    IF with OR 01:25:57
    Nested IF 01:30:00
    IFS 01:34:12
    VLOOKUP 01:36:49
    XLOOKUP 01:40:29
    INDEX/MATCH 01:44:56
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Please note that the owners of this RUclips 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.

Комментарии •