- 84
- 62 317
Datatech Analytics
Приєднався 26 вер 2016
This channel is to provide learning on Microsoft Excel, PowerBI, Python, Tableau and MySQL for data analysts, accountants, finance analyst, investment bankers and many more professionals. The channel will provide contents which will assist professionals to be more productive and efficient in their various careers. Microsoft Excel is a powerful software which can be used to solve many business problems. If you can think of it and highly skilled at the software, Excel will do it for you.
The owner of this channel has BSc in Economics, MSc in Energy Finance, and he is also a chartered accountant. He has dynamic industry experience in finance, data analytics and accounting.
The owner of this channel has BSc in Economics, MSc in Energy Finance, and he is also a chartered accountant. He has dynamic industry experience in finance, data analytics and accounting.
Machine Learning in Excel. Supervised Learning Type.
Machine Learning in Excel. Supervised Learning Type.
Переглядів: 74
Відео
How to Extract Middle Names from the List of Names Using Excel.
Переглядів 99День тому
How to Extract Middle Names from the List of Names Using Excel.
Create Python Function to Compute Present Value of Cash Loan and Compare it with Excel Function.
Переглядів 9414 днів тому
Create Python Function to Compute Present Value of Cash Loan and Compare it with Excel Function.
How to Format Non Blank Cells in Excel Using Conditional Formatting
Переглядів 100Місяць тому
How to Format Non Blank Cells in Excel Using Conditional Formatting
How to Check for the Last Value in Rows Using Excel.
Переглядів 1742 місяці тому
How to Check for the Last Value in Rows Using Excel.
Stop Using Offset Function and Use Sum Function Instead to Sum up an Interval Periods.
Переглядів 943 місяці тому
Stop Using Offset Function and Use Sum Function Instead to Sum up an Interval Periods.
How to Separate Numbers and Insert a Character In between Them in Excel.
Переглядів 2153 місяці тому
How to Separate Numbers and Insert a Character In between Them in Excel.
How to Extract Special Characters, Numbers and Alphabet in a Text Using Python. #regex
Переглядів 993 місяці тому
How to Extract Special Characters, Numbers and Alphabet in a Text Using Python. #regex
How to Extract Special Characters, Numbers and Alphabet in a Text Using Power Query.
Переглядів 1333 місяці тому
How to Extract Special Characters, Numbers and Alphabet in a Text Using Power Query.
How to Create a Form to Ease Data Entry in Excel.
Переглядів 1744 місяці тому
How to Create a Form to Ease Data Entry in Excel.
Byrow and Bycol Functions Application in Excel
Переглядів 2024 місяці тому
Byrow and Bycol Functions Application in Excel
How to Customize Column Bar Chart with a Company Logo in Excel.
Переглядів 1064 місяці тому
How to Customize Column Bar Chart with a Company Logo in Excel.
How to Extract Out of Stock Products Using Excel.
Переглядів 1435 місяців тому
How to Extract Out of Stock Products Using Excel.
This Excel Trick will Make Your Presentation Powerful.Make Row and Column Visible When click a Cell.
Переглядів 3155 місяців тому
This Excel Trick will Make Your Presentation Powerful.Make Row and Column Visible When click a Cell.
How to Use Excel Filter Function with Multiple Criteria to Make Important decisions.
Переглядів 1596 місяців тому
How to Use Excel Filter Function with Multiple Criteria to Make Important decisions.
How to Insert Blank Rows in between Data and Wrap Rows in Excel.#Wraprows
Переглядів 666 місяців тому
How to Insert Blank Rows in between Data and Wrap Rows in Excel.#Wraprows
How to Use Map Function to Implement Decision in Excel. #Mapfunction
Переглядів 2616 місяців тому
How to Use Map Function to Implement Decision in Excel. #Mapfunction
Ways to Filter Records in Python. Number Two and Three will Surprise You. #Python #filter
Переглядів 1466 місяців тому
Ways to Filter Records in Python. Number Two and Three will Surprise You. #Python #filter
How to Automate Frequent Input Data or Records in Excel. #Excel
Переглядів 3477 місяців тому
How to Automate Frequent Input Data or Records in Excel. #Excel
How to Extract Saturday and Sunday Dates from a Given Date Periods in Excel.
Переглядів 4928 місяців тому
How to Extract Saturday and Sunday Dates from a Given Date Periods in Excel.
How to determine students who met the cutoff mark for admission in Excel.#CountIf #Nfunction #filter
Переглядів 1588 місяців тому
How to determine students who met the cutoff mark for admission in Excel.#CountIf #Nfunction #filter
Stop Using Sum Function in Excel. Subtotal is the best.
Переглядів 2418 місяців тому
Stop Using Sum Function in Excel. Subtotal is the best.
How to Copy All Filtered Values in Excel.
Переглядів 2219 місяців тому
How to Copy All Filtered Values in Excel.
How to Find Differences and Percentage Changes of Sales over Periods in Python. #Python #MOMChanges
Переглядів 1689 місяців тому
How to Find Differences and Percentage Changes of Sales over Periods in Python. #Python #MOMChanges
How to Define Function to Add Multiple Numbers in Python. #Python #args
Переглядів 33210 місяців тому
How to Define Function to Add Multiple Numbers in Python. #Python #args
How to Extract Debt and Credit Values in the Same Column to Separate Columns using If and Wilcard .
Переглядів 2,2 тис.11 місяців тому
How to Extract Debt and Credit Values in the Same Column to Separate Columns using If and Wilcard .
How to Make Excel Communicates with the PowerPoint?
Переглядів 23711 місяців тому
How to Make Excel Communicates with the PowerPoint?
How to Create Emails for Employees in an organization within Some Seconds in Excel
Переглядів 36911 місяців тому
How to Create Emails for Employees in an organization within Some Seconds in Excel
How to match records to see the difference and intersection in the records in Excel.#filters #tocol
Переглядів 33711 місяців тому
How to match records to see the difference and intersection in the records in Excel.#filters #tocol
That helped me alot... KUDOS
Thanks for this 😊
You are a great Teacher
Thank you! 😃
Helpful!!! thanks
This is really good... learnt new trick
@@debbyDgoodnews Great you learn new trick
Thanks for this work
Thanks very much
INSIGHTFUL✨✨✔
This is exactly what I needed, thanks!
It is my pleasure that you find it useful .
This is the simplest explanation and formula input of PAYE i have seen. Well done, keep the good work coming.
Thanks for the feedback.
Excellent trick
Thanks for this. Well explained.
Glad it was helpful!
Great video.
Glad you enjoyed it
Please can i get a template. Thank you sir
Drop your email
Please can you give me the template. 🙏🙏🙏🙏🙏
Drop your email
Very nice! Thank you
Glad you like it!
Please, what if my salary is not the same for every month
Promo sm 😋
More wisdom sir
Great video. ❤
More wisdom sir
Great video.
Insightful.
More wisdom
Nice video
This is a great video. Thanks very much for this. It comes in handy.
It is my pleasure that you find it useful
nice explanation <3 keep it up ^^
Is it possible to leave the link to a sample data? Or where can I get one
Drop your email
Excellent 👍
Thank you for the educative video. I have my suggested formula below Dr column =IF(ISNUMBER(D2),D2, "") Cr column =IF(ISTEXT(D2),VALUE(LEFT(D2, LEN(D2)-3)),"") Using above formulas, the Cr will disappear in Cr column. Many other ways to achieve the same results AGBOOLA Muideen Olalekan
Kindly help me out, am using your formula, but it's not working for me
@madeinghanatv5617 Please ensure you write to the correct cell reference.
This is great. I tried it and it really works out. Thank you
It is our pleasure that you find the video great
You can watch how to compute loan amortization in the link below. ua-cam.com/video/SVGLFbKRySQ/v-deo.htmlsi=I7vJAYTmga8CvpKn
P R O M O S M
Please the template
Drop your mail
Great video. Thanks for this.
Well detailed. Thank you sir for this. please can you send the formulas?
Thanks so much for this.... Please can I have the data used so one can use to practice, also what do you mean by fix it .. I do not understand it even in the PAYE computation, what function key did you pressed ?
To fixed a cell means you want to permanent that cell in a formula across cells. We use button F4 to fix it. Once you do that, you will see double dollars sign .
Please sir can you share the data used?
Please I want to ask what you meant by fix it when you selected that column that has 300000
It means to lock the cell($) so it can be applied to the other cells. Simply click on F4 after you selected the cell.
Keep the good work. I learned from you
Cheers. Thank you
Thanks so much for this but I want to ask how did you arrive at value for housing, transport and meal allowance?
That's in line with the finance act.
template?
hello sir, I love this video and I would love to get the template
Drop your email here
Hands down the best video I have seen on computing PIT, thank you very much sir.
It is our pleasure seeing comment like this.
this is very helpful the only challenge is the formular combination sir.
Sir please can you share this file so I can also practise with it Thank you so much
Drop your email.
Thank you for this. God bless
Aameen. It is our pleasure to share knowledge.
Keep up the good work I found this video very helpful when I was trying to design a pay slip for my company👍👍.
It is my pleasure you find the video useful. Ensure you subscribe and recommend the channel for others.
Thank you sir, for this.
Am coming soon