Tutor profile: Jay M.
Subject: Microsoft Excel
I have a text file containing the first and last names of my customers and their billing addresses. The data is a bit of a mess. I need to clean it up. So I decide to import this data into an Excel worksheet, then convert the text to columns, followed by removing any duplicates. How would I do this?
1. Either copy/paste the text into a worksheet or use the Get Data tool. 2. Using the Text to Columns I would covert the first/last/addresses into columns. This will make filtering and sorting the data possible. 3. I would use the Remove Duplicates feature to remove any duplicate entries. I've successfully taken raw data and turned it into usable information that can be sorted, filtered, conditioned, exported, etc.
How do I deal with writer's block when drafting a new document for a client?
I look for inspiration in what others have done. I'll read other documents, articles, blog posts, etc., and formulate a plan to move the project forward.
Why would any person choose the path of entrepreneurship, specifically as a business owner, and all the stress, risks, and uncertainties that are sure to be part of the journey? Why not just let someone else, an employer, assume these burdens.
The simple answer. Fear. Fear of failing. Fear of taking a risk. Fear of the unknown. For me, the thought of looking back on my life and not taking a chance on something I was passionate about was a greater fear than of failing, of the risks, or the unknowns. Fear is a great motivator and it was fear that pushed me to plan, to execute, and, ultimately, to succeed.
needs and Jay will reply soon.