Excel 10 Tutorial: What is This All About?
25,839 views 7 years ago
Excel 10 Tutorial focuses on Microsoft Excel 2010. In this channel i will be providing tutorials for both dummies and advance users. I will be covering excel vba, functions, formulas, graph, macros, pivot table, chart and everything else that is excelly possible. Subscribe now; it’s free forever: https://goo.gl/uL8fqQ This channel is like an online excel training platform where I will focus on solving different problems with excel 2010. I believe in “learn as we go” and that is the best way to learn excel online. The idea is to increase productivity of people who uses Microsoft excel. In every tutorial you find a short article in the description and there will be a PDF Tutorial with it with a detailed article. You can request for tutorials or PDF through “Channel discussion” and I will be responding to every tutorial request in a timely manner. Request Page: https://goo.gl/jM78fA There will be tutorials every day and as the host of the channel, I “Kazi”, cordially request you to subscribe to “Excel 10 tutorial”. A supportive community is everything to me. Remember; Subscription means a lot to me. Please subscribe: https://goo.gl/uL8fqQ *Become a member and enjoy exclusive perks while supporting the channel you love!* https://www.youtube.com/@Excel10tutor...
In this playlist you will find Excel Tutorials that are for Beginners. I will be solving different problems with excel formulas and functions, chart, graph and other excel tips and tricks. There will be PDF tutorials for beginners. In short this is a complete and free excel training for beginners. Channel subscription link: https://goo.gl/uL8fqQ Tutorial Request Link: https://goo.gl/jM78fA
In this video series you will be looking at some advanced Excel Tutorial which is cutting edge in solving different problems in Excel. These excels hacks will be also provided in detailed PDF tutorial for your convenience. We will be covering Excel VBA, Pivot Table, Excel Macros, Excel Vlookup, and other advanced functions and formulas of Microsoft Excel. Subscribe this channel for free advance excel training course. Channel subscription link: https://goo.gl/uL8fqQ You can also request for advance tutorial and I will provide you ASAP. Request Page: https://goo.gl/jM78fA
In this comprehensive "Combine Workbook and Worksheets in Excel" playlist, you will discover how to effectively merge multiple workbooks and worksheets into one centralized file using a variety of methods. With an emphasis on using the "Consolidate" feature, Visual Basic for Applications (VBA), and Power Query, you will learn how to simplify and streamline your data management process. In this playlist, you'll learn how to use the "Consolidate" feature to quickly combine data from multiple worksheets into a single worksheet. You'll also learn how to use VBA to automate the process of combining workbooks and worksheets, eliminating manual and repetitive tasks. Additionally, you'll discover the power of Power Query, a powerful data connection tool in Excel, which enables you to combine and transform data from multiple sources with ease. By the end of this playlist, you'll have a deep understanding of how to use the "Consolidate" feature, VBA, and Power Query to effectively merge your data. Whether you're dealing with large amounts of data or just want to streamline your workbook, this playlist will provide you with the skills you need to succeed. Don't miss out on the opportunity to improve your data management skills and streamline your workbook. Subscribe now and start combining workbooks and worksheets in Excel like a pro!
Case sensitivity: Case sensitivity is an important fact in any computer program. It requires you to enter characters just the way it was pre-programmed. For example: If the command requires uppercase letter then it won’t work if you enter lowercase letter. This is case sensitivity and it has a great impact on Microsoft excel Too. To learn more about case sensitivity you can visit Wikipedia: https://en.wikipedia.org/wiki/Case_sensitivity Changing Case in Excel: Microsoft Excel doesn’t have change case button for changing capitalization like Microsoft word, yet changing case in excel is very crucial. To change the case of a text you can use excel functions and in this playlist you will learn all about Excel Case: https://goo.gl/xiP3tv There are different types of letter cases and these are the mostly used character cases in excel. Let’s learn about them. 1. Title case or proper case 2. Sentence case 3. Uppercase 4. Lowercase Title case or proper case: Title case and proper case are the same. If a sentence is written in a way that the first letter of every word is in capital letter and the rest of the letter is in the small letter that is title case or proper case. The name title case came from the writing style of titles which is as same as proper case. So if first letter of every word is capitalized it is called title case or proper case. Example: This Is A Proper Case Sentence. In the following you will find the way of changing proper case to uppercase and proper case to lowercase in Excel 2010. How to change proper case to lowercase in Microsoft Excel 2010: https://youtu.be/M3FBKERMGOU How to change proper case to uppercase in Microsoft Excel 2010: https://youtu.be/Zjc9w-9iy8s Sentence case: Sentence case indicates the character case where only the first letter of a sentence is capital letter and the rest is small letter. The way we write usually is sentence case. Example: This is a sentence case example where only first letter is capital. Let’s check a video on converting any sentence in sentence case in Microsoft Excel 2010. How To Capitalize First Letter Of A Sentence In Excel 2010: https://youtu.be/LtFC-5lY1CI Uppercase: Uppercase letter indicates every letter of a sentence is in capital letter or in All Caps. This is a commonly used letter case. Example: THIS IS UPPERCASE SENTENSE. Let’s check some video on how to change uppercase to proper case and upper case to lowercase. How to change uppercase letter to lowercase in excel: https://youtu.be/ikq9x9u_mtE How to change uppercase to proper case or title case in excel: https://goo.gl/GjkUa7 Lowercase: Lowercase letter indicates everything in small letter. That means you’ll write every letter of a sentence in small letter. This is called lowercase letter. Example: this is a lowercase sentence example. Let’s learn how to change lowercase to uppercase and lowercase to proper case in Microsoft Excel 2010. How to change lowercase letters to uppercase in excel: https://youtu.be/tlYAMEh1IPI How to change lowercase to proper case or title case in excel: https://youtu.be/SZ4wBBbGCt8 Now in this playlist you will learn transitions between Proper case, lowercase, uppercase and sentence cases. Bonus Video: How to prevent uppercase entry in excel 2010: https://youtu.be/2qa1iQgnvGw How to prevent lowercase entry in an excel selection: https://youtu.be/IHAM2Ag96rg Subscribe to the channel: https://goo.gl/uL8fqQ ______________________________________________________________ Support the channel: https://www.patreon.com/excel10tutorial ------------------------------------------------------------------------------------------------------ Connect on Social Media: Facebook: https://www.facebook.com/excel10tutorial/ Blogger: https://excel10tutorial.blogspot.com/ Tumblr: https://excel10tutorial.tumblr.com/ Instagram: https://www.instagram.com/excel_10_tutorial
One of the most powerful features of Microsoft excel is Comments or Notes. Comments helps users to give instructions to colleagues or keep note for themselves & many more. There are numerous usages of comments in excel. In Excel 10 Tutorial: https://bit.ly/2WxChtC We intend to cover everything you can do with excel comments. Tons of resources on Microsoft excel comments in one place. You can use these techniques in Excel 10, 13, 16 & 19 Versions. In office 365 you will encounter with threaded comments or notes. Here is a resource for that: https://bit.ly/2KjgZe8 I have created 32 “How To” Videos on Excel Comments. If you watch these videos, you’ll never need anything else. First thing to learn is to insert one. In the below video you’ll learn to add, show, hide, edit & delete a comment in different excel version. Add, Edit, Delete, Show & Hide Comments: https://bit.ly/34MkqDE So, you’ve learned the basics of adding comments & let’s move to the next phase. Here we’ll insert comments to multiple cells at once & add comments to protected workbooks. Insert A Comment to Multiple Cells at Once: Insert A Comment to Multiple Cells at Once Using Paste Special Feature: Allow Comments in Protected Worksheet: Let’s convert comments to cell value & vice versa. Next three videos will illustrate how you can do that. Convert Comments to Cell Contents: Convert to Cell Contents Using Function: Convert Cell Contents into Comments: You have added your comments. it’s time to format them to match your level of professionalism. The next one is on formatting. Format Comments in Excel: https://bit.ly/2yrvJ8a Now we are going to duplicate comments, that means copy comments to multiple cells. Copy Only Comments & Paste in Multiple Cells: https://bit.ly/3boEvlZ Now we need to think about the author name of comments. How to add author name & change it. What is the default author name in excel? Next two videos will cover everything on comments name. Change Author Name in comments: https://bit.ly/2VIlQuK Change All Author Names in Comments at Once: https://bit.ly/3akGKp2 Usually you can’t add date & time in comments. But in the next two videos I’ll explain how you can add date & time to it. Automatically Add Date & Time to Comments Using Button: https://bit.ly/2RYfPJi Add Date & Time to Comments Using Keyboard Shortcut: https://bit.ly/2zlzvR2 Now we’ll learn to add different things to comments. Like adding formula results inside comments or inserting image or even adding clickable hyperlink. Insert Formula Result in Comment: Insert Picture in Comments: Normally, you can add hyperlink in comment but you can’t make it clickable. In this tutorial I’ll teach you how to do it. Add Clickable Hyperlink in Comments: Now if you are working on a large data-set you might have already added a lot of comments. Sometimes you need to highlight them or even count how many cells have comments. Here are a few ways to do that. Count the Number of Cells with Comments: Count the Number of Cells with Comments Using “Go to Special” Function: Highlight All Cells with Comments: Highlight All Cells with Comments Using “Go to Special” Option: By now you must have noticed all those awkward red comment indicators. What if you need to remove them or even change the color of them? The next two videos will solve that. Change Comment Indicator Color: https://bit.ly/34VcQH2 Remove Red Comment Indicator: https://bit.ly/2XP9C69 Resizing & Reshaping comment box is necessary. Without it you can’t see your data properly. Next three tutorials will cover that. Auto-size Comment Box Inside A Range to Fit Its content: Auto-size All Comment Box in A Worksheet to Fit Its content: Change the Shape of Comment Box: If you moved your comment boxes you’ll need to reset its position. Here is how to do that. Reset All Comment Positions: Find & Replace inside comments is impossible right? No, I know how to do it. Find & Replace Text Within Comments: If you need to list all your comments or even export them can do that, here is how. List All Comments to A New Worksheet: Export Comments from Excel to Word: It’s time to Print. In the next video I will explain different ways of printing comments Print comments in Excel: https://bit.ly/3bhQ6mO Now that we have covered everything, it’s time to delete. Here is how you can delete comments in bulk. Here you go, the last two videos on Microsoft Excel Comments. Delete All Comments in A Worksheet at Once: Delete All Comments in A Workbook at Once:

Shorts

Excel 10 tutorial
• 9 months ago
10. Rate my channel! On a scale from 1 to 5, how much do you love hanging out with me here?
34 votes
Vote now
34 votes
⭐ (Meh, it’s okay. 🤷)
⭐⭐
⭐⭐⭐
⭐⭐⭐⭐
⭐⭐⭐⭐⭐ (LOVE IT! It’s like Excel therapy. 🧘‍♂️)
3
4
Excel 10 tutorial
• 9 months ago
9. Would you be into more advanced topics, like combining Excel with Power BI or SQL? 💻
30 votes
Vote now
30 votes
Yes, I’m ready to go advanced and take over the world! 🌍
Nope, let’s keep it Excel-focused. Spreadsheet life is enough 🧘‍
2
2
Excel 10 tutorial
• 9 months ago
8. What kind of Excel content makes you hit the “like” button without even thinking? 👍
30 votes
Vote now
30 votes
Solving tricky Excel problems (you’re welcome!) 🧩
Time-saving hacks that blow your mind 🤯
Budgeting or financial tracking tips (we gotta manage that 💵)
Productivity and workflow tips (because time is money!) 🕒
Other? Comment Please. (You tell me what you love to watch!) 🧐
Excel 10 tutorial
• 9 months ago
7. Do you prefer tutorials where I walk you through every step, or do you like seeing how it's done with real-world examples? 🛠️
23 votes
Vote now
23 votes
Step-by-step, like a pro hand-holding session 🖐️
Show me real-world examples, so I can apply them to my job 🔧
A mix of both (Why choose?!) 🔄
Suggestions? (Drop a comment! I’m all ears 👂)
1
Excel 10 tutorial
• 9 months ago
6. How long do you want to hang out with me on YouTube? 🎥
25 votes
Vote now
25 votes
0-5 minutes (Quick tips, please!) ⏲️
6-10 minutes (Just enough time for a coffee and a good tutorial)
20+ minutes (Give me the deep dive! I’m ready to learn) 🏊‍♂️
Video duration doesn't matter, full project in 1 video 📈💰📊
1
Excel 10 tutorial
• 9 months ago
5. If I could make ONE video that would change your life, it would be about…? 🌟
38 votes
Vote now
38 votes
Short, quick tips to boost my Excel game in 5 minutes ⚡
Deep-dive tutorials on the hardest Excel stuff (bring it on!) 🏋️
Real-world examples (how to use Excel to solve actual problem)📈
Excel hacks you didn’t know you needed but now can’t live without
Something else entirely? Leave a Comment, I’m curious! 🤓
4