- Видео 195
- Просмотров 1 457 809
Career Solutions
США
Добавлен 20 май 2023
Career Solutions is a channel looking to provide scenarios you will come across in your career and demonstrate how to solve them utilizing tools you have available.
Excel Tips - For Autofitting Columns and Rows | Multiple Methods
Hey team,
In this video we cover multiple ways to autofit columns and rows in Excel.
Chapters:
0:00 Introduction
0:14 First Method | Using Cursor
0:44 Second Method | Keyboard Shortcuts
1:07 Third Method | Format Menu
Video on using VBA code to Autofit Column Width: ruclips.net/video/A8TYqvf05GU/видео.html
Video on using VBA code to Autofit Row Height: ruclips.net/video/vwQ7ebaZTmM/видео.html
In this video we cover multiple ways to autofit columns and rows in Excel.
Chapters:
0:00 Introduction
0:14 First Method | Using Cursor
0:44 Second Method | Keyboard Shortcuts
1:07 Third Method | Format Menu
Video on using VBA code to Autofit Column Width: ruclips.net/video/A8TYqvf05GU/видео.html
Video on using VBA code to Autofit Row Height: ruclips.net/video/vwQ7ebaZTmM/видео.html
Просмотров: 534
Видео
Excel Tips - Filling in Dates | Different Fill Types
Просмотров 420Месяц назад
Hey team, In this video we cover how to easily fill in a range of dates in Excel and show you how to utilize different fill options.
Excel Tips - Autofit Column Width | Apply to Specified Range Example
Просмотров 600Месяц назад
Hey team, In this video we cover how to set up your Excel files to autofit the column width to fit cell contents for both the whole spreadsheet and just a certain range. Chapters: 0:00 Introduction 0:17 Apply Autofit to Full Spreadsheet 0:43 Apply Autofit to Certain Range VBA Code examples Full spreadsheet: Cells.EntireColumn.AutoFit Selected Range: Set Rng = Range("A2:A10") Rng.EntireColumn.Au...
Excel Tips - TEXTSPLIT Function to Separate Strings with Multiple Delimiters into Columns and Rows
Просмотров 562Месяц назад
Hey team, This video covers the TEXTSPLIT function in detail with 5 unique examples. Text to Columns video: ruclips.net/video/6rVKY2Z19Fk/видео.html Chapters: 0:00 Introduction 0:45 Basic Example | One Delimiter 1:39 Multiple Delimiters 2:40 Unique Delimiters 4:02 Handling Missing Data 4:58 Split Data into Rows and Columns
Excel Tips - Display Image When Hovering Over A Cell
Просмотров 659Месяц назад
Hey team, In this video we cover how to set up a note in Excel that displays an image so that when you hover over the cell, the image appears.
Excel Tips - Calculating Average | 3 Easy Methods
Просмотров 3242 месяца назад
Hey team, In this video we cover three easy ways to calculate averages in Excel. Chapters: 0:00 Introduction 0:13 Average Function 0:25 Quick Analysis Tool 0:48 Status Bar Averages
Excel Tips - Calculating Percent of Total | Quick Analysis Shortcut
Просмотров 5912 месяца назад
Hey team, In this video we cover how to calculate the percent of total and share a few examples of how to do this in Excel. Chapters: 0:00 Introduction 0:13 Calculating Percent of Total 0:47 Quick Analysis Tool
Google Sheets - Dropdown Lists | Custom or From a Range | Selecting Colors
Просмотров 2822 месяца назад
Hey team, In this quick video we cover how to create dropdown lists in Google Sheets. Chapters: 0:00 Introduction 0:10 Custom Dropdown Lists 0:26 Dropdown List from Range | Colors
Excel Tips - Create Unlimited Folders Quickly | Choose Folder Names
Просмотров 9472 месяца назад
Hey team, In this quick video we cover how to create thousands of folders on your PC in moments using Excel.
Installing New Languages | Text or Speech to Text | Windows 11
Просмотров 2552 месяца назад
Hey team, In this video we cover how to add additional languages into Windows 11 for typing and speech to text.
Excel Tips - Create Email Hyperlinks that Dynamically Include Recipient, CC Line, Subject and Body
Просмотров 6392 месяца назад
Hey team, This video explains how to use the hyperlink function in Excel to create dynamic hyperlinks that can include who the email is going to, the CC line, subject line and the body of the email. Chapters: 0:00 Introduction 0:26 Email Hyperlink Basics 1:16 Adding a CC Line to the Email 2:00 Adding Subject Line 2:41 Adding Body to the Email 3:26 Creating Link to Email a Group
Google Sheets - GOOGLETRANSLATE Helps You Translate Text | Other Languages
Просмотров 2772 месяца назад
Hey team, In this video we cover how to use GOOGLETRANSLATE to translate text into different languages. Link to language codes for function: developers.google.com/admin-sdk/directory/v1/languages
Excel Tips - Autofit Row Height to Cell Contents | Auto Text Wrap | Apply to Specified Range Example
Просмотров 1,2 тыс.3 месяца назад
Hey team, In this video I show you how to autofit row height and text wrap using basic VBA for both the entire worksheet and only a certain range, if desired. Chapters: 0:00 Introduction 0:36 Autofit Row Height | Entire Workbook 1:06 Autofit Row Height | Specified Range VBA Code for applying autofit row height to entire worksheet: Cells.WrapText = True Cells.EntireRow.AutoFit VBA Code example f...
Google Sheets - IMPORTRANGE Function | Add or Combine Data
Просмотров 5813 месяца назад
Hey team, In this video we cover how to add or combine data in Google Sheets using the IMPORTRANGE function. Chapters: 0:00 Introduction 0:20 IMPORTRANGE Basics 2:05 Cleaning Up the Function 3:02 Importing Multiple Spreadsheets
Excel Tips - Text Search Box | Dynamic Filtering | One or Multiple Columns
Просмотров 5023 месяца назад
Hey team, This video will show you how to create a text search box in Excel that can dynamically filter one or multiple columns. Chapters: 0:00 Introduction 0:17 Filter Basics | One Column 1:30 Filter Advanced | Multiple Columns
Google Sheets - Freeze Columns and Rows
Просмотров 2863 месяца назад
Google Sheets - Freeze Columns and Rows
Excel Tips - INDEX And MATCH Functions | Simple and Complex Examples
Просмотров 5203 месяца назад
Excel Tips - INDEX And MATCH Functions | Simple and Complex Examples
Excel Tips - 10 Important Functions and Formulas
Просмотров 1 тыс.3 месяца назад
Excel Tips - 10 Important Functions and Formulas
Google Sheets - Dynamic Search Box Creation | One or Multiple Columns
Просмотров 6543 месяца назад
Google Sheets - Dynamic Search Box Creation | One or Multiple Columns
Excel Tips - Combine First and Last Names | Two Methods Shared
Просмотров 4583 месяца назад
Excel Tips - Combine First and Last Names | Two Methods Shared
Excel Tips - Restore Previous Save Files or Versions | Microsoft Applications
Просмотров 3943 месяца назад
Excel Tips - Restore Previous Save Files or Versions | Microsoft Applications
Excel Tips - Creating a Pie Chart in Excel | Formatting Tips and Tricks
Просмотров 3733 месяца назад
Excel Tips - Creating a Pie Chart in Excel | Formatting Tips and Tricks
Google Sheets - Find and Remove Duplicates
Просмотров 2824 месяца назад
Google Sheets - Find and Remove Duplicates
Excel Tips - Calculating Time Difference | Hours Worked
Просмотров 6214 месяца назад
Excel Tips - Calculating Time Difference | Hours Worked
Excel Tips - IF Function Explained | Multiple Examples | AND/OR Statements | Nested IF Function
Просмотров 6904 месяца назад
Excel Tips - IF Function Explained | Multiple Examples | AND/OR Statements | Nested IF Function
Excel Tips - Remove Blank Rows | 3 Methods Included
Просмотров 7994 месяца назад
Excel Tips - Remove Blank Rows | 3 Methods Included
Google Sheets - Checkboxes That Insert Current Date and Time
Просмотров 1,1 тыс.4 месяца назад
Google Sheets - Checkboxes That Insert Current Date and Time
Excel Tips - Unhide Columns | Ctrl + Shift + 0 Not Working | Windows 11
Просмотров 1 тыс.4 месяца назад
Excel Tips - Unhide Columns | Ctrl Shift 0 Not Working | Windows 11
Excel Tips - Find and Unhide All Rows and Columns
Просмотров 5114 месяца назад
Excel Tips - Find and Unhide All Rows and Columns
Excel Tips - Progress Bars That Dynamically Update | Easy
Просмотров 6914 месяца назад
Excel Tips - Progress Bars That Dynamically Update | Easy
Good one, thank you for sharing!👌
Thank you so much!
Hi career solution, can you please make a video on how dropdown list will have their values automatically updated in next row? Thanks for this video.
@@harkaacharya8157 Hey there, thank you for the comment. Help me understand fully what you are looking for. Do you mean dependent dropdowns that update based in your first selection?
How about we do like this? ((90000/60000) - 1 ) * 100
@@adwayduttagupta9887 Thank you for the comment =)
Thank you so much it is a game changer for me!
Thank you as well =)
When I use this it doesn't allow me to fill a cell with a color if I need to. Is there a fix?
Hey there, do you have the fill tab in the formatting dialogue box?
Hi I see you didn't answer me anything. Do you think you can help me or not? If you don't know, it's no problem, I'll keep looking. Thank you
Hey there, apologies for the delay. I don't yet have a way set up to share files. Sorry I cannot help more but not sure I would be able to offer a good solution without fully understanding. I am trying to remedy the data transfer issue and hope to have something set up soon. Wish you all the best.
@@CareerSolutionsforToday Ok.When I want to create a simple table. I select some cells, then Insert, then Table, and something appears below that says Create Table. And you can directly give Ok or you can select the box where it says "My table has headers". But even though I don't want to select "My table has headers" and I don't give that, I just give Ok, it appears with "My table has headers". What can I do to stop this from happening, to stop appearing with "headers"?
@@forestdamian5601 Hello and thanks for this, I think I totally understand now. Did the option of selecting "Header Row" on the Table Design tab not help? That is how I can remove the header row if not needed. Let me know =)
@@CareerSolutionsforToday That's what I tried, it didn't work. It's probably something memorized
@@forestdamian5601 Oh I am sorry to hear that. Not sure why it would force the headers if you deselect them. I hope you find the answer you need.
This was more than useful dude🎉hats off👌
Thank you so much!
Howdy. I have a problem and I don't know what to do. Now tables with headers appear automatically when I click on tables and ok, although I don't want them to appear with headers. What can I do? do you think you can help me? Thank you
Hello, I would be happy to try and help. I am not 100% sure I fully understand the question, but if you go to the Table Design tab in Excel with the table selected, and then click on the checkbox for header row, it removes the header formatting. Let me know if this helps, or if you were wondering about something else.
@@CareerSolutionsforToday I could send you some pictures so you can understand exactly what it is about. But how to send them to you? Thank you
@@CareerSolutionsforToday I made a short video of a few seconds. I can send it to you if you want. But how, where?
How would you do this on Excel in sharepoint? There isn't a "view code" option when right clicking the tab.
Hey there and thank you for the comment. So you cannot create or edit macros in Excel online but you can create macros in the app version and then transfer them.
Useful
Thank you!
Ok, thanks but how i leave the insider mood
Hey there, you can use the same menu you used to enter to exit the program if you'd like =)
Good Advanced Excel Channel ruclips.net/video/yqK0bQZGOME/видео.htmlsi=Dph6hJKOaYRCU-_k
Thanks I understand this more better now
Thank you so much!
It will not allow me to complete this on a shared sheet. Why?
Hey there, sorry to hear that, not sure why it wouldn't work on a shared sheet. Are you able to add a note at all?
I'm still using 2016, the option is Get External Data>From Web, then New Web Query pops up with all kind of AVG Secure search on the top and next to URL address 'enhanced by Yahoo. Did not work.
Holly shot, why hidden?
What do you mean by hidden?
Please lets say i want to get the index of candy type of sour 210 how do u go about it. Thats trying to find the label area of the values. Its like the other way round this time
Hey there, so in your example based on the video are you wanting to replace the candy store dropdown with a sales figure? Apologies if I am a bit lost, trying to make sure I understand your question.
@@CareerSolutionsforTodayokay thanks for your response. So I want a situation where if I choose taffy, with 180 I'll get the answer of candy baron. Like I want to get the value of the label area if I'm giving the type and amount or quantity.
@@amandakennedy6895 Hey there, so to find the solution you are looking for with this same table, you would switch cell C3 to candy type "taffy" and switch cell C4 to number sold "210". Then in cell C5 you can enter the function: =INDEX(B7:D7, MATCH(C4, INDEX(B8:D11, MATCH(C3,A8:A11, 0), 0), 0)) And this will return the candy store name based on sales and candy type. Let me know if this helps.
Thank you so much! As I get a little older, it's hard for me to see what row I'm in when I'm in a cell really far on the right side of the spreadsheet.
Thank you so much for the comment =)
Thanks!
Thank you!
Great video, thank you!!
Thank you so much as well =)
Clear and concise. Thank you.
Thank you as well!
How to change color hire area
Hey there, the background is just based on my Excel theme and that is how you can change it, by adjusting the theme. Let me know if this helps =)
Is it work in any particular Excel format or any format can work..what main file & source file should be same?
I wish there was a way to change the default fill method. Auto increment by one is rarely what I need.
Hey there, hold down the Ctrl key while you drag and this will stop/change the auto-increment method. Let me know if this helps.
Hi Thanks for the amazing tutorial but is it also possible to hide the grey area or center the excel sheet?
It did not work whatsoever
Hey there, I have a video on my channel for when this doesn't work as well. Check here: ruclips.net/video/JpMyIZxHAS0/видео.html
Is this video explained how to do it with adding code or not?
Can i do it without coding?
This is lowkey gold, Thank you!
Thank you!
The Target.Calculate is a vba code from Excel?
It is VBA code yes =) Let me know if this helps.
Thank you! You’re my memory when it comes to remembering useful stuff in Excel
Thank you so much!
When I right clock the sheet. View code is not an option
@@pauljohnson8921 Are you using the application version of Excel or the web version?
Thank you, these little tips are really useful. Please keep them coming.
@@stephenrowland5436 Thank you so much!
Not trying to type a formula? When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula: • you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: • you type: '=1+1, cell shows: =1+1 thisis the messeg I got when I use this formula every time
Thank you!❤
Thank you as well =)
Thank you ❤
Thank you again!
Holy smokes. Never knew this existed and I have been using Excel for 20 years. Awesome video. Thanks. 😊
Thanks so much!
Thank you! This saved me sooo much time
Thank you so much for the comment =)
I took time to read the comments and I must commend you for engaging all the comments with a response. Thank you. However I will like to reiterate "the problem with Copy paste data from one cell to another) Have you found the solution?
Hey there, sorry for my delay. Still haven't found the reason or workaround for this. I will let you know if I uncover anything. I hope you have a great weekend =)
Sir how do we reverse it?
@@RH7777 Just remove the VBA code and conditional formatting and it will be removed.
Amazing video, thanks as always!
@@Shelby.Correia Thank you as always =)
Thank you! 🫶
@@ciaratobin Thank you so much as well!
Super helpful thank you 🫡
@@Shelby.Correia Thank you =)
it works. thanks.
@@shahnawazabbasi6911 Thank you so much as well =)
Good
@@khalidbaacha Thanks!
Sir I wanted to thank you for this quick and efficient video! I truly appreciate you so much for this!
Thank you as well =)
What a time saver! Thank you for sharing this great insight!!!
@@oliverphotography1 Really appreciate the comment =)
While not as much *fun* as functions 'n' formulas, I have always *loved* CTL+E's magical instant-ness!
Wow. 🎉
Thank you =)
Great feature, but I cannot edit VB in Excel for Mac, do you have a solution? the is the VB error "Variable uses an Automation type not supported in Visual Basic"