Centriq Training Print Logo

Sunday

January 29 09:31 AM


Blog Banner Graphic

Centriq Blog Category: Microsoft Office

PowerPoint Fantastic Features:  Custom Animations & Using Layers and Triggers

PowerPoint Fantastic Features: Custom Animations & Using Layers and Triggers

September 25, 2017 in Corporate IT Training, Microsoft Office / 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 Corporate IT Training, Microsoft Office / 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

Fantastic Functions in Excel

Fantastic Functions in Excel

August 4, 2017 in Corporate IT Training, Microsoft Office / 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 Corporate IT Training, Microsoft Office / 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 Corporate IT Training, Microsoft Office / by Craig Gerdes

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.).Read More

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 8, 2023
Aug 11, 2023
Day
5/29/23-6/2/23
7/3/23-7/7/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 19, 2023
Oct 6, 2023
Day
7/3/23-7/7/23
9/4/23-9/8/23
FSCP-V
Jun 26, 2023
Sep 29, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-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
If you don't see the Cohort Start date you are looking for don't forget to check out our campus calendars.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
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
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
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
Dec 4, 2023
Mar 8, 2024
Day
12/25/23-12/29/23
2/5/24-2/9/24
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.