New and Upcoming Features for G-Suite

Google’s massively popular set of tools known as G-Suite is an ever evolving mixture of tools tailored for businesses large and small. Each and every week, new features are being added, existing features updated, and new tools for no additional cost to users. Let’s take a look at some of the newest updates to G-Suite… […]

Make Business Data Usable with e-Discovery

Make Business Data Usable with e-Discovery

Make Business Data Usable with e-Discovery

E-Discovery, or electronic discovery, refers to any process in which electronic data is sought, located, secured and analyzed. Electronically stored information can include emails, documents, presentations, audio and video files, social media, and websites.
As part of an information governance project, one of the most helpful things an organization can do is to run an audit of its unstructured data (e-Discovery). When organizations understand what data they have, a wide range of possibilities opens up and exposes the need for well-thought-out information governance policies and procedures.

E-Discovery and information governance — a symbiotic relationship

Have you ever heard the phrase, “I’ll scratch your back if you scratch mine”? This idea of helping someone in order to receive some help in return is the essence of a symbiotic relationship. E-Discovery and information governance can benefit from this type of relationship. On their own, discovery, inventory, retention and disposal do not provide the full picture; e-Discovery is just one driver for a more robust information governance program.
Information governance changes what has typically been a reactive process into a more proactive one by defining what information assets are available and the value that each provides. This ensures that corporate and customer information is secure and easily located. It defines the policies by which information should be controlled and enforces those policies across the company’s information repositories while taking into account all of the necessary and appropriate jurisdictional laws and regulations.
As businesses look at e-Discovery and information governance options, they need to consider the following:

  • Delete Expired Information — Everyone agrees that the “keep it forever” mentality that has existed for years is not cost effective. Companies must have policies that enforce the deletion of redundant, obsolete and trivial data as well as information that has met its legal and regulatory retention requirements. This must be done in an auditable manner to ensure compliance — which will protect companies from future litigation. Most organizations should conclude that content discovery and cleanup is a great first step to modern retention implementation.
  • Defined Process — Embedding the information governance program and retention management process with the content cleanup process ensures the organization has an end-to-end flow of how information should be governed, collected, used and produced.
  • Proactive Information Approach — Having a proactive approach to e-Discovery delivers value to the organization when it must collect information from multiple resources. The benefit of being proactive is that the information is under control. This provides a state of readiness and a streamlined response for time-sensitive and on-demand information requests.
  • Analysis — Unstructured content, once classified, becomes structured and therefore findable, usable and manageable throughout its life cycle. Structuring data using classification will move the organization a long way toward information governance standards.
  • Staff Effort — With a definition of “clean” in place, a lot of cleanup is possible without huge staff effort. Also, with properly engaged management, the main issue of “over-review” due to staff concerns about cleanup risks should not be a problem. That is, if the cleanup is supported by management, defensible and done in good faith, those executing it should not be concerned and feel the need to explicitly scrutinize every file.
  • Content cleanup is best considered part of a broader approach to information governance. In many ways, it is a key first step because it can actually be connected to real savings (be they in-year operational or longer term avoidance) and therefore provides a budget to acquire the technologies, processes and skills that will be needed to implement many other parts of an information governance strategy.

    If you would like to learn more about e-Discovery and information governance, contact us!

Keep Business On-Track with Proactive Information Governance


Keep Business On-Track with Proactive Information Governance
Keep business on track with proactive information governance
In the modern digital economy, information has become a powerful and essential corporate asset. However, given today’s legal and technological environment, unprecedented demands are being placed on private- and public-sector organizations, and their data information security needs are rapidly outpacing traditional compliance plans, best practices and settled industry norms. In response, many businesses have shifted mindsets from reactive responsiveness and are instead investing in proactive information governance, featuring electronic discovery (e-Discovery) and enterprise planning and analysis. But what are these processes, and how do they help businesses?

Information Management and e-Discovery
E-Discovery is the process of discovering “raw data” or “metadata” that is carried out in electronic formats. It encompasses what most often is referred to as electronically stored information, or ESI. Understanding how e-Discovery works can help businesses determine what records to keep or delete. This is vital for a majority of small-, medium- and large-sized businesses, including those in the fields of construction, information technology, banking, government and healthcare.

  • The key to addressing e-Discovery is to be proactive in the management of information and records with control over the handling of potential e-Discovery requests.
  • E-Discovery analyzes ESI such as emails; instant messaging chats; documents; accounting databases; CAD/CAM files; websites; and any other electronic information created, sent and stored by a broad range of organizations of all sizes.
  • For a majority of companies, the #1 culprit of both unnecessary and redundant content storage is the company’s or company employees’ retention of duplicate, non-critical received and sent emails.
  • A company’s decision to neglect — or failure to have — an information management e-Discovery policy results in overzealous storage of unneeded documents, increasing risk of data security breach, and unnecessary operational network cost.

Enterprise Planning and Analysis
Enterprise analysis describes the business analysis activities that take place for an enterprise to identify business opportunities, build a business architecture, determine the optimum project investment path for that enterprise, and — finally — implement new business and technical solutions. If you’re familiar with enterprise architecture, you might wonder how enterprise planning is any different.

  • Business and enterprise planning solutions help companies of all sizes automate and transform planning, reporting and analysis processes, while enterprise architecture focuses more on defining an organization’s operation and framework.
  • At first sight, business opportunities are not always considered as being part of an enterprise architecture initiative; instead, they are more often viewed as activities that should be considered as inputs.
  • Your company’s decision to integrate sound business and enterprise planning solutions helps you anticipate performance gaps; analyze root cause; assess alternatives; and enable more effective decision making, execution and operational cost reduction.

Reach out to us today to learn more about information governance solutions to fit your business.

Using Google Sheets: Keyboard Shortcuts

Using Google Sheets: Keyboard Shortcuts

Changing and Manipulating Data
Many of the shortcuts available within Google Sheets match those found in other products. If you are already familiar with products such as Excel, you may find yourself in familiar territory. Once a cell is selected, one can use Ctrl + Space to select the entire current column or Shift + Space to select the entire current row. To select all data on a sheet, use Ctrl + a (⌘ + a for Mac Users).

Formatting Cells
Formatting the text within cells for readability and proper display is important. Simple formatting such as making text bold (Ctrl + b), italicizing text (Ctrl + i) and underlining important text (Ctrl + u) is available via shortcuts. Text alignment within cells can be changed to center (Ctrl + Shift + e), left (Ctrl + Shift + l) or right (Ctrl + Shift + r). Again, these are also available to Mac users by replacing Ctrl with ⌘.

Quickly being able to navigate a spreadsheet or form is vital for those performing data entry. Shortcuts to move to the beginning of a row (Home), the end of a row (End), the beginning of the sheet (Ctrl + Home or ⌘ + Home) and the end of the sheet (Ctrl + End or ⌘ + End) may already be familiar to users, making the transition to Google Sheets easier.

A useful feature of Google’s suite of tools is the ability to store and read from a list of changes made to a document over time. To bring up the revision history for a document, use Ctrl + Alt + Shift + h in Windows or ⌘ + Option + Shift + h on a Mac. The window will appear to the side detailing versions of the current document, including those made by other users. Google Sheets utilizes Google Drive to provide real time collaboration on documents regardless of location or device. This means that a user can see and make change on their phone off-site while users in the office can watch them make changes in real time, requiring no additional set up nor cost.

More Information
Google Sheets provides nearly all of the same functionality as any of the other major spreadsheet applications. Updates and additional features to include more functionality are common, and are free of cost with no downtime or installation of software required. For a full listing of keyboard shortcuts, visit the documentation here.

Focusing on Small Business

Why does PQC Tech focus on small-to-medium businesses? Because of our status as a small business ourselves, we believe that the biggest success stories start with the humblest beginnings. Vera Bradley was the brainchild of two women finding a solution to a real market need, Microsoft sprung from the minds of two friends with an idea and passion, and even Walmart began with a single store and a driven salesman. As with any venture, no matter the industry, these entrepreneurs faced countless challenges and setbacks, building both knowledge and expertise along the way./span>

We understand that, to a business, managing day-to-day operations, building a strategy for future success, and managing the technical needs of such a venture is daunting at best. Finding the right answers to all of his or her problems in a timely and cost effective manner can overwhelm an entrepreneur, and that’s before implementation of the solution. Most businesses are also focused around other markets, and simply don’t have the experience needed to solve some of their technical problems.

PQC Tech is here to lend our wealth of experience and technical knowledge to help you find solutions that enhance every aspect of your business: business analysis, software implementation, hardware implementation, social media marketing, website design, and more. Our team has decades of cumulative experience in all of these fields. We would love to hear about your business’s concerns and needs so we can offer you reliable, cost-effective solutions tailored specifically to your business. Let’s grow together.

PQC Tech – Engaging With The Community

PQC Tech prides itself on serving the community and the businesses which call it home. We would like to announce our membership and participation in these local organizations:

The Overland Park Chamber of Commerce ( serves the Overland Park, Kansas business community. Comprised of over 800 members, the Overland Park Chamber seeks to improve the business environment, allowing local entrepreneurs to flourish.

The Northeast Johnson County Chamber of Commerce ( promotes local commercial relationships, serving the cites of northeast Johnson County, Kansas. By maintaining a conducive business environment, the chamber continues to grow with over 350 members across a wide variety of industries.

Serving the city of Olathe, Kansas, the Olathe Chamber of Commerce ( welcomes its 1300 members from many sizes and types of businesses across the area. The chamber provides networking, resources and support to businesses looking to grow within the city.

The Briarcliff Business Partner Alliance ( serves businesses in the Briarcliff development in northern Kansas City, Missouri. The alliances provides networking opportunities and marketing services among other resources for its members.

We are excited to work alongside such motivated entrepreneurs and provide our services to these booming business communities.

Introducing PQC Tech – Who are we?

PQC Tech is the latest great idea by our parent company, PQC. We provide technical services and expertise to build custom tailored solutions for our clients. Notably, PQC Tech develops easy to implement and easy to use solutions, blending both technology and service to make it simple for your ideas to take off.

Google Suite Implementation

G Suite is a massive, ever evolving package of tools blending mail, cloud storage, and scheduling amongst other utilities. We specialize in helping businesses learn how to leverage these tools and get the most value possible for their investment. To blend this functionality together, our One Workbench software provides a portal into your business’s workflows and processes in real time, no matter where you are. Integrating these features with your existing business model is our priority.

Web Engagement

A strong online presence is essential to attract potential clients. We understand this. PQC Tech can assist with your marketing and social media campaigns. We are experienced in getting your message out, building a strong platform to elevate your visibility above competitors, and building stable, responsive websites. We ensure at a technical level that this is done smoothly and seamlessly, minimizing the amount of time invested by your business.

Our team has the capability and the desire to provide solutions above and beyond what’s listed here, including software, hardware, integration, migration, expansion or installation. We encourage you to reach out to us to discuss any challenges your business may face. It would be our pleasure to solve them.

PQC’s Regus Social

On Thursday, January 25th, PQC Tech hosted an after hours networking social at the Briarcliff Regus office space for the Kansas City area. It was a great opportunity to meet a number of local entrepreneurs face to face while enjoying a light snack and drinks. Discovering new, local businesses and the people behind them was a pleasure, as was introducing ourselves to these great minds.

With the success of this event, we will be holding further networking events to provide networking opportunities for local business to meet and discover each other. If you’re interested in attending future events, please reach out to us for more information.

Team Spotlight: Stephen Kretsinger

Today, we would like to highlight one of the talented team members within PQC, Stephen Kretsinger!

Stephen has been with PQC for nearly three years, acting as Multimedia Manager for the U.S. Army’s Combined Arms Center. Previous to his tenure with PQC, Stephen plied his trade as a Public Relations Manager in the real estate industry. Presently, he works with PQC to provide a rich and engaging user experience and social media presence for the U.S. Army. Stephen currently wears the hats of photographer, videographer, graphic designer, as well as writer for the Center’s website, providing any and all forms of content.

During his personal time, Stephen spends time with his wife, Christie, and his three boys. He enjoys collaborating with his wife in the realm of photography and marketing. Additionally, he enjoys both video and traditional board games with his entire family. Stephen’s family also participate in various organizations and events in order to spread Autism Awareness and to support ALS and Alzheimer’s research.

Stephen is one of many fantastic associates at PQC, and a welcome addition to our team. We are proud to have him here at PQC, and excited to continue work alongside such talented individuals.

Real Time Collaboration With Google Suite

Google Suite provides your team with the ability to collaborate on documents, spreadsheets, and slideshows and more in real time, with multiple users working on the same document simultaneously, and no need to ever hit the save button again with instantaneous saves to the cloud. Teammates can collaborate through direct editing, comments, and annotations. Google Docs also provides version tracking, conversion to your favorite formats including Office and PDF, and a marketplace of addons that give you even more powerful features. Documents are never lost in your coworker’s inbox, they are stored in the Google Cloud, where your teammates can access them any time on their PC, Chromebook, Tablet, Phone, and more.

Real time collaboration is just one of the powerful tools provided by Google Suite. PQC Tech can analyze your business processes and help you find and utilize every feature that Google Suite has to offer for your business, all while handling day-to-day administration of your Google Suite so you and your team members can focus on what counts, your business.

Contact us today to learn more about Google Suite and how PQC Tech can help you get the most out of the powerful tools it provides.

This article represents only views and opinions held by PQC Tech, and is in no way intended to represent the views or opinions of Google or Google personnel.