Articles & Videos
Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.
Excel 2016/Win 10:
Please see the attached scrubbed spreadsheet (scene schedule for a novel). The first column (chapter) contains merged cells b/c chapters can contain multiple scenes.
I have 4 databases setup on one Exchange 2013 standard server. Everybody on mxb01 can see each others free busy without problems. Everybody on mxb02 can see the free and busy of everybody else on …
I have a list a IP address' that correspond to specific locations. As IP address' go however, there are variations in the last digits. For instance, the Albuquerque office has IP address 184.108.40.206 …
Hi I need to remove names in data that is in a string in excel.
Currently looks like this:
I have been provided an excel sheet from my management.It has 2 sheets.The first has all the raw data and the second has the summarized view of the first with all the formula.
Iam trying to …
I have two sets of data that each have a column that has a unique ID. I need to pull data from one sheet to the other based on that unique ID.
Please see attached spreadsheet for example.
Does anyone know how to use data from one cell to create the hyperlink for another cell?
1 http://google.com …
I have Office 2010 and I changed my router. It now says it detected new hardware and must be activated. I have the product key but it will not let me activate using the internet because it say I have …
I've created a relatively complex network drawing. However, I'm now being asked to provide a power point slide, and everything I've tried has consistently either skewed the drawings so it's …
I’m searching a good service that can convert PDF to OCR. It would be a plus if we can rotate image.
I found these services:
I'm using Windows 7 (up to date) and MS Office 2013. When ever I use print preview it hangs and says searching for printer; it finds the printers after waiting a while. My print drivers are up to …
I have some figures related to a count of folder items/files. Does anyone have a graph via Excel or another program that they would recommend to base projections on?
Is there a way to turn off the notification email when someone accepts or declines your calendar invite?
XenDesktop 7.5 with 7.5 VDA and PvD running Windows 7 Enterprise
Standard Windows domain
After streaming a new vDisk to three VDAs, I am not getting consistent…
How do I write a formula in a cell using the key words like percentage.
Say in Cell A2 I have the number 480. And in B2 I want to write a =sum formula, 25% of A2. What is the syntax please? …
If I select both columns, then on the home tab select conditional formatting>duplicate values, fill with light red, I get no results. But meald shows up in both columns. Why would that not highlight? …
I have a batch file to install MSoffice in MDT. After installing MSOffice command prompt screen wont go away. So the Lite touch installation wont go away and deployment stuck there.
Here is the batch…
I have table like this
Month | Year | Date I Customer Name | Metric1Sales | lastSixMonths_NOMetric1Sal
January|2016| 1/1/2016 ISafeway | 400 | |
I am using excel 2016 and when I open any excel file or clean file I'll get "Excel has stopped working.
A problem caused the program to stop working correctly. Windows …
There is table in SQL Server called history log. And it looks like this
Month | Year | Customer Name | Metric1 | DateReceived
January|2016|Safeway | 400 | …
I have an image repository that died and it held my Office 2010 H&B installer, specifically 64 bit, filename x17-22375.exe. Client's pc died and needs to be replaced, and they have a …
I have a user with Office 2016 Home and Business on her Desktop. She needs Access so added in a spare 2013 license that we had.
It installs but when I try and run Access I get "Automatic …
Trying to find a good review (personal experiences with both products) on people who have gone from a stand alone Office suite (Office 2010/2013/2016) to a more cloud based suite (Office 365). What is…
what are troubleshooting for users related to microsoft office
or which errors , normal users can solve on microsoft office 2010 ( word/excel/outlook/powerpo
I recently installed Microsoft Office 2013 on a new computer and was disappointed to discover that Microsoft Office Picture Manager is not included in Office 2013. This article explains how to corre…
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dic…
Joe Winograd, EE MVE
Greater Chicago Area, United States
9,848 points this week
Walvis Bay, Erongo, Namibia
6,400 points this week
3,225 points this week
2,800 points this week
2,548 points this week