- Видео 46
- Просмотров 193 326
Neotech Navigators
Индия
Добавлен 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!"
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...
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
I am interested in this file, how do I buy this. Please
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.
Great Learning Thank you
Most welcome
Need Download link this format. For use
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
Need Download link
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
PK…. You are Great!
Thanks 👍
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.
Am amazed how you construct a formula, is there a way how to learn these, or a least tips how to make one? 😥
Will create the formula tutorial soon
@@NeotechNavigators thank you so much, can’t wait.
Gracias por compartir, excelente!!!
Most welcome
Thanks, please let me know your contact details
Thank you very much boss wow great one!
You're welcome!
Well explained
Thanks
Excellent sir I wish to grow same as Excel sheet subscribers for this channel also sir All videos and your dedication wonderfull sir
Thanks for your best wishes 🙏🙏🙏
Please we need this in excel
Will create soon. You can check our other Excel templates on WWW.PK-AnExcelExpert.Com
Great sir 👍👍😃
Many many thanks
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?
Man you saved my life thanks for sharing i would love to buy you a coffee :)
Glad I could help!
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
i want to use it for a register and payment of school fees ( where can i talk to you direct)
Email us at info@PK-AnExcelExpert.com
I could not find the link to the demo Google Sheet file?
When we are changing the month we are not getting a fresh sheet but with previous month data on the next month
This is very good, thank you!
Most welcome
fx = 0 in my google sheet how i can fix it ?
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.
I am learning alot. Thank you.
Most welcome
product master data is not getting update, how to link it with input sheet
Thx! Very helpfull <3
Most welcome
great video, thank you
Most welcome
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 ?
Is it possible on android tablets and phones?
Super easy and great video! Thank you
Most welcome
Thank you so much, your method is easier than other videos!!
You're welcome!
sir footwear ka liya bhi banao
sure. will create soon
Thanks Master. You're a good teacher indeed. This is a different channel.
You are very welcome
Thank you.
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
Google sheets is updated by google. menu may be slighlty different.
How do you calculate the percentage?
You can check the formula in the template. Link is given description box.
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?