Tag: Excel

Excel Rules for Creating Formulas and Functions

There are lots of rules out there in the world, and we don’t always follow them. Most everyone I know has broken the speed limit at some point, and I hear some people are actually eating laundry detergent recently (ugh!). There are clearly marked speed limits on the side of every highway, and I trust there must be a label on the side of detergent boxes that says do not consume. But breaking those rules isn’t necessarily going to ruin …

Excel Rules for Creating Formulas and Functions Read More »

Tagged with: , ,

New Text Box Shortcut works in PowerPoint, Word and Excel

Many users feel condemned to using the mouse to hunt and peck through the Microsoft Ribbon. They just don’t know a better way! Today’s tip is going to drill down on one shortcut, how to add a new text box in Microsoft PowerPoint, Word or Excel using the keyboard. Once you have the program open and are ready to perform this technique, just press the Alt key and the letter N at the same time, then let go of those …

New Text Box Shortcut works in PowerPoint, Word and Excel Read More »

Tagged with: , , , , ,

Nested Functions and Formulas in Excel

Lots of Excel experts love to nest functions and formulas inside of each other. This is actually a great way to combine several calculations in one cell, but it can be downright confusing if you are looking at it without understanding the Orders of Operation. The most important mathematical symbols in Excel are the parentheses. Everything inside of parentheses happens first in any formula, and if there are parentheses inside of parentheses, then you always work from the innermost set …

Nested Functions and Formulas in Excel Read More »

Tagged with: , ,

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: , , , , , , , , , , , , , ,

Creating your first macro using visual basic

The computer is first and foremost a time-saving device. My husband was just telling me about how the railroads used armies of clerks to keep track of each box car and it’s contents “back in the day,” and how all of that labor was now being handled by a few desktop computers. Imagine Mr. Scrooge meets the Nutty Professor to get a visual. Advanced users of Microsoft Office products like Excel, PowerPoint and Word know that the easiest way to get …

Creating your first macro using visual basic Read More »

Tagged with: , , , ,

Accessibility Features in Office 2016 Strengthen

Features that make computer software accessible are often over-looked by mainstream bloggers because they don’t understand them. People who work with the disabled, and those who work for organizations that want to communicate with them, however, know that this is the place where we need to put our strongest efforts. Like most people, I hadn’t thought that much about accessibility until I started researching the topic for a class I was asked to write. The numbers were pretty astounding. Millions …

Accessibility Features in Office 2016 Strengthen Read More »

Tagged with: , , , ,