BCTI Blog

Outlook Meeting Invitations Deleted After Accepted… WHY?!?! (March 6, 2017) - Outlook is an indispensible application when it comes to maintaining communication with friends and coworkers.  Microsoft has packed an array of wonderful features into Outlook to assist in this endeavor.  However, there is an interesting “feature” in Outlook that, for some people, seems to go one step too far in helping and actually doubles back […]
Excel Color – Order of Application (Hierarchy) (February 20, 2017) - Have you ever wondered why Excel, on occasion, will or will not color a cell according to your instructions?  The reason may lie in the order by which Excel applies colors. Excel applies colors in layers.  These layers are comprised of three criteria: Colors automatically applied via the implementation of a Data Table Colors manually […]
iPhone – Make a Call Without Unlocking Your Phone (February 20, 2017) - Apple’s iOS 10 has some amazing new features.  Performing a simple Google search can reveal dozens upon dozens of neat tricks.  The following trick has become a fast favorite amongst iPhone users. Placing a call without unlocking your phone It is well known that you can make an emergency call to 9-1-1 on any cellphone […]
Restoring FIND Keyboard Shortcut in Word 2016 (February 17, 2017) - There’s nothing like a good keyboard shortcut to help improve workflow efficiency.  Most Office users quickly learn the standard keyboard shortcuts, like CTRL+S for SAVE or CTRL+P for PRINT, but what about CTRL+F for FIND?  This is a great way to bring up the FIND dialog box. Somewhere along the way, Microsoft, in its infinite […]
Excel IFS and SWITCH Function (Say Goodbye to Nested IFs and VLOOKUPS On Small Tables) (February 6, 2017) - Some of the first functions that a newly-titled “power user” learn are IF and VLOOKUP.  The IF function provides the user the ability to ask a question and perform action “A” for one answer and action “B” for another answer.  The catch is that any question posed must be answerable as either “true” or “false”. […]
Two-Way Lookup with the Intersection Operator (February 3, 2017) - Locating a specific item in a table based on two separate criteria can be a challenging task, even for the most ardent Excel user.  Take the following table, for example: Suppose you wish to locate the sales for the Southern region in the month of March.  You could try to write a sophisticated VLOOKUP with […]
VLOOKUP–Looking to the LEFT! (January 20, 2017) - Anyone who has ever used Excel and needed to query a table for information has no doubt used a VLOOKUP function.  VLOOKUP is one of the most widely used functions in all of Excel.  But even the most popular things in life are not without their shortcomings. The single most vexing problem for VLOOKUP users […]
How Big is a Spreadsheet? (January 10, 2017) - Have you ever wondered just how large an Excel spreadsheet really is? When it comes to entering data, Excel spreadsheets have grown larger and larger over the years.  In Excel’s infancy, spreadsheets were only 256 columns wide and 16,384 rows tall.  Over the years the number of columns remained at 256 but the height grew […]
Using Excel MODE Function to Return a Text Response (January 5, 2017) - Excel’s MODE function is a great tool for returning the most frequently occurring number in a set of numbers. But what if you want to return the most frequently occurring word in a list of words? MODE with Numbers Using the MODE function in Excel is quite simple; you point to a list of numbers […]
Add Dropbox to Office 2016 (December 23, 2016) - We’ve come a long way over the years when it comes to where we store our files.  In the 80’s and 90’s it was all about local storage; the venerable C:, or “C-drive”.  Then in the 2000’s, when connecting all of the office computers together on a network became the norm, companies told us not […]
Send “Out of Office” Replies from Outlook (December 20, 2016) - You can send automatic “Out of Office” replies from Outlook 2013 or Outlook 2016 for Windows whenever you want to let people who send you email know that you won’t be responding to their messages right away.There are two different ways to set up automatic replies. The method you choose depends on the type of […]
Conditional Formatting with Subtotals in Excel (December 9, 2016) - Just as there should be a Nobel Prize for the person who put a screwdriver in the end of a power drill, thus inventing the Power Screwdriver, there should be a Nobel Prize for merging the abilities of Conditional Formatting with the Subtotals tool in Excel. If you have ever used the Subtotals tool to […]
Never Miss Another Public Holiday (November 23, 2016) - In the spirit of Thanksgiving, this week’s blog post will deal with managing holidays in Outlook. Do you have trouble remembering which day Labor Day is on versus Memorial Day?   Ever show up for work one morning just to discover that the office is closed for President’s Day and you could have slept late?  Well, […]
Supercharge Your VLOOKUP Functions in Excel (November 18, 2016) - Any Excel user who considers themselves a “power user” cannot make such a statement with a straight face without knowing how to use VLOOKUP functions. Of all of the ways to retrieve information, the VLOOKUP function is without debate the most popular means of looking up and returning information from an Excel list.  It’s not […]
Create a Video in PowerPoint 2016 (October 26, 2016) - If you have ever been tasked with creating a video to demonstrate come process in an application, like creating pivot tables in Excel or performing a mail merge in Word, you probably had to spend a bit of money on some screen capturing software.  There are many great programs on the market designed specifically for […]
Office 2016–New Chart Types (October 12, 2016) - As a seasoned producer of charts, you have probably wondered why Microsoft has not included certain type of charts that have previously only been available via third-party add-on programs.  Microsoft has heard your calls and added some new and exciting charts to the Office 2016 charting engine.  These charts type are not just available in […]
QlikView–Creating a Master Calendar (October 10, 2016) - If you’ve ever struggled with constructing a master calendar for a QlikView data model, this post should help reduce your stress levels. If you’re unsure of what the purpose of a master calendar is, a master calendar helps reduce the redundancy of date information in a data set.  Imagine placing in a table a year’s […]
Apply Two Different Number Formats to a Single Field (Excel Pivot Tables) (September 30, 2016) - There comes a time in every Excel Power User’s life when they must deal with mixed content in a single field.  Examine the following table: The Value field (column E) contains a mixture of sale amounts (values as decimals) and discount rates (percentages.)  If a pivot table is constructed using this data, it can take […]
Missing Resources in Microsoft Project Resource Pools (September 8, 2016) - If you work with Microsoft Project and have ever leveraged the power of Resource Pools across multiple projects, you may have encountered a strange behavior when assigning those resources. When you share resources between a Resource Pool file (a dummy project file that typically has no tasks but is merely a container for holding resources) […]
iPhone Trick – View an Email Message While Composing Another (September 2, 2016) - Have you ever been composing an email message and realize that you have to check something in a different message?  If you’re like most people, you save the message you are currently composing as a draft, close the message, open the OTHER message to get the needed information, close THAT message, and then reopen the […]
Automatically Refresh Pivot Tables in Excel (August 26, 2016) - Excel PivotTables are one of the greatest tools in the spreadsheet user’s toolkit. However, there is one tiny bit of functionality that appears to be missing: the ability of pivot tables to automatically update when information in the source data changes. Most user’s see this as a glaring lack of functionality. There is, however a […]
10 Word Features that will Improve Your Workflow (August 16, 2016) - With so many features packed inside each Microsoft application, it’s easy to overlook some that can really add value to your daily workflow.  Below is a list of some of the features you may have never noticed but will quickly become part of your daily routine. Styles Styles are not only a great time-saver, but […]
Sandvik 2 BCTI Contributes $10,000 in Computer Application Training to Sandvik Mining (July 20, 2016) - BCTI has announced a $10,000 contribution for desktop application training to Sandvik Mining and Construction Co., Bristol, Va. BCTI is providing Sandvik employees desktop computer training, which includes Windows 7, Microsoft Word, and Microsoft Excel to assist them in finding new jobs as quickly as possible. “Giving back to the community is important to us […]
Welcome (July 18, 2016) - Welcome to BCTI blog