- Видео 567
- Просмотров 15 590 190
Excel 10 tutorial
США
Добавлен 31 окт 2017
Excel 10 Tutorial focuses on Each Excel Versions from Excel 2010 to Office 365. In this channel, I’ll be providing tutorials for both beginners & advanced users. I will be covering excel VBA, functions, formulas, graph, macros, pivot table, chart & everything else that is excel-ly possible.
In this online excel training platform, I’ll focus on solving different Excel problems. I believe in “learn as we go” & that’s the best way to learn excel online. The idea is to increase the productivity of people who uses Microsoft Excel. In each tutorial, you’ll find a resourceful article in the description & all of these tutorials are tested. So, anything you find on #Excel10Tutorial, it works.
You can request tutorials in “Community Tab” or even by leaving a comment, & I’ll be responding to each tutorial request promptly.
There will be tutorials every day & as the host of the channel, I “Kazi”, cordially request you to subscribe to “Excel 10 tutorial”. A supportive community is everything to me
In this online excel training platform, I’ll focus on solving different Excel problems. I believe in “learn as we go” & that’s the best way to learn excel online. The idea is to increase the productivity of people who uses Microsoft Excel. In each tutorial, you’ll find a resourceful article in the description & all of these tutorials are tested. So, anything you find on #Excel10Tutorial, it works.
You can request tutorials in “Community Tab” or even by leaving a comment, & I’ll be responding to each tutorial request promptly.
There will be tutorials every day & as the host of the channel, I “Kazi”, cordially request you to subscribe to “Excel 10 tutorial”. A supportive community is everything to me
How to Convert Grams to Kilograms and Kilograms to Grams In Excel
*How To Convert From Grams to Kilograms and Kilograms to Grams in Excel*
Converting between different units of measurement, such as Grams and Kilograms or vice versa can be of great essence for large calculation. If we do it manually, of course we can do that, we might end up long formula and inaccurate result because we generally roundup numbers and keep only two decimals. Excel provides a convenient solution for this through its CONVERT function. In this guide, we'll explore how to harness the power of the CONVERT function in excel to easily convert measurements between Grams and Kilograms in your Excel spreadsheets.
*Understanding the CONVERT Function:*
Here is a video on how to use conve...
Converting between different units of measurement, such as Grams and Kilograms or vice versa can be of great essence for large calculation. If we do it manually, of course we can do that, we might end up long formula and inaccurate result because we generally roundup numbers and keep only two decimals. Excel provides a convenient solution for this through its CONVERT function. In this guide, we'll explore how to harness the power of the CONVERT function in excel to easily convert measurements between Grams and Kilograms in your Excel spreadsheets.
*Understanding the CONVERT Function:*
Here is a video on how to use conve...
Просмотров: 30
Видео
How to Remove Number from Alphanumeric Text Strings In Excel
Просмотров 1202 часа назад
*How to Remove All Numbers From a Alpha-numeric Cell* Are you grappling with the common issue of messy data in Excel, where text strings are often cluttered with numbers? This problem is particularly prevalent when working with product codes, serial numbers, or any other data where you need to strip away numeric characters to focus solely on the alphabetic content. Excel offers several efficien...
How to Display Different Symbol Based on Cell Value In Excel
Просмотров 1114 часа назад
*How to Display Different Symbols Based on Cell Value In Excel* In the realm of Excel spreadsheets, functionality often takes precedence over aesthetics. However, there are instances where visual representations can significantly enhance data interpretation. One such method is displaying different symbols based on cell values. It adds a visual dimension to your data and aids in conveying inform...
How to Use the Value Function In Excel
Просмотров 1397 часов назад
*How to use the Value Function in Excel* Excel is a powerful tool used by millions worldwide for data analysis, financial modeling, and various other tasks. While many users are familiar with basic functions like SUM, AVERAGE, and IF, there are numerous lesser-known functions that can significantly enhance your Excel proficiency. One such function is the VALUE function, a versatile tool that al...
How to Convert Feet and Inches to Inches in Excel
Просмотров 1889 часов назад
*How to Convert Feet and Inches to Inches in Excel* Converting measurements from feet and inches to inches is a common task in various fields, including construction, architecture, and interior design. Even health and fitness also require height measurements in feet and inches. Excel proves to be an invaluable tool for such conversions, providing a straightforward method to handle complex calcu...
How to Use Arabic Function In Excel
Просмотров 8612 часов назад
*How to Use Arabic Function in Excel* In this Excel Function Explained video series, let's uncover the simplicity and power of the ARABIC function in Excel. The ARABIC function serves as a fundamental tool for converting Roman numerals into Arabic numerals, facilitating seamless numeral conversions within Excel spreadsheets. In plain word, we are going to convert I, II, III, IV, V, etc to 1, 2,...
How to Remove Rows Based on Cell Value in Excel Without VBA
Просмотров 46314 часов назад
*How to Remove Rows Based on Cell Value in Excel Without VBA* In this intermediate excel tutorial, I’ll show you two different ways to delete entire row based on text in excel. I’ll be using Excel’s built in features to do it and I’ll not be using any vba in this tutorial. Here it goes: 0:00 How to Remove Rows Based on Cell Value in Excel Without VBA We have a sample dataset where we want to re...
How to Convert Miles to Kilometers and Kilometers to Miles in Excel
Просмотров 15816 часов назад
*How To Convert From Miles to Kilometers and Kilometers to Miles in Excel* Converting between different units of measurement, such as miles and kilometers or vice versa can be of great importance for large calculation. If we do it manually, we can do that, we might end up long formula and inaccurate result because we generally roundup numbers and keep only two decimals. Excel provides a conveni...
How to Convert 8 Digit Numbers to Dates In Excel
Просмотров 15619 часов назад
*Converting an 8-Digit Number to Date in Excel* In Excel, transforming an 8-digit number into a readable date might seem like a daunting task for some. However, with the right formula, this process becomes a breeze. Using a combination of Excel functions, specifically “LEFT”, “RIGHT”, and “MID”, alongside the “DATE” function, you can effortlessly convert these numbers into understandable dates....
How to Convert Ordinal Numbers to Numbers in Excel (1st, 2nd, 3rd to 1, 2, 3)
Просмотров 11621 час назад
*Converting Ordinal Numbers to Numbers in Excel Using Formula* Ordinal numbers, such as "1st," "2nd," "3rd," etc., are commonly used to denote the position of items in a sequence. While they are intuitive for humans to understand, they can sometimes pose challenges when working with data in Excel, especially if you need to perform calculations or comparisons. However, with a simple formula, you...
How to Convert Inches to Feet and Inches in Excel
Просмотров 128День назад
*How to Convert Inches to Feet and Inches in Excel* In our daily lives, measurements are omnipresent, whether we're dealing with carpentry, sewing, or simply measuring a room. Among the various units of measurement, converting inches to feet and inches is a frequent task. While it's a straightforward conversion, employing tools like Microsoft Excel can streamline the process, saving time and re...
How to Convert Numbers to 1st 2nd 3rd 4th 5th in Excel
Просмотров 177День назад
*How to Convert Numbers to Ordinal Numbers in Excel* Ordinal numbers are a fundamental part of many data presentations, particularly in contexts where data involves dates, rankings, or sequential order. Microsoft Excel offers powerful tools for data manipulation and presentation, and it's essential to understand how to effectively represent ordinal numbers within Excel spreadsheets. In this Int...
How to Use Roman Function In Excel
Просмотров 121День назад
*How to Use Roman Function In Excel* In this Excel Function Explained video series, let's delve into the versatile world of the ROMAN function in Excel. The ROMAN function serves as a powerful tool for converting Arabic numerals into Roman numerals, allowing users to tailor the output to their specific needs. *Understanding the ROMAN Function:* The ROMAN function enables users to seamlessly con...
How to Convert Dates to Words In Excel
Просмотров 208День назад
*How to Convert Dates to Words in Excel* Have you ever found yourself lost where you need to convert 1000 dates to words in excel? Well, now you are safe. In this advanced excel tutorial, you’ll easily be able to solve this. Suppose you have a date in cell A2 like this, 4/25/2024 and in cell B2 you need to convert it to words like this, Twenty-Fifth April Two Thousand Twenty-Four. Well, it can ...
How To Convert From Meters to Centimeters and Centimeters to Meters in Excel
Просмотров 17614 дней назад
*How To Convert From Meters to Centimeters and Centimeters to Meters in Excel* Converting between different units of measurement, such as meters and centimeters or vice versa can become a great problem for large calculation. If we do it manually, we can do that, we might end up long formula and inaccurate result because we generally roundup numbers and keep only two decimals. Excel provides a c...
How to Highlight Cells Referenced in Formula In Excel
Просмотров 19314 дней назад
How to Highlight Cells Referenced in Formula In Excel
How to Show or Hide Horizontal and Vertical Scroll Bar in Microsoft Excel
Просмотров 27214 дней назад
How to Show or Hide Horizontal and Vertical Scroll Bar in Microsoft Excel
How to Remove Middle Name from A Full Name in Excel
Просмотров 34014 дней назад
How to Remove Middle Name from A Full Name in Excel
How to Copy Page Setup to Other Worksheets in Excel
Просмотров 34714 дней назад
How to Copy Page Setup to Other Worksheets in Excel
How to Check if Time is Between Two Times in Excel
Просмотров 483Месяц назад
How to Check if Time is Between Two Times in Excel
How to Auto Fill Text Based on Cell Colors in Excel
Просмотров 553Месяц назад
How to Auto Fill Text Based on Cell Colors in Excel
How to Remove Middle Initials from Full Name in Excel
Просмотров 851Месяц назад
How to Remove Middle Initials from Full Name in Excel
How to Rename Multiple Worksheets at Once in Excel
Просмотров 621Месяц назад
How to Rename Multiple Worksheets at Once in Excel
How to Get A List of All Worksheet Names In Excel
Просмотров 1,1 тыс.2 месяца назад
How to Get A List of All Worksheet Names In Excel
How to Make a List of 1 to 100 in Excel
Просмотров 9792 месяца назад
How to Make a List of 1 to 100 in Excel
How to Set Character Limit in an Excel Column
Просмотров 8362 месяца назад
How to Set Character Limit in an Excel Column
How to Highlight Specific Text within a Cell In Excel
Просмотров 2,1 тыс.2 месяца назад
How to Highlight Specific Text within a Cell In Excel
ভাই margecell করে পুনরায় ফিরে আনার জন্য কি করতে হবে?
Select the Merged Cell, From the Home tab click on the "Merge & Center" Dropdown and then select "Unmerge Cell".
Beautiful just what I needed
Glad I could help
ขอบคุณมากครับ
You're most welcome
Thank you so much
You're most welcome
Thank you so much
You're most welcome
Thank you so much
You're most welcome. Please subscribe and share
@@Excel10tutorial I have been subscribed to the channel for a while
@@Excel10tutorial I have been subscribed to the channel for a while
Thanks a million. Stay with us and keep sharing.
Fabulous, perfect for my needs! Thank you so much!!
Glad you like it. Please subscribe and share.
Thank you very much!!! Great work!!!
Glad you liked it!
I need the code for How To Create Hyperlinked Index Of Sheets In Excel Workbook
Code link is in the video description.
Great Info - I use cond format quite often and this is now in my list for future use. Tks for posting.
Glad you like it. Please subscribe and share.
Excellent - thanks so much. Been looking for something that worked for hours.
Glad you like it. Please subscribe and be with us
How do i create a minimum for a cell? for example if I have a formula that adds up the sum but I never want that sum to be less than 3500... so if the total is 2500 it will automatically make it 3500
Wrap this up with another if function. If value is less than 2500 show 3500 else write the formula you are using. In the if condition the value will be the formula you are using.
Thanks
You're most welcome.
Thank you brother❤
You're most welcome. Please subscribe and be with us
Thanks mate :)
Happy to help
Thanks you... ur video helped me now
You're most welcome. Please subscribe and Share
Thank you!
You're welcome!
Everyone else had .bat tutorials and it is not always possible to use .bat in a secured environment. This tutorial helped me save loads of time! Thanks 👍
Glad it helped. Please share with others.
Pl send me a code sir
In the video description.
goodone
Thanks
This did not work for me. I find Microsoft 365 does not work as well as Excel before 365!!
Oops. I used Thurs as my start date instead of Thu. Now it works!! Thank you - and thanks to other commenter.
Glad you figured it out.
Wow - It's great but a bit above my pay grade - but if I need to use it I'll find your video and learn again. Tks for posting!
Subscribe and be with us
Thanks for the video. I tried your method but the cell returned only part of the url but the whole of it. What do you think could be the issue here?
Is there a way to update the value if the cell colour updates
Try F9 and if it doesn't work let me know
I have a problem with a text file - it has some kind of hidden characters or something - like page breaks 🤷♀️ So will filter and select the 1st group of accounts - but nothing after So I have to manually go thru after the first set and delete rows (cleaning the file for upload to our database) So frustrating - nobody else in our IT group can get that file to filter correctly So we can only automate to a point
Can you remove formatting? select everything. Go to Home tab, editing group and clear format.
I keep getting a run time error - Document not saved. How do I fix this?
Save the workbook before doing this.
how to add image format comment
Try this: ruclips.net/video/1K-vPH7tWGk/видео.html
Thank you!!
You're welcome!
makasi bang tutorialnya aku udah like dan sabrek yaaa ditunggu konten selanjutnya yang bermanfaat
Thanks a million for subscribing.
Thank you. It's a good trick
You're most welcome
Hi, are you still able to share the code?
Yes I can. Its already in the video description.
thank you, very helpful
Glad it was helpful!
Thanks for the video
You're most welcome.
Where can I get the code?
In the description.
Hi bro could you please advise on the below scenario: In the above set off data which you showed in the video, how to pull out data for revenue without using filter function, I want values by using vlokkup/xlookup but if I use vlookup the next value of revenue is not showing it is pulling out first value of revenue .
will this work: ruclips.net/video/MNckj0Em--k/видео.html
@@Excel10tutorial thanks brother, is there any way to check without unique numbers?
hi, I have subscribed - Kindly forward code, thanks
Check in the video description. Its already there.
Tq sir
All the best
thanks
You're welcome!
Thank you so so much, I've been looking for this everywhere and couldn't find it. Also, great explanation, very easy :)
Great to hear!
Thanku so much Brother May Allah(swt) Bless uh ❤
Thanks a million
Thanks bro.
Any time
If I add row it gets disturbed. Please guide
What about the other way so keep the side always there
Select "Freeze First Column"
You are wonderful and awesome , there are 100 ways to do this but you have given easiest way . Many thanks and keep sharing
So nice of you
Thanks ❤
You're welcome 😊
Thank you brother
Any time
Thank u!!!
You're welcome!
Amazing, I have some skills but not at this level, your formula is fantastic to add on my project.
Glad you like it! Please subscribe and be in touch
👍👍👍♥️♥️♥️
Thanks
All of these are enabled for me. When using =$A1 and I drag horizontal it shows =$A1 in every cell when it should be =$A1, =$A2, =$A3, etc. This isn't happening. Why?
If you drag it horizontally it will not work because of the $ sign. It locked the column name. and also, it doesn't work like that. Even if you remove the $ sign and you drag horizontally you'll get B1, C1, D1 etc. If you drag it vertically then it will give you your desired result. One way is to drag it vertically and then use text to column feature or use advanced formula. This is not an issue of Autofill Handle.