![Neotech Navigators](/img/default-banner.jpg)
- 43
- 153 794
Neotech Navigators
India
เข้าร่วมเมื่อ 18 มิ.ย. 2023
"Welcome to Neotech Navigators, your comprehensive guide to the ever-evolving world of technology. We're dedicated to breaking down the complexities of tech into understandable, engaging content for all. Whether you're a seasoned techie or a novice in the digital world, our channel offers a wealth of information to keep you informed and ahead of the curve.
Here, we explore everything from the latest apps to innovative websites, new gadgets to trending tech, and beyond. We decode the jargon, simplify the intricate, and bridge the gap between you and the future. Our mission is to make advanced tech accessible and enjoyable for everyone.
Join us on this journey and become a part of our growing community of tech enthusiasts. Stay tuned for regular updates and dive deep into the fascinating realm of technology with Neotech Navigators.
Subscribe now and start navigating tomorrow today!"
Here, we explore everything from the latest apps to innovative websites, new gadgets to trending tech, and beyond. We decode the jargon, simplify the intricate, and bridge the gap between you and the future. Our mission is to make advanced tech accessible and enjoyable for everyone.
Join us on this journey and become a part of our growing community of tech enthusiasts. Stay tuned for regular updates and dive deep into the fascinating realm of technology with Neotech Navigators.
Subscribe now and start navigating tomorrow today!"
Dynamic Monthly Attendance Template in Google Sheets with Check Boxes – FREE Download
#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/dynamic-monthly-attendance-template-in-google-sheets-with-check-boxes-free-download/
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
th-cam.com/video/5KLQlafUpVg/w-d-xo.html
Create Attendance Template in Google Sheet | Complete Process
th-cam.com/video/6Ni_dy5McmY/w-d-xo.html
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
th-cam.com/video/IA3hEm5KmkI/w-d-xo.html
How to create dynamic Calendar in Google Sheet
th-cam.com/video/H6Cke3rYjlY/w-d-xo.html
Conditional formatting in Google Sheet Chart | Step by Step tutorial
th-cam.com/video/ASGOx6PDos8/w-d-xo.html
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/dynamic-monthly-attendance-template-in-google-sheets-with-check-boxes-free-download/
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
th-cam.com/video/5KLQlafUpVg/w-d-xo.html
Create Attendance Template in Google Sheet | Complete Process
th-cam.com/video/6Ni_dy5McmY/w-d-xo.html
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
th-cam.com/video/IA3hEm5KmkI/w-d-xo.html
How to create dynamic Calendar in Google Sheet
th-cam.com/video/H6Cke3rYjlY/w-d-xo.html
Conditional formatting in Google Sheet Chart | Step by Step tutorial
th-cam.com/video/ASGOx6PDos8/w-d-xo.html
มุมมอง: 365
วีดีโอ
Connect Power BI with Existing Power BI Semantic Model
มุมมอง 91วันที่ผ่านมา
#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 th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance Template in Google Sheet | Complete Process th-cam.com/video/6Ni_dy5McmY/w-d-xo.html Bes...
Connect Power BI with SQL Server (Direct Query and Import Mode)
มุมมอง 18114 วันที่ผ่านมา
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 th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance Template ...
Create and Publish your First Power BI Report
มุมมอง 210หลายเดือนก่อน
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 th-cam.com/...
Project Management Issue Tracker in Google Sheets
มุมมอง 602หลายเดือนก่อน
#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 th-cam.com/video/5KLQlafUpVg/w-...
Auto WhatsApp and Email Functionality Address book in Google sheet
มุมมอง 350หลายเดือนก่อน
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 th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance...
Filter and Filter View in Google Sheet | Complete Guide
มุมมอง 5762 หลายเดือนก่อน
#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: docs.google.com/spreadsheets/d/1M8HY0Sssf-S8-4shEX93BARYe3veklIZvqmXbdd-yxc/edit?usp=sharing Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance Template ...
Inventory Management and Profit Analysis Dashboard in Google Sheet
มุมมอง 3K3 หลายเดือนก่อน
#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. Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance Template in Google S...
ChatGPT's Secret: Boost PowerPoint Creation Speed by 10x!
มุมมอง 5024 หลายเดือนก่อน
#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 th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance Template in Google ...
Sales Dashboard in Google sheet
มุมมอง 5K4 หลายเดือนก่อน
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 th-cam.com/video/5KLQlafUpVg/w-d-xo...
How to use Copilot in Windows 11
มุมมอง 4334 หลายเดือนก่อน
#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 th-cam.com/video/5KLQlafUpVg/w-d-xo.html Create Attendance Template in Google Sheet | Complete Process th-cam.com/video...
Multi-Location Inventory Management in Google Sheets
มุมมอง 4.5K4 หลายเดือนก่อน
#googlesheets #inventoryvideo #inventorysystems Hello Friends, In this video, we have explained how to create an automated Inventory Management System for Multiple Locations in Google Sheet. In this template, we have 4 worksheets, Summary, Input Data, Product Master and List. We are showing the in the summary below metrics: Opening Stock : Available Stock in particular warehouse on selected dat...
Sales Commission Template with Bonus Amount in Google sheet
มุมมอง 1.1K5 หลายเดือนก่อน
#googlesheets #templates #googlesheetstutorial Hello Friends, In this video, we have explained how to create a Sales Commission with Bonus amount in Google sheet. This is ready to use template. Below is the link of this template: docs.google.com/spreadsheets/d/1OhrfbwLjIFdXLPRM17sAj13v8_Sf7pxGoa7BohrjuGk/edit?usp=sharing Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial th-cam....
Dynamic Holiday and Event Calendar in Google Sheet | Step by Step tutorial
มุมมอง 2.1K5 หลายเดือนก่อน
#googlesheets #calendar #googlesheetstutorial Hello Friends, In this video, we have explained how to create a dynamic Calendar with Holiday and Events in Google Sheets. Below are the key features of this calendar: Calendar Sheet tab: we have 12 month's date and the list of holiday or Event on range Z5:AA39. This is a dynamic Calendar; you can change the Year on range R3 from the drop-down list....
Pivot Table Guide for Google Sheets | Step by Step tutorial
มุมมอง 8725 หลายเดือนก่อน
Pivot Table Guide for Google Sheets | Step by Step tutorial
Magic Search box in Google Sheet | Step by Step tutorial
มุมมอง 10K5 หลายเดือนก่อน
Magic Search box in Google Sheet | Step by Step tutorial
Send bulk emails using from Google Sheet through Gmail
มุมมอง 1.1K5 หลายเดือนก่อน
Send bulk emails using from Google Sheet through Gmail
Weekly Roster Template in Google Sheet | Step by Step tutorial
มุมมอง 2.3K6 หลายเดือนก่อน
Weekly Roster Template in Google Sheet | Step by Step tutorial
Waffle Charts in Google Sheets: Easier Than You Think!
มุมมอง 1.7K6 หลายเดือนก่อน
Waffle Charts in Google Sheets: Easier Than You Think!
Create Inventory Management System in Google Sheet | Complete Process
มุมมอง 38K6 หลายเดือนก่อน
Create Inventory Management System in Google Sheet | Complete Process
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
มุมมอง 13K7 หลายเดือนก่อน
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
Conditional formatting in Google Sheet Chart | Step by Step tutorial
มุมมอง 3.9K7 หลายเดือนก่อน
Conditional formatting in Google Sheet Chart | Step by Step tutorial
How to create dynamic Calendar in Google Sheet
มุมมอง 9K8 หลายเดือนก่อน
How to create dynamic Calendar in Google Sheet
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
มุมมอง 1.2K8 หลายเดือนก่อน
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.2K8 หลายเดือนก่อน
From Zero to Hero: Sparklines in Google Sheets FAST! 🔥 Ultimate Tutorial
NETWORKDAYS Vs NETWORKDAYS.INTL In Google Sheet
มุมมอง 1.7K9 หลายเดือนก่อน
NETWORKDAYS Vs NETWORKDAYS.INTL In Google Sheet
Create Attendance Template in Google Sheet | Complete Process
มุมมอง 38K9 หลายเดือนก่อน
Create Attendance Template in Google Sheet | Complete Process
Google Sheet Magic: Double MATCH with INDEX Function - You Won't Believe!
มุมมอง 60410 หลายเดือนก่อน
Google Sheet Magic: Double MATCH with INDEX Function - You Won't Believe!
Google Sheets Magic: 6 VLOOKUP Hacks That'll Blow Your Mind!
มุมมอง 77110 หลายเดือนก่อน
Google Sheets Magic: 6 VLOOKUP Hacks That'll Blow Your Mind!
Google Sheet Hacks: The Ultimate 3D Doughnut Chart Guide!
มุมมอง 1.2K10 หลายเดือนก่อน
Google Sheet Hacks: The Ultimate 3D Doughnut Chart Guide!
Thanks Master. You're a good teacher indeed. This is a different channel.
You are very welcome
How do we unselect data selected
Just put False in one cell then copy to all
@@NeotechNavigators thank you
the menu that you show when you right click is different than what I get, there is no drop down
How do you calculate the percentage?
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?
Sir pz hindi me bana diya karo video ko samj nahi sakte ase
thank youuuu
I'm learning a lot from your videos. Thank you.
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)?
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.
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.
Hugely complicated, Too many steps makes it too slow and hard
GOOD
Thanks
I am not satisfied, how we can update the weekly off and holiday in every month??????
why present absent not updating to default ?
how to get the total present/absent per day? it only shows the info per employee
what if i want to start the calendar on Monday?
can this also work for (restaurant) raw materials inventory? recipe based?
Thanks a lot, had some problem with my gant scheduler, right now I got everything in the place working, atm I have to connect my e-agreement with zapier and my worksheet so it will automatically ad the projects 🎉
13:13 - everything is fine while I am trying to add a new entry and check, in the summery sheet its not reflecting changes, please let us know what went wrong?
Saved my ass minutes to deadline🤣
How to filter absent name list ?
=if(B2<C2,B2,NA())
from where can i download this sheet, your website is very confusing.
Can you make video about apps script in google sheets automatic? File import export. Automatic task run. FMS, backup script
This works wonderfully, thank you. I have noticed a display issue if I have all N/A in the Red column: docs.google.com/spreadsheets/d/e/2PACX-1vQyppdI9znYEHOLpRWkZw7SGDy33QlxvSyU9SJ4DkVED8wfrdoACmBfopobvAb8Y3F5MyCOkA64e3Yd/pubhtml.I did a little trying to self-help and it seems Sheets does have an issue charting non-numerical data but the chart displays correctly when I have all N/A in the Green column so I lost. Help please.
Thank you for making this process so easy and straightforward! Is there a way to highlight specific dates? Im trying to "blackout" specific future dates, but when I do it effects every month in my calendar. Thank you in advance!
Wow Thanks Man for the really good explanation👊🏻🔥🚀. Is this possible with only one column i.e. not providing the support columns. For example I have a profit column that shows profit or loss and profit is anything above 0 being green bar and of course loss is anything below 0 being red bar. Thanks in advance and I appreciate your efforts!
Yes you can!
@NeotechNavigators good to know. Do you have a video on it? Or could you please explain it here? Thanks 👊🏻
Thank you for sharing
Most welcome
Please make Google sheet automation
Sure will make
Wonderful . Thank you so much
Most welcome
Any option that array functions could work inside the table as they throw #spill error
Very useful video - thank you😀
Glad it was helpful!
Hello Sir, can you pl share the link to download this Excel sheet
Link is in the description box
how do I down load this , looked at this the whole of last night....I NEED THIS PLEASE HELP
Link is in the description box
why is my available stocks in product search not accurate? I dont understand the opening balance and closing balance
THIS FORMULA IS NOT WORKING I MEAN I CANT SEE Any number insed the OUT CELL PLEASE HELP ME (=SUMIFS('Input sheet '!$E:$E,'Input sheet '!E:E,"Out",'Input sheet '!$B:$B,$A6,'Input sheet '!$A:$A,$B$3)
Same here after putting formula 0 opening balance
Great! but the special dates highlight function is not showing on other year's calendars
sir I put tis formula is not getting Opening Stock and all plz hell I like this
Good for sharing as template
Thanks
Can we create this in ms excel
Please watch the below video th-cam.com/video/6kFmnt4dab0/w-d-xo.html
HLO SIR HOW CAN I CONTACT YOU I HAVE A QUESTION
You can email us at info@NeoTechNavigators.com
Best tutor ever. Thank you
Most welcome
That you Jatinder?
Most welcome
Great
Thank you
One of the best plan vs actual chart ....
Thanks
why the number format is not working in my speadsheet? what should i do
how to record ledger of daily in and out of an item
Will create a video on this soon
This is a very underrated video. I really like your use of the functionality in Google sheets-you’ve shown me a few things that I didn’t know.
Thanks for your valuable feedback
Please sir send me format
The template link is in the description box.
This not downloading please send me the template