Excel

Microsoft Excel started out with a simple concept: bring a paper spreadsheet into a desktop computer. Since its inception the program has broken all boundaries, brought complicated functions and formulas into the hands of non-mathematicians, and now handles data models like a 3-D database. It is the standard for all business software requirements, and you need to know these tips!

Accessible Links in Documents

Accessible Links

There are some easy-to-follow guidelines on creating accessible links in documents. If you’ve become accustomed to just pasting a URL into a Word document, these extra steps will make a world of difference for people using assistive technology. Creating Accessible Links It is always a best practice to create links in your authoring document. With… Keep Reading

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… Keep Reading

New Text Box Shortcut works in PowerPoint, Word and Excel

Keyboard Shortcut for New Text Box

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… Keep Reading

When Excel Columns become Numbers instead of Letters…

Using the R1C1 Cell Reference Style

aka Turning the R1C1 Address Option On and Off A client called me a while back with a terrifying problem: all of the column letters in Excel had become numbers and she had no idea how it got that way or how to write formulas anymore. Rest assured, it was not the beginning of the… Keep Reading

Password Protect Macros in Excel

Password Protect Macros

I confess that today’s tip was motivated by a student asking a question in a recent class. During a discussion about all of the different ways you can password protect a document, the question was asked about how to password protect just a macro. This technique will allow you to protect your macro code from… Keep Reading

Encrypt Excel with a Password

Excel Password Encryption

The most complete protection you can provide an Excel document is Password Encryption. It requires that someone have your password before they can open or view your workbook, and it is virtually bullet-proof. I’m not aware of any ways you can break into an encrypted Excel workbook, but I wouldn’t put it past some cyber-fiend… Keep Reading

Nested Functions and Formulas in Excel

Nested Functions 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.… Keep Reading

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

Learn how to use the concatenate() function in Excel

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… Keep Reading

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,… Keep Reading

Text to Columns in Microsoft Excel

Converting 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… Keep Reading