Creating Art in Excel

How many times have you been there? Hours of compiling and scrubbing data. Then days at the keyboard to get the Excel formulas and marcos just right so reports run correctly. Followed by the arduous back and forth of End User Testing only to hear “Can you make it look better? It just looks too […]

Read more

New AI Features Available in Excel

Excel is an incredibly useful piece of software that can be found in offices across the world. However, many of the companies that use this software aren’t taking advantage of the full range of features. Microsoft recently added some new AI based features to Excel that can make this software tool even better. Ideas – […]

Read more

Create a Heatmap from a Large Data Set using Excel’s Power Maps

One of the exciting new features of Excel 2016 is the capability to generate geographical maps. This feature, called Power Maps, is now also available for Excel 2013. The types of maps that can be generated with Power Maps are only limited by your imagination! After covering the basics, we will demonstrate how to create […]

Read more

Why You Should Customize Your Excel Dashboard

When you implement the use of business dashboard reporting in Excel, it offers a number of benefits. You can use the information to make important decisions, develop strategies, and more. With a customized excel dashboard in place, you can have an effective view of the data, and give you and managers information they need to […]

Read more

5 Preparation Tips for a Software Development Engagement

If you’re about to embark upon a software development engagement, you may be wondering about the best way to gather and communicate your requirements.   Here are five tips that will help put everyone on the same page from the start: Create a list of definitions Create a diagram List the functional requirements List the non-functional […]

Read more

How to use Excel for Forecasting, Scheduling and Analyzing Staffing Levels

Five Key Features of an Excel Staffing Application: Forecasting Human Resource Needs Forecasting Human Resource Availability Allocating Human Resources to various Projects, Locations and Business Unit Comparing Allocated vs Needed Staff Generating Reports for Management and Regulatory purposes It’s common for organizations to start out with a simple Excel spreadsheet to manage their staffing needs. […]

Read more

How to Hire Professional Excel Programmers

If your company is growing and is in need of a better software management system, it’s highly likely that you may need one that is specifically customized for your business practices. You may already have one in place, but find that it’s still taking more time or more people to execute a certain task. In […]

Read more

Why Real Estate Analysts Rely on Excel

Analysts Need Support, Too Managers of real estate investments tend to rely on internal analysts to provide the reports needed to manage their properties effectively. These analysts are likely well trained and experienced Excel users and may even have VBA experience. However, just like managers need their analysts, the analysts need reliable support for their […]

Read more

Microsoft Ignite: 5 Features to Know About

At the end of September 2017, Microsoft held its annual Ignite conference, showcasing the new and upcoming products from its roadmap. Included were updates to the search interface, Office 2019, and more. Below we’ve listed the top five features which will bring new and exciting enhancements to business owners: 1. Office 2019 will be available […]

Read more

Dynamic Excel Filters in Microsoft Excel

Remember that complicated home renovation and/or furniture assembly project you convinced yourself to work on independent of expert help? If you’re anything like the average human being: Any instructions appeared to be presented in every possible language except one(s) you could understand. You had to make at least three trips to the hardware store to […]

Read more