Craig Gerdes, Author at Centriq
Centriq Training Print Logo

Friday

November 24 11:49 AM

59°F Mostly Sunny


Blog Banner Graphic

Posts by: Craig Gerdes

Terrific Tips and Tricks in PowerPoint: Learn to Present Like a Pro

Terrific Tips and Tricks in PowerPoint: Learn to Present Like a Pro

October 23, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

There is no shortage of tips for creating and delivering an effective presentation in PowerPoint.  Just search the web and you will find lots of advice.  Here is Microsoft’s official article on the subject.

My goal for this blog posting is not to repeat some of the generic information and suggestions out there but to provide less common tools, applications, and tricks such as:

  • Using tools and shortcut keys for screen and cursor options
  • Utilizing special applications such as Mix (Free Add-in) and Office Presentation Service (Free Option)
  • Employing special tricks like hiding slides and creating custom shows

Read More

Awesome Add-ins for PowerPoint

Awesome Add-ins for PowerPoint

October 9, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

An add-in is a term used for a software utility added to a primary program.  In other words, add-ins are mini applications that extend what you can do with Microsoft Office programs, such as PowerPoint.  When you enable an add-in, it adds custom commands and new features that help increase your productivity.

By default, add-ins are not immediately available, so you must first install (and in some cases activate or configure) these add-ins so that you can use them.  Many of the add-ins are free from the Microsoft Store (https://store.office.com).  You may also be able to search for add-ins from third party vendors.Read More

PowerPoint Fantastic Features:  Custom Animations & Using Layers and Triggers

PowerPoint Fantastic Features: Custom Animations & Using Layers and Triggers

September 25, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

Without a doubt, one of the most powerful features in PowerPoint is the ability to animate objects; there are several basic options available, which are very good.  However, you can supercharge your animations and really dazzle your audience by creating custom animations and by using layers and triggers.

You can create custom animation effects using one of the following methods:

  • Applying multiple animation effects to one object
  • Applying motion path animation (including Custom path)

Read More

Super Settings (or rather Outstanding Options) in Excel

Super Settings (or rather Outstanding Options) in Excel

September 5, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

If you are like most people, you may not have spent much time in the Options area of Excel.  That is unfortunate because you can choose some settings that can really customize your version of the program to your own personal preferences and work situation.

This blog will share some examples of the things you can do with options and settings.  Hopefully these “golden nuggets” will encourage you to explore other options and settings that you might find helpful to you.Read More

Awesome Add-ins for Excel

Awesome Add-ins for Excel

August 17, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

An add-in is a term used for a software utility added to a primary program.  In other words, add-ins are mini applications that extend what you can do with Microsoft Office programs.  When you enable an add-in, it adds custom commands and new features to programs that help increase your productivity.Read More

Fantastic Functions in Excel

Fantastic Functions in Excel

August 4, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

With hundreds of functions available in Excel in multiple categories, it is nearly impossible for any one person to know how to use all of the functions.

This blog article will discuss a few of the lesser-known functions such as FORECAST, GETPIVOTDATA, TRANSPOSE, LARGE/SMALL (not the same as MAXIMUM/MINIMUM), and INDEX with MATCH.

As you may already know Excel functions are grouped into several categories including financial, logical, text, date/time, lookup and reference, math, statistical, engineering, cube, and of course, several others including the basic AutoSum functions.Read More

Getting Certified in Microsoft Office: Special Insights

Getting Certified in Microsoft Office: Special Insights

July 31, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

Are you interested in earning a higher salary?  Do you like being on the fast track to a possible new promotion?  Are you attracted to the idea of earning recognition for your hard-earned knowledge and skills?  Then a Microsoft Office Specialist (MOS) certification may be just right for you!  It certainly would add something extra on your resume and set you apart from your coworkers or other job seekers.

This article will share some helpful insights into the certification process including describing the different levels of achievement available, the best methods to study and practice for the exams, practical tips from a recent completer (me!), and much more.Read More

How to use Flash Fill in Microsoft Excel

How to use Flash Fill in Microsoft Excel

July 6, 2017 in Microsoft Office, Corporate IT Training / by Craig Gerdes

You are probably familiar with Excel’s very powerful Autofill feature (if not, click here to learn more and then read on). However, did you know there is a similar feature that is equally useful called Flash Fill?

Say you have information in Excel not formatted the way you need it to be and going through the entire list manually to correct it seems daunting. In this case, Flash Fill can do the work for you. You use the Flash Fill feature to automatically fill-in values in one column from information referenced from another, adjacent column (extract, combine/concatenate, insert characters, reverse data, change case, format, etc.).Read More