Directive Analytics

Directive Blog

Directive Blogs

Directive has been serving the Oneonta area since 1993, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Get Better Insights from Your Spreadsheets… Use Quick Analysis

Do you ever find your eyes glazing over at the sight of a sprawling spreadsheet? That feeling of being overwhelmed by a sea of data is universal… but what if you could instantly start making sense of it all with just one click?

Both Microsoft Excel and Google Sheets offer powerful, yet often overlooked, features to help you quickly analyze and visualize your data. In Excel, this is called the Quick Analysis tool. While Google Sheets doesn't have a single button with the same name, it provides the same powerful capabilities through its intuitive menus and the AI-powered Explore feature. Let's dive into how you can leverage these tools to transform your data from a source of sighs to a font of insight.

0 Comments
Continue reading

Even Basic Business Software Can Be Used to Make Art

What is art? It’s not an easy question to answer, especially with new techniques and mediums being developed all the time. By definition, art can be basically summed up as the creative expression of an individual through some medium.

For Japanese artist Tatsuo Horiuchi, that medium is one that is familiar to those in and out of the art world.

0 Comments
Continue reading

Tip of the Week: How to Use Excel to Quickly Generate Folders

As a manager, some of the administrative work can be, if not the worst part of the job, easily the least engaging. For instance, having to create all the different folders for the employees under your purview, projects, and other organizational needs. Fortunately, Microsoft Excel offers a relatively quick and easy way of doing just this.

0 Comments
Continue reading

Tip of the Week: Using People Graph in Microsoft Excel

Microsoft Excel is a great way for data to be visualized, particularly as it offers various features to highlight the context of the data you’re trying to communicate with. Today, we wanted to walk you through how you can use one such feature—People Graphs—to do so particularly impactfully.

0 Comments
Continue reading

Tip of the Week: The Easiest Way to Add Up a Column in Excel

Microsoft Excel is an extremely capable spreadsheet creation and management tool, made all the more powerful through the inclusion of many handy shortcuts and features. We wanted to share one for a common enough function that you are effectively sure to find a use for it: quickly adding up the values in a single column.

0 Comments
Continue reading

Tip of the Week: How to Copy Excel Worksheets

If you have ever invested time and effort into an Excel spreadsheet, then you know how irritating it is to move all of that data to a different sheet. Thankfully, you can easily and accurately copy this data using a simple technique. Here’s how you can do it.

0 Comments
Continue reading

How to Add Dropdown Menus to Your Business Spreadsheets

Modern spreadsheet programs, like Microsoft Excel or Google Sheets, carry a plethora of functions under the surface that—if used correctly—can take their utility to another level. For instance, the cells in your spreadsheets can be turned into dropdown menus. Let’s go over how to do so in both Excel and Sheets.

0 Comments
Continue reading

Microsoft Office is Dead, Long Live Microsoft 365

In what seems to be the final stage of a plan that Microsoft has been inching towards for years, Microsoft Office will apparently be phased fully into the Microsoft 365 brand. Let’s consider what we know so far about this change.

0 Comments
Continue reading

Tip of the Week: Remove Duplicate Values in Excel

Microsoft Excel is a great tool that can provide loads of value to power users, but oftentimes users just don’t have the know-how to make the most of it. Thankfully, you have power users like us to guide you through some of the more intricate processes in the spreadsheet software. Let’s look at one such process: removing duplicate values in columns.

0 Comments
Continue reading

Tip of the Week: Saving Time in Microsoft Office

Microsoft Office is a super useful collection of software that serves the purposes of just about any business, at least to some degree. Since it is so popular—taking up almost half of the office productivity software market in February 2022—we figured it would be helpful to share a few tips to help speed up some of the things you may be spending time on now.

0 Comments
Continue reading

Tip of the Week: Tips that Can Help You Be More Productive with Microsoft Word

A lot of businesses rely on Microsoft Word, the leading word processing app for companies, but the question is, are you using it to its fullest potential? Today, we thought we’d go through some of the features that can help you be more productive with Microsoft Word.

0 Comments
Continue reading

Tip of the Week: Taking You Through Embedding a Video with PowerPoint

When looking to present an idea, the first two options people think of are often to use a video, or to use a slideshow (typically, citing Microsoft PowerPoint). Our question is, why pick? Let’s go over how simple it is to embed a YouTube video right into your next PowerPoint presentation whether you’re using PowerPoint 365 or PowerPoint 2016.

0 Comments
Continue reading

Tip of the Week: Linking Text Across Microsoft Word Documents

Microsoft Word has a lot of time-and-effort-saving capabilities baked in. For instance, did you know that you can paste the same text—down to the formatting—across numerous documents? This makes it simple to replicate text without having to fix it each time, and to make changes everywhere the text appears all at once. Let’s go over how to do so.

0 Comments
Continue reading

Your Eyes Will Thank You if You Try This Microsoft Word Dark Mode Trick

If you spend a lot of time in front of a computer, eye strain can be a big problem. Staring at a screen for too long can be irritating, and some even experience headaches and exhaustion from it.

Fortunately, a lot of common applications have been deploying dark or night modes. Microsoft Word’s take on this has been, well, less than desirable. We’ll show you a way around it to help save your eyeballs a lot of strain.

0 Comments
Continue reading

Forgot to Save? How to Recover an Unsaved Document

b2ap3_thumbnail_RecoverDoc400.jpgHave you ever closed an application and accidently hit 'Don't Save'? Poof. In one forgetful moment all of your progress is gone and your stomach turns into a giant knot. Before you go out and do something crazy, like forsake technology and modern civilization, you will first want to see if Windows was nice and automatically saved you a copy.

0 Comments
Continue reading

Two Tips for Managing Your Email in Outlook Better

Email! We all know it. We all stare at it every day (or it stares down at us, depending on how you look at it). Microsoft Outlook has some neat features to help cut down on the time you spend managing your email. Let’s jump right into it.

0 Comments
Continue reading

Tip of the Week: Getting More Mileage Out of PDFs

PDFs--Portable Document Format files--are a common enough thing to see. However, many people may not realize the extent of what can be done with them… like editing them. For our tip this week, we’ll go over a few of the ways you can create and edit a PDF file.

0 Comments
Continue reading

What’s New in Office 2019

Microsoft Office is the most utilized productivity suite in the world; and, there are several reasons why. One of the most cited is that they routinely update the applications with new and innovative features. Office 2019 has been out for just under a year and today, we’ll talk about the biggest improvements Microsoft has made within their signature productivity suite. 

0 Comments
Continue reading

Tip of the Week: How to Set Up Multi-Factor Authentication for Office 365

b2ap3_thumbnail_office_365_multi_factor_400.jpgHackers are growing bolder by the day, taking on huge organizations like the IRS and Sony Entertainment, and forcing businesses to stay on the defensive at all times. In spite of this, what can the average small business do to keep themselves safe? For starters, you can integrate multi-factor authentication, a solution designed to make it extra difficult for hackers to access online accounts.

0 Comments
Continue reading

Tip of the Week: 5 Ways to Make Using Word Better

Microsoft Office is possibly the most well-known suite of software solutions out there, with Microsoft Word probably being the first of the suite’s included programs to come to mind. We’d also wager that most people don’t know all of Word’s capabilities. This week, we’re taking a closer look at some of Word’s handiest, but relatively unknown, features.

0 Comments
Continue reading

Recent News

Our business began its journey with the purchase of a personal computer back in 1992. This purchase ignited a passion with Chris Chase, our CEO, and there was no stopping its momentum. Less than one year later, he had his first IT support client (and...

Understanding IT

Get the Knowledge You Need to Make IT Decisions

Technology is constantly evolving, and keeping up can feel overwhelming. Whether you want to understand cybersecurity threats, explore automation, or learn how regulations like PCI DSS impact your business, we’ve made it easy to access clear, straightforward insights on key IT topics.

Insights to Understanding IT

Contact Us

330 Pony Farm Road Suite #2
Oneonta, New York 13820

Mon to Fri 9:00am to 6:00pm

support@directive.com

(607) 433-2200