Centriq Training Print Logo

Friday

January 27 09:18 AM


Blog Banner Graphic

Centriq Blog Category: Corporate IT Training

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

Microsoft and Google Gain Ground on AWS

Microsoft and Google Gain Ground on AWS

June 19, 2017 in Corporate IT Training, Microsoft / by Centriq Training

Although there are many cloud computing vendors in the marketplace, some of the major players are making strong moves towards the top. In an article taken from Redmond Channel Partner, Jeffrey Schwartz describes the increasing usage of Microsoft and Google’s respective cloud platforms. The following is taken from Schwartz, article, Microsoft, Google Gaining on AWS, But Not Quickly Enough. To read the full article, follow the link at the bottom of the page.

As the current cloud field stands, leader Amazon Web Services (AWS) may be ceding some market share to Microsoft Azure and the Google Cloud Platform (GCP), but the challengers still have a lot of ground to make up. Among the big three public cloud infrastructure providers, Microsoft Azure has clearly established itself as No. 2. Considering that it’s a distant second, Azure has gained considerable ground on Amazon Web Services over the past year. While Azure still has a reasonable lead over the Google Cloud Platform, the latter has also grown significantly.As the competitors move closer, AWS remains poised to hold on to its clear lead. The RightScale 2017 State of the Cloud Report shows that 57 percent of customers are currently running applications in AWS, the same number as last year. Meanwhile, 34 percent are running apps in Azure, compared with 20 percent last year; and 15 percent are using GCP, up from 10 percent last year.Read More

Problems Students Face with Corporate Online IT Training

May 25, 2017 in Corporate IT Training / by Centriq Training

Technology courses can be rewarding, but also difficult.

Enrolling in IT classes can help a person further their understanding of technology and excel in their career field. While some people opt for online IT training due to its convenience, it isn’t without its problems.

Many students face difficulties when it comes to these kinds of remote IT classes. Sometimes a lack of motivation can be the issue, while a lack of hands-on assistance can also contribute to the problem. We understand the difficulties associated with virtual learning, which is why we also offer in-person technology courses.Read More

How Do I Find Which Technology Courses Are Right for Me?

How Do I Find Which Technology Courses Are Right for Me?

May 9, 2017 in Corporate IT Training / by Centriq Training

We all know that choosing the right technology training course is important.

A quality course can help a person gain the knowledge they need to excel in their current jobs and find better career opportunities in the future.

Choosing the right type of IT training, online or in-class, is important for getting the best results. Since everyone has different professional goals and aspirations, it is important to ask the right questions when choosing technology courses. Here are some things to consider during the decision-making process.Read More

What Technology Courses Should Your Employees Take?

What Technology Courses Should Your Employees Take?

May 8, 2017 in Corporate IT Training / by Centriq Training

Knowledgeable employees are the foundation of any successful company.

When it comes to the technology, it is important for employees to get the continuous and up-to-date training they need to excel at their jobs and stay ahead of new technological advances.

Some technology courses are great for anyone, whereas others are better for employees in a specific discipline. We know that choosing the right courses is important, and Centriq’s broad selection offers anyone the chance to get a thorough education.Read More

How to Synchronize Directories with Azure AD Connect

How to Synchronize Directories with Azure AD Connect

April 25, 2017 in Azure, Corporate IT Training, Microsoft / by Centriq Training

Since the release of Windows 2000, Active Directory (AD) has been the way users have logged in to on-premises enterprise networks and business-based systems, including Microsoft Exchange Server.

As more computing takes place in the cloud, businesses need both on-premises and cloud user verification. For one set of credentials to access both (“synchronize”), Microsoft in 2015 introduced the “Azure AD Connect” tool.Read More

Expert Microsoft Excel Tips and Training

Expert Microsoft Excel Tips and Training

April 3, 2017 in Corporate IT Training, Microsoft / by Centriq Training

Microsoft Excel is the standard software for managing and organizing data and spreadsheets.

This software is widely used by businesses across various industries on a daily basis. Whether you need to compare monthly sales revenue or document weekly traffic for a website, you’ve probably used Micorsoft Excel at some point on the job.

But while you may have some experience with the program, you probably have only scratched the surface of all of its features. Here are some ways any user can get more out of Microsoft Excel.Read More

Expert Microsoft Word Tips and Training for Professionals

Expert Microsoft Word Tips and Training for Professionals

March 22, 2017 in Microsoft / by Centriq Training

Microsoft Word is the most common word processing program for people and organizations all over the world. Just about every digitally-created document is made with Microsoft Word.

We all may use this software from time to time, but professionals may need it weekly or even daily. And while we all think we may be Microsoft Word experts, so few people truly take advantage of all of its time-saving features. Here are some powerful tips to become Microsoft Word ExpertsRead More

Centriq Reviews: Corporate IT Training

Centriq Reviews: Corporate IT Training

March 10, 2017 in Corporate IT Training, Reviews: Corporate Training / by Centriq Training

It’s become common practice for businesses to ask for customer feedback on all types of transactions. Whether you’re at the grocery store, getting gas or shopping online, companies want to know how satisfied or dissatisfied you are with them and their product/service.

We ask for feedback from every customer that attends a corporate IT training class at Centriq. The feedback you provide is shared with the instructor that taught your class, as well as the company’s Owners and members of the Management team.Read More

2017 IT Certification Roadmap

2017 IT Certification Roadmap

March 6, 2017 in Cisco, Corporate IT Training, EC-Council, Microsoft, Security / by Centriq Training

CompTIA has created a vendor neutral IT certification roadmap that will be useful to all IT Pros.

Whether you’re just starting out or are a seasoned professional in information security, storage and data, training, software development, hardware services, infrastructure, web and mobile or IT management and strategy, this roadmap will show you the certification route that’s best.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.