Centriq Blog Category: Microsoft Office

SharePoint Online: Get to know the Sites

February 20, 2020 in Microsoft 365/Office 365, Corporate IT Training, Microsoft Office, Microsoft / by Alison Chludzinski

Your company intranet doesn’t have to be a black hole of everyone’s projects and information. By using SharePoint Online, you can tailor each user’s experience by creating sites that best suit each user’s needs. Not sure where to start? Take a look at these four commonly used sites and how they can streamline your internal communications.

O365: Start with these 5 apps (that aren’t Outlook)

July 29, 2019 in Corporate IT Training, Microsoft Office / by Ted Parker

Office 365 is the first step in leading your company to a Digital Transformation— but that means getting comfortable with more than just Outlook in the Cloud. There are more than 25 amazing new apps with O365. So, where to start? Read More

Office 365 vs Microsoft 365: What’s the Difference? Are They the Same?

March 5, 2019 in Microsoft 365/Office 365, Corporate IT Training, Microsoft Office / by Ted Parker

Revised July 20, 2020: If you asked the two questions in the title of this blog today, the answers would be: “There is no difference.” “Yes, they are the same.” So, if you prefer current events, read our new blog Office 365 is now Microsoft 365. If you are a fan of the History Channel, keep reading this blog from March 2019 and re-live the glory days when the once powerful Office 365 brand ruled the world of Microsoft Productivity Apps.

Quick Reference Guide for O365 Apps

November 14, 2018 in Corporate IT Training, Microsoft Office / by Centriq Training

As more organizations migrate to Office 365, end-users now have to determine how to use the applications included in the new office suite. Centriq Training instructor Mickie Brewer put together the following chart to help Centriq employees better understand how to take advantage of OneDrive, SharePoint, and Teams that are new to them. We found it so useful we decided to share it with you!Read More

How do I use conditional formatting in Microsoft Excel?

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

Conditional Formatting is one of the best features in Excel, is relatively simple to use, and provides very powerful results.

Conditional formatting applies colors to cells that meet specific criteria—such as “greater than $40,000”. If the condition is true, formatting occurs; if false, formatting does not happen.Read More

Microsoft OneNote – What is OneNote? Why should I use OneNote?

July 18, 2018 in Corporate IT Training, Microsoft Office, Microsoft / by Craig Gerdes

What Is Microsoft OneNote?

Essentially, it is a digital notebook available anytime, anywhere. OneNote is available as a traditional desktop app, a web app, and a mobile app. In addition, a simplified OneNote version comes pre-installed with Windows 10. The features available to the user depend on the version and environment used.Read More

Microsoft Excel How To’s – Tips for Excel Spreadsheets

July 2, 2018 in Corporate IT Training, Microsoft Office / by Craig Gerdes

Most people would agree that Microsoft Excel is a very powerful program. Even someone who classifies themselves as an ‘expert user’ could admit to finding new functions and commands from time to time. But, since most of us aren’t Excel experts, it’s helpful to have a resource to turn to when your Excel spreadsheet isn’t quite right.

As a Microsoft Excel instructor, my goal with this blog is to share my knowledge and provide answers to questions I often hear from Excel users. There are some tips included that will increase your efficiency as well! As always, I can’t cover everything in one blog, so if you don’t find the answer you’re looking for, look to the ‘HELP’ feature within the software itself (or sign up for one of my classes).Read More

Microsoft Word How To’s – Formatting Tips for Word Documents

June 15, 2018 in Corporate IT Training, Microsoft Office / by Craig Gerdes

Has this ever happened to you? You’re plugging along on a Microsoft Word document only to freeze because you can’t recall how to do a relatively simple formatting function. I think it’s happened to all of us at one point or another and I hope the following will be your go-to resource whenever an instance like that takes place. (Bookmark the link so you can easily find it whenever a brain freeze occurs!)

My goal is not to cover all Microsoft Word formatting capabilities, just the basic ones that can increase your efficiency greatly. If you need more information or other guidance, look to the ‘HELP’ feature within the software itself.Read More

Outstanding Options in Microsoft Access

May 22, 2018 in Corporate IT Training, Microsoft Office / by Craig Gerdes

Customized Keyboard Shortcut Keys

Many users find that keyboard shortcuts for Access helps them work more efficiently. In the previous blog, we discussed some frequently used keyboard shortcuts. In this blog, we will discuss how to create customized keyboard shortcut keys.

The AutoKeys macro assigns shortcut key combinations to a set of tasks. You can only create one AutoKeys macro in each database but you can create multiple submacros, with each submacro assigned a shortcut key combination. You must name the macro “AutoKeys” for it to work.Read More

Microsoft Access Tips and Tricks

May 10, 2018 in Corporate IT Training, Microsoft Office / by Craig Gerdes

Symbols for Special/Custom Formatting

To customize the display of numbers, dates/times, and text, use the Format property.

For a field, you set this property in the Table Design View (in the Field Properties section) or in the Query Design View (in the Field Properties property sheet). For a control, you set this property in the control’s property sheet.

The Format property affects only how the data is displayed, not how the data is stored.Read More