Microsoft Archives - Centriq
Centriq Training Print Logo

Sunday

August 20 12:49 AM

78°F Partly Cloudy


Blog Banner Graphic

Centriq Blog Category: Microsoft

Awesome Add-ins for Excel

Awesome Add-ins for Excel

August 17, 2017 in Microsoft, 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, 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

SharePoint and the Future of Work

SharePoint and the Future of Work

August 3, 2017 in Microsoft, Corporate IT Training / by Sara Lamb

When it comes to its signature SharePoint document management software, Microsoft is deservedly ambitious. The company claims to reinvent the digital connected workplace and empower every person and every organization on the planet to achieve more. Underlying these big claims is technology that truly can revolutionize the way people work on every level.Read More

Why IT Departments Need to Integrate SharePoint Into Their Workflows

Why IT Departments Need to Integrate SharePoint Into Their Workflows

August 3, 2017 in Microsoft, Corporate IT Training / by Sara Lamb

Today’s IT departments often find themselves pigeonholed by accessibility – both in terms of employees’ standard capacity to access documents and applications, and in the greater scope of making technology available to individuals with permanent, temporary, or situational accessibility needs.

In both respects, Microsoft SharePoint is leading the way towards creating a powerfully accessible digital office workspace. SharePoint users enjoy a unified, secure platform for employee data access.Read More

Getting Certified in Microsoft Office: Special Insights

Getting Certified in Microsoft Office: Special Insights

July 31, 2017 in Microsoft, 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 Benefit from the Shortcomings of IoT

How to Benefit from the Shortcomings of IoT

July 12, 2017 in Microsoft, Corporate IT Training / by Sara Lamb

The Internet of Things (IoT) offers the advanced connectivity of devices and services by connecting the physical world to the virtual world in the exchange of data in real-time. Despite the many promising opportunities IoT offers, it is still surrounded by many misconceptions that lead professionals to ignore its promise.  Many of these misconceptions are wrong and do not encapsulate the actual issues surrounding IoT. The following is taken from an article from Redmond Channel Partner, in which Howard Cohen explains many of the problems with IoT and how Microsoft partners can actually offer solutions to these problems and benefit in the process. To read the full article, follow the link at the bottom of the page.

Before moving on to the real problems, let’s begin with the misconceptions surrounding IoT:Read More

How to Choose the Right MSP

How to Choose the Right MSP

July 11, 2017 in Microsoft, Corporate IT Training / by Sara Lamb

When looking for additional help on the technology side of your business, a Managed Service Provider may be the help you need. Managed service providers (MSPs) are companies that can manage IT services for a company through the Web. In an article from Redmond, Scott Bekker explains many of the reasons for using an MSP, as well as questions to consider so that you can choose the right one for your company. The following is excerpted from his article, Picking the Right MSP. To read the full text, follow the link at the bottom of the page.

Starting off, you must consider what you want to get out of an MSP.Read More

How to use Flash Fill in Microsoft Excel

How to use Flash Fill in Microsoft Excel

July 6, 2017 in Microsoft / 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

Stop searching for IT Training & let Centriq do it for you

Stop searching for IT Training & let Centriq do it for you

June 30, 2017 in Big Data, Microsoft, Corporate IT Training, Security, Web Development, Cisco, EC-Council, IBM / by Sara Lamb

As technology evolves, professionals in the field of IT need to be educated and up-to-speed on the latest versions of existing software and the capabilities of new software as soon as they become available. Blogs, YouTube videos and usergroup discussions are all great places to gain small amounts of knowledge, but to be fully immersed and hands-on experience, instructor-led IT training is the way to go.

Sometimes IT training can be hard to find (especially if the technology is uncommon or very new), which is where Centriq comes in. Not only do we have offer IT training classes on technologies like Cisco, Microsoft, ITIL, etc, but we teach Agile Bootcamps, IBM, Apache, Hadoop and Business Skills classes as well. If you need training on a technology we don’t have on our Class Schedule, we will locate a class for you that fits your schedule and budget, saving you time and money.
Read More

Microsoft and Google Gain Ground on AWS

Microsoft and Google Gain Ground on AWS

June 19, 2017 in Microsoft, Corporate IT Training / by Ryan Grawe

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