Archive for tutorial

How to Create and Use Excel Macros

Microsoft Excel has a feature called macros, which records of a set of actions. You can record common processes and run them later to automate your actions. Follow these steps to create and run a macro.

How to Merge Excel Files with Different Headers in Power Query

When you try to merge these files, some columns may disappear, and some cells might list “null” instead of your data. Follow these steps to properly merge these files after you have combined them in Power Query.

How to Email Someone Your Calendar Using Outlook

Microsoft Outlook has made event scheduling and collaboration easy with the calendar feature. Follow these step-by-step instructions to share your calendar with people inside and outside your organization.

How to Use Flash Fill in Excel

Entering a high volume of data into Excel can be a tedious process. Once you learn how to use Flash Fill in Excel, you can seamlessly extract and enter data into your spreadsheet.

When to Use Drop-Down Lists in Excel

Excel spreadsheets are designed to be user-friendly, and tools and features like drop-down lists make data entry even more accessible. Drop-down lists in Excel can help you compile data faster and more accurately than ever.

How to Complete a Network Build-Out at a New Office

Moving to a new office? Building a network is a sizable job. Learn about the right equipment to optimize the setup for speed, security, and reliability.

Phishing Attack Targets Financial Services Executives

A phishing campaign is targeting Office 365 users specifically at financial services firms, and have compromised over 150 businesses.

How To Detect Phishing: A Beginner’s Guide

Here are some helpful tips to spot phishing attempts, not only for hedge funds and private equity firms, but for all organizations.