- Видео 32
- Просмотров 106 154
Omoabugan Emmanuel
Нигерия
Добавлен 3 сен 2020
Hello and welcome to my RUclips channel.
My name is Emmanuel Omoabugan, An Accountant| Data Analyst | Microsoft Excel Expert.
In this channel, you will learn how to apply Microsoft Excel to your Business, Finance and have access to all Excel Template Videos.
The Excel templates video will serve as a step by step guide on how to use each Template you purchase from us.
If you are new to this channel kindly please subscribe to my RUclips channel for more video content.
Thank you!!!
My name is Emmanuel Omoabugan, An Accountant| Data Analyst | Microsoft Excel Expert.
In this channel, you will learn how to apply Microsoft Excel to your Business, Finance and have access to all Excel Template Videos.
The Excel templates video will serve as a step by step guide on how to use each Template you purchase from us.
If you are new to this channel kindly please subscribe to my RUclips channel for more video content.
Thank you!!!
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
#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
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 use Microsoft Excel to Create Student results/School report sheet.
Просмотров 39 тыс.Год назад
How to use Microsoft Excel to Create Student results/School report sheet.
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 an Invoice using Microsoft Excel.
Просмотров 7732 года назад
How to prepare an Invoice using Microsoft Excel.
Good job 👍 Please how do you save it when you’re done?
It's a helpful video esply for beginners
This is helpful for me a new beginner. I will appreciate any further help sir.
God bless you for this Very very understandable
Amen thanks for stopping by and for the review
Thank You
Great video. Thanks for sharing
God bless you for this😊 but how do I upload as pdf without other cells included?
I love this ❤ Thank you, Sir.
U welcome. Dont forget to like and subscribe
Noted
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
I dont get the question which information are u pasting sir.
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.
Good afternon sir, trust u are doing great, Pl can you help with a video, daily contribution tracker loan thanks
Follow same Excel format but change the Jan to DEC. To Mon to Sat instead and spread across the sheets in a coherent order.
So my question is how will print in one page
Set the print preview option area in Excel and change orientation to land scape. And then print
@@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
Very understandable... Thank you
Thanks for the Feedback
Thank you sir❤
You welcome. Don't forget to like and subscribe. Thanks for the Feedback
Where is this reference number from please?
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.
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.
Thanks for this More knowledge to you sir
U welcome. Thanks for the Feedback
Thanks for sharing this.
Thanks for the Feedback
You have done a great job, is there any regulated percentage for BHT?
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.
Thanks
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. 😊
Thanks for the Feedback really appreciate
great video, a lot learnt
Thanks for the Feedback really appreciate
Thank you for the video!
Thanks for the Feedback really appreciate
Well clear!
Sir I need to know how set a report in Excel Can you give your WhatsApp number
❤
U are good
Thanks for the Feedback really appreciate
goodwork
Thanks for the Feedback really appreciate
great work can you sent download link please
This was so helpful, thank you
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
Excellent job..but I need video on store keeping record using excel
Check out this video tutorial on that : ruclips.net/video/g8ynkabdBXw/видео.htmlsi=A89DPzhXBhO9qvPQ
Pls, is it possible for you to prepare this for someone?
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
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.
Helpful. Thank you
You welcome dear
super
Thank you
You made this very simple. Thank you
Thanks for the feed back
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
Chat me up on WhatsApp I have a premium report card template for you. +2348169394017. Though it comes with a token price
Guy you dey teach…. I understood every part of it.
Thanks so much for the Feedback
Emmanuel if I may ask which update year version of Microsoft Excel do you use for this video?
Microsoft Excel 2016
I understood every part of it thank you 🙏🏻
U welcome. Thanks for the Feedback consider subscribing to my RUclips channel for more updates
GOOD TEACHER
Thanks for the Feedback I really appreciate
Thanks boss for this video it's very helpful
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
Thanks for the Feedback
Thank you very much. This was apt, precise and detailed, i can say i know how to fo payrolling
U welcome thanks for the Feedback. I really appreciate
God bless you sir Is very understanding than those india ones am see How can I do the formula sir ❤
For this though I didnt use a formula. Is just to use auto fill handle feature in Excel.
I started watching your video today and I found myself enjoying your lectures, thank you sir from south Sudan.
I appreciate the feedback. Kindly please subscribe to my RUclips channel
This is a very useful video. Thank you for posting it. It gave me great help.
Thanks for the feedback.
Glad it was helpful!
Thanks you for this video
You welcome sir
Nice Sharing!
Thanks for the feedback
Thanks you very much l like it sir
You are welcome sir. Kindly please go ahead and subscribe to my RUclips channel
I totally love this.🇰🇪
Thanks so much for this feedback. Really appreciate