Neotech Navigators
Neotech Navigators
  • Видео 46
  • Просмотров 193 326
Birthday and Anniversary Tracker in Google Sheets with Search feature
#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
ruclips.net/video/5KLQlafUpVg/видео.html
Create Attendance Template in Google Sheet | Complete Process
ruclips.net/video/6Ni_dy5McmY/видео.html
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
ruclips.net/video/IA3hEm5KmkI/видео.html
How to create dynamic Calendar in Google Sheet
ruclips.net/video/H6Cke3rYjlY/видео.ht...
Просмотров: 748

Видео

Task Management Tracker in Google Sheets | Step by Step tutorial
Просмотров 2,3 тыс.21 час назад
#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!
Просмотров 95328 дней назад
#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
Просмотров 953Месяц назад
#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
Просмотров 331Месяц назад
#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 ruclips.net/video/5KLQlafUpVg/видео.html Create Attendance Template in Google Sheet | Complete Process ruclips.net/video/6Ni_dy5McmY/видео.html Bes...
Connect Power BI with SQL Server (Direct Query and Import Mode)
Просмотров 293Месяц назад
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 ruclips.net/video/5KLQlafUpVg/видео.html Create Attendance Template ...
Create and Publish your First Power BI Report
Просмотров 2332 месяца назад
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 ruclips.net...
Project Management Issue Tracker in Google Sheets
Просмотров 8602 месяца назад
#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 ruclips.net/video/5KLQlafUpVg/в...
Auto WhatsApp and Email Functionality Address book in Google sheet
Просмотров 4572 месяца назад
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 ruclips.net/video/5KLQlafUpVg/видео.html Create Attendance...
Filter and Filter View in Google Sheet | Complete Guide
Просмотров 7893 месяца назад
#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 ruclips.net/video/5KLQlafUpVg/видео.html Create Attendance Template in Google Sheet | Complete Proc...
Inventory Management and Profit Analysis Dashboard in Google Sheet
Просмотров 4,1 тыс.4 месяца назад
#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!
Просмотров 5305 месяцев назад
#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 ruclips.net/video/5KLQlafUpVg/видео.html Create Attendance Template in Google ...
Sales Dashboard in Google sheet
Просмотров 10 тыс.5 месяцев назад
Hello Friends, In this video, we have explained how to create a Sales KPI dashboard in Google sheet. we have taken 5 KPI as Sale Price, Gross Sales, Discounts, Sales, COGS and Profit. Below is the link of Sales Dashboard template link: neotechnavigators.com/sales-kpi-dashboard-in-google-sheet/ Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial ruclips.net/video/5KLQlafUpVg/видео...
How to use Copilot in Windows 11
Просмотров 5385 месяцев назад
#windows11 #copilot #aiassistance Hello Friends, In this video, I have explained how to use Copilot in Windows11. Read our details blog post on this topic: neotechnavigators.com/how-to-use-copilot-in-windows-11 Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial ruclips.net/video/5KLQlafUpVg/видео.html Create Attendance Template in Google Sheet | Complete Process ruclips.net/vide...
Multi-Location Inventory Management in Google Sheets
Просмотров 6 тыс.6 месяцев назад
Multi-Location Inventory Management in Google Sheets
Sales Commission Template with Bonus Amount in Google sheet
Просмотров 1,3 тыс.6 месяцев назад
Sales Commission Template with Bonus Amount in Google sheet
Dynamic Holiday and Event Calendar in Google Sheet | Step by Step tutorial
Просмотров 3,1 тыс.6 месяцев назад
Dynamic Holiday and Event Calendar in Google Sheet | Step by Step tutorial
Pivot Table Guide for Google Sheets | Step by Step tutorial
Просмотров 1,1 тыс.6 месяцев назад
Pivot Table Guide for Google Sheets | Step by Step tutorial
Magic Search box in Google Sheet | Step by Step tutorial
Просмотров 12 тыс.6 месяцев назад
Magic Search box in Google Sheet | Step by Step tutorial
Send bulk emails using from Google Sheet through Gmail
Просмотров 1,3 тыс.7 месяцев назад
Send bulk emails using from Google Sheet through Gmail
Weekly Roster Template in Google Sheet | Step by Step tutorial
Просмотров 2,7 тыс.7 месяцев назад
Weekly Roster Template in Google Sheet | Step by Step tutorial
Waffle Charts in Google Sheets: Easier Than You Think!
Просмотров 2 тыс.7 месяцев назад
Waffle Charts in Google Sheets: Easier Than You Think!
Create Inventory Management System in Google Sheet | Complete Process
Просмотров 47 тыс.8 месяцев назад
Create Inventory Management System in Google Sheet | Complete Process
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
Просмотров 18 тыс.8 месяцев назад
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
Conditional formatting in Google Sheet Chart | Step by Step tutorial
Просмотров 4,6 тыс.8 месяцев назад
Conditional formatting in Google Sheet Chart | Step by Step tutorial
How to create dynamic Calendar in Google Sheet
Просмотров 9 тыс.9 месяцев назад
How to create dynamic Calendar in Google Sheet
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
Просмотров 1,4 тыс.9 месяцев назад
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
Просмотров 1,3 тыс.10 месяцев назад
From Zero to Hero: Sparklines in Google Sheets FAST! 🔥 Ultimate Tutorial
NETWORKDAYS Vs NETWORKDAYS.INTL In Google Sheet
Просмотров 1,9 тыс.10 месяцев назад
NETWORKDAYS Vs NETWORKDAYS.INTL In Google Sheet
Create Attendance Template in Google Sheet | Complete Process
Просмотров 43 тыс.10 месяцев назад
Create Attendance Template in Google Sheet | Complete Process

Комментарии

  • @arunkumargurram4532
    @arunkumargurram4532 17 часов назад

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

  • @GEOTRANSITEXPRESS
    @GEOTRANSITEXPRESS День назад

    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 День назад

    Great Learning Thank you

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

    Need Download link this format. For use

    • @NeotechNavigators
      @NeotechNavigators День назад

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

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

    Need Download link

    • @NeotechNavigators
      @NeotechNavigators День назад

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

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

    PK…. You are Great!

  • @noeter
    @noeter 4 дня назад

    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 4 дня назад

    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 4 дня назад

      Will create the formula tutorial soon

    • @noeter
      @noeter 4 дня назад

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

  • @gabirabbit9470
    @gabirabbit9470 5 дней назад

    Gracias por compartir, excelente!!!

  • @Capturemail
    @Capturemail 6 дней назад

    Thanks, please let me know your contact details

  • @ruginathomas3873
    @ruginathomas3873 8 дней назад

    Thank you very much boss wow great one!

  • @ankitkushwaha8577
    @ankitkushwaha8577 8 дней назад

    Well explained

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 8 дней назад

    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 8 дней назад

    Please we need this in excel

    • @NeotechNavigators
      @NeotechNavigators 8 дней назад

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

  • @user-vq1hf4fi5w
    @user-vq1hf4fi5w 9 дней назад

    Great sir 👍👍😃

  • @sanjeevfernandes8280
    @sanjeevfernandes8280 10 дней назад

    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 10 дней назад

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

  • @adilshahzad4672
    @adilshahzad4672 11 дней назад

    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 17 дней назад

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

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

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

  • @naazparveen5812
    @naazparveen5812 19 дней назад

    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 20 дней назад

    This is very good, thank you!

  • @alaaelhady3674
    @alaaelhady3674 23 дня назад

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

  • @MattArma
    @MattArma 25 дней назад

    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 27 дней назад

    I am learning alot. Thank you.

  • @SHELLY-k8m
    @SHELLY-k8m 28 дней назад

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

  • @mateusz3875
    @mateusz3875 29 дней назад

    Thx! Very helpfull <3

  • @j.k6580
    @j.k6580 Месяц назад

    great video, thank you

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

    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 Месяц назад

    Is it possible on android tablets and phones?

  • @LindsayWilson-e6f
    @LindsayWilson-e6f Месяц назад

    Super easy and great video! Thank you

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

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

  • @Abhishekkumar-lw5jo
    @Abhishekkumar-lw5jo Месяц назад

    sir footwear ka liya bhi banao

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

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

  • @NadineAlfonso-g4t
    @NadineAlfonso-g4t Месяц назад

    How do we unselect data selected

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

    the menu that you show when you right click is different than what I get, there is no drop down

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

      Google sheets is updated by google. menu may be slighlty different.

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

    How do you calculate the percentage?

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

      You can check the formula in the template. Link is given description box.

  • @AmirIqbalAnsari-c3s
    @AmirIqbalAnsari-c3s Месяц назад

    if we are entering data for the next month, data is getting replaced in the original month as well.. how to keep all the months' data stored?

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

    Sir pz hindi me bana diya karo video ko samj nahi sakte ase

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

    thank youuuu

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

    I'm learning a lot from your videos. Thank you.

  • @eFilet-O-Fish
    @eFilet-O-Fish Месяц назад

    It's a wonderful concept; however, it's restricted to viewing transactions only within the specified day requested. How can you modify and view transactions within a range of dates? ie: (week, biweekly, monthly)?

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

    This is only good for one month. Once you change the month, the present and absences is still showing and not getting back to empty default.

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

    Is there anyway to make a chart color match a cell color? I already have my data being conditionally formatted and I just want my chart to match the colors.

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

    Hugely complicated, Too many steps makes it too slow and hard

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

    GOOD

  • @VivekKumar-dy6it
    @VivekKumar-dy6it Месяц назад

    I am not satisfied, how we can update the weekly off and holiday in every month??????

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

    why present absent not updating to default ?

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

    how to get the total present/absent per day? it only shows the info per employee

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

    what if i want to start the calendar on Monday?