09:43
How to Extract Initial Letter from Names in Excel. These two tricks will surprise you.# regex
08:09
Logical Way of Cleaning Texts and Numeric Values Withn The Same Cell in Excel. #regex
07:03
How to Aggregate Loss/Profit Withn a Column in Excel. Four Excel Tricks Used!
06:55
Real Life Application of Excel Filter and Textjoin Functions. #datacleaning #filterchallenge
11:09
Best way to clean and automate reports in Excel.
06:40
Real-Life Problems Solved with MAXIFS & MINIFS Functions. #maxifs #minifs #averageif #seo
07:52
Stop Filter Data Manually in Excel. Use This Method to Filter Dynamically .#filter #datavalidation
08:50
Vlookup in Python. #Python #loc
11:26
These new Excel functions will make you analyze data like pro. #dataanalysis #newexcelfuncions
04:53
How to Make Love Symbol in Excel Using Equations 😍
07:02
How to Separate Numbers from Texts and Texts from Numbers Within a Column in Excel. #datacleaning
05:17
How to Search for Information from a Table Using Conditional Formatting .
04:42
How to Consolidate Daily Sales Into Single Table
07:42
Which is better? for loops or list comprehension in Python iteration.
16:29
Data Scrapping and Cleaning from Web Using Excel
10:05
Machine Learning in Excel. Supervised Learning Type.
05:08
How to Extract Middle Names from the List of Names Using Excel.
05:58
Create Python Function to Compute Present Value of Cash Loan and Compare it with Excel Function.
04:25
How to Format Non Blank Cells in Excel Using Conditional Formatting
04:52
How to Check for the Last Value in Rows Using Excel.
05:26
Stop Using Offset Function and Use Sum Function Instead to Sum up an Interval Periods.
06:30
How to Separate Numbers and Insert a Character In between Them in Excel.
09:04
How to Extract Special Characters, Numbers and Alphabet in a Text Using Python. #regex
05:43
How to Extract Special Characters, Numbers and Alphabet in a Text Using Power Query.
07:33
How to Create a Form to Ease Data Entry in Excel.
12:21
Byrow and Bycol Functions Application in Excel
05:55
How to Customize Column Bar Chart with a Company Logo in Excel.
06:15
How to Extract Out of Stock Products Using Excel.
07:42
This Excel Trick will Make Your Presentation Powerful.Make Row and Column Visible When click a Cell.
12:30
How to Use Excel Filter Function with Multiple Criteria to Make Important decisions.
05:45
How to Insert Blank Rows in between Data and Wrap Rows in Excel.#Wraprows
14:27
How to Use Map Function to Implement Decision in Excel. #Mapfunction
15:51
Ways to Filter Records in Python. Number Two and Three will Surprise You. #Python #filter
06:37
How to Automate Frequent Input Data or Records in Excel. #Excel
13:41
How to Extract Saturday and Sunday Dates from a Given Date Periods in Excel.
10:20
How to determine students who met the cutoff mark for admission in Excel.#CountIf #Nfunction #filter
04:46
Stop Using Sum Function in Excel. Subtotal is the best.
02:16
Data is the new oil.
03:16
How to Copy All Filtered Values in Excel.
13:14
How to Find Differences and Percentage Changes of Sales over Periods in Python. #Python #MOMChanges
09:23
How to Define Function to Add Multiple Numbers in Python. #Python #args
07:51
How to Extract Debt and Credit Values in the Same Column to Separate Columns using If and Wilcard .
04:38
How to Make Excel Communicates with the PowerPoint?
06:53
How to Create Emails for Employees in an organization within Some Seconds in Excel
09:15
How to match records to see the difference and intersection in the records in Excel.#filters #tocol
06:23
Combine Rows in Excel to a Single Cell Based on a Criteria.#exceltip
05:57
How to Assign Numbers Randomly to a Set of Individuals or Objects in Excel.
02:42
Stop copying this way in Excel! Do this instead.
18:12
Receivables for Data Analysts or Receivable Officers #receivables #datedif #if #sumif
07:00
How to Extract a Month Name from a Month Number within a Date Using Excel and MySQL. #exceltip #sql
13:09
Data Cleaning Techniques you might never Experienced in Excel.#datacleaning #dataanalyst
06:02
Formatting string looks numbers to numeric for data analysis in Excel.(#datacleaning)
05:06
Use filter function instead of vlookup, xlookup, and index and match to avoid wrong decisions.
10:16
Fill Down the Missing Values Using Microsoft Excel, Power Query and SQL Queries. #datacleaning
04:31
Data Consolidation from Two or More Sheets in Excel.
02:57
Computation of Running Total, Based on Unique ID Transaction in Excel.#excel #sumif
07:07
Data Cleaning in Excel
02:28
How to reverse row records from bottom to top in Excel.
11:52
Highest Salary by Department Using MySQL. #mysql_workbench #windowfunction #cte #subquery
05:45
Highest Salaries by Department Using Python. #python #pythontutorial
X
About
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.
26 September 2016
Tags