Microsoft Office Archives

PowerPoint Fantastic Features: Custom Animations & Using Layers and Triggers

Craig Gerdes September 25, 2017

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)

Super Settings (or rather Outstanding Options) in Excel

Craig Gerdes September 5, 2017

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.

Awesome Add-ins for Excel

Craig Gerdes August 17, 2017

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.

Fantastic Functions in Excel

Craig Gerdes August 4, 2017

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.

Getting Certified in Microsoft Office: Special Insights

Craig Gerdes July 31, 2017

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.

How to use Flash Fill in Microsoft Excel

Craig Gerdes July 6, 2017

You are probably familiar with Excel’s very powerful Autofill feature (if not, learn more about Autofill here 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. What is Flash Fill? 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.).

Start Date	End Date	Day/Eve	Break Weeks	Track
Jan 23, 2023	Jul 27, 2023	Eve	4/3/23-4/7/23 5/22/23-5/26/23 7/3/23-7/7/23	CSSP-V
Jan 30, 2023	May 5, 2023	Day	3/6/23-3/10/23 4/10/23-4/14/23	CSSP-V
Feb 6, 2023	May 19, 2023	Day	3/27/23-3/31/23	FSCP-V
Mar 20, 2023	Jun 23, 2023	Day	4/24/23-4/28/23 5/22/23-5/26/23	CSSP-V
Apr 10, 2023	Jul 28, 2023	Day	5/29/23-6/2/23 7/3/23-7/7/23	FSCP-V
Apr 24, 2023	Oct 19, 2023	Eve	7/3/23-7/7/23 8/21/23-8/25/23	CSSP-V
May 15, 2023	Dec 14, 2023	Eve	7/3/23-7/7/23 9/4/23-9/8/23 11/20/23-11/24/23	FSCP-V
Jun 5, 2023	Sep 8, 2023	Day	7/3/23-7/7/23 8/7/23-8/11/23	CSSP-V
Jun 19, 2023	Oct 6, 2023	Day	7/3/23-7/7/23 9/4/23-9/8/23	FSCP-V
Jul 24, 2023	Jan 25, 2024	Eve	10/2/23-10/6/23 11/20/23-11/24/23 12/25/23-12/29/23	CSSP-V
Aug 14, 2023	Nov 17, 2023	Day	9/5/23-9/8/23 10/16/23-10/2/23	CSSP-V
Aug 28, 2023	Dec 15, 2023	Day	9/4/23-9/8/23 11/20/23-11/24/23	FSCP-V
Oct 30, 2023	Feb 2, 2024	Day	11/20/23-11/24/23 12/25/23-12/29/23	CSSP-V
Oct 30, 2023	May 2, 2024	Eve	11/20/23-11/23/23 3/4/23-3/7/23	CSSP-V
Nov 6, 2023	Mar 1, 2024	Day	11/20/23-11/24/23 12/25/23-12/29/23 1/29/24-2/2/24	FSCP-V

Start Date	End Date	Day/Eve	Break Weeks	Track
Feb 13, 2023	Mar 19, 2023	Day	3/20/23-3/24/23 4/17/23-4/21/23	CSSP-I
Apr 17, 2023	Jul 21, 2023	Day	5/22/23-5/26/23 7/3/23-7/7/23	CSSP-I
Jun 5, 2023	Sep 8, 2023	Day	7/3/23-7/7/23 8/7/23-8/11/23	CSSP-I
Jul 31, 2023	Nov 3, 2023	Day	9/4/23-9/8/23 10/2/23-10/6/23	CSSP-I
Sep 25, 2023	Dec 22, 2023	Day	11/20/23-11/24/23	CSSP-I
Nov 27, 2023	Mar 1, 2024	Day	12/25/23-12/29/23 1/29/24-2/2/24	CSSP-I

Start Date	End Date	Day/Eve	Break Weeks	Track
Jan 16, 2023	Apr 21, 2023	Day	2/2023-2/24/23 3/20/23-3/24/23	CSSP-I
Jan 23, 2023	Jul 27, 2023	Eve	4/3/23-4/7/23 5/22/23-5/26/23 7/3/23-7/7/23	CSSP-I
Feb 27, 2023	Jun 2, 2023	Day	4/3/23-4/7/23 5/1/23-5/5/23	CSSP-I
Apr 10, 2023	Jul 14, 2023	Day	5/15/23-5/19/23 7/3/23-7/7/23	CSSP-I
May 22, 2023	Aug 18, 2023	Day	7/3/23-7/7/23	CSSP-I
Jun 26, 2023	Sep 29, 2023	Day	7/3/23-7/7/23 8/7/23-8/11/23	CSSP-I
Aug 7, 2023	Nov 10, 2023	Day	9/4/23-9/8/23 10/9/23-10/13/23	CSSP-I
Sep 11, 2023	Dec 15, 2023	Day	10/16/23-10/20/23 11/20/23-11/24/23	CSSP-I
Oct 23, 2023	Jan 26, 2024	Day	11/20/23-11/24/23 12/25/23-12/29/23	CSSP-I
Oct 30, 2023	May 2, 2024	Eve	11/20/23-11/23/23 12/25/23-12/28/23 3/4/24-3/7/24	CSSP-I
Dec 4, 2023	Mar 8, 2024	Day	12/25/23-12/29/23 2/5/24-2/9/24	CSSP-I

PowerPoint Fantastic Features: Custom Animations & Using Layers and Triggers

Super Settings (or rather Outstanding Options) in Excel

Awesome Add-ins for Excel

Fantastic Functions in Excel

Getting Certified in Microsoft Office: Special Insights

How to use Flash Fill in Microsoft Excel

General

Blog

New IT Career