- Видео 54
- Просмотров 360 457
Hands-On-Data
Нигерия
Добавлен 26 июл 2019
Hello and welcome to my channel - Hands-On-Data. My name is Charles and I have a strong passion for anything data. I hold strongly to the words that “if you can measure it, you can manage it - and data is the key to all measurements.
Here in this channel, I intend to offload all my experience in the use of data management tools like Microsoft Excel for data analysis, dashboards and financial modeling, Python(Pandas) for Business Intelligence and talks on business strategy. If you have passion on these and want to learn or share yours with mine, you are more than welcomed to subscribe to my channel and join. Your views, comments will be appreciated.
Please check my playlists which categorizes my videos in ways you may find more logical. I have videos on Microsoft Excel fundamentals which considers basics in the application. I have videos in “Ones Upon a Spreadsheet” which takes on issues faced by individuals like you and me in the workplace but related to Microsoft Excel. If you are
Here in this channel, I intend to offload all my experience in the use of data management tools like Microsoft Excel for data analysis, dashboards and financial modeling, Python(Pandas) for Business Intelligence and talks on business strategy. If you have passion on these and want to learn or share yours with mine, you are more than welcomed to subscribe to my channel and join. Your views, comments will be appreciated.
Please check my playlists which categorizes my videos in ways you may find more logical. I have videos on Microsoft Excel fundamentals which considers basics in the application. I have videos in “Ones Upon a Spreadsheet” which takes on issues faced by individuals like you and me in the workplace but related to Microsoft Excel. If you are
How to Convince Businesses to Go Data-Driven: A Guide for Consultants
Are you a consultant looking to help businesses embrace the power of data? Many non-data-driven companies struggle to see the value of analytics, but with the right approach, you can lead them to transformative insights and growth.
In this video, we share actionable strategies to help consultants guide businesses toward adopting data-driven solutions:
Demonstrating the value of data-driven decision-making using real-world comparisons.
Framing analytics around cost-associated decisions to resonate with business leaders.
Progressively introducing data technologies to ensure seamless adoption without overwhelming stakeholders.
These insights are designed to help you position your services as a tr...
In this video, we share actionable strategies to help consultants guide businesses toward adopting data-driven solutions:
Demonstrating the value of data-driven decision-making using real-world comparisons.
Framing analytics around cost-associated decisions to resonate with business leaders.
Progressively introducing data technologies to ensure seamless adoption without overwhelming stakeholders.
These insights are designed to help you position your services as a tr...
Просмотров: 34
Видео
How to Stand Out as a Data Analyst: Leverage YouTube for Job Success
Просмотров 2621 день назад
Are you a data analyst looking to stand out in the competitive job market? This video reveals actionable strategies to showcase your skills, including using RUclips to demonstrate your problem-solving abilities. Learn how creating content can: 1️⃣ Show hiring managers what you can do. 2️⃣ Get you hired for temporary jobs or freelance gigs. 3️⃣ Boost your chances of internal referrals. Start bui...
Do I need to study SQL up to the advanced level given the presence of AI support tools?
Просмотров 2128 дней назад
In this video I answer the question on learning SQL in the presence of AI support tools. #sql #dataanalysis #ai SQL question and answer video ruclips.net/video/43hZz4-XtVo/видео.html
How to Perform Cohort Analysis Using Excel and Power Query
Просмотров 691Месяц назад
Learn how to perform Cohort Analysis using Microsoft Excel and Power Query in this step-by-step tutorial! Whether you're analyzing customer behavior, tracking retention, or uncovering business insights, this video makes it easy to master cohort analysis. Perfect for beginners and advanced Excel users alike. Watch now to enhance your data analysis skills! Link to file docs.google.com/spreadsheet...
Parents, Don’t Miss This! ChatGPT Can Transform Your Child’s Learning
Просмотров 47Месяц назад
This is a video on chat-gpt for children
SQL Questions & Answers - Basic to Intermediate
Просмотров 2673 месяца назад
#sql #sqltutorials #postgresql This video take 10 questions, each question helping to prepare you for the next question from basic SQL to intermediate SQL. Select, from, where, group by, order by, subquery, CTE, value conversion, date conversion and much more are considered in this video. The video is a good SQL for Beginners and SQL for refreshers.
Building Dashboards with Microsoft Excel - Video Game Sales Dashboard
Просмотров 3514 месяца назад
This video teaches how to use Microsoft Excel in building data dashboards. Pivot tables, shapes and excel functions and formulas have been used coupled with best practice principles in building dashboards. #dashboard #exceltutorial #exceldashboard
10 Questions & Answers - Using Microsoft Excel Pivot Tables
Просмотров 6496 месяцев назад
This video exploits Microsoft Excel's Pivot Tables in doing the following: 1. Analyze data 2. Lookup data presented in pivot tables 3. Use the Show value as feature to manipulate presentations a) Show values as percentage of row and column totals b) Show values as difference and percentage difference c) Rank values in a pivot table 4. chart data from pivot table 5. Use Slicers to drip down in e...
Microsoft Excel Test Questions and Solved Answers - Excel Interviews Part 2
Просмотров 2 тыс.9 месяцев назад
This video presents likely Microsoft excel test questions and solve them all. The aim of this video is to teach Microsoft Excel functions and formulas through hands-on problem solving. Part 1 ruclips.net/video/n2JqJwDpvrM/видео.html #excelinterview #excelinterviewquestionsandanswers #excelquickandeasy 📈 Get Personalized Training and Financial Modelling Expertise! 📊 Are you looking to enhance yo...
Microsoft Excel Test Questions and Solved Answers - Excel Interview Questions Part 1
Просмотров 6 тыс.9 месяцев назад
This video presents likely Microsoft excel test questions and solve them all. The aim of this video is to teach Microsoft Excel functions and formulas through hands-on problem solving. Part 2 ruclips.net/video/m7Z-GYKdDqc/видео.html #excelinterview #excelinterviewquestionsandanswers #excelquickandeasy 📈 Get Personalized Training and Financial Modelling Expertise! 📊 Are you looking to enhance yo...
Building Dynamic Monthly Operational (OPEX) Budget Template in Microsoft Excel
Просмотров 1,2 тыс.9 месяцев назад
Learn how to revolutionize your budgeting process using Microsoft Excel with this comprehensive tutorial. In this video, we dive into the intricacies of departmental budgeting, guiding you through the creation of individualized budget sheets for each department. Discover expert formatting techniques to ensure consistency and clarity across multiple sheets. Delve into the realm of automation as ...
Calculating & Modelling Depreciation - Comparing Depreciation Models: Straight-Line Method Showdown
Просмотров 25210 месяцев назад
In this video, we delve into the world of depreciation modeling, focusing on the straight-line method. 📉 We'll explore two different approaches to modeling depreciation, highlighting their key differences and effectiveness. 💡 Whether you're a finance enthusiast, accounting student, or business owner, understanding depreciation is crucial, and we've got you covered! Join us as we break down comp...
Screen Annotation with Zoomit Verson 8 2024
Просмотров 34310 месяцев назад
Learn how to enhance your presentations and tutorials with ZoomIt version 8! In this tutorial, we'll walk you through the features and functionalities of ZoomIt's screen annotation tool, enabling you to effortlessly highlight key points, draw attention to specific areas, and engage your audience like never before. Whether you're a teacher, trainer, or content creator, mastering ZoomIt's latest ...
Accounting Equation Demystified
Просмотров 5110 месяцев назад
Unlock the mysteries of accounting and financial statements with our comprehensive guide! Dive deep into the core concepts of the balance sheet equation and discover how it intertwines with the income statement and cash flow statement. Through clear explanations and detailed diagrams, this video breaks down complex financial jargon into digestible bits, making it easier for beginners and season...
Creating Depreciation Schedule - Long and Short Option
Просмотров 11711 месяцев назад
Creating Depreciation Schedule - Long and Short Option
Introduction to HR Dashboards #hr #hrmetrics #hrdashboards
Просмотров 4903 года назад
Introduction to HR Dashboards #hr #hrmetrics #hrdashboards
Analyzing Nigeria's Historic Foreign Exchange Rates data with Python Pandas #python #pandas #nigeria
Просмотров 1073 года назад
Analyzing Nigeria's Historic Foreign Exchange Rates data with Python Pandas #python #pandas #nigeria
Dax SELECTCOLUMNS Function #daxstudio #dax #daxfunctions #powerbi
Просмотров 2933 года назад
Dax SELECTCOLUMNS Function #daxstudio #dax #daxfunctions #powerbi
Stem and Leaf Plot using Microsoft Excel #charts #statistics #excel
Просмотров 6 тыс.3 года назад
Stem and Leaf Plot using Microsoft Excel #charts #statistics #excel
Deep Dive: Excel Functions & Formulas - Mental Blocks that Hinder Mastery of Excel Functions
Просмотров 1154 года назад
Deep Dive: Excel Functions & Formulas - Mental Blocks that Hinder Mastery of Excel Functions
Introduction - Deep Dive Learning in Excel Functions and Formulas
Просмотров 844 года назад
Introduction - Deep Dive Learning in Excel Functions and Formulas
Creating Organizational Charts with Microsoft Excel #excel #organizationalchart #charting
Просмотров 1,2 тыс.4 года назад
Creating Organizational Charts with Microsoft Excel #excel #organizationalchart #charting
Working with DAX Studio | Splitting Tables | Relationships in Data Model
Просмотров 8694 года назад
Working with DAX Studio | Splitting Tables | Relationships in Data Model
Number Format| Formatting Values in Cells in Microsoft Excel.
Просмотров 1274 года назад
Number Format| Formatting Values in Cells in Microsoft Excel.
Working with Dax Studio | Introduction to Using Dax Studio for Dax
Просмотров 3,4 тыс.4 года назад
Working with Dax Studio | Introduction to Using Dax Studio for Dax
Aligning text in Microsoft Excel | Working with Microsoft Excel Tools
Просмотров 3114 года назад
Aligning text in Microsoft Excel | Working with Microsoft Excel Tools
Advance Copy and Paste | Working with Microsoft Excel Tools
Просмотров 1214 года назад
Advance Copy and Paste | Working with Microsoft Excel Tools
I started watching your presentation last night and just finished it. I really enjoyed your approach. The step-by-step guide, with the use of the case study, was very helpful. I am going to share with my colleagues. I've never felt confident using Pivot tables; your walk-through has been a tremendous help. Thank you again!😃
Wao! Thank you. Your complements made my day🙏🙏🙌
This presentation is extremely helpful - thank you!
So happy you found it helpful. Let me know if there is any way I can be of further help.
👍🏻
Me one doubt sir
Excellent video! Thank you for taking the time to prepare and share😃
I am happy to know you found it useful. Thank you.
Great work sir
Great work!!
Thanks for sharing @high5 Tutorials
Thank you for your appreciation
I’m always pleased to follow your insights 👏
Thank you very much for your kind words.
Thank you ! Excellent video
Thank you. Happy to know you liked it
Sir why don't you solve those business questions btw video is very helpful for learning basics and one more thing i genuinely request you to improve your video quality i need one more help like can you please provide me this excel sheet
Nice job bossss
Thank you
Thanks!
Welcome!
Thanks for recording and sharing your knowledge. Bringing in the combo box is a top-notch idea 🔥🔥🔥🔥🔥🔥🔥🔥
Thank you very much. I very well appreciate you compliments.
You are the real MVP🙌. Thanks Charles
This is the best tutorial ever! I had never done a process chart before and did a picture perfect one with your tutorial! You also saved me a lot of stress. Thanks again!
Hes a good guy
Great explanations. Perhaps you can provide the workbook for practice.
thank you for this video. 🙂🤝
Thank very much for your kind appreciation.
Thank you for your kind appreciation
To get the end date I can't get the answer,is showing #Value
Check your cell that have the start and end date. Make sure the date reads month number/day number/year number. Or dd-mmm-yyyy format. Hopefully, this will help
Thank you for this video. It was very helpful!
So happy you enjoyed it.Thank you
please text sumif formula apply in gross block
Check the condition within your sumif function. If you have multiple conditions, use sumifs.
Check the condition in your sumif formula. Make sure it matches. Also make sure that the sum and criteria range is completely referenced. If you are using multiple conditions, use sumifs function.
Thank you for helping me understand index match. Your explanation were simple and clear
Lovely
Very good content
Great stuff
Thank you very much
VERY HELPFUL AND easy to apply
Thank you Sir
This is the best explanation of index and match I have seen in a long time time🎉
So happy you found it understandable
great content sir!!
Thank you for watching. Glad you found it a great content
At the end of video you mentioned something about being unable to reduce the width of the line in the drawing mode. I found out that this could be possible by holding down the shift key and scrolling down with your mouse wheel.
Thank you for watching and for adding value to this video. Happy to learn from you.
Hi Charles! This is a great video. I would love to connect and discuss this template with you. I sent you a LinkedIn invite to connect. Thank you.
I am happy you live it. Connected. Thank you.
I appreciate the informative video. Currently, I'm experiencing problems with the index formula as it doesn't capture the total amount for a specific asset class, eg for furniture and fittings. The index formulae seems to be missing some asset values when calculating the gross black for the same asset asset class on different rows
I am very sorry for late response. I may need to look the spreadsheet with you using not sensitive data. otogca@gmail.com. However, the index function returns a value and not the sum of values. The sumifs function should do the job if I understood what you have stated. Thank you for the compliments
@@hands-on-data Thank you for reaching out. It has been sorted already
OMG this was so helpful. Thankyou Sir !
Welcome. Happy to know it helped
What a fantastic video and tutorial, thanks for all your help.
Welcome and thank you for watching.
What is the Report Date and how do I know about the Report Date
Just like in monthly reports, the report date is the last day of a report month. However, the report date can be any date from which the report need to be evaluated
What is the Report Date and how do I know about the Report Date
This video is very helpful, thank you for your time.
Very impactful. highly simplified
Thank you a lot!
Thanks for the appreciation. You inspire me.
Thanks i enjoyed the lecture.
Thank you so much
Great tutorial! Speaking about the disposal, what about if I want to dispose a part of an asset amount not an entire asset?
Thank you very much. Very helpful
Thanx
Great presentation
Hi - Trying to do the Gross Block - the formula only calculates the first row of figures and not the 10 ( I have 11 rows of assets) any ideas ??
Use Sumifs to calculate the gross block
Golden, thanks!
I should probably learn to use Visio but with limited time I am attempting to use Excel.
That is the advantage of Excel - A rapid flowchart development tool
You are a genius! Thanks so much xx😍
So happy to know you like it
Is a good practical PPE register. I tried it but released that the depreciation per day is not zero when the asset reached its useful life. Therefore push the lapse days more than the uesful life days abd the net effect is in negative
Could it be because of the salvage value?
Was helpful. Thanks.
Very good, thanks