- 81
- 58 193
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.
How to Format Non Blank Cells in Excel Using Conditional Formatting
How to Format Non Blank Cells in Excel Using Conditional Formatting
มุมมอง: 75
วีดีโอ
How to Check for the Last Value in Rows Using Excel.
มุมมอง 160หลายเดือนก่อน
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.
มุมมอง 892 หลายเดือนก่อน
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.
มุมมอง 2042 หลายเดือนก่อน
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
มุมมอง 972 หลายเดือนก่อน
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.
มุมมอง 1112 หลายเดือนก่อน
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.
มุมมอง 1682 หลายเดือนก่อน
How to Create a Form to Ease Data Entry in Excel.
Byrow and Bycol Functions Application in Excel
มุมมอง 1943 หลายเดือนก่อน
Byrow and Bycol Functions Application in Excel
How to Customize Column Bar Chart with a Company Logo in Excel.
มุมมอง 1043 หลายเดือนก่อน
How to Customize Column Bar Chart with a Company Logo in Excel.
How to Extract Out of Stock Products Using Excel.
มุมมอง 1184 หลายเดือนก่อน
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.
มุมมอง 3064 หลายเดือนก่อน
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.
มุมมอง 1474 หลายเดือนก่อน
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
มุมมอง 614 หลายเดือนก่อน
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
มุมมอง 2545 หลายเดือนก่อน
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
มุมมอง 1455 หลายเดือนก่อน
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
มุมมอง 3335 หลายเดือนก่อน
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.
มุมมอง 4506 หลายเดือนก่อน
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
มุมมอง 1536 หลายเดือนก่อน
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.
มุมมอง 2387 หลายเดือนก่อน
Stop Using Sum Function in Excel. Subtotal is the best.
How to Copy All Filtered Values in Excel.
มุมมอง 2108 หลายเดือนก่อน
How to Copy All Filtered Values in Excel.
How to Find Differences and Percentage Changes of Sales over Periods in Python. #Python #MOMChanges
มุมมอง 1678 หลายเดือนก่อน
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
มุมมอง 2909 หลายเดือนก่อน
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 .
มุมมอง 1.8K9 หลายเดือนก่อน
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?
มุมมอง 23210 หลายเดือนก่อน
How to Make Excel Communicates with the PowerPoint?
How to Create Emails for Employees in an organization within Some Seconds in Excel
มุมมอง 33310 หลายเดือนก่อน
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
มุมมอง 33710 หลายเดือนก่อน
How to match records to see the difference and intersection in the records in Excel.#filters #tocol
Combine Rows in Excel to a Single Cell Based on a Criteria.#exceltip
มุมมอง 1.8K11 หลายเดือนก่อน
Combine Rows in Excel to a Single Cell Based on a Criteria.#exceltip
How to Assign Numbers Randomly to a Set of Individuals or Objects in Excel.
มุมมอง 83311 หลายเดือนก่อน
How to Assign Numbers Randomly to a Set of Individuals or Objects in Excel.
Stop copying this way in Excel! Do this instead.
มุมมอง 29011 หลายเดือนก่อน
Stop copying this way in Excel! Do this instead.
Helpful!!! thanks
This is really good... learnt new trick
@@debbygoodnewssubmit7179 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
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. th-cam.com/video/SVGLFbKRySQ/w-d-xo.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
Thank you sir
Thanks
You're doing great, baba