Software Archives - The Silicon Underground

Home » Software

How to accept all changes in Word

Dave Farquhar Office, Software July 15, 2018July 29, 2018markup, microsoft, microsoft word, ribbon 0 Comment

Every couple of months or so, we have to collaborate at work on a Microsoft Word document and submit it without all the distracting markup in it. And it seems like it always takes four of us half an hour to re-figure out how to accept all changes in Word and remove the comments. This applies to Word 2007 and all newer versions.

Sometimes I also find the tracked changes and other markup causes weird problems, and the fastest way to make them go away is to get rid of the markup.

So I figured it might help someone. This is something that either takes you 30 seconds or 30 minutes. If you don’t do this every day, it’s likely to take too long. This is for those of you who can’t do it in less than 30 minutes.
Read more

How to create a stacked bar chart in Excel

Dave Farquhar Office, Software July 15, 2018July 29, 2018Add Data Labels, Click Number, excel, Format Axis, Format Cells, microsoft, Painting, Plumbing, ribbon, sprint 0 Comment

My boss’ management is clamoring for metrics. They want to know, at a glance, what we’re doing and how far along we are. Sounds like a job for stacked bar charts in Excel to me. So here’s how to create a stacked bar chart in Excel.

Figuring out a way to track our progress was fairly easy. Figuring out how to make Excel display that chart in a meaningful fashion… Well, that took about five hours. I’ll try to make it easier for you than it was for me.
Read more

What does compressing a file do?

Dave Farquhar Retro Computing, Software June 11, 2018May 27, 2018 0 Comment

What does compressing a file do? There are several ways to describe it, from eliminating redundancy, to just thinking of it as digital shorthand. The goal is to make the file take up less space on disk and in transit. How it works is a bit more complicated.

What is a bot in computer terms?

Dave Farquhar Software May 21, 2018May 19, 2018 0 Comment

You hear the word “bot” thrown around a lot today. It’s in conversations, on the news, and even in stand-up comedians’ routines. So everyone assumes you know what it means. But what is a bot in computer terms?

Don’t be afraid to ask. I’ll explain it.

Zero client vs thin client

Dave Farquhar Software May 2, 2018August 12, 2018 3 Comments

Zero clients and thin clients are two ways companies deal with the problem of sprawling computer infrastructure its associated costs. Instead of putting an expensive computer on every desk, you put something small and cheap on every desk and share that expensive computer. Let’s look at zero client vs thin client, and the advantages and disadvantages of each.

What is public cloud?

Dave Farquhar Software April 12, 2018April 11, 2018 0 Comment

Cloud computing is all the rage right now, and it’s created a mess of jargon that can make your head spin. Don’t worry though. No one was born knowing this stuff. So, what is public cloud, and what makes it different from other clouds? Assuming there are other clouds?

Public cloud is a booming business. In Q4 of 2017, Amazon’s cloud business accounted for 60 percent of the company’s total operating income. Amazon made its name selling books, but today it makes its money renting computer time. A lot of people don’t know that. Or at least it seems that way.

What is machine language?

Dave Farquhar Software April 3, 2018April 2, 2018 0 Comment

From time to time you may find a reference to something mysterious and computer-related called machine language. Most people just assume you know what it means, if you care. But what is machine language in computer terminology, and why is it important?

Who still uses Wordperfect?

Dave Farquhar Software July 7, 2017August 16, 2018budget, desktop support, excel, keyboard shortcuts, menus, microsoft, Microsoft Office, microsoft word, office 2007, ribbon, troubleshooting 4 Comments

I had an odd question come up the other day: Who still uses Wordperfect? It’s a fair question. Wordperfect, as you may know, is still very much in production. Corel releases new versions every year or two. It’s the #2 word processor in the market, still. Someone is still using it, then.

Wordperfect is a software classic, especially the old version 5.1 that ran under DOS. For a time, Wordperfect 5.1 was one of the two most famous programs for IBM compatible PCs. The other was Lotus 1-2-3.

Why is Publisher hyphenating my words?

Dave Farquhar Office, Software April 12, 2017April 9, 20171990s, early 1990s, journalism, Justification, microsoft, Publishing, ribbon 0 Comment

Why is Publisher hyphenating my words? That’s probably one of the most common questions I hear about Microsoft Publisher. There’s a good reason for it, but I understand if you want to disable it. So I’ll answer both questions.

Find capitalized words in Libreoffice or Openoffice

Dave Farquhar Software January 4, 2017November 26, 2016capitalization, lowercase letters 0 Comment

Sometimes you need a way to find capitalized words in Libreoffice or Openoffice. This can make it easier to figure out if the word needed to be capitalized, in the case of a poorly written or edited document. Then you can make a decision whether the capitalization was appropriate.

Another time you would need to find capitalized words in Openoffice or Libreoffice would be when you’re creating an index. I’m sure there are others.

It’s easier than it sounds.
Read more

← Previous