- Видео 76
- Просмотров 6 768
CA Sachin Jangra
Индия
Добавлен 8 фев 2013
Corporate Updates | Educational | Self Learning | Computer Tricks
Hello Everyone
My name is Sachin Jangra, I am Chartered Accountant by profession. I have created this channel to share helpful videos about corporate updates, computer tricks, educational updates. Something you can expect by subscribing to this channel is an opportunity of learning and enhancing your knowledge.
I am always down to connect and answer any business related queries. Feel free to reach me on my mail ID
sachinjangraca@outlook.com
Thanks for your love and support !!
Hello Everyone
My name is Sachin Jangra, I am Chartered Accountant by profession. I have created this channel to share helpful videos about corporate updates, computer tricks, educational updates. Something you can expect by subscribing to this channel is an opportunity of learning and enhancing your knowledge.
I am always down to connect and answer any business related queries. Feel free to reach me on my mail ID
sachinjangraca@outlook.com
Thanks for your love and support !!
Day 57 | TIME Formula | MS Excel 365 | 365 Formulas
In this video, we’ll dive into the TIME function in Microsoft Excel, which allows you to create a time value by specifying hours, minutes, and seconds. Whether you're working with time calculations or need to convert time in your spreadsheets, this formula will help you handle all your time-related tasks with ease!
You’ll learn:
What the TIME function is and how it works.
Step-by-step instructions on using the TIME formula.
How to use TIME for time calculations and data manipulation.
Tips and tricks for working with time in Excel effectively.
This tutorial is perfect for both beginners and those looking to enhance their Excel skills, making it easier to manage time data in your spreadsheets.
🔔 D...
You’ll learn:
What the TIME function is and how it works.
Step-by-step instructions on using the TIME formula.
How to use TIME for time calculations and data manipulation.
Tips and tricks for working with time in Excel effectively.
This tutorial is perfect for both beginners and those looking to enhance their Excel skills, making it easier to manage time data in your spreadsheets.
🔔 D...
Просмотров: 4
Видео
Day 56 | DATEVALUE Formula | MS Excel 365 | 365 Formulas
Просмотров 342 часа назад
In this video, we’ll walk you through the powerful DATEVALUE function in Microsoft Excel, which allows you to convert a date stored as text into an actual Excel date value. Whether you’re working with imported data or manually entering dates in a text format, this formula can help you easily convert and manipulate your data! You'll learn: What the DATEVALUE function is and how it works. Step-by...
Day 55 | NOW Formula | MS Excel 365 | 365 Formulas
Просмотров 84 часа назад
Learn how to use the NOW formula in MS Excel 365 to display the current date and time dynamically! This tutorial will help you understand the syntax, applications, and tips to efficiently work with real-time data in your spreadsheets. #MicrosoftExcel #ExcelTips #ExcelFormulas #NOWFunction #ExcelTutorial #ExcelTipsAndTricks #ExcelTimeFormula #DynamicDate #ExcelDateTime #ProductivityTools #ExcelF...
Day 54 | TODAY Formula | MS Excel 365 | 365 Formulas
Просмотров 577 часов назад
In this video, we explore the TODAY function in Microsoft Excel, a simple yet powerful tool for working with dates. The TODAY function returns the current date and automatically updates each time the workbook is opened or recalculated. Whether you're creating dynamic reports, tracking deadlines, or building time-sensitive formulas, the TODAY function is an essential tool in your Excel toolkit. ...
Day 53 | DATE Formula | MS Excel 365 | 365 Formulas
Просмотров 809 часов назад
In this video, we explore the versatility of the DATE formula in Microsoft Excel and how it can simplify your work with dates. Whether you're generating specific dates, calculating future or past dates, or extracting date components, the DATE function is essential for managing and manipulating dates in Excel. Watch as we walk you through 5 practical ways to use this powerful function, including...
Day 52 | YEAR Formula | MS Excel 365 | 365 Formulas
Просмотров 612 часов назад
In this video, we dive into the powerful YEAR formula in MS Excel 365 and explore five different functions that help you extract and manipulate years from dates. Whether you're simply extracting a year, formatting it, or calculating time intervals, Excel has a variety of functions that allow you to work seamlessly with date data. Watch the tutorial to learn how to: Use the YEAR function to extr...
Day 51 | MONTH Formula | MS Excel 365 | 365 Formulas
Просмотров 1914 часов назад
Learn how to use the MONTH formula in MS Excel to extract and manipulate date data, making your spreadsheets smarter and more efficient. #ExcelTips #ExcelFormula #ExcelFunctions #MONTHFormula #DataAnalysis #ExcelTutorial #ExcelTricks #ExcelHelp #MicrosoftExcel #ExcelForBeginners #DataScience #ExcelShortcuts #ExcelCharts #ExcelPivotTables #SpreadsheetTips #ExcelPowerUser #ExcelAutomation #ExcelS...
Day 50 | DAY Formula | MS Excel 365 | 365 Formulas
Просмотров 10216 часов назад
Welcome to our latest video where we dive deep into the Day Formula-a game-changing approach to planning and optimizing your day for maximum productivity and success! Whether you’re looking to improve your routine, get more done, or simply make the most of your time, the Day Formula can help you create a structured yet flexible schedule tailored to your goals. In this video, we’ll cover: What t...
Day 49 | TEXT Formula | MS Excel 365 | 365 Formulas
Просмотров 2419 часов назад
In this video, learn how to use the TEXT formula in Excel to format numbers, dates, and times into custom formats. Master this powerful function and enhance your Excel skills with easy-to-follow examples! Whether you're a beginner or an advanced user, this tutorial is perfect for anyone looking to improve their Excel formatting. Watch now and become an Excel pro with CA Sachin Jangra! #Excel #E...
Day 48 | TEXTBEFORE Formula | MS Excel 365 | 365 Formulas
Просмотров 5321 час назад
In this video, we’ll dive into the TEXTBEFORE formula in Excel, a powerful function designed to extract the text that comes before a specified delimiter. Whether you're working with large datasets, text strings, or need to parse URLs, this function simplifies extracting the relevant part of your text. Key Topics Covered: What is the TEXTBEFORE formula? Syntax and structure of the TEXTBEFORE fun...
Day 47 | TEXTAFTER Formula | MS Excel 365 | 365 Formulas
Просмотров 30День назад
In this video, we'll explore the TEXTAFTER formula in Excel, a versatile function that allows you to extract text after a specified delimiter. Whether you're working with long strings of text, URLs, or data with consistent patterns, this function simplifies text extraction by providing an easy way to isolate the information you need. Key Topics Covered: What is the TEXTAFTER formula? Syntax and...
Day 46 | ARRAYTOTEXT | MS Excel 365 | 365 Formulas
Просмотров 21День назад
In this video, we'll dive into the ARRAYTOTEXT formula in Excel, a powerful function that allows you to convert an array or range of values into a text string. Whether you're working with multiple cells, rows, or columns of data, this function makes it easy to join values into a readable format. Key Topics Covered: What is the ARRAYTOTEXT formula? Syntax and structure of the ARRAYTOTEXT functio...
Day 45 | SUBSTITUTE Formula | MS Excel 365 | 365 Formulas
Просмотров 78День назад
Welcome to this tutorial on using the SUBSTITUTE formula in Microsoft Excel 365! In this video, we'll walk you through how to replace specific text within a cell using the SUBSTITUTE function. Whether you're looking to clean up your data, fix errors in text, or perform advanced text manipulation, this powerful formula will make your job much easier. You'll learn how to: Use the SUBSTITUTE funct...
Day 44 | PROPER Formula | MS Excel 365 | 365 Formulas
Просмотров 14День назад
In this tutorial, we will dive into the PROPER formula in Microsoft Excel! Learn how to easily convert text to proper case by capitalizing the first letter of each word while leaving the rest of the letters in lowercase. This function is essential for formatting names, titles, and other text data to ensure consistent and professional-looking results. Whether you're working on spreadsheets for w...
Day 43 | UPPER Formula | MS Excel 365 | 365 Formulas
Просмотров 47День назад
In this tutorial, we dive deep into the UPPER formula in Microsoft Excel! The UPPER function is used to convert all lowercase letters in a text string to uppercase. Whether you're cleaning up data, standardizing text, or just need to convert case for better presentation, this simple but powerful function will help. 💡 What You’ll Learn: How to use the UPPER function in Excel Real-world examples ...
Day 42 | LOWER Formula | MS Excel 365 | 365 Formulas
Просмотров 2014 дней назад
Day 42 | LOWER Formula | MS Excel 365 | 365 Formulas
Day 41 | TEXTJOIN Formula | MS Excel 365 | 365 Formula
Просмотров 14114 дней назад
Day 41 | TEXTJOIN Formula | MS Excel 365 | 365 Formula
Day 40 | CONCAT Formula | MS Excel 365 | 365 Formulas
Просмотров 7314 дней назад
Day 40 | CONCAT Formula | MS Excel 365 | 365 Formulas
Day 39 | CONCATENATE Formula | MS Excel 365 | 365 Formulas
Просмотров 1514 дней назад
Day 39 | CONCATENATE Formula | MS Excel 365 | 365 Formulas
Day 38 | TEXTSPLIT Formula | MS Excel 365 | 365 Formulas
Просмотров 4414 дней назад
Day 38 | TEXTSPLIT Formula | MS Excel 365 | 365 Formulas
Day 37 | AGGREGATE Formula | MS Excel 365 | 365 Formulas
Просмотров 19114 дней назад
Day 37 | AGGREGATE Formula | MS Excel 365 | 365 Formulas
Day 36 | XMATCH Formula | MS Excel 365 | 365 Formulas
Просмотров 8721 день назад
Day 36 | XMATCH Formula | MS Excel 365 | 365 Formulas
Day 35 | MATCH Formula | MS Excel 365 | 365 Formulas
Просмотров 7421 день назад
Day 35 | MATCH Formula | MS Excel 365 | 365 Formulas
Day 34 | INDEX Formula | MS Excel 365 | 365 Formulas
Просмотров 3221 день назад
Day 34 | INDEX Formula | MS Excel 365 | 365 Formulas
Day 33 | SUBTOTAL Formula | MS Excel 365 | 365 Formulas
Просмотров 2021 день назад
Day 33 | SUBTOTAL Formula | MS Excel 365 | 365 Formulas
Day 32 | SUMX2PY2 Formula | MS Excel 365 | 365 Formulas
Просмотров 2121 день назад
Day 32 | SUMX2PY2 Formula | MS Excel 365 | 365 Formulas
Day 31 | SUMXMY2 Formula | MS Excel 365 | 365 Formulas
Просмотров 2721 день назад
Day 31 | SUMXMY2 Formula | MS Excel 365 | 365 Formulas
Day 30 | SUMX2MY2 | MS Excel 365 | 365 Formulas
Просмотров 2721 день назад
Day 30 | SUMX2MY2 | MS Excel 365 | 365 Formulas
DAY 29 | SUMSQ Formula | MS Excel 365 | 365 Formulas
Просмотров 1528 дней назад
DAY 29 | SUMSQ Formula | MS Excel 365 | 365 Formulas
Day 28 | SUMPRODUCT | MS Excel 365 | 365 Formulas
Просмотров 9528 дней назад
Day 28 | SUMPRODUCT | MS Excel 365 | 365 Formulas
🎉🎉🎉
🎉
Sachin sir ki jai ho 🎉🎉🎉🎉🎉
@@Sombir_roadways Jai ho
🎉
🎉🎉
@@mohit_malik_8 Jai ho
Very good sachin..keep going ..
Amazing
Amazing😊
Ca Sachin sir ki class ❤🎉🎉🎉
🤩
Nice 👍
What a fantastic session ...All corporation should learn from here
🎉
Sachin bhai CA hai apne
Good 👍
Thank you! Cheers!
🎉
🎉🎉
🎉
very helpful formula sachin. thanks
Very informative
❤❤
🎉
❤❤❤❤❤❤
👌
Amazingly explained❤
@@sahiltrehan6282 thanks
Thanks sachin for the video.
audio is not audible till 1:40
@@santoshmuvvala6681 watch next video uploaded
@@santoshmuvvala6681 thanks for highlighting
nice video sachin. Thanks
Nice sir ji ❤️
Most welcome
Nice
Thanks
🎉
🎉
@@mohit_malik_8 👌
Very useful
Thank u Pankaj :)
🎉
Very advanced functions
Osm video
Match ka concept clear ❤
🎉
First like 🎉
Bhadiya 😊
Amazing 👏
Awesome ❤😊
Nice😊
@@fcavikaspathak7729 shukriya Vikas Ji
Amazing ❤❤❤🎉🎉
❤
❤❤
So ke uthe ho kya😂❤
👍
👍
helpuful
Sir, ek video haryanvi mein aane do. Baba ki daya te 😂
Baba ki dya t jald avegi
Great explanation 🎉
Great explaining sachin . Keep doing the series🎉