Digital School Academy
Digital School Academy
  • 179
  • 565 891
Built in Functions in Excel & how to use them | Excel for Absolute Beginners - #22
This is the 22nd lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you.
In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spreadsheets:
*** Built in Functions in Excel & how to use them
*** How to use functions in Excel
*** Text functions (lower, upper, trim, concatenate, left, right, len)
*** Date & Time (date, time, datevalue, timevalue, now, today)
*** Statistical (max, min, average, count, countif, sum)
*** Logical (and, or, not)
*** Math & Trig (ABS, sign, sqrt, mod)
Playlist for the full course: ua-cam.com/play/PLRKBQyzCSrVAppW0KDLJfdWd-O0tpIlVE.html
Check out our Microsoft Excel playlist: ua-cam.com/play/PLRKBQyzCSrVAm32cu7zratdcJG3y-o8J2.html
If you like the videos I produce and would like to support me to produce more educating content, then become a patron of the channel by clicking on this link: patreon.com/ehoneah
Here are links to the communities that we have built around this UA-cam channel, join any of them that you are interested in:
Telegram: techpady.com/r/telegram
Facebook: techpady.com/r/ikrate
WhatsApp: techpady.com/r/whatsapp
Переглядів: 329

Відео

How to use functions in Excel | Excel for Absolute Beginners - #21
Переглядів 962 роки тому
This is the 21st lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
Excel Cell Reference & How to use them | Excel for Absolute Beginners - #20
Переглядів 572 роки тому
This is the 20th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to create formulas in Excel | Excel for Absolute Beginners - #19
Переглядів 722 роки тому
This is the 19th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
Conditional formatting in Excel | Excel for Absolute Beginners - #18
Переглядів 402 роки тому
This is the 18th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to format your sheet in Excel | Excel for Absolute Beginners - #17
Переглядів 612 роки тому
This is the 17th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
Various Number Types in Excel | Excel for Absolute Beginners #16
Переглядів 552 роки тому
This is the 16th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to Format Cells in Excel | Excel for Absolute Beginners #15
Переглядів 512 роки тому
This is the 15th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to Format Text In Excel | Excel for Absolute Beginners #14
Переглядів 432 роки тому
This is the 14th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
Inserting Comments in an Excel spreadsheet | Excel for Absolute Beginners 13
Переглядів 462 роки тому
This is the 13th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
Using special symbols & characters in Excel | Excel for Absolute Beginners #12
Переглядів 642 роки тому
This is the 12th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to use spelling check in Excel | Excel for Absolute Beginners #11
Переглядів 852 роки тому
This is the 11th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to Find & Replace Data in Excel | Excel for Absolute Beginners #10
Переглядів 662 роки тому
This is the 10th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel spre...
How to Copy, Paste & Move Data | Excel for Absolute Beginners #9
Переглядів 572 роки тому
This is the 9th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about some actions that you can take whiles working with Microsoft Excel sprea...
How to insert, select and delete data - Excel for Absolute Beginners #8
Переглядів 752 роки тому
This is the 8th lesson of the Excel for Absolute beginners course. This lesson starts from the very basics of Excel so even if you haven't used Excel before or this is your first time hearing about Microsoft Excel, this is a good lesson for you. In this lesson of the Excel for Absolute beginners course you will learn about inserting, deleting, and selecting data in Excel as well as all tips and...
How to create, delete or hide spreadsheets - Excel for Absolute Beginners #7
Переглядів 732 роки тому
How to create, delete or hide spreadsheets - Excel for Absolute Beginners #7
How to save in excel - Excel for Absolute Beginners Lesson 6
Переглядів 702 роки тому
How to save in excel - Excel for Absolute Beginners Lesson 6
Moving around in Excel - Excel for Absolute Beginners Lesson 5
Переглядів 852 роки тому
Moving around in Excel - Excel for Absolute Beginners Lesson 5
How to enter data in Excel - Excel for Absolute Beginners Lesson 4
Переглядів 1152 роки тому
How to enter data in Excel - Excel for Absolute Beginners Lesson 4
Backstage view of Excel - Excel for Absolute Beginners Lesson 3
Переглядів 1182 роки тому
Backstage view of Excel - Excel for Absolute Beginners Lesson 3
Exploring the Excel interface - Excel for Absolute Beginners 2
Переглядів 1752 роки тому
Exploring the Excel interface - Excel for Absolute Beginners 2
Introduction to Microsoft Excel - Excel for Absolute Beginners 1
Переглядів 2592 роки тому
Introduction to Microsoft Excel - Excel for Absolute Beginners 1
How Soon/Fast Can You Master a Digital Skill
Переглядів 422 роки тому
How Soon/Fast Can You Master a Digital Skill
How to Learn a New Digital Skill Quickly
Переглядів 972 роки тому
How to Learn a New Digital Skill Quickly
5 Easy Steps to Improve Your Digital Literacy in 2022
Переглядів 2252 роки тому
5 Easy Steps to Improve Your Digital Literacy in 2022
Top 4 Digital Skills That Everyone Must Master in 2022
Переглядів 1432 роки тому
Top 4 Digital Skills That Everyone Must Master in 2022
Which is the best place to learn new digital skills: YouTube VS Udemy
Переглядів 762 роки тому
Which is the best place to learn new digital skills: UA-cam VS Udemy
10 Best Platforms To Learn Programming For Free - Digital Skills
Переглядів 2342 роки тому
10 Best Platforms To Learn Programming For Free - Digital Skills
How to remove duplicates in Excel using the COUNTIF function
Переглядів 1,2 тис.2 роки тому
How to remove duplicates in Excel using the COUNTIF function
How to split a column into multiple columns in excel - Power Query
Переглядів 352 роки тому
How to split a column into multiple columns in excel - Power Query

КОМЕНТАРІ

  • @royalwavemusic9471
    @royalwavemusic9471 День тому

    Best presentation on this topic!

  • @mrsmith1097
    @mrsmith1097 5 днів тому

    Thanks!

  • @muhammadafzalhussainkhan5689
    @muhammadafzalhussainkhan5689 7 днів тому

    This website has been taken down my austrain CIA can tell about other sites similar to this?

  • @BrightAngel-u1y
    @BrightAngel-u1y 11 днів тому

    Thank you 🙏

  • @evvehiclesnextgeneration2943
    @evvehiclesnextgeneration2943 18 днів тому

    do not wasting time watching this video the website is down

  • @rkhoshnaw3615
    @rkhoshnaw3615 29 днів тому

    Thank you.

  • @ShadowMindInsights-qk4vc
    @ShadowMindInsights-qk4vc Місяць тому

    Thank you sir

  • @alexandreismaelgastene7317
    @alexandreismaelgastene7317 Місяць тому

    I liked so much. Thanks!

  • @transformedmindrenewed5451
    @transformedmindrenewed5451 2 місяці тому

    thank you so much.

  • @user-ix6dx1xy1v
    @user-ix6dx1xy1v 2 місяці тому

    ❤❤❤

  • @henrysmith883
    @henrysmith883 2 місяці тому

    This is complete annoying crap

  • @russellng
    @russellng 2 місяці тому

    I can’t understand what the speaker is saying, not fluent in English. Plus there’s an irritating background track that makes a bad situation even worse. What a waste.

  • @joannajames2354
    @joannajames2354 2 місяці тому

    Worked for me and thank you.

  • @hatemaltahir3868
    @hatemaltahir3868 2 місяці тому

    Thanks a million for a job well done.

  • @juangallego714
    @juangallego714 2 місяці тому

    Turn off the annoying background music. This video was not planned and is of poor quality.

  • @IGOR73ASRM
    @IGOR73ASRM 2 місяці тому

    Thank you so much 😭😭😭

  • @osaheniosas4731
    @osaheniosas4731 2 місяці тому

    What of from word to PowerPoint?

  • @osamausmani8702
    @osamausmani8702 2 місяці тому

    How to use this app on apple?

  • @vinnynzuza
    @vinnynzuza 2 місяці тому

    Awesome brother..

  • @user-yc6up6so7m
    @user-yc6up6so7m 3 місяці тому

    Thanks so much.

  • @ntabwobaleandre8326
    @ntabwobaleandre8326 3 місяці тому

    Thank you. Would like to send me your email?

  • @amishasingla9736
    @amishasingla9736 3 місяці тому

    👍

  • @KritarthMalviya
    @KritarthMalviya 3 місяці тому

    Thank you so much! You saved my day

  • @IIFJAS
    @IIFJAS 3 місяці тому

    Thank you for the video. You saved me from a lot of struggle. 👍🙂

  • @richardnyarko6871
    @richardnyarko6871 3 місяці тому

    Thank boss...this has always been a challenge for me. Now, I've learnt an easy way to do it👏👏👍🤗

  • @Planje1
    @Planje1 3 місяці тому

    Love you! Found it via a proxy website. Just type in the site and proxy on the end and you get some options via Google :)

  • @startup-mamaSarl
    @startup-mamaSarl 3 місяці тому

    Tanks full

  • @framex_media
    @framex_media 4 місяці тому

    Excellent explanation, thank you very much, you saved me a lot of time!

  • @alexrizzo2762
    @alexrizzo2762 4 місяці тому

    Good directions, worked very well

  • @glenorrett6181
    @glenorrett6181 4 місяці тому

    FBI shut down the website\

  • @benkuzzy
    @benkuzzy 4 місяці тому

    this is the error i got "word cannot safe or create this file. make sure the disk you want to safe the file on is not full, write protected of damaged", how do i fix

  • @xukay6706
    @xukay6706 4 місяці тому

    Good job man!!! Saves me time. Very efficient and easy way to do.

  • @alfredwaqa9946
    @alfredwaqa9946 4 місяці тому

    What a wonderful presentation sir. Keep up the good work.

  • @tebidanwenyuwei8902
    @tebidanwenyuwei8902 5 місяців тому

    I tried to open but what I saw was it has been seized so can’t open

  • @user-dc2fq4fm6o
    @user-dc2fq4fm6o 5 місяців тому

    Thank you.

  • @f9883h
    @f9883h 6 місяців тому

    Thank you.

  • @maladhokane7234
    @maladhokane7234 6 місяців тому

    I really appreciate this video it helped me a lot Thanks

  • @maladhokane7234
    @maladhokane7234 6 місяців тому

    Thank i did it

  • @PreciousProperty-sl6ds
    @PreciousProperty-sl6ds 6 місяців тому

    Thank you so much, you have no idea how much this helped me.

  • @arungovindan7028
    @arungovindan7028 6 місяців тому

    Thanks brother 💖

  • @deenanddunya9911
    @deenanddunya9911 7 місяців тому

    Thanks sir

  • @chimdichikezie7932
    @chimdichikezie7932 7 місяців тому

    This saved me right now. Thanks.

  • @user-dw3of5px8e
    @user-dw3of5px8e 7 місяців тому

    Perfect explanation - thanks : )

  • @zzz78826
    @zzz78826 7 місяців тому

    Thank you for saving my time.

  • @ac6683
    @ac6683 7 місяців тому

    That was really helpful. Could you please explain how this would work if you copy and past contents of an excel spreadsheet into the word document and the content is longer than one page?

  • @susantanabe5783
    @susantanabe5783 7 місяців тому

    I can't thank you enough for this video! You helped me find something I could NOT find anywhere! Thank you so, so much!

  • @muhammadjahankhan6861
    @muhammadjahankhan6861 8 місяців тому

    well explained, thank you.

  • @arianehuang8841
    @arianehuang8841 8 місяців тому

    thanks for the content rly useful!

  • @daddyawesome5100
    @daddyawesome5100 8 місяців тому

    thank you for this, this is 3years after but your video was helpful to me. just want to encourage you to keep up with this ur channel. you are a good teacher. u just got a follower

  • @ojogbemisola9975
    @ojogbemisola9975 8 місяців тому

    THANK YOU. GOD BLESS YOU