Go Ask Debbie BLOG

Smart Art is not only offered in Excel, but other Microsoft Office programs, so you can use this tutorial for Word Smart Art and PowerPoint Smart Art as well. To Insert Smart Art, follow these steps: 1. Select the Insert tab from the Ribbon. 2. Select SmartArt. 3. In the Choose a SmartArt Graphic dialog box, select the category on the left. Then you select the item in the middle. The right shows a preview of the item. Select OK to insert the content. Excel inserts the selecte

I've had so many people over the years ask, "I have data in a text file, but need to put it into Excel to analyze the data and get reporting in a workable format, but don't know how." And the answer is actually so simple, I love showing people the 2 different ways you can get text into columns using Excel. Using the Text to Columns Feature To convert text to columns, follow these steps. 1. Paste text from another application. 2. Select the text. 3. Select the Data tab from th

Since Excel 2013, removing duplicates has now become such an easy task, I wanted to share it with you. So, when would you need to remove duplicates? Many times over the years, Sales Managers and Data Analysts have come to me to ask questions like this: "How can I see the types of widgets my sales people are selling?" If the list is not from a drop-down list, but someone is just typing information into cells, remove duplicates is a great way for a Sales Manager to get their an