Omoabugan Emmanuel
Omoabugan Emmanuel
  • Видео 32
  • Просмотров 106 154
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 RUclips channel for more update.
#excel #library #database #excelclasses #librarymanagementsystem #exceltraining
Просмотров: 1 115

Видео

Using Custom Sort in Microsoft Excel
Просмотров 107Год назад
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 Function
Просмотров 147Год назад
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 Functions
Просмотров 106Год назад
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 Excel
Просмотров 95Год назад
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:* ruclips.net/video/jhq3g8bYNss/видео.html Kindly Pl...
How To Create a Search box using Conditional Formatting in Microsoft Excel
Просмотров 371Год назад
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 Certification
Просмотров 106Год назад
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.
Просмотров 158Год назад
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 RUclips channel for more updates. Thank you!!!
How to remove Duplicates in Microsoft Excel
Просмотров 151Год назад
In this video tutorial I demonstrated how to remove duplicate text and values in Microsoft Excel. #excel #exceltutorial #duplicate #removeduplicates
Inventory Management in Microsoft Excel
Просмотров 562Год назад
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: ruclips.net/video/Ogx6AAn30w8/видео.html
The Excel Status Bar
Просмотров 156Год назад
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 RUclips channel for more updates and also to support my channel. Thank you!!! #excel #exceltutorial #statusbar
How to Create a Custom Auto-fill List in Excel
Просмотров 228Год назад
In this video tutorial I demonstrated How to Create a Custom Auto-fill list in Microsoft Excel. Kindly please subscribe to my RUclips Channel to encourage me to release more video contents like these. Thank you !!!
How to Create a Copy of a Worksheet in Microsoft Excel
Просмотров 170Год назад
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:* ruclips.net/video/m8mrE6yh4yU/видео...
Solving Simultaneous Equations in Excel
Просмотров 1,3 тыс.Год назад
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 Functions
Просмотров 91Год назад
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 Excel
Просмотров 104Год назад
How to Transpose Data in Microsoft Excel
Quadratic Equations Using Microsoft Excel
Просмотров 1,2 тыс.Год назад
Quadratic Equations Using Microsoft Excel
Excel Functions to Help Fix Bad Text
Просмотров 136Год назад
Excel Functions to Help Fix Bad Text
Creating Easy Data Entry Forms in Excel
Просмотров 460Год назад
Creating Easy Data Entry Forms in Excel
Calculate Loan Payment with Excel PMT Function
Просмотров 280Год назад
Calculate Loan Payment with Excel PMT Function
Financial Analysis with Microsoft Excel Master Class - Virtual Training
Просмотров 172Год назад
Financial Analysis with Microsoft Excel Master Class - Virtual Training
How To Make Sales Report in Excel
Просмотров 353Год назад
How To Make Sales Report in Excel
How to Calculate GPA using Ms Excel
Просмотров 6 тыс.Год назад
How to Calculate GPA using Ms Excel
How to use Microsoft Excel to Create Student results/School report sheet.
Просмотров 39 тыс.Год назад
How to use Microsoft Excel to Create Student results/School report sheet.
Create Multiplication Table in Excel
Просмотров 1 тыс.Год назад
Create Multiplication Table in Excel
Monthly payment schedule in Excel
Просмотров 13 тыс.Год назад
Monthly payment schedule in Excel
How to make monthly income and expenses in excel sheet
Просмотров 4,8 тыс.2 года назад
How to make monthly income and expenses in excel sheet
How to Compute Pension schedule using Microsoft Excel.
Просмотров 2,1 тыс.2 года назад
How to Compute Pension schedule using Microsoft Excel.
How to prepare a payroll in Excel
Просмотров 29 тыс.2 года назад
How to prepare a payroll in Excel
How to prepare an Invoice using Microsoft Excel.
Просмотров 7732 года назад
How to prepare an Invoice using Microsoft Excel.

Комментарии

  • @dramaniabubakari3200
    @dramaniabubakari3200 5 часов назад

    Good job 👍 Please how do you save it when you’re done?

  • @hauwamusa9589
    @hauwamusa9589 8 дней назад

    It's a helpful video esply for beginners

  • @davisonphiri5554
    @davisonphiri5554 11 дней назад

    This is helpful for me a new beginner. I will appreciate any further help sir.

  • @OluwadamilolaOni-y6p
    @OluwadamilolaOni-y6p 12 дней назад

    God bless you for this Very very understandable

  • @informT.V
    @informT.V 22 дня назад

    Thank You

  • @nonoobott8602
    @nonoobott8602 Месяц назад

    Great video. Thanks for sharing

  • @SmalltalkswithVee
    @SmalltalkswithVee Месяц назад

    God bless you for this😊 but how do I upload as pdf without other cells included?

  • @lebeneahiabor6646
    @lebeneahiabor6646 Месяц назад

    I love this ❤ Thank you, Sir.

  • @incskills
    @incskills Месяц назад

    Noted

  • @afitaahceelbuur9949
    @afitaahceelbuur9949 Месяц назад

    Eng. can i ask you one question when i paste my information my info are not row but is column why and how to solve that

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Месяц назад

      I dont get the question which information are u pasting sir.

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Месяц назад

      The main explanation or goal of the video was to prepare a broad sheet using Microsoft Excel. The copy and paste I did there wasn't part of what I intended to explain. It was just a means to speed things up regarding the data entry.

  • @incskills
    @incskills Месяц назад

    Good afternon sir, trust u are doing great, Pl can you help with a video, daily contribution tracker loan thanks

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Месяц назад

      Follow same Excel format but change the Jan to DEC. To Mon to Sat instead and spread across the sheets in a coherent order.

  • @jellebashirmohamed-wc9op
    @jellebashirmohamed-wc9op Месяц назад

    So my question is how will print in one page

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Месяц назад

      Set the print preview option area in Excel and change orientation to land scape. And then print

    • @jellebashirmohamed-wc9op
      @jellebashirmohamed-wc9op Месяц назад

      ​@@omoabuganemmanuel3642 I am preparing exam results of students using excell. The spreadsheet is very wide that some contents are cut of so how can I solve it. I have even changed the orientation of the paper to landscape

  • @iyanuwonder3606
    @iyanuwonder3606 Месяц назад

    Very understandable... Thank you

  • @obednancy-ib1li
    @obednancy-ib1li Месяц назад

    Thank you sir❤

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 Месяц назад

      You welcome. Don't forget to like and subscribe. Thanks for the Feedback

  • @Allinfootball-y4b
    @Allinfootball-y4b 2 месяца назад

    Where is this reference number from please?

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 2 месяца назад

      Is based on the unique identifier assigned to each transaction or entry in the accounting record. Basically it is a serial number assigned to each entry in our income and expenses account, used for internal record keeping and Accounting purpose. E.g for the expenses the reference number could be the invoice number for the purchase of let say A4 paper. You need this things to track figures stated on the income and expenses account.

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 2 месяца назад

      That being said the reference number used here were assumed by me for the purpose of creating this video. So they are assumed Okay. I hope this answer your question.

  • @OyindamolaMuhammed
    @OyindamolaMuhammed 2 месяца назад

    Thanks for this More knowledge to you sir

  • @patrickconstant7472
    @patrickconstant7472 2 месяца назад

    Thanks for sharing this.

  • @ClarionttechHRServices
    @ClarionttechHRServices 2 месяца назад

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

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 2 месяца назад

      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 2 месяца назад

      Thanks

  • @portiachinda7982
    @portiachinda7982 2 месяца назад

    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 2 месяца назад

    great video, a lot learnt

  • @Miguelskytwins
    @Miguelskytwins 2 месяца назад

    Thank you for the video!

  • @chiomaekwunife2307
    @chiomaekwunife2307 2 месяца назад

    Well clear!

  • @khalifamaawiyya3767
    @khalifamaawiyya3767 3 месяца назад

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

  • @AbebeNegeri
    @AbebeNegeri 3 месяца назад

  • @OnyesRozy
    @OnyesRozy 3 месяца назад

    U are good

  • @NAOMIWANJIKUKINUTHIA
    @NAOMIWANJIKUKINUTHIA 4 месяца назад

    goodwork

  • @elabbadiamine4296
    @elabbadiamine4296 4 месяца назад

    great work can you sent download link please

  • @constanciamabel8077
    @constanciamabel8077 4 месяца назад

    This was so helpful, thank you

  • @josues6473
    @josues6473 5 месяцев назад

    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 6 месяцев назад

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

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 5 месяцев назад

      Check out this video tutorial on that : ruclips.net/video/g8ynkabdBXw/видео.htmlsi=A89DPzhXBhO9qvPQ

  • @PennsHill-gw3ih
    @PennsHill-gw3ih 6 месяцев назад

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

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 5 месяцев назад

      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 6 месяцев назад

    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 6 месяцев назад

    Helpful. Thank you

  • @suchithavishwa939
    @suchithavishwa939 6 месяцев назад

    super

  • @yawbaffour1441
    @yawbaffour1441 7 месяцев назад

    You made this very simple. Thank you

  • @enejohyemisi4241
    @enejohyemisi4241 7 месяцев назад

    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 7 месяцев назад

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

  • @ibisojack3653
    @ibisojack3653 7 месяцев назад

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

  • @agabaandrewattah4443
    @agabaandrewattah4443 7 месяцев назад

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

  • @sefraeric
    @sefraeric 7 месяцев назад

    I understood every part of it thank you 🙏🏻

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 7 месяцев назад

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

  • @orjiolisadebe1109
    @orjiolisadebe1109 8 месяцев назад

    GOOD TEACHER

  • @henryjohn9748
    @henryjohn9748 8 месяцев назад

    Thanks boss for this video it's very helpful

  • @truetv5953
    @truetv5953 8 месяцев назад

    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

  • @ChinenyeAkuonu
    @ChinenyeAkuonu 8 месяцев назад

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

  • @Timi_leyin
    @Timi_leyin 8 месяцев назад

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

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 8 месяцев назад

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

  • @moyobeky-rv5tz
    @moyobeky-rv5tz 9 месяцев назад

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

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 9 месяцев назад

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

  • @azamhafidzul7450
    @azamhafidzul7450 9 месяцев назад

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

  • @joshuagayina6913
    @joshuagayina6913 9 месяцев назад

    Thanks you for this video

  • @daryza7990
    @daryza7990 9 месяцев назад

    Nice Sharing!

  • @ahmadadam2965
    @ahmadadam2965 9 месяцев назад

    Thanks you very much l like it sir

    • @omoabuganemmanuel3642
      @omoabuganemmanuel3642 9 месяцев назад

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

  • @bentaokoo6680
    @bentaokoo6680 9 месяцев назад

    I totally love this.🇰🇪