MSPNetworks Blog

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.

Tatsuo Horiuchi Excels at His Craft…

…in a very literal sense. His art is not formed by clay or paint, but instead, the cells found in a Microsoft Excel worksheet.

Upon his retirement from his work as a medical equipment engineer, Tatsuo wanted to keep himself occupied, and his thoughts turned to becoming an artist. Lacking the supplies to do so traditionally (as well as the desire to invest in these supplies), the burgeoning artist decided to utilize a tool that he already had access to: Excel.

As he had never actively used the software for his work, Tatsuo dove into learning about the software and its features, teaching himself how to use different tools to accomplish different things. The autoshape feature helps with the overall design, the graph-focused line tool was repurposed to create trees, and the fill tool allows him to accomplish the shading that amplifies a painting’s depth. Gradually teaching himself these little tricks, Tatsuo’s process began in 2000 with the goal of creating something he would be willing to show to people within 10 years. His first three years were focused on learning to use Excel’s tools to create recognizable shapes and objects, while the next three were focused on combining them all into a cohesive image. In 2006, he won the Excel Autoshape Art Contest.

Since then, Tatsuo’s art has been featured at the Gunma Museum of Art, an honor shared by the likes of Monet and Renoir.

You can check out some of his work here.

One Moral of the Story: Technology Can Be Leveraged in Many Ways

All it takes is a bit of ingenuity. That being said, we don’t want your business to go without the information technology that would benefit its processes—or that keeps it compliant with various regulations and requirements.

Our team at MSPNetworks has been helping businesses around New York manage their IT since YEAR, and we’d love the opportunity to help you with yours. While we can’t promise to turn your team into award-winning artists, we can help them do more with their technology. Find out more about our managed IT services and what they can help you accomplish by calling (516) 403-9001.

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.

Let’s walk through the process.

How to Use Excel to Mass Generate Folders (and Even Subfolders!)

Rather than manually going through, creating and naming each folder you need, Microsoft Excel enables you to automate the process somewhat. The trick revolves around you creating a Windows Batch file—a type of file that contains a script that executes predetermined commands in a specified order.

The process is as follows:

• In one column, list all of the names your different folders need to have, whether that’s a month and year, each of your team members’ names, or your different departments.
  
  
• To turn this into a batch file, you first need to add a second column that formats this data in a very specific way. Let’s assume that you wanted a folder for each month of 2024, for instance.
  
  
  
  • Your first column will be your list of months, January, February and so on, with cell A1 formatted as “2024 - January” to help avoid Excel auto-formatting your data.
    
    
  • Your second column will have the batch command filled out. This will require the following formula to be used:
    
    ="MD "&""""&A1&""""
    
    Dragging the bottom corner of your top cell down will populate the rest of your list, referencing the proper cell in the first column to complete the formula.

• This will give you a list formatted as MD “2024 - January” and so on. Copy and paste this data into your Notepad application.
  
  
• Once your batch commands are copied over, save your Notepad file as a .bat file format wherever you want your folders to be saved. Clicking this file will generate the folders where the .bat file was located.

Hopefully, this will help you to more quickly create the folders you require for your assorted needs.

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.

What are People Graphs?

People Graphs are a Microsoft Office Add-In that allows you to create a quick data visualization. While the default icon included in the People Graphs is, predictably, a person, the graphs can be customized to display different icons—from a star, a heart, a clock, a bag of money or various others.

Let’s go over how you can create these simple graphs to present simple data points to your advantage.

Creating a People Graph

First, you need to have the data you want your People Graph to depict in your spreadsheet. Let’s assume that you wanted to share some statistics concerning the work/life balance habits of today’s workers. In one column, list out the stats you want to share, and in the next, list out the numerical values associated with these statistics.

Select this data range. Then, in the Insert toolbar, select People Graph under Add-Ins. A premade graph will appear on your sheet. Select the Settings option, which will appear in the top-right corner when you click on the graph.

From there, you can customize what your graph looks like, its color scheme, and the shape of the icon itself.

Once you’re pleased with the appearance of your graph, you can then select the grid button that appears next to the settings option. From there, you can customize the title and select the data that your graph pulls from.

Once you’ve selected the data, click Create, and your People Graph is complete.

Hopefully, you find plenty of use out of this capability!

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.

Some Shortcuts Apply to All of Microsoft Office’s Programs

One thing that Microsoft has historically focused on in its Office suite is consistency. The interfaces are all similar, the menu options (so far as they overlap, at least) are arranged the same, and many of the keyboard shortcuts you learn in one of Microsoft’s apps will do the same thing in another.

A great example of these are the basic formatting tools: Bold (Ctrl+B), Italic (Ctrl+I), and Underline (Ctrl+U) are the same across Microsoft applications, just like saving a file can be accomplished by pressing Ctrl+S and printing a file can be done through Ctrl+P.

There are plenty more examples of these, so don’t be afraid to try some out and see what works for you (just don’t experiment too much on anything important).

Find & Replace Does More than You May Have Considered

Even at first glance, Find & Replace is an obviously useful utility. Calling up the box to use it (handily, filed under Editing in the Home ribbon) allows you to find all instances of whatever text you specify, with the option to change it as needed. Again, that’s just useful.

However, Find & Replace offers even more just under the surface. By selecting Advanced Find, you’re presented with a much larger box that gives you many more options, from matching the case to finding words that match the word’s prefix—and allow you to replace them en masse. This is even the case with features like page breaks and other formatting elements.

Personalizable Ribbons Make Office Work Your Way

Speaking of the menu ribbons (the menu bars across the top) that all of Microsoft Office’s programs feature, they can all be customized to suit the individual user’s needs. While it will likely take some doing, one of your users can adjust a single ribbon to cover the majority of their needs while getting rid of things that they just have no use for. This is great for saving the time otherwise spent searching for functions buried deep in the menus. It’s also easy to access, as it can be found under File > Options > Customize Ribbon.

Hopefully, making these adjustments to the way you use Microsoft Office’s programs will help boost your overall productivity. For other ways to improve your business’ operations through the technology available to us today, give MSPNetworks a call at (516) 403-9001.

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.

In PowerPoint 2016

Here is the process you’ll need to follow to embed a video into your presentation:

1. Navigate to YouTube and find the video you want to include in your presentation. Find the Share option and select Embed from the menu that appears when you click into it.
2. You’ll see a preview of your chosen video’s thumbnail, along with a series of code and some other options that allow you to control the point from which the video starts, whether your embedded video will provide viewers with controls, and the ability to enable a privacy-enhanced mode (which pertains more to videos that are posted on a website). Copy the code in its entirety.
3. Back in PowerPoint, click into the Insert tab and select Video. Select Online Video from the provided drop-down.
4. A box will appear. Paste the code you copied into the From a Video Embed Code field. Alternatively, you could attempt searching for the video you wanted to use using the YouTube search field.

In PowerPoint 365

PowerPoint 365 requires a similar process:

1. Find the video you wish to embed on YouTube and copy its URL from the address bar.
2. In PowerPoint, click into the Insert tab and select Video, then Online video…
3. Paste the URL into the Online Video dialog box.
4. You can also add various effects to the video preview (not the video that plays) via the buttons in the Video Format tab.

Whichever version you use, Microsoft PowerPoint has historically been an excellent tool, provided you know how to use it properly. The same can be said of most business applications available today.

MSPNetworks can help you acquire these solutions, along with the rest of the business technology management services we offer. To learn more about what we can do for you and your operations, give us a call at (516) 403-9001.

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.

Dark mode and Night mode options have been showing up a lot lately, especially in mobile apps. Twitter, Amazon Kindle, Evernote, Gmail (on Android 10), and Firefox (on iOS) have all deployed a mode that makes the background of the application dark, and the text light.

For most, this makes it easier to view your screen in a dimly lit area without straining your eyes. For those of us who spend a lot of time in front of screens, it can be a huge difference.

I was using Microsoft Word the other day, and working on a long document and I was starting to feel a headache coming on. It reminded me that Word had some settings for changing the theme, and I wondered if they had finally added a dark mode.

(Note that I’m using the PC version of Microsoft Word, not the mobile version)

While in Word, click File and go to Options. On the General tab, under Personalize your copy of Microsoft Office, you can change the Office Theme to Black.

I got pretty excited because it seemed like that was exactly what I was looking for, but to my chagrin… 

Alright, so changing the office theme only makes the surrounding area (including the tool ribbon) darker. That’s a start, but the brilliant bright white of the document area was still burning away at my retinas. I wasn’t totally content with this, but I found a trick that takes this one step further.

The Trick for a Real Microsoft Word Dark Mode

I totally understand why Microsoft Word doesn’t let the office theme change the background and font color of the document. Afterall, a lot of documents get printed or sent as PDFs, and they want you to get a feel for what the document would look like if you were to print it. They don’t want the user getting confused and thinking that it will actually make them print a full sheet with a black background and white text.

This rationality wasn’t doing much for my headache, and I was determined to find a fix for it.

It’s actually really easy too!

NOTE: I want to point out that I definitely do not want to print my document with a black background and white text, I only want to view the document that way when I’m editing the document.

Go to the Design tab on the tool ribbon at the top of Word and click on Page Color.

If you don’t see Page Color, try clicking on the Magnifying Glass at the very top of Word towards the right, and type Page Color instead.

From there, choose one of the darker colors. You’ll notice your document will change as you hover over the different color options. The lower values tend to make the text light. I usually choose the second option from the bottom in the second column, as indicated above.

If you ever want to switch it back, go back to the Page Color option and just choose the white box on the top left of the color grid.

Keep in mind that this only changes on the document you are working on, and doesn’t affect your other documents. If you save the document and share it, and someone else opens it, they will also see the dark background.

Before Printing, Be Sure to Preview

I had no problem printing my document after changing these settings, but older versions of Microsoft Word might not behave the same way. Let’s say you did want to print this document, but obviously didn’t want to waste a ton of ink by printing a black background.

In my experience, you just need to print the document normally, but just to be safe, you can either go back to Page Color and set the color back to white, or before you print, review the preview Word shows you.

If the preview is white text on a black background, you’ll need to either go back to Page Color and switch to a white background, or you can tell Word to always ignore your background colors.

To do this, click on File and Options. Go to the Display tab and look for the Printing Options area. Make sure Print Background Colors and Images is unchecked, and click Ok.

Then, you never have to worry about wasting a ton of ink when you print your document.

Hope this tip helped! For more great tips, keep coming back to our blog!

A database is an incredibly useful tool for organizing a lot of information in a relatively concise and accessible way. Did you know that you can use a relatively common program, Microsoft Excel, to generate a database for your business to use? For this week’s tip, we’ll walk you through this process to help you keep your data organized.

Step One: Enter Your Data
Opening Excel, your first step should be to enter the data that is to be included in your database - however, it is important that you do this correctly. If you are using a title, the only space between any of your inputs should be a row between the title and the data you are organizing. This includes empty cells, so you’ll want to make sure you determine a standardized placeholder to avoid any of your cells being unpopulated. This “no space” rule applies to the labels on your records and fields in relation to your data as well.

Records and Fields
In your new database, each row should represent an individual record, with each column serving as its own field.

• Each record should pertain to a single item in the database. Depending on what your database is organizing, this could be a specific piece of equipment in the office, or a particular employee… essentially, any single unit out of the contents of the database.
• Each field, on the other hand, dictates what information about the item is to be placed in the cell. This might be the price a certain item had, the date it was brought into the company, an employee’s middle initial… again, whatever piece of data should be the one in that particular column.
• Make sure you are consistent in how you input your data. For instance, don’t start by entering numbers as digits and suddenly transition to writing them out.

This will require you to set particular standards for data collection, as you will want to be sure that your records are as complete as possible. You will also need to stick to this organizational pattern, so you will want to make sure that you figure out what works for you early on.

Step Two: Convert Your Data into a Table
Now, you will want to create a table out of your data. To begin, highlight your data, with exception to your optional title and the placeholder space that separated it from the data. In the Home tab, open the Format as Table menu to select your choice of table.

This will add drop-down boxes to the field titles, allowing you to sort your data by the criteria you wish, without the concern that your data will be lost.

Step Three: Expanding Your Database and Putting It to Use
Of course, chances are that you will need to change the contents of the table, adding more records as your business continues. Excel makes it relatively simple to do so, with a simple click-and-drag interface.

To expand your table, simply hover over the bottom-right corner of your table, as indicated by a small dot. Your cursor should convert into the double-headed arrow icon. Click and drag downward to add the number of rows - or records - you have to incorporate into your table. Then all you have to do is add the new data in the proper fields, and your table has expanded.

Of course, as your database grows, it’ll become harder and harder to interpret due to information overload. At least, it would if Microsoft hadn’t incorporated a means to rectify this shortcoming as well. You can filter the data that your table displays, hiding the records that don’t apply to the criteria you set your filters to. Mind you, this doesn’t delete the data - you can easily display it again by clearing your filters.

To use your filters, click the drop-down arrow on the field category that you wish to filter through. You will see a few options, with a search bar and some checkbox options below it that specify each entry in that column. You want to uncheck the (Select All) option, and instead check the checkbox option that correlates with the data you want to view specifically. Once you’re ready to see your complete data, you can go back in and select the Clear Filter from option.

This is a very basic version of a database, but it can help serve you well in many ways. Are there any other uses you’d like to know about, let us know! Leave your questions in the comments, and for help with any of your bigger IT concerns, give us a call at (516) 403-9001!

The funny thing about some documents is how the data written on them can strongly influence how important they are. If, for instance, there were two pieces of paper on a table, there is objectively no difference between the two, and so they are objectively equivalent in value.

When Documents Aren’t All Created Equally
However, if one sheet has a picture of a cat on it, and the other one has the coordinates to the lost city of El Dorado, one page suddenly has considerably more value than the other. This happens all the time with documents in a business setting, and depending on the business, many of these documents can be basic text files. With the popularity of the Microsoft Office software titles, there’s also a fair chance that the go-to word processing software in your office is Microsoft Word.

Microsoft Word offers many business-friendly features that many of its users don’t know about - including the capability to protect a document with a password. This allows a document’s creator to restrict access to only those other users who need to have this kind of access for review or collaboration purposes. Doing so is relatively simple:

Adding a Password

• In the File tab, select Info
• Select the Protect Document button and find Encrypt with Password in the drop-down options. You will be presented with the Encrypt dialog box.
• In the provided space, enter the password you want to use. These passwords are case-sensitive and cannot be recovered if forgotten. Keep this in mind before resorting to this option. Once you’ve settled on a password, click OK, confirm your password by typing it again, and click OK again.

Just like that, your Word document will require that password before it can be viewed. This process works whether you’re using Microsoft Word 2016 or Microsoft Office 365.

If you ever need to remove the password from this file, you will actually follow the same steps until you reach the Encrypt dialog box. You should see the password you chose in the provided space. Delete it and press OK.

Your document should now again be available for hypothetically anyone to access, assuming that they have the ability and authorization to do so. For more tips, subscribe to this blog, and for more solutions to assist your security and operations, reach out to MSPNetworks directly at (516) 403-9001.