Omoabugan Emmanuel
Omoabugan Emmanuel
  • 32
  • 85 056
How to Create a Library Management System Program in Microsoft Excel
In this video tutorial I will be showing us how to manage a Library data base. Most especially being able to track books borrowed from the Library. This particular activity can be tracked using Microsoft Excel. Therefore, go watch this video tutorial and don't forget to like, share and subscribe to my CZcams channel for more update.
#excel #library #database #excelclasses #librarymanagementsystem #exceltraining
zhlédnutí: 783

Video

Using Custom Sort in Microsoft Excel5:16Using Custom Sort in Microsoft Excel
Using Custom Sort in Microsoft Excel
zhlédnutí 94Před 11 měsíci
In this video tutorial, I will be showing us * How to use Custom Sort in Microsoft Excel*. The *Custom Sort* is a feature in Excel that allows you to sort your data using a particular order of list. This feature can be helpful especially when you are trying to sort a Large data set in a particular order. *Link to the Excel File used in this video tutorial:* docs.google.com/spreadsheets/d/1JgodY...
How to use Excel SUBTOTAL Function8:28How to use Excel SUBTOTAL Function
How to use Excel SUBTOTAL Function
zhlédnutí 129Před rokem
In this video tutorial I will be showing us how to use Excel SUBTOTAL function to manipulate a data set. *Here is the Link to the Practice File:* docs.google.com/spreadsheets/d/1pzPqzF9UAAqEB9ulPF39EqjOAmEztd1a/edit?usp=drive_link&ouid=116792682608318583840&rtpof=true&sd=true Kindly leave a comment below this video if you found this video tutorial to be helpful. Don't also forget to *SUBSCRIBE*...
Using the Excel LARGE and SMALL Functions8:38Using the Excel LARGE and SMALL Functions
Using the Excel LARGE and SMALL Functions
zhlédnutí 91Před rokem
In this video tutorial I will be showing us how to use the LARGE and SMALL functions in Microsoft Excel in order to determine the order of the Highest and Lowest number in a data set. *Link to the Excel workbook used in this video:* docs.google.com/spreadsheets/d/1re1B9G_Ufi5DVLqm4EwKoIOIC2mMZemF/edit?usp=drive_link&ouid=116792682608318583840&rtpof=true&sd=true Don't forget to Like, Share and S...
How to Check Spellings in Microsoft Excel6:25How to Check Spellings in Microsoft Excel
How to Check Spellings in Microsoft Excel
zhlédnutí 86Před rokem
In this video tutorial I will be showing us how to correct spelling errors in Microsoft Excel. *Link to the Practice File:* docs.google.com/spreadsheets/d/126p3_FenX2He8hfE8TjMlEOTtwLOvYuA/edit?usp=drive_link&ouid=116792682608318583840&rtpof=true&sd=true You can also see my other video on: *How to prepare a Pension Schedule in Microsoft Excel:* czcams.com/video/jhq3g8bYNss/video.html Kindly Ple...
How To Create a Search box using Conditional Formatting in Microsoft Excel7:55How To Create a Search box using Conditional Formatting in Microsoft Excel
How To Create a Search box using Conditional Formatting in Microsoft Excel
zhlédnutí 278Před rokem
In this video I will be showing us how to create a search box in Microsoft Excel using Conditional Formatting that would allow Excel to highlight the rows of the selected criteria in your data set. Attached here is the Excel File for your personal practice: *Link to Practice File:* docs.google.com/spreadsheets/d/1hT9zQi4a9xa3GSXHbTDaV18yjIa01EAe/edit?usp=drive_link&ouid=116792682608318583840&rt...
Microsoft Excel Training and Certification1:37Microsoft Excel Training and Certification
Microsoft Excel Training and Certification
zhlédnutí 96Před rokem
The *Financial Analysis Master Class* is divided into 2 Levels, we have the: - *Beginners to Intermediate Excel level* - *Advanced Excel Level* For further enquires feel free to: *Call/WhatsApp:* 234169394017 *Email:* omoabuganemmanuel@gmail.com or Chat us directly following this link: bit.ly/3wjYy0S #exceltutorial #excel #exceltraining #excelcompletecourse #excelcourse #virtualtraining #virtua...
How to Create QR Code in Microsoft Word, Excel and PowerPoint.10:01How to Create QR Code in Microsoft Word, Excel and PowerPoint.
How to Create QR Code in Microsoft Word, Excel and PowerPoint.
zhlédnutí 151Před rokem
In this video tutorial I demonstrated how to create a Qr code using Microsoft Application that can take us directly to a website. Kindly please subscribe to my CZcams channel for more updates. Thank you!!!
How to remove Duplicates in Microsoft Excel2:09How to remove Duplicates in Microsoft Excel
How to remove Duplicates in Microsoft Excel
zhlédnutí 139Před rokem
In this video tutorial I demonstrated how to remove duplicate text and values in Microsoft Excel. #excel #exceltutorial #duplicate #removeduplicates
Inventory Management in Microsoft Excel15:55Inventory Management in Microsoft Excel
Inventory Management in Microsoft Excel
zhlédnutí 472Před rokem
In this video tutorial I demonstrated how to manage Inventory using Microsoft Excel. To registeration and enquires about my Financial Analysis with Microsoft Excel course, click on the link below: bit.ly/3wjYy0S Here is a detailed video exposing some of the benefits of my Financial analysis with Microsoft Excel course here: czcams.com/video/Ogx6AAn30w8/video.html
The Excel Status Bar12:02The Excel Status Bar
The Excel Status Bar
zhlédnutí 122Před rokem
In this video tutorial I showed us how the Excel Status Bar can really come in handy as a tool to use in order to quickly gain insight from your data set. Kindly please subscribe to my CZcams channel for more updates and also to support my channel. Thank you!!! #excel #exceltutorial #statusbar
How to Create a Custom Auto-fill List in Excel16:32How to Create a Custom Auto-fill List in Excel
How to Create a Custom Auto-fill List in Excel
zhlédnutí 204Před rokem
In this video tutorial I demonstrated How to Create a Custom Auto-fill list in Microsoft Excel. Kindly please subscribe to my CZcams Channel to encourage me to release more video contents like these. Thank you !!!
How to Create a Copy of a Worksheet in Microsoft Excel10:26How to Create a Copy of a Worksheet in Microsoft Excel
How to Create a Copy of a Worksheet in Microsoft Excel
zhlédnutí 150Před rokem
In this video Tutorial I demonstrated How to Create a Copy of a Worksheet in Microsoft Excel. In Excel there are several ways to duplicate a worksheet, they include: *Method 1:* The Move or Copy method *Method 2:* Using the keyboard short cut and dragging of the mouse You can also check out our other video on: *How to prepare a Sales Data report using Excel:* czcams.com/video/m8mrE6yh4yU/video....
Solving Simultaneous Equations in Excel9:14Solving Simultaneous Equations in Excel
Solving Simultaneous Equations in Excel
zhlédnutí 942Před rokem
In this video tutorial I demonstrated *How To Solve Simultaneous Equations Using Microsoft Excel*. #excel #exceltutorial #mathematics #maths #algebra #equation #simultaneousequation
Using the Excel ROMAN and ARABIC Functions2:58Using the Excel ROMAN and ARABIC Functions
Using the Excel ROMAN and ARABIC Functions
zhlédnutí 87Před rokem
In this video I demonstrated how to use the *ROMAN* and *ARABIC* Functions in Microsoft Excel to convert numbers into a Roman numerals and vice versa. Here is the Link to the Practice File for the Video: #excel #exceltutorial #Roman_Numerals #roman_number #Numbers_to_RomanNumber_in_Excel
How to Transpose Data in Microsoft Excel5:45How to Transpose Data in Microsoft Excel
How to Transpose Data in Microsoft Excel
zhlédnutí 100Před rokem
How to Transpose Data in Microsoft Excel
Quadratic Equations Using Microsoft Excel10:05Quadratic Equations Using Microsoft Excel
Quadratic Equations Using Microsoft Excel
zhlédnutí 846Před rokem
Quadratic Equations Using Microsoft Excel
Excel Functions to Help Fix Bad Text4:04Excel Functions to Help Fix Bad Text
Excel Functions to Help Fix Bad Text
zhlédnutí 134Před rokem
Excel Functions to Help Fix Bad Text
Creating Easy Data Entry Forms in Excel10:04Creating Easy Data Entry Forms in Excel
Creating Easy Data Entry Forms in Excel
zhlédnutí 438Před rokem
Creating Easy Data Entry Forms in Excel
Calculate Loan Payment with Excel PMT Function3:17Calculate Loan Payment with Excel PMT Function
Calculate Loan Payment with Excel PMT Function
zhlédnutí 274Před rokem
Calculate Loan Payment with Excel PMT Function
Financial Analysis with Microsoft Excel Master Class - Virtual Training8:32Financial Analysis with Microsoft Excel Master Class - Virtual Training
Financial Analysis with Microsoft Excel Master Class - Virtual Training
zhlédnutí 163Před rokem
Financial Analysis with Microsoft Excel Master Class - Virtual Training
How To Make Sales Report in Excel12:26How To Make Sales Report in Excel
How To Make Sales Report in Excel
zhlédnutí 322Před rokem
How To Make Sales Report in Excel
How to Calculate GPA using Ms Excel11:28How to Calculate GPA using Ms Excel
How to Calculate GPA using Ms Excel
zhlédnutí 6KPřed rokem
How to Calculate GPA using Ms Excel
How to use Microsoft Excel to Create Student results/School report sheet.19:30How to use Microsoft Excel to Create Student results/School report sheet.
How to use Microsoft Excel to Create Student results/School report sheet.
zhlédnutí 32KPřed rokem
How to use Microsoft Excel to Create Student results/School report sheet.
Create Multiplication Table in Excel7:14Create Multiplication Table in Excel
Create Multiplication Table in Excel
zhlédnutí 801Před rokem
Create Multiplication Table in Excel
Monthly payment schedule in Excel21:12Monthly payment schedule in Excel
Monthly payment schedule in Excel
zhlédnutí 9KPřed rokem
Monthly payment schedule in Excel
How to make monthly income and expenses in excel sheet27:50How to make monthly income and expenses in excel sheet
How to make monthly income and expenses in excel sheet
zhlédnutí 3,5KPřed rokem
How to make monthly income and expenses in excel sheet
How to Compute Pension schedule using Microsoft Excel.21:26How to Compute Pension schedule using Microsoft Excel.
How to Compute Pension schedule using Microsoft Excel.
zhlédnutí 1,7KPřed rokem
How to Compute Pension schedule using Microsoft Excel.
How to prepare a payroll in Excel32:45How to prepare a payroll in Excel
How to prepare a payroll in Excel
zhlédnutí 24KPřed rokem
How to prepare a payroll in Excel
How to prepare an Invoice using Microsoft Excel.21:31How to prepare an Invoice using Microsoft Excel.
How to prepare an Invoice using Microsoft Excel.
zhlédnutí 693Před rokem
How to prepare an Invoice using Microsoft Excel.

Komentáře

  • @ClarionttechHRServices
    @ClarionttechHRServices Před 7 dny

    You have done a great job, is there any regulated percentage for BHT?

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 7 dny

      In Nigeria, the regulated percentage for Basic Housing and Transportation (BHT) in payroll computation is: - 30% of basic salary for Housing - 20% of basic salary for Transportation This is in line with the guidelines provided by the National Salaries, Incomes and Wages Commission (NSIWC) and the Federal Inland Revenue Service (FIRS). The total BHT allowance is usually capped at 50% of basic salary, which is: 30% (Housing) + 20% (Transportation) = 50% Please note that these percentages are subject to change, and it's essential to consult the relevant authorities or a tax professional for the most up-to-date information.

    • @ClarionttechHRServices
      @ClarionttechHRServices Před 7 dny

      Thanks

  • @portiachinda7982
    @portiachinda7982 Před 9 dny

    Wow!!! I've been seeing payroll as rocket science until I stumbled upon your video. Your teaching is the Montessori pattern, very clear and concise 👏👏. Thank you so much. You earned yourself a big fan. 😊

  • @goodview360
    @goodview360 Před 10 dny

    great video, a lot learnt

  • @Miguelskytwins
    @Miguelskytwins Před 16 dny

    Thank you for the video!

  • @chiomaekwunife2307
    @chiomaekwunife2307 Před 21 dnem

    Well clear!

  • @khalifamaawiyya3767
    @khalifamaawiyya3767 Před měsícem

    Sir I need to know how set a report in Excel Can you give your WhatsApp number

  • @AbebeNegeri
    @AbebeNegeri Před měsícem

    ❤

  • @OnyesRozy
    @OnyesRozy Před měsícem

    U are good

  • @shattaadiwale
    @shattaadiwale Před měsícem

    what kind of report card is this

  • @shattaadiwale
    @shattaadiwale Před měsícem

    is it only in my country that knows that this is not report sheet/ card

  • @NAOMIWANJIKUKINUTHIA
    @NAOMIWANJIKUKINUTHIA Před 2 měsíci

    goodwork

  • @elabbadiamine4296
    @elabbadiamine4296 Před 2 měsíci

    great work can you sent download link please

  • @constanciamabel8077
    @constanciamabel8077 Před 2 měsíci

    This was so helpful, thank you

  • @josues6473
    @josues6473 Před 3 měsíci

    You helped me so much make a payment plan on excel, to the point I rewatched the video multiple times! Just to listen to it as back ground noise, Thank you Omoabugan Emmanuel

  • @edisonidoko2324
    @edisonidoko2324 Před 4 měsíci

    Excellent job..but I need video on store keeping record using excel

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 3 měsíci

      Check out this video tutorial on that : czcams.com/video/g8ynkabdBXw/video.htmlsi=A89DPzhXBhO9qvPQ

  • @PennsHill-gw3ih
    @PennsHill-gw3ih Před 4 měsíci

    Pls, is it possible for you to prepare this for someone?

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 3 měsíci

      Sure I can do that for you and even customize it to include more details like position among others at a token fee. Kindly message me on +234-7087212992

  • @penscription
    @penscription Před 4 měsíci

    But I need to rank them in order from (1st, 2nd, 3rd, etc) from the top to bottom to show their positions. How do I do that? Thank you again for the video.

  • @IrwinOdee
    @IrwinOdee Před 4 měsíci

    Helpful. Thank you

  • @suchithavishwa939
    @suchithavishwa939 Před 4 měsíci

    super

  • @yawbaffour1441
    @yawbaffour1441 Před 4 měsíci

    You made this very simple. Thank you

  • @enejohyemisi4241
    @enejohyemisi4241 Před 5 měsíci

    Thank you so much sir please How can i create termly result with excel I have been using word for a long tine and it's very difficult

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 5 měsíci

      Chat me up on WhatsApp I have a premium report card template for you. +2348169394017. Though it comes with a token price

  • @ibisojack3653
    @ibisojack3653 Před 5 měsíci

    Guy you dey teach…. I understood every part of it.

  • @agabaandrewattah4443
    @agabaandrewattah4443 Před 5 měsíci

    Emmanuel if I may ask which update year version of Microsoft Excel do you use for this video?

  • @sefraeric
    @sefraeric Před 5 měsíci

    I understood every part of it thank you 🙏🏻

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 5 měsíci

      U welcome. Thanks for the Feedback consider subscribing to my CZcams channel for more updates

  • @orjiolisadebe1109
    @orjiolisadebe1109 Před 5 měsíci

    GOOD TEACHER

  • @henryjohn9748
    @henryjohn9748 Před 5 měsíci

    Thanks boss for this video it's very helpful

  • @truetv5953
    @truetv5953 Před 6 měsíci

    Are you from nigeria ? Omo this guy remind of my old days in yaba tech Lagos. Do you have whatsapp ? Please send here make i go back to school

  • @user-ob5ct7xs7q
    @user-ob5ct7xs7q Před 6 měsíci

    Thank you very much. This was apt, precise and detailed, i can say i know how to fo payrolling

  • @Timi_leyin
    @Timi_leyin Před 6 měsíci

    God bless you sir Is very understanding than those india ones am see How can I do the formula sir ❤

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 6 měsíci

      For this though I didnt use a formula. Is just to use auto fill handle feature in Excel.

  • @moyobeky-rv5tz
    @moyobeky-rv5tz Před 6 měsíci

    I started watching your video today and I found myself enjoying your lectures, thank you sir from south Sudan.

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 6 měsíci

      I appreciate the feedback. Kindly please subscribe to my CZcams channel

  • @azamhafidzul7450
    @azamhafidzul7450 Před 7 měsíci

    This is a very useful video. Thank you for posting it. It gave me great help.

  • @joshuagayina6913
    @joshuagayina6913 Před 7 měsíci

    Thanks you for this video

  • @daryza7990
    @daryza7990 Před 7 měsíci

    Nice Sharing!

  • @ahmadadam2965
    @ahmadadam2965 Před 7 měsíci

    Thanks you very much l like it sir

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 7 měsíci

      You are welcome sir. Kindly please go ahead and subscribe to my CZcams channel

  • @bentaokoo6680
    @bentaokoo6680 Před 7 měsíci

    I totally love this.🇰🇪

  • @habibmomodu1074
    @habibmomodu1074 Před 7 měsíci

    Thank you sir,sir pls make series of videos showing all the books of account that are opened to the statement of financial position.you are a tutor I will love to have your number .

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 7 měsíci

      Thanks for the feedback I really appreciate consider subscribing to my CZcams channel so as I continue to drop videos you get notified about it.

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 7 měsíci

      Here Is my contact number via whatsapp: 07087212992

  • @emmanueluka2766
    @emmanueluka2766 Před 7 měsíci

    Your lecture was much detailed

  • @nanaadinkra9020
    @nanaadinkra9020 Před 7 měsíci

    Also, if the rank function for the positions, how do you make the student names, and the scores match with the positions?

    • @Chairmoe_analytics
      @Chairmoe_analytics Před 7 měsíci

      Then u filter the data according to the position you Created. Basically what am saying is that you should ensure that the data set is filtered on the basis of the rank /position of the students

  • @nanaadinkra9020
    @nanaadinkra9020 Před 7 měsíci

    How can one position the data in order of merit(1st to last)?

  • @Tiffany_Lindy
    @Tiffany_Lindy Před 7 měsíci

    Please, do you have a video on salary slip

    • @Chairmoe_analytics
      @Chairmoe_analytics Před 7 měsíci

      Unfortunately I don't have a video on Salary slip. I think it is available to only those of my students in the Advanced Excel Training class. Cos there I teach a lot ranging from Payslip, Computation of bank statements, Sensitivity analysis etc.

  • @Tiffany_Lindy
    @Tiffany_Lindy Před 7 měsíci

    Excellent, for the first time, I have learnt how to do a salary payroll. But please, can I use this format for a small business of just 3 employees?

    • @Chairmoe_analytics
      @Chairmoe_analytics Před 7 měsíci

      Sure you can. Very suitable just some modifications. You know in small business u may not bother about all the allowances. So the basic salary and just bonus if it exist will be added to be the Gross Salary. In some cases self the basic salary will just be the Gross salary. For a small business you get.

  • @queenbee_afo
    @queenbee_afo Před 8 měsíci

    This is really detailed and well explanatory. Thank you, sir.

  • @awosanyakemisola4046
    @awosanyakemisola4046 Před 9 měsíci

    This awesome ❤ thank you very much 🙏

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Před 9 měsíci

      Thanks for the Feedback consider subscribing to my CZcams channel for more updates

  • @victorlupai
    @victorlupai Před 9 měsíci

    Thank you so much sir I really appreciate your lecture ❤❤❤❤❤❤❤❤❤❤❤❤ How do you calculate the subtotals from the departments/position

  • @AFRICANMONEYMASTERY
    @AFRICANMONEYMASTERY Před 9 měsíci

    Please sir how did you save the work area only without the excel features

  • @user-qr2kw2jz7u
    @user-qr2kw2jz7u Před 9 měsíci

    Well done. I really like your explanation. Can I have videos on terminal report

  • @adebiyiademolataiwo507
    @adebiyiademolataiwo507 Před 10 měsíci

    Bravo

  • @rewacwalker7568
    @rewacwalker7568 Před 10 měsíci

    I enjoyed this lesson so much, I watched the entire video then I watched it again and worked along side it. 🙂

  • @user-op4oz9nn7x
    @user-op4oz9nn7x Před 10 měsíci

    Boss, is it possible to filter income and expenses?

  • @OObayan
    @OObayan Před 11 měsíci

    Great work Keep it up The Lord is your strength