by Susan Mangina | Dec 1, 2021 | Educational Resources, Microsoft, Microsoft Excel, MS Office Tips and Tricks, Productivity
Microsoft Excel is often used to store data including, personal information like names, addresses, contact numbers, etc. There are times when a spreadsheet contains a column of full names, and I need to split the first and last names into separate columns. In this...
by Susan Mangina | Dec 1, 2021 | Educational Resources, Microsoft Excel, MS Office Tips and Tricks, Productivity, Tech Tips for Business Owners
Lets say you have a table in Excel and you want to combine two columns, row-by-row, into one. For example, you want to merge the First Name & Last Name columns into one, or join several columns such as Street, City, Zip, State into a single “Address”...
by Susan Mangina | Nov 9, 2021 | Microsoft, Microsoft Excel, Productivity
Tracking changes on your Excel spreadsheets makes it easier for other people to update or review your file. It also comes in handy when you want to keep track of all the changes made to it. The track changes command is easy to find in the Review tab of Microsoft...
by Susan Mangina | Jul 1, 2021 | Microsoft, Microsoft Excel, Productivity
Adjusting dates on a spreadsheet can be cumbersome. Rather than digging out your calendar to count days or months, you can adjust dates right in Microsoft Excel with simple addition or subtraction. Whether it’s a project schedule with deadlines, a budget with due...
by Susan Mangina | Jun 3, 2021 | Microsoft, Microsoft Excel, Productivity
Drop down lists can greatly facilitate data entry. Here’s a look at how to use Microsoft Excel’s data validation feature to create handy lists within your worksheets. An Excel drop down list or dropdown menu can make it easier for the average Microsoft...
