High5 Tutorials
High5 Tutorials
  • Видео 49
  • Просмотров 338 533
SQL Questions & Answers - Basic to Intermediate
#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.
Просмотров: 164

Видео

Building Dashboards with Microsoft Excel - Video Game Sales Dashboard
Просмотров 21921 день назад
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
Просмотров 2632 месяца назад
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
Просмотров 1,1 тыс.5 месяцев назад
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
Просмотров 2,9 тыс.6 месяцев назад
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
Просмотров 7366 месяцев назад
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
Просмотров 1916 месяцев назад
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
Просмотров 2326 месяцев назад
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
Просмотров 486 месяцев назад
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
Просмотров 917 месяцев назад
This video intends to show a long approach, which is the common approach for modeling depreciation and a short approach which takes advantage of Excel's TAKE function, thereby limiting the number of rows that can be used to model depreciation. Excel's TOCOL and SEQUENCE functions are also used in the modelling. #depreciation #excel #excelfunctions #excelnewfunction #finance #financialeduction #...
Introduction to HR Dashboards #hr #hrmetrics #hrdashboards
Просмотров 4642 года назад
In this video, I show how to chart Some HR Metrics and some of the tools available in Excel to do just this.
Analyzing Nigeria's Historic Foreign Exchange Rates data with Python Pandas #python #pandas #nigeria
Просмотров 982 года назад
In this video, I use python pandas, Numpy and Matplotlip to analyze Nigeria's foreign exchange rates data since year 2000. I show how to use python pandas in this analysis.
Dax SELECTCOLUMNS Function #daxstudio #dax #daxfunctions #powerbi
Просмотров 2763 года назад
This video show how to use the SELECCOLUMN functions to extract just the number of columns you may want from a specified table. It also show how to create calculated columns within virtual tables.
Stem and Leaf Plot using Microsoft Excel #charts #statistics #excel
Просмотров 6 тыс.3 года назад
This video shows you how to plot a stem and leaf plot using Microsoft Excel. 📈 Get Personalized Training and Financial Modelling Expertise! 📊 Are you looking to enhance your financial planning and Excel skills? Need a professional to handle your financial modeling tasks? I'm here to help! Contact info below 👨‍🏫 One-on-One Training: I offer personalized, one-on-one hourly training sessions to he...
Relative and Absolute Referencing
Просмотров 783 года назад
Relative and Absolute Referencing
Excel Referencing Cell Range
Просмотров 2773 года назад
Excel Referencing Cell Range
Deep Dive: Excel Functions & Formulas - Mental Blocks that Hinder Mastery of Excel Functions
Просмотров 1063 года назад
Deep Dive: Excel Functions & Formulas - Mental Blocks that Hinder Mastery of Excel Functions
Introduction - Deep Dive Learning in Excel Functions and Formulas
Просмотров 823 года назад
Introduction - Deep Dive Learning in Excel Functions and Formulas
Creating Organizational Charts with Microsoft Excel #excel #organizationalchart #charting
Просмотров 1 тыс.3 года назад
Creating Organizational Charts with Microsoft Excel #excel #organizationalchart #charting
Working with DAX Studio | Splitting Tables | Relationships in Data Model
Просмотров 8264 года назад
Working with DAX Studio | Splitting Tables | Relationships in Data Model
Number Format| Formatting Values in Cells in Microsoft Excel.
Просмотров 1264 года назад
Number Format| Formatting Values in Cells in Microsoft Excel.
Creating Fixed Assets Registers
Просмотров 46 тыс.4 года назад
Creating Fixed Assets Registers
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
Просмотров 2914 года назад
Aligning text in Microsoft Excel | Working with Microsoft Excel Tools
Advance Copy and Paste | Working with Microsoft Excel Tools
Просмотров 1154 года назад
Advance Copy and Paste | Working with Microsoft Excel Tools
Process Flow Chart with Microsoft Excel
Просмотров 242 тыс.4 года назад
Process Flow Chart with Microsoft Excel
Microsoft Excel Fonts for Microsoft Excel Beginners
Просмотров 1444 года назад
Microsoft Excel Fonts for Microsoft Excel Beginners
Working with Microsoft Excel Tools | Excel for Beginners
Просмотров 3164 года назад
Working with Microsoft Excel Tools | Excel for Beginners
Microsoft Excel | How to create a Cumulative Frequency Table in Excel
Просмотров 1,4 тыс.4 года назад
Microsoft Excel | How to create a Cumulative Frequency Table in Excel
Payback Period - Financial Modeling
Просмотров 3384 года назад
Payback Period - Financial Modeling

Комментарии

  • @dhruvjoshi524
    @dhruvjoshi524 2 дня назад

    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

  • @Mark-sf4kh
    @Mark-sf4kh 11 дней назад

    Nice job bossss

  • @zach4hoff
    @zach4hoff 18 дней назад

    Thanks!

  • @wisdom_uboh
    @wisdom_uboh 24 дня назад

    Thanks for recording and sharing your knowledge. Bringing in the combo box is a top-notch idea 🔥🔥🔥🔥🔥🔥🔥🔥

    • @high5tutorials135
      @high5tutorials135 24 дня назад

      Thank you very much. I very well appreciate you compliments.

    • @ngoziokafor3891
      @ngoziokafor3891 24 дня назад

      You are the real MVP🙌. Thanks Charles

  • @TatafoEnjoymentTV
    @TatafoEnjoymentTV Месяц назад

    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!

  • @vincentchidiebere1652
    @vincentchidiebere1652 Месяц назад

    Great explanations. Perhaps you can provide the workbook for practice.

  • @zararahmed1103
    @zararahmed1103 2 месяца назад

    thank you for this video. 🙂🤝

  • @iyaboishola7165
    @iyaboishola7165 2 месяца назад

    To get the end date I can't get the answer,is showing #Value

    • @high5tutorials135
      @high5tutorials135 2 месяца назад

      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

  • @dennisappiah-kubi5269
    @dennisappiah-kubi5269 2 месяца назад

    Thank you for this video. It was very helpful!

  • @brandsouqriyadh
    @brandsouqriyadh 2 месяца назад

    please text sumif formula apply in gross block

    • @high5tutorials135
      @high5tutorials135 2 месяца назад

      Check the condition within your sumif function. If you have multiple conditions, use sumifs.

    • @high5tutorials135
      @high5tutorials135 2 месяца назад

      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.

  • @oluseyeoyeyemisunday4890
    @oluseyeoyeyemisunday4890 3 месяца назад

    Thank you for helping me understand index match. Your explanation were simple and clear

  • @MuhammadIrfan-ml5gb
    @MuhammadIrfan-ml5gb 3 месяца назад

    Lovely

  • @ngapuikuemberirua3670
    @ngapuikuemberirua3670 4 месяца назад

    Very good content

  • @ngapuikuemberirua3670
    @ngapuikuemberirua3670 4 месяца назад

    Great stuff

  • @rajeshparsekar2994
    @rajeshparsekar2994 4 месяца назад

    VERY HELPFUL AND easy to apply

  • @raphaelokoye4310
    @raphaelokoye4310 5 месяцев назад

    This is the best explanation of index and match I have seen in a long time time🎉

  • @ravmon1000
    @ravmon1000 5 месяцев назад

    great content sir!!

    • @high5tutorials135
      @high5tutorials135 5 месяцев назад

      Thank you for watching. Glad you found it a great content

  • @oluseyeoyeyemisunday4890
    @oluseyeoyeyemisunday4890 5 месяцев назад

    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.

    • @high5tutorials135
      @high5tutorials135 5 месяцев назад

      Thank you for watching and for adding value to this video. Happy to learn from you.

  • @karlagranados9921
    @karlagranados9921 6 месяцев назад

    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.

    • @high5tutorials135
      @high5tutorials135 6 месяцев назад

      I am happy you live it. Connected. Thank you.

  • @peteriruogu8928
    @peteriruogu8928 8 месяцев назад

    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

    • @high5tutorials135
      @high5tutorials135 7 месяцев назад

      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

    • @peteriruogu8928
      @peteriruogu8928 7 месяцев назад

      @@high5tutorials135 Thank you for reaching out. It has been sorted already

  • @mohitmishra9322
    @mohitmishra9322 9 месяцев назад

    OMG this was so helpful. Thankyou Sir !

  • @Grandmajoe123
    @Grandmajoe123 10 месяцев назад

    What a fantastic video and tutorial, thanks for all your help.

  • @sindhujamilkuri-k2c
    @sindhujamilkuri-k2c Год назад

    What is the Report Date and how do I know about the Report Date

    • @high5tutorials135
      @high5tutorials135 7 месяцев назад

      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

  • @ravindharmadas6729
    @ravindharmadas6729 Год назад

    What is the Report Date and how do I know about the Report Date

  • @christyo.9125
    @christyo.9125 Год назад

    This video is very helpful, thank you for your time.

  • @christyo.9125
    @christyo.9125 Год назад

    Very impactful. highly simplified

  • @micalghebreab1
    @micalghebreab1 Год назад

    Thank you a lot!

  • @kingjoseph927
    @kingjoseph927 Год назад

    Thanks i enjoyed the lecture.

  • @annietran8200
    @annietran8200 Год назад

    Thank you so much

  • @H-do8tr
    @H-do8tr Год назад

    Great tutorial! Speaking about the disposal, what about if I want to dispose a part of an asset amount not an entire asset?

  • @komninoskamamis1098
    @komninoskamamis1098 Год назад

    Thank you very much. Very helpful

  • @khaledhasan6998
    @khaledhasan6998 Год назад

    Thanx

  • @michaelrouse5286
    @michaelrouse5286 Год назад

    Great presentation

  • @sday2551
    @sday2551 Год назад

    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 ??

  • @nyambesimangolwa5755
    @nyambesimangolwa5755 Год назад

    Golden, thanks!

  • @tehxii7706
    @tehxii7706 Год назад

    I should probably learn to use Visio but with limited time I am attempting to use Excel.

  • @hushtoroar1677
    @hushtoroar1677 Год назад

    You are a genius! Thanks so much xx😍

  • @dabbahprosperprince862
    @dabbahprosperprince862 Год назад

    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

  • @mawaemmanuelalex4179
    @mawaemmanuelalex4179 2 года назад

    Was helpful. Thanks.

  • @kevinassang3158
    @kevinassang3158 2 года назад

    Very good, thanks

  • @diamondglow7947
    @diamondglow7947 2 года назад

    Great explanation! Thank you for sharing

  • @theatmp97
    @theatmp97 2 года назад

    Shouldnt you include the effect of the tax shield?

  • @fredricklangat1677
    @fredricklangat1677 2 года назад

    This indeed is very helpful

  • @bhawanihada9986
    @bhawanihada9986 2 года назад

    Superb illustration boss

  • @Sp18111
    @Sp18111 2 года назад

    Do you have the link to download this excel template which u created ?

  • @kaluanyim1453
    @kaluanyim1453 2 года назад

    Thanks for the insightful tutorial, Sir. Can the formula be adjusted to depreciate for a full year irrespective of the purchase date of the asset?

    • @high5tutorials135
      @high5tutorials135 2 года назад

      Thanks for watching. Let me get you clear. If I buy the assets at the Middle of the year, do you want it to assume a full year depreciation at the end of the purchase year?

  • @tongvang724
    @tongvang724 2 года назад

    Why not just use visio?

    • @high5tutorials135
      @high5tutorials135 2 года назад

      Because Microsoft made the possibilities in Excel. Anyway Visio was made for flow charts thank you for commenting

  • @surfmarko
    @surfmarko 2 года назад

    fantastic! Thank you!

  • @wavesofhealingssj6303
    @wavesofhealingssj6303 2 года назад

    This is very helpful, thank you. How do I create a Legend as shown in the video?

  • @WavesofHealing-jz2ef
    @WavesofHealing-jz2ef 2 года назад

    Well done, thank you!