Datatech Analytics
This channel provides 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 content that will assist professionals to be more productive and efficient in their various careers. Microsoft Excel is a powerful software that can be used to solve many business problems. If you can think of it and highly skilled at the software, Excel can do it for you.
The owner of this channel has a BSc in Economics, an MSc in Energy Finance, and he is also a chartered accountant. He has dynamic industry experience in finance, data analytics and accounting.
How to Extract Stock Price/Data for Free in Excel
Stocks Performance Trackers in Excel
How to Convert Picture Data to Table in Excel
How to Extract Initial Letter from Names in Excel. These two tricks will surprise you.# regex
Logical Way of Cleaning Texts and Numeric Values Withn The Same Cell in Excel. #regex
How to Aggregate Loss/Profit Withn a Column in Excel. Four Excel Tricks Used!
Real Life Application of Excel Filter and Textjoin Functions. #datacleaning #filterchallenge
Best way to clean and automate reports in Excel.
Real-Life Problems Solved with MAXIFS & MINIFS Functions. #maxifs #minifs #averageif #seo
Stop Filter Data Manually in Excel. Use This Method to Filter Dynamically .#filter #datavalidation
Vlookup in Python. #Python #loc
These new Excel functions will make you analyze data like pro. #dataanalysis #newexcelfuncions
How to Make Love Symbol in Excel Using Equations 😍
How to Separate Numbers from Texts and Texts from Numbers Within a Column in Excel. #datacleaning
How to Search for Information from a Table Using Conditional Formatting .
How to Consolidate Daily Sales Into Single Table
Which is better? for loops or list comprehension in Python iteration.
Data Scrapping and Cleaning from Web Using Excel
Machine Learning in Excel. Supervised Learning Type.
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.
How to Format Non Blank Cells in Excel Using Conditional Formatting
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.
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
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.
Byrow and Bycol Functions Application in Excel
How to Customize Column Bar Chart with a Company Logo in Excel.