Neotech Navigators
Neotech Navigators
  • 49
  • 220 872
Income and Expense Dashboard in Google Sheets | | Step by Step tutorial
#googlesheets #googlesheetstutorials #financetutorial
Hello Friends,
In this video, we have explained how to create an Income and Expense Dashboard in Google Sheets.
Copy this template from below given link:
neotechnavigators.com/income-expense-dashboard-in-google-sheets/
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
czcams.com/video/5KLQlafUpVg/video.html
Create Attendance Template in Google Sheet | Complete Process
czcams.com/video/6Ni_dy5McmY/video.html
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
czcams.com/video/IA3hEm5KmkI/video.html
How to create dynamic Calendar in Google Sheet
czcams.com/video/H6Cke3rYjlY/video.html
Conditional formatting in Google Sheet Chart | Step by Step tutorial
czcams.com/video/ASGOx6PDos8/video.html
zhlédnutí: 544

Video

Task Priority Tracker in Google Sheets | Step by Step tutorial
zhlédnutí 590Před 19 hodinami
#googlesheetstutorials #googlesheets #taskmanagement Hello Friends, In this video, we have explained how to create a Task Priority Tracker in Google Sheets in Google Sheets. This is ready to use template. In this template we have 4 different worksheets as Dashboard, Task Priority View, Input data and Support Sheet. Below is the template link for Task Priority Tracker: neotechnavigators.com/task...
Birthday and Anniversary Tracker in Google Sheets with Search feature
zhlédnutí 1,1KPřed 21 dnem
#googlesheetstutorials #googlesheets #template Hello Friends, In this video, we have explained how to create Birthday and Anniversary Tracker in Google Sheets with Search feature. Below is the template link: neotechnavigators.com/birthday-and-anniversary-tracker-in-google-sheets-with-search-feature Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/v...
Task Management Tracker in Google Sheets | Step by Step tutorial
zhlédnutí 3,8KPřed 28 dny
#googlesheets #googlesheetstutorials #spreadsheet Hello Friends, In this video, we have explained how to create a Task Management Tracker in Google Sheets. You can use this Task Management Tracker for your Project Management Process. Below is the link of Task Management Tracker in Google Sheets neotechnavigators.com/task-management-tracker-in-google-sheets Project Plan (Gantt Chart) in Google S...
Tables in Google Sheets - NEW Feature!
zhlédnutí 1,1KPřed měsícem
#googlesheets #tables #datanalytics Hello Friends, In this video, we have explained the step by step about the Tables in Google Sheets. This is a new feature in Google Sheet. Watch the complete video till the end. Below is the link of practice file which we have used in this video: neotechnavigators.com/tables-in-google-sheets-new-feature Project Plan (Gantt Chart) in Google Sheet | Step by Ste...
Dynamic Monthly Attendance Template in Google Sheets with Check Boxes - FREE Download
zhlédnutí 1,1KPřed měsícem
#googlesheets #attendancemanagement #attendancesheet Hello Friends, In this video, we have explained how to create a Dynamic Monthly Attendance Template in Google Sheets with Check Boxes. We are providing the free template of this attendance sheet. We have used lot of formulas and conditional formatting in the Google sheet to create this. Below is the template link: neotechnavigators.com/dynami...
Connect Power BI with Existing Power BI Semantic Model
zhlédnutí 689Před 2 měsíci
#powerbi #powerbi_training #powerbipro Hello Friends, In this video, we have explained how to connect Power BI desktop file with existing Power BI Dataset or Power BI Semantic Model. Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/video.html Create Attendance Template in Google Sheet | Complete Process czcams.com/video/6Ni_dy5McmY/video.html Best ...
Connect Power BI with SQL Server (Direct Query and Import Mode)
zhlédnutí 375Před 2 měsíci
Hello Friends, In this video, we have explained how to connect Power BI desktop with SQL Server. We have explained the Direct Query and Import Mode. Also explained how to used SQL Statement to connect and how to use Relational ship in the mixed mode data model. Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/video.html Create Attendance Template i...
Create and Publish your First Power BI Report
zhlédnutí 248Před 2 měsíci
Hello Friends, In this video, we have introduced the Microsoft Power BI. In this video, we have explained how to install the Power BI desktop Application and how to Create and Publish your First Power BI Report. Below is the link to download the Power BI desktop: www.microsoft.com/en-us/download/details.aspx?id=58494 Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/...
Project Management Issue Tracker in Google Sheets
zhlédnutí 1KPřed 3 měsíci
#projectmanagement #googlesheets #projects Hello Friends, In this video, we have explained how to create a Project Management Issue Tracker in Google Sheet. This is a ready to use template. Below is the link of this template: neotechnavigators.com/project-management-issue-tracker-in-google-sheets/ Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/vi...
Auto WhatsApp and Email Functionality Address book in Google sheet
zhlédnutí 537Před 3 měsíci
Hello Friends, In this video, we have explained how to create an Address book with auto WhatsApp and Email functionality in the Google sheet. Below is the link of the practice file: neotechnavigators.com/auto-whatsapp-and-email-functionality-address-book-in-google-sheet/ Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/video.html Create Attendance ...
Filter and Filter View in Google Sheet | Complete Guide
zhlédnutí 938Před 4 měsíci
#googlesheets #filters #salesdata Hello Friends, In this video we have explained how to use Filter and Filter view in Google sheet. Below is the link for practice file: neotechnavigators.com/filter-and-filter-view-in-google-sheet/ Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/video.html Create Attendance Template in Google Sheet | Complete Proce...
Inventory Management and Profit Analysis Dashboard in Google Sheet
zhlédnutí 4,8KPřed 5 měsíci
#googlesheets #inventory #dashboard Hello Friends, In this video, we have explained how to create the Inventory Mangement and Profit Analysis dashboard in Google sheet. We have explained step by step all the formulas and charts use in this dashboard. Below is the link of template Sheet: neotechnavigators.com/inventory-management-and-profit-analysis-dashboard-in-google-sheet/ Project Plan (Gantt...
ChatGPT's Secret: Boost PowerPoint Creation Speed by 10x!
zhlédnutí 542Před 5 měsíci
#chatgpt #powerpoint #ai Hello Friends, In this video, we have explained how to create automatic PowerPoint slides using Chat GPT. Read our details blog point on this topic: neotechnavigators.com/chat-gpt-secret-boost-powerpoint-creation-speed-by-10x/ Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial czcams.com/video/5KLQlafUpVg/video.html Create Attendance Template in Google S...
Sales Dashboard in Google sheet
zhlédnutí 13KPřed 6 měsíci
Sales Dashboard in Google sheet
How to use Copilot in Windows 11
zhlédnutí 601Před 6 měsíci
How to use Copilot in Windows 11
Multi-Location Inventory Management in Google Sheets
zhlédnutí 7KPřed 6 měsíci
Multi-Location Inventory Management in Google Sheets
Sales Commission Template with Bonus Amount in Google sheet
zhlédnutí 1,4KPřed 6 měsíci
Sales Commission Template with Bonus Amount in Google sheet
Dynamic Holiday and Event Calendar in Google Sheet | Step by Step tutorial
zhlédnutí 3,8KPřed 7 měsíci
Dynamic Holiday and Event Calendar in Google Sheet | Step by Step tutorial
Pivot Table Guide for Google Sheets | Step by Step tutorial
zhlédnutí 1,3KPřed 7 měsíci
Pivot Table Guide for Google Sheets | Step by Step tutorial
Magic Search box in Google Sheet | Step by Step tutorial
zhlédnutí 14KPřed 7 měsíci
Magic Search box in Google Sheet | Step by Step tutorial
Send bulk emails using from Google Sheet through Gmail
zhlédnutí 1,5KPřed 7 měsíci
Send bulk emails using from Google Sheet through Gmail
Weekly Roster Template in Google Sheet | Step by Step tutorial
zhlédnutí 2,9KPřed 8 měsíci
Weekly Roster Template in Google Sheet | Step by Step tutorial
Waffle Charts in Google Sheets: Easier Than You Think!
zhlédnutí 2,2KPřed 8 měsíci
Waffle Charts in Google Sheets: Easier Than You Think!
Create Inventory Management System in Google Sheet | Complete Process
zhlédnutí 53KPřed 8 měsíci
Create Inventory Management System in Google Sheet | Complete Process
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
zhlédnutí 21KPřed 8 měsíci
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
Conditional formatting in Google Sheet Chart | Step by Step tutorial
zhlédnutí 5KPřed 9 měsíci
Conditional formatting in Google Sheet Chart | Step by Step tutorial
How to create dynamic Calendar in Google Sheet
zhlédnutí 10KPřed 9 měsíci
How to create dynamic Calendar in Google Sheet
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
zhlédnutí 1,6KPřed 10 měsíci
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
From Zero to Hero: Sparklines in Google Sheets FAST! 🔥 Ultimate Tutorial
zhlédnutí 1,3KPřed 10 měsíci
From Zero to Hero: Sparklines in Google Sheets FAST! 🔥 Ultimate Tutorial

Komentáře

  • @TheGabriellepp
    @TheGabriellepp Před 2 dny

    Very helpful, many thanks

  • @MariaCarmellaAbenes

    I'm having issue following this instructions :(

  • @Rubeenaajeed
    @Rubeenaajeed Před 6 dny

    hi, how to do product creation for same product with different sizes?

  • @SS19_96
    @SS19_96 Před 7 dny

    Thank you so much, it was very helpful and easy to follow!

  • @tabsamsung3798
    @tabsamsung3798 Před 8 dny

    The best sir... 🎉

  • @RaviKumar-ri5kx
    @RaviKumar-ri5kx Před 8 dny

    Very nice explanation

  • @ZagiGoraya
    @ZagiGoraya Před 12 dny

    Total sales formula not applied 😢 in dashboard 😊

  • @juliari9697
    @juliari9697 Před 12 dny

    Why the format always not working for my sheet

  • @muthulakshmin1147
    @muthulakshmin1147 Před 13 dny

    I tried the filter you have shared, unfortunately am getting "Formula Phrase Error"

  • @desbullard26
    @desbullard26 Před 15 dny

    Hi! This is a very helpful video! I am trying to create a social media calendar and it would be helpful to have three rows in between each week of dates where I could add social media details for each date. Is it possible to build this calendar and add the extra space? I tried simply adding rows, but obviously that didn't work. Lol

  • @esperanzapadilla6314
    @esperanzapadilla6314 Před 15 dny

    I hope this message finds you well. I'm a huge fan of your channel, especially the way you break down complex financial and business topics into digestible, actionable insights. Your content has been a valuable resource for many, and I truly appreciate the work you put into each video. I wanted to suggest a topic that I believe would resonate with many of your viewers, especially those in management, HR, or finance roles: Headcount Planning and Budgeting with Salaries. Understanding how to effectively plan for headcount, while balancing budget constraints and salary considerations, is a crucial skill in today’s business environment. It’s an area where many struggle, and your expertise could provide much-needed clarity on: The key factors to consider when planning headcount for upcoming periods. How to align headcount planning with budgetary constraints. Best practices for forecasting salaries and understanding their impact on the overall budget. Tools or frameworks that can simplify the process. I believe a video on this topic would not only draw significant interest but also add immense value to your audience. Thank you for considering this suggestion. I’m looking forward to your future content!

  • @OakRealtyRealEstate-l4j

    hello brother, if we go to the next month to mark attendence it is already showing the previous month attendence

  • @ir_a01
    @ir_a01 Před 18 dny

    Really Nice...Simple & Informative....

  • @ir_a01
    @ir_a01 Před 19 dny

    Excellent.....

    • @NeotechNavigators
      @NeotechNavigators Před 19 dny

      Many many thanks

    • @ir_a01
      @ir_a01 Před 15 dny

      Sir How, To make Product wise Profit And Loss Report...?

  • @bobbysinghbindra6875
    @bobbysinghbindra6875 Před 20 dny

    What happens when the sales price and purchase price changes

  • @arunkumargurram4532
    @arunkumargurram4532 Před 22 dny

    I am interested in this file, how do I buy this. Please

    • @NeotechNavigators
      @NeotechNavigators Před 21 dnem

      It is free of cost. Download link is given in the description box or visit our website NeoTechNavigators.com

  • @GEOTRANSITEXPRESS
    @GEOTRANSITEXPRESS Před 22 dny

    Hi, Your teaching is very much useful. Thanks for the video... But i was trying to add some more options like half day leave and timings of login and logout.. i ended up in confusion.

  • @verasamatraders
    @verasamatraders Před 23 dny

    Great Learning Thank you

  • @msmsajal8334
    @msmsajal8334 Před 23 dny

    Need Download link this format. For use

    • @NeotechNavigators
      @NeotechNavigators Před 22 dny

      Link is in videos description box or visit our website WWW.NeotechNavigators.Com

  • @msmsajal8334
    @msmsajal8334 Před 23 dny

    Need Download link

    • @NeotechNavigators
      @NeotechNavigators Před 22 dny

      Link is in videos description box or visit our website WWW.NeotechNavigators.Com

  • @joseferrato
    @joseferrato Před 24 dny

    PK…. You are Great!

  • @noeter
    @noeter Před 26 dny

    My date won’t much the day of my calendar if I add 1, could you please explain further why + 1? I chose this year, 2024 but 1 won’t work, I added 6 to correct the date. Could you explain the formula of adding 1 please, thank you.

  • @noeter
    @noeter Před 26 dny

    Am amazed how you construct a formula, is there a way how to learn these, or a least tips how to make one? 😥

    • @NeotechNavigators
      @NeotechNavigators Před 25 dny

      Will create the formula tutorial soon

    • @noeter
      @noeter Před 25 dny

      @@NeotechNavigators thank you so much, can’t wait.

  • @gabirabbit9470
    @gabirabbit9470 Před 27 dny

    Gracias por compartir, excelente!!!

  • @Capturemail
    @Capturemail Před 28 dny

    Thanks, please let me know your contact details

  • @ruginathomas3873
    @ruginathomas3873 Před 29 dny

    Thank you very much boss wow great one!

  • @ankitkushwaha8577
    @ankitkushwaha8577 Před 29 dny

    Well explained

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 Před měsícem

    Excellent sir I wish to grow same as Excel sheet subscribers for this channel also sir All videos and your dedication wonderfull sir

  • @sass1330
    @sass1330 Před měsícem

    Please we need this in excel

    • @NeotechNavigators
      @NeotechNavigators Před měsícem

      Will create soon. You can check our other Excel templates on WWW.PK-AnExcelExpert.Com

  • @user-vq1hf4fi5w
    @user-vq1hf4fi5w Před měsícem

    Great sir 👍👍😃

  • @sanjeevfernandes8280
    @sanjeevfernandes8280 Před měsícem

    Bro, I want an employee evaluation form. We have around 150 employees. I want to make an evaluation for all. Based on the evaluation score, we will decide the increment percentage. Do you have any such format?

  • @ahamek
    @ahamek Před měsícem

    Man you saved my life thanks for sharing i would love to buy you a coffee :)

  • @adilshahzad4672
    @adilshahzad4672 Před měsícem

    Hi! Present and Leave Tabs are Working where numbers are counted but in Absent tab there showed 0 values and nothing changed! Please guide a bit why this is happening

  • @MuhammadUmarBabangida
    @MuhammadUmarBabangida Před měsícem

    i want to use it for a register and payment of school fees ( where can i talk to you direct)

  • @MoJo01
    @MoJo01 Před měsícem

    I could not find the link to the demo Google Sheet file?

  • @naazparveen5812
    @naazparveen5812 Před měsícem

    When we are changing the month we are not getting a fresh sheet but with previous month data on the next month

  • @RohitYadav-vv6hg
    @RohitYadav-vv6hg Před měsícem

    This is very good, thank you!

  • @alaaelhady3674
    @alaaelhady3674 Před měsícem

    fx = 0 in my google sheet how i can fix it ?

  • @MattArma
    @MattArma Před měsícem

    How to exclude saturday and sunday in the bar? For example, if the duration is 6 then the result is 1 week plus 1 day because it excludes the sat and sun.

  • @Crismatics
    @Crismatics Před měsícem

    I am learning alot. Thank you.

  • @SHELLY-k8m
    @SHELLY-k8m Před měsícem

    product master data is not getting update, how to link it with input sheet

  • @mateusz3875
    @mateusz3875 Před měsícem

    Thx! Very helpfull <3

  • @j.k6580
    @j.k6580 Před měsícem

    great video, thank you

  • @Jayshreebrijmohan
    @Jayshreebrijmohan Před měsícem

    Thanks for the video --- i have downloaded a pbix file ( downloaded) -- when I open it in the Power BI browser ( I am using Mac) , I can see the report and the associated semantic model .. i need to point this report to my existing model -- how do I do that ?

  • @thegrandzeno1404
    @thegrandzeno1404 Před měsícem

    Is it possible on android tablets and phones?

  • @LindsayWilson-e6f
    @LindsayWilson-e6f Před měsícem

    Super easy and great video! Thank you

  • @labelus9826
    @labelus9826 Před měsícem

    Thank you so much, your method is easier than other videos!!

  • @Abhishekkumar-lw5jo
    @Abhishekkumar-lw5jo Před měsícem

    sir footwear ka liya bhi banao

  • @jahbyke
    @jahbyke Před měsícem

    Thanks Master. You're a good teacher indeed. This is a different channel.

  • @NadineAlfonso-g4t
    @NadineAlfonso-g4t Před měsícem

    How do we unselect data selected