Tag: Excel 2016

Concatenate(): Your $10 Excel Function of the Day

You may have already read my previous post on how to string text together in Excel. That technique has been around forever, but it is so… 1995. Modern Excel users know that there is a very powerful function built into Excel that makes stringing text together as simple as 1-2-3. Before we get started, let’s review a few salient points: You can’t use math to add columns of text together; and Whenever you are combining columns of text you will …

Concatenate(): Your $10 Excel Function of the Day Read More »

Tagged with: , , , , ,

Stringing Text Together in Microsoft Excel

I showed you how to break text in one column into multiple columns using the Text to Columns tool in a previous Tip, but today I’m going to show you how to string text together. In other words, same problem, just going in a different direction. You can’t add words together… As you can see, I’ve got a list of first names in Column A and last names in Column B. You might be inclined to write a formula that …

Stringing Text Together in Microsoft Excel Read More »

Tagged with: , , , , , ,

Text to Columns in Microsoft Excel

The need to break one column into multiple columns is one that every Excel user needs upon occasion. In the accompanying example, you can see that both the first and the last names are combined into one column. If I was handed this worksheet, the first thing I would want to do is break the two names into separate columns. Back in “days of yore” this would entail hours of Cutting and Pasting. Thanks to a feature in Excel called …

Text to Columns in Microsoft Excel Read More »

Tagged with: , , , , ,

Why things don’t always add up in Excel

Number formatting is a great way to change the appearance of a number, including the number of decimal places of accuracy, but it can also yield some strange results. If you’ve ever had the experience of puzzling over a column of numbers that AutoSum can’t seem to add up, or perhaps you’ve got percentages of a whole that add up to more than 100%, then this article is for you! Number Formatting Number Formatting is a quick and easy way …

Why things don’t always add up in Excel Read More »

Tagged with: , , , , ,

The More Button in Microsoft Office

There are a lot of “hidden secrets” in Microsoft Office that are actually sitting there right out in the open. A little bit of curiosity will go a long way toward making you into a Microsoft Power User. One of my favorites is the More button. The More button is ubiquitous throughout Microsoft Office, and appears often in the Ribbon when there is more information to be shared than will fit on your display. The More button is best described …

The More Button in Microsoft Office Read More »

Tagged with: , , , , , , , , , , , , , ,

Asking Users for Data using a VBA Input Box

If you are getting started working with Macros in Microsoft Office, there will be plenty of times when you want to ask a user for information. An Excel purchase log might ask how many widgets were ordered, or a Word time card might ask for a user’s name. Whatever information you want to request, the most common method of getting it is via an Input Box. I’m going to create a macro in an Excel document for this example, but …

Asking Users for Data using a VBA Input Box Read More »

Tagged with: , , , , ,

Excel: Fill Right and Fill Down Keyboard Shortcuts

There are several ways that Excel can help you with formulas and functions, and a great one is the Fill Down and the Fill Right commands. Essentially, if you’ve gotten the formula correct one time, let Excel do the work for you of copy and pasting it into the other cells. The technique is really simple Select the starting cell that has your correct formula in it. Hold down the Shift key and click on the last cell you want …

Excel: Fill Right and Fill Down Keyboard Shortcuts Read More »

Tagged with: , , ,

The Go-To Keyboard Shortcut: Jumping Around in Excel and Word

There are several great tools that will help you jump around in Excel and Word without having to use the mouse. These tools are called Command Shortcuts by Microsoft, but most everyone else knows them as Keyboard Shortcuts. The key to using shortcuts is to be willing to experiment! If you want to do something with the keyboard, try holding down the Ctrl key and typing the first letter of whatever it is you want to do. You can see …

The Go-To Keyboard Shortcut: Jumping Around in Excel and Word Read More »

Tagged with: , , , , ,

Excel 2016 offers Business Intelligence… built in

New chart types in Office 2016 Charts are critical for visualizing data, and Office 2016 promises you three news to look at your information. Microsoft promises that they are “particularly good for visualizing financial or hierarchal information and for revealing statistical properties in your data.” Financial: Waterfall Statistical: Histogram, Pareto, Box and Whisker Hierarchical: Treemap and Sunburst Excel + Visio = Dashboard! Dashboards are one of the new “it” words in IT. (Get it?) Coming soon in Office 2016 you’ll …

Excel 2016 offers Business Intelligence… built in Read More »

Tagged with: , ,