How Can I Remove Spaces in Excel?

Many times, data is entered into Excel workbooks with spaces. These unwanted spaces might be at the beginning of the data or at the end, or even sometimes in between strings. These spaces can cause issues when you try to analyse the data and create reports out of it. My Excel classes will help you figure out the best ways to remove unwanted spaces in your data or data strings. Read the Excel [...]

2018-06-18T14:37:14+00:00 Excel Classes|

How Can I Password Protect My Important Excel Files?

Excel workbooks might contain sensitive information like bank account numbers, employee addresses, social security numbers, critical weekly reports a or company’s financial reports. My online Excel classes will not only teach you how to create these spreadsheets, but also how to protect them in the Excel tutorial below. In this article, you will learn to password protect an Excel file. This can be achieved by using the native GUI method or a macro. [...]

2018-06-18T14:37:39+00:00 Excel Classes|

What if I Need to Highlight Every Other Row in Excel?

You will commonly find it in good practice to highlight every other row in Excel. It is a common practice for better aesthetics. It’s more of a visual trick to improve readability so that when one scans through some data, it can prevent them from getting lost. My beginner Excel classes teach the benefits of this, as well as how to apply it to your own spreadsheets. Sure, you can sit there and [...]

2018-06-18T14:41:40+00:00 Excel Classes|