Blog Feed
Learn about the Excel Find Formula
Sometimes getting valuable or actionable information out of your data is a bit like going on a treasure hunt: You spend a lot of time solving puzzles and putting together a "map" of formulas that will hopefully lead you to the goldmine of information hidden inside. The FIND function, and…
Read More
How to Remove Spaces in Excel Data
Does this sound familiar? You are searching for data that you know you've entered, but a query for Joe Smith simply doesn't return any results. Or, how about – you are trying to add up two columns of numbers, but you keep getting errors. Often, these issues are caused by…
Read More
Use Excel Data Forms to Simplify Data Entry
Spreadsheets are valuable tools for organizing, manipulating, and analyzing data. But first you have to enter the data. This can be the least fun part of building a spreadsheet, especially if you have many columns of information that scroll horizontally off the screen. It can also be easy to introduce…
Read More
The Importance of Business Communication for Your Organization
Companies understand that internal communication is important to their business operations. Still, many fail to implement deliberate internal communication programs that address broader corporate needs such as revenue goals, brand consistency and company values. As a result, middle managers, co-workers, media, friends and outside organizations determine what messages employees receive.…
Read More
How to Improve Business Communication
The idea that “people work for people, not for a company” is even more relevant in today’s work environment than when it was conceived. Modern employees are more independent and demand more flexibility from their work environment. Teams are more geographically dispersed and more employees telecommute than in any other…
Read More
Technology in Business Communication
The technology explosion of the past two decades has left businesses running catch-up. It’s easy for an individual to use a smart phone, but how does a large, or even not-so-large, organization leverage that convenience into business advantage? In some cases, communication technology has even harmed efficiencies by introducing tools…
Read More
Developer Tab: Find the Tab that You Need for Macros, VBA and More
Does this sound familiar? You open a workbook that contains macros and see a Security Alert message. You can’t find the Macro Dialog Box, and you can see that all VBA content is disabled by the default version of the program. How familiar are you with the Developer tab? If…
Read More
About Excel Formula Syntax: The Language of Formulas and Functions
Excel makes it a simple task to perform mathematical operations. Using Excel formula syntax, you can calculate and analyze data in your worksheet. As a reminder: Formulas are equations that combine values and cell references with operators to calculate a result. Functions are prebuilt formulas that can be quickly fed values without…
Read More
How to Record an Excel Macro (Part 2)
Do you want a practical way to make repetitive tasks in Excel easier and faster? Say you receive a spreadsheet every week from a reseller that markets your products. You perform the same changes weekly to adjust the format of the sheet to your company’s standards. You also run a…
Read More
Excel Macro Examples for Use (Part 1)
How much of your time do you spend on spreadsheets? You manually enter line after line of data and then painstakingly format it. This method might be fine for small, infrequent jobs, but imagine the time that could be saved if repetitive steps were automated! There are numerous Excel Macro…
Read More