- Видео 238
- Просмотров 2 173 876
Simple Software Tutorials
США
Добавлен 25 май 2013
Learn what you came here to learn in just a few minutes. I skip straight to the point so you can quickly learn and complete what you came here to do.
Please note - I work full time for a software company and do not do contract work. I will do my best to assist with any questions posted in the comments, but I may not always be able to assist in more complex requests.
For quick assistance with Microsoft software, check out Microsoft Tech Communities at: techcommunity.microsoft.com/t5/Communities/ct-p/communities
Please note - I work full time for a software company and do not do contract work. I will do my best to assist with any questions posted in the comments, but I may not always be able to assist in more complex requests.
For quick assistance with Microsoft software, check out Microsoft Tech Communities at: techcommunity.microsoft.com/t5/Communities/ct-p/communities
How to Align Your Taskbar to the Left in Windows 11
Windows 11 places the default location of your taskbar in the center. Luckily, there's an easy fix to move it back to the left, for those of us who have been accustomed to having it there.
In this video, I walk you through accessing your taskbar settings by right-clicking on the taskbar, and changing the alignment in the taskbar behavior section.
Don't forget to subscribe to my channel for more tutorials!
Check out my website at simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in!
In this video, I walk you through accessing your taskbar settings by right-clicking on the taskbar, and changing the alignment in the taskbar behavior section.
Don't forget to subscribe to my channel for more tutorials!
Check out my website at simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in!
Просмотров: 468
Видео
How to Hide or Unhide the Meet Now Icon in Windows 10
Просмотров 1,7 тыс.3 года назад
In this video, I show you how to hide and unhide the Meet Now icon in Windows 10. Sorry if this is super obvious, but I thought it might be helpful to some users. These instructions as well as instructions to remove Skype are below. The easiest way is to just right-click on the icon and click "hide". (starts around 0:35) Not sure if that will keep it permanently hidden, but it stayed hidden for...
How to Delete a Pattern of Rows in Excel
Просмотров 4,3 тыс.3 года назад
In this video, I show you how to delete a pattern of rows in Excel. This was a request in the Microsoft Tech Community (techcommunity.microsoft.com/) asking how to automate deleting 3 rows after every 2 rows. This was my solution. -Add a column to designate which rows to keep or delete -Enter "keep" or "delete" in the pattern you want down the column next to the rows you want to keep or delete ...
How to Create Mailing Labels in Word From an Excel List
Просмотров 170 тыс.3 года назад
In this video, I show you how to create mailing labels in Word from an Excel list with the option to format parts of the address, such as making the name bold or a larger font. I've also detailed the steps below: -Format your addresses in Excel including column headers at the top of each column of data (i.e. first name, last name, company, address, etc) and ensure zip codes are formatted correc...
How to Print Just the Outline of Text In Microsoft Word
Просмотров 19 тыс.3 года назад
In this video, I show you how to print just the outline of text in a Microsoft Word document by setting an outline color and changing the font color to white. You can also bold the text or increase the weight of the outline to make the outline a bit bolder. -Highlight the text you want to change -On the Home tab in the font section, click on the "text effects and typography" icon - it's the blu...
2 Ways to Create a Dropdown List in Excel
Просмотров 3613 года назад
In this video, I show you two ways to create a dropdown list in Excel. Both methods use the data validation tool on the data tab and we select "list" from the allow field. In the first method, we enter each item we want on the dropdown list in the source field, separated by a comma (spaces are not required, but may make it easier to read). In the second method, we create the list on another she...
How to Manage Prospects or Leads in Excel
Просмотров 20 тыс.3 года назад
In this video, I show you a handy way to manage prospects or leads in Excel, with dropdown lists and filters so you can efficiently work your prospects! Steps: -Add a "Contacted" column to track contacted prospects with an optional yes/no dropdown using data validation -Add a "Date of Contact" column to note date of contact & format for dates -Add a "Results" dropdown to track contact results u...
How to Show the Developer Tab in Excel
Просмотров 3 тыс.3 года назад
In this video, I show you how to add the developer tab in Excel. Steps: -Click on File -Click on Options -Click on Customize Ribbon -Under Main Tabs, check the box next to Developer -Click OK Don't forget to subscribe to my channel for more tutorials! Check out my website at simplesoftwaretutorials.com Video recorded using Screencast-O-Matic (www.screencast-o-matic.com) Thanks for tuning in!
4 Ways to Combine Names or Text in Excel
Просмотров 2,9 тыс.3 года назад
In this video, I show you 4 simple ways to combine first and last names or other separated text. Enter first names in column A & last names in column B Method 1: CONCAT (starting at 0:10) · Click in cell C2 & select CONCAT function · Text 1 = A2, Text 2 = " ", Text 3 = B2 · Formula: =CONCAT(A2," ",B2) Method 2: CONCAT Range (starting at 1:45) · Insert a column of spaces (insert a column between...
2 Easy Ways to Separate First & Last Names in Excel
Просмотров 2,3 тыс.3 года назад
In this video, I show you two easy ways to separate first and last names (or other similar data) in Excel, using flash fill and text to columns. Enter list of names in column A Method 1: Flash Fill · Type first name from A1 into B1 and last name into C1 · Click in cell B2 and click Data tab - Flash Fill · Click in cell C2 and click Data tab - Flash Fill Method 2: Text to Columns · Select column...
How to Display a Zero at the Beginning of a Number in Excel
Просмотров 1563 года назад
In this video, I show you a few different ways to display a zero at the beginning of a number. The example I show is for zip codes, but my methods can be adapted to fit other scenarios. These methods work best if the numbers are all the same format and length (i.e. zip codes or international phone numbers), not a combination of different types/lengths of numbers. Method 1: Format Cells - Number...
How to Randomize a List in Excel
Просмотров 2,9 тыс.3 года назад
In this video, I show you how to randomize a list in a column in Excel. For this example, I entered my list in column A, then used the RANDBETWEEN function to generate random numbers in column B. I then sorted columns A & B in ascending order by column B to randomize the contents in column A. The formula I used was =RANDBETWEEN(1,1000) Don't forget to subscribe to my channel for more tutorials!...
How to Create a Cryptogram in Excel
Просмотров 2,4 тыс.3 года назад
In this video, I show you how to create your own cryptogram/cipher in Excel using multiple functions. We start by breaking down strings of text into individual columns, creating a randomized key then using VLOOKUP to translate your text. This also provides the option of creating multiple versions with different keys to discourage answer sharing if giving this to a group. Below is an overview & ...
How to Lock, Hide & Protect Content in Excel
Просмотров 5 тыс.3 года назад
In this video, I show you how to lock, hide (formulas) and protect Excel worksheets and workbooks. You can also password protect your settings, but make sure to take note of the password and store it in a secure place in case you forget the password as passwords cannot be recovered if forgotten. Select cells to lock/unlock/hide (formulas). Right click - Format Cells - Protection Tab & choose se...
How to Split a String of Text Into Individual Rows in Excel
Просмотров 3,7 тыс.3 года назад
In this video, I show you how to easily split a string of text into individual rows in Excel using MID & ROWS functions. Enter text in cell A1. Paste this formula starting from A2 in each cell down until all text is separated into individual rows: =MID(A$1, ROWS($A$1:$A1), 1) To split a string of text across into individual columns, check out this video: ruclips.net/video/ZuNJZUVZzaU/видео.html...
2 Ways to Split a String of Text Into Individual Columns in Excel
Просмотров 1,8 тыс.3 года назад
2 Ways to Split a String of Text Into Individual Columns in Excel
How to Remove Spaces to the Left of a Text String in Excel
Просмотров 5603 года назад
How to Remove Spaces to the Left of a Text String in Excel
How to Remove Spaces to the Left of a Text String in Excel + Fixing Non-Breaking Spaces
Просмотров 1733 года назад
How to Remove Spaces to the Left of a Text String in Excel Fixing Non-Breaking Spaces
How to Solve a Cryptogram Using Excel & VLOOKUP
Просмотров 1,4 тыс.3 года назад
How to Solve a Cryptogram Using Excel & VLOOKUP
Solving a Fraction Story Problem with Excel Pizza Party Problem
Просмотров 1293 года назад
Solving a Fraction Story Problem with Excel Pizza Party Problem
Solving a Fraction Story Problem with Excel (Ice Cream Party Problem)
Просмотров 883 года назад
Solving a Fraction Story Problem with Excel (Ice Cream Party Problem)
How to Make Columns in Microsoft Word
Просмотров 6 тыс.3 года назад
How to Make Columns in Microsoft Word
How to Create a Portfolio Cover in InDesign (Adobe InDesign 2020)
Просмотров 3,3 тыс.4 года назад
How to Create a Portfolio Cover in InDesign (Adobe InDesign 2020)
How to Create a Basic Resume in Microsoft Word
Просмотров 1494 года назад
How to Create a Basic Resume in Microsoft Word
How to Use Resume Assistant in Word to Create a Great Resume
Просмотров 3,6 тыс.4 года назад
How to Use Resume Assistant in Word to Create a Great Resume
How to Create a Resume Using Free Templates in Microsoft Word
Просмотров 384 года назад
How to Create a Resume Using Free Templates in Microsoft Word
How to Add a Header and Footer to a Word Document
Просмотров 494 года назад
How to Add a Header and Footer to a Word Document
How to Add Artboards for Different Devices in Adobe XD
Просмотров 1,6 тыс.4 года назад
How to Add Artboards for Different Devices in Adobe XD
this video sounds so aestetic idk why
thnaks
Wow! Fantastic tutorial. That's exactly what I needed, thank you.
A big thank you, just small hint, you may double click the black cursor instead of drag it, greetings and thanks again 🌹
Thank your video help a lot!
Thank you so much!
I am looking to move my task bar VERTICALY on the left side of the screen. Can you help ?
How to align an object to selection like in Illustrator?
This was the best tutorial and helped me immediately!!thank you
Nice way to explain, easy to understand thank you
Thank Youuuuu!!!
Straight and to the point. Thanks.
Thanks for the video instructions!
Super helpful, thanks!
So easy to follow. Great job and thank you so much!
What if I need to exclude some of the names/addresses that are in my Excel spreadsheet for labels? For example, if I have 123 names and addresses, but I only want to print labels for a specific 75 of them...
You taught me so much in such a short time! Thank you! Excellent tutorial!
In Excel, you have 6 columns of actual addressee data. But you are presenting 21 extra columns, all vacant. So that an old curmudgeon like me doesn't try to view this with his nose 4 inches from the screen, next time would you go the bottom right, magnify the data to 150 - 200 %, and make it a little easier for this old goat? Thanks.
Thank you 🙏
Great!. It helped me
THANK YOU
Thank you - wish I had found you two hours and 4 other instructions ago!!!! Eve
I watched 3 other videos before finding this one. It's exactly what I needed! Thank you!
Thanks so much for posting. I forget how to do this every Holiday (and then the software changes anyway). This was easy and fast. Thank you! (And happy holidays!)
I have a cryptogram code. I could not resolve it. I need your help
Thank you so much! Very helpful! I knew there was a way to do this. WAY back when before they changed everything like late 90's early 00' I had this down...now I swear I have to look it up every time.
Holy cow, this is the 5TH video I've watched on this and I FINALLY got it. THANK YOU! You did an excellent job of explaining this. I never leave comments on videos but here I am! Thanks again and happy holidays!
SUPER easy to follow tutorial! Thank you!!!
This was fantastic! I have tried before without success, but you walked me through it! Thank you!!!
THANK YOU!
Hurray! Well done. I do this every year and have always looked at the Microsoft instructions. I would never get it right! This was SOOOO much better. Thank you!
Thanks so much! My daughter wanted a puzzle like this and helped me create it much faster. The tutorial was very easy to follow.
Could not have done it without You.... So grateful.
Excellent and very helpful!
this helped so much
Great video.. I always center my labels and sometimes need to move label up or down a little to fit in the label. How do I do that? Thanks
I used to have to take a Xanax before doing my annual huge mail merge for work purposes, it was that stressful. Now I just go to this video, watch as a refresher, and get to it. THANK YOU.
EXCELLENT WORK , I NEED THIS , I WAS SEARCHING THIS CONTENT IT IS REALLY HELPFUL THANKS
thanks so much
Literally drove me crazy...in 2023. Thank you so much! God bless you!
This does not work for a thick black line under a picture.
Thank You
Thanks a million. May God bless you always. Love from Malaysia
Great video!
Thank you so so much - simple yet effective!
GREAT TUTORIAL IF ONLY I WATCHED THIS A FEW WEEKS AGO LOL BUT WILL USE MOVING FORWADS THANKS
thankyou mam exactly what i was looking for! may god bless u with unmatched love!
thank you so much! very easy to follow, I will be saving this for the future!!
Your video was spot on. I had done this before and I needed a refresher. As soon as I heard your voice and teaching style, I knew your channel was for me. I am going to subscribe and I look forward to viewing more videos. Many thanks.
Thank you so much! This just made my English project where I have multiple documents open at once much less painful!