f-jeffdavis, Author at TechRepublic

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

f-jeffdavis

Latest from f-jeffdavis

Image: iStockphoto/Getty Images

Software

Transpose Excel data from rows to columns, or vice versa

When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task.

Microsoft

Three timesaving Ctrl-key tricks in Excel

Working with Excel data is a whole lot easier when you know a few shortcuts -- like these easy efficiency-boosting keyboard tricks.

Microsoft

Convert Excel calculations to literal values

Copying Excel data to a different location can send your calculations into a tailspin. Avoid problems by using Paste Special to copy values rather than formulas.

Software

Generate a list of unique entries in an Excel column

When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick walk-through shows how it's done.

CXO

Resist bad decisions that will waste your client’s money

If you're in a position where you believe a client's time and money is going to be wasted because of mismanagement or micromanagement by another consultant, Jeff Davis offers advice about what you should do.

Software

10 obscure Excel tricks that can expedite common chores

Some Excel users waste a lot of time (and add to your support burden) because they don't know the smartest ways to work with spreadsheet data. Here are some highly useful tips that can streamline typical tasks and boost productivity.

Software

10 obscure Excel tricks that can expedite common chores

The business world is full of users who have neither the opportunity nor the inclination to figure out Excel's shortcuts. They end up wasting a lot of time (and adding to your support burden) because they just don't know the smartest ways to work with spreadsheet data. Here are some highly useful tips that can streamline typical tasks and boost productivity.

CXO

The pressing need for an Office-specific help desk

Some of you will read the title of this post and think to yourselves, “Ha! We don’t have the funds we need to hire enough ‘regular’ help desk personnel. There’s no way we can afford to hire a bunch of Microsoft Office experts to sit around waiting for people to call the help desk.” But ...

Printers

Enough already with arrogant analysts who give the “good ones” a bad name

You know one thing I love about being a “computer person?” No matter where I go, I usually meet people who like to talk about computers or technology in general. You know one thing I hate about being a “computer person?” Same thing. Everywhere I go, I meet people who want to talk about computers. ...

CXO

Counsel the screamers to turn down the volume

To paraphrase the Peter Finch character in the 1976 movie “Network,” I’m mad as heck, and I’m not going to take it any more. Growing up in a small town in Indiana, my mom attempted to instill in my siblings and me the now old-fashioned notion of manners. Don’t chew your food with your mouth ...

IIoT software assists manufacturers and other industrial operations with configuring, managing and monitoring connected devices. A good IoT solution requires capabilities ranging from designing and delivering connected products to collecting and analyzing system data once in the field. Each IIoT use case has its own diverse set of requirements, but there are key capabilities and ...

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

f-jeffdavis

Transpose Excel data from rows to columns, or vice versa

Three timesaving Ctrl-key tricks in Excel

Convert Excel calculations to literal values

Generate a list of unique entries in an Excel column

Resist bad decisions that will waste your client’s money

10 obscure Excel tricks that can expedite common chores

10 obscure Excel tricks that can expedite common chores

The pressing need for an Office-specific help desk

Enough already with arrogant analysts who give the “good ones” a bad name

Counsel the screamers to turn down the volume

Industrial Internet of Things: Software comparison tool

How to recruit and hire an Operations Research Analyst

Quick glossary: Industrial Internet of Things

Software Procurement Policy