CDATips

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

Life Cycle of a WordPress Website Edit

The cycle of WordPress editing

One of the biggest mistakes I see “newbies” make with WordPress is that they fail to observe all of the steps of a WordPress website edit. Just because it is easy to make changes to a WordPress site does not mean that you are ready to start making changes to it. In fact, that mindset… Keep Reading

Getting Started with a Local Server

Setting up a local server

If you’re a visual person like I am, being told that you need to setup a local server to get started with WordPress might sound intimidating. In fact, I’ve been told it can also make some people head for the hills, convinced that they can’t do this thing called WordPress. Luckily, setting up a local… Keep Reading

Create a New Notebook in OneNote

If you loved going back to school time as much as I did when you were a kid, then you are going to love Microsoft OneNote. Remember that feeling of picking out just the right notebook each year? Should I go 3-ring binder or spiral? Scooby-doo or Flintstones? (Okay, so I guess I’m dating myself… Keep Reading

WordPress from the very beginning

Puzzle-men-cropped

I am going to build a blog that contains individual articles about using WordPress, starting from the very beginning. It is the resource I always wanted as a graphic designer trying to become a web designer with WordPress. If you have any helpful thoughts about how I am putting this together, please feel free to… 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

Adding Action Buttons to a Form in Acrobat Pro

If you played along in previous posts then you’ve learned how to start with a form created in Microsoft Word, convert it to Adobe Acrobat PDF, and then recognize the fields so that people can use their computer to enter data in the form and then save the results. Those tips by themselves should save… Keep Reading

Why is Microsoft Word not saving changes I make to styles…

when I Save, Close and later Open a document. We’ve talked a lot about the power of styles in Microsoft Word in the last few weeks. They give you the ability to control the structure and the appearance of your document with just a few clicks. Today’s Tip, however, is about those times when your… Keep Reading

More free images for your pleasure

Free Images

Just because an image is available on Google Images or Bing Images, does not mean you have permission to use it. Not only is it a violation of copyright and trademark laws, it is also morally wrong. Luckily, there are dozens, if not hundreds of sites that offer free, high-quality images for you to download.… Keep Reading

Making a PDF Form that Allows Users to Save Data

If you don’t already know it, you’ll quickly run into a basic issue when making forms in Adobe Acrobat: you are using Adobe Acrobat Pro or Adobe Acrobat Pro DC, but most of your users are probably using Adobe Acrobat Reader. The difference is simple: the Pro version of the program costs money while the… Keep Reading