Microsoft Applications

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

spreadsheet with rules
This article addresses the need, sometimes extreme, for a legend that may not be easy to create, depending on the features of conditional formatting you have used. Almost all spreadsheets need some sort of legend.
0
C++ 11 Fundamentals
LVL 13
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Microsoft Office Picture Manager
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in 2013 or 2016. Now that Office 2019 is here, the bad news is that it is still missing, but the good news is that the same no-cost method that works to install it with Office 2013 and 2016 also works with 2019.
2
How Machine Learning Is Changing Our World
0
merge multiple pst files into one
Learn how to merge PST files in Outlook 2016, 2013, 2010, 2007. The article explains the quick manual solution to merge Outlook PST files into a single file without losing any data. The post also suggested easy to use tool to merge PST files and remove duplicates
2
Microsoft's Excel has many features that most people will never need nor take advantage of. Conditional formatting is one feature that you may find a necessity once you start using it.
2
Fonts
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how to install downloaded fonts.
8
LVL 28

Expert Comment

by:Brian B
That is a really useful article, Andrew. Thanks for sharing.

A question though, back in the "old days" by my standards, you weren't supposed to share fonts because many of them were sold separately and were considered to be under the software license of the product they worked with. I would assume if you can get the font from Google that it is safe, but are there still instances of those IP fonts today that aren't supposed to be shared?
0
LVL 29

Author Comment

by:Andrew Leniart
Hi Brian,

An excellent observation. With regards to safety of available fonts, I can only assume that all submissions are checked by Google in this respect before a listing is accepted, so while never beyond the realms of possibility, am confident that a malicious font download is unlikely.

I'm sure there are many fonts to be found on the web which are not supposed to be shared as you've rightly pointed out, however with every font downloaded from the Google Fonts site, there is also a license agreement included within the downloaded Zip file that specifies which usage license the font has been released under.

In the case of the illustrated "Lato" font used in my example, that particular font has been released under the Sil Open Font License (OFL) and comes with the following conditions when downloaded.
PERMISSION & CONDITIONS
Permission is hereby granted, free of charge, to any person obtaining a copy of the Font Software, to use, study, copy, merge, embed, modify, redistribute, and sell modified and unmodified copies of the Font Software, subject to the following conditions,
The list of exclusions are as one would expect for most open source material, such as preventing the sale of the font by itself etc, however for personal or commercial use within other products, there's no problem.  This could differ of course with each font that's made available so it always pays to check what rights are provided. Font families not available on Google Fonts and found on other font distribution sites would of course contain their own rules and restrictions, which should always be respected.

I hope that answers your questions and thank you for your feedback and up-vote. I very much appreciate it. Regards, Andrew
2
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
0
Decision Making
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
28

Expert Comment

by:Brendan Wilson
This is an excellent article. I appreciate you taking the time to write this.
1

Expert Comment

by:Judy Deo
Thanks for taking the time to post this in such detail. Appreciate it.
1
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to do.
28

Expert Comment

by:Brendan Wilson
I read the other article that you wrote, and they both have been very useful. Thank you for taking the time to put this information together.
2

Expert Comment

by:Judy Deo
Wow this was so simple and I did not know it. Nice to know now and I know for sure I will have many opportunities to use this in the future.
1
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)
 

Step 1: Make sure you meet the requirements!


Operating System Requirements

  • Windows Vista (any edition) with the latest service pack
  • Windows 7
  • Windows Server 2008 with the latest service pack
  • Windows Server 2008 R2
(Taken from http://technet.microsoft.com/en-us/library/hh519788.aspx as of 12/9/2014)

Note: I have tested the installation on Windows 8.1 and can confirm it is working here too, leading me to conclude it should also work on Windows Server 2012 R2 as well (although I have not tested this personally).
 

Additional Requirements


  • Microsoft .NET Framework 3.5, which you can download from the Microsoft Download Center.
  • Microsoft Visual Studio 2008 Shell, which must be in the same language as the display language of the operating system. You can install Visual Studio 2008 Shell from the Prerequisites page in the Service Manager Authoring Tool Setup Wizard.
     
Note: During Authoring Tool Setup, if an error appears stating that Microsoft Visual Studio Shell 2008 is not installed and you’ve verified that it is installed, then the Visual Studio 2008 Shell Isolated Mode Redistributable Package might not be installed completely. To install it, navigate to \VS 2008 Shell Redist\Isolated Mode\ and run VS_Shell_isolated.enu.exe as administrator.
 …
1
OWASP: Threats Fundamentals
LVL 13
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

PowerPoint Still Works
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
0

Expert Comment

by:Taylor Swift
I'd like to start a blog so I will be able to share my experience and feelings online. Please let me know if you have any kind of ideas or tips for new aspiring blog owners. Appreciate it!
0
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take you a long step deploying successfully.
2
LVL 68

Expert Comment

by:Jim Horn
Nice article, voted yes.   I think this article can be improved if the script were rendered in pieces-parts code blocks, with helpful text explanation on what the script does, so that experts can get an understanding and manipulate if they have to.
0
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with Office 2013 also works with Office 2016/Office 365.
63

Expert Comment

by:nicohyde
Just wanted to thank you for the clear process for installing the Microsoft Office 2010 Microsoft Office Picture Manager.
Upgraded from office 2007 to 2016, a couple of days ago, and like many others found the picture manager missing, not so good when you are taking 1000's of pics.

Cheers


Nick
0
LVL 67

Author Comment

by:Joe Winograd
You're welcome, Nick. Thanks for letting me know that the method worked for you after upgrading from Office 2007 to 2016. Btw, it also works for the new Office 2019, which I documented in a recent article here at Experts Exchange. Cheers, Joe
1
Main Metering Runbook
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
2
LVL 68

Expert Comment

by:Jim Horn
Nicely illustrated and reads very well.   Voted Yes.
0
LVL 68

Expert Comment

by:Jim Horn
You're welcome.  Nice work.

Speaking of .. my recent article just went Featured Article ... Top 10 Ways to Write Rock Star Articles
0
This collection of functions covers all the normal rounding methods of just about any numeric value - at extreme precision.
3
LVL 60

Author Comment

by:Gustav Brock
Finally I have these assembled. Through the years bits and pieces were collected, but now I had the option for a rewrite.

/gustav

PS: There are minor flaws in the layout but the editor is somewhat strange so I couldn't get it completely straight.
0
LVL 68

Expert Comment

by:Jim Horn
Nicely laid out.  Voted Yes.
0
Windows 10 is spying on you
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the information it can gather - without you knowing!
7

Expert Comment

by:Mark Rhodes
Excellent I will get this set up and Thanks for the step by step
0
LVL 33

Author Comment

by:Thomas Zucker-Scharff
Anytime - just be careful when installing - always use custom install.
0
Delete Emails from Server
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  At least at my institution, one has to show a business need for such an action.  So proceed with caution, and remember if this is an attempt to keep the email you have received so far private, it won't work.  Backups are there for a reason.  An email you receive going forward would not be stored on the exchange server, so would not be accessible as easily.  But anything going through your work network is available to your bosses in some shape or form.

So first, the easiest way to do this is with outlook.  This example will use Outlook 2010 on a windows 7 Pro 64bit computer connected to an Exchange 2010 installation.  One of the only reasons I am writing this is because in the past week I have either had several requests or seen several questions here on Experts Exchange asking for just this information.  

I made a quick silent video of the process here.  the video repeats what is listed below, with some emphasis of what to do when.  It comes down to the following:
  1. Start outlook
  2. When you see the main Outlook window, click on the file menu
  3. After clicking on the File menu you should see the following screen:file-menu.PNG
  4. Click on Account settings and in the drop down click Account Settings again and this screen should pop up:data-files-settings.PNG
0
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring.

SCOM monitors:
 
  • Windows or UNIX/Linux
  • Network Devices
  • .Net application (APM)
  • Java application
  • Web Application as well as URLs
  • More monitoring capabilities by using the management packs which help to monitor specific objects or application….
SCOM has the ability to send you alerts when a monitored object is not healthy, providing you with information about the problem and how to resolve it.
 
The main SCOM components and roles are:
 
  1. Management Server
  2. Resource pool
  3. Gateway Server
  4. Operational Database
  5. Data warehouse
  6. Agents
  7. Services
  8. Managemet Packs
  9. Reporting
  10. ACS (audit collection service)
 
  • Managemet Server:
When you want to install SCOM 2012 and during the setup, you will be asked to create a management group. The MG contains the management servers you want to add to your environment. The management server manages the MG and communicates with agents and databases.
 
  • Resource Pool
When you add another management server to your SCOM environment, the management servers will be members of a resource pool, so you can distribute works between the management servers and grant high availability when a management server member is failed.
 
  • Gateway Server
A gateway server will help you to monitor objects in an untrusted domain. For more details see
0
Many companies are making the switch from Microsoft to Google Apps. Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps.

It is important to note that there is a pricing plan to use Google Apps for businesses. The cost is $5 per user per month or $50 per user per year. The pricing for Microsoft Office 365 is much more complex and expensive.  

First and foremost, for those who are unfamiliar with Google’s office integration platform, Google Apps works similarly as Microsoft Office 365. Gmail and Google Calendar can substitute Microsoft Outlook and Microsoft Exchange. Google Drive contains platforms that are similar to Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft One Drive. All documents made through Google Drive can be shared with others. Google Drive will allow users to edit files in real-time as well.
 
Google Drive includes services such as Google Docs, Google Sheets and Google Slides. These can be accessed online or by downloading the respective app through your smartphone. Through the web you can access and edit all your files through Google Drive. On your mobile device you must download each separate app to use the editing function. Google Drive can sync documents by using the cloud and also allows users to collaborate on files offline. 
 
The most …
13
LVL 13

Expert Comment

by:Greg Hejl
Most folks are to tied to the Office Apps to give up on them.  if you tie Google Apps cost and the cost of Office licensing you might as well get on board with O365 for the online experience as well as the device experience for the same overall price.
0
LVL 4

Expert Comment

by:pchettri
Office365 does offer web version to application access. It is specially useful for saving documents on Onedrive, when you are accessing application form tablet or phone. Most of the plan allows application access for up to 5 devices. For laptop or desktop,  I would prefer full downloaded version which gives option to same on OneDrive or local drives. 5 devices option is same for business essentials/premium, E3 or E5, of course the application and storage varies with plan
0
PMI ACP® Project Management
LVL 13
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings). The Microsoft support team will tell you to open Lync federation for this to work or use the Lync web app instead. How do you expect corporate users to be copying meeting URLs and pasting them into web browser and then insert "?SL=1" at the end of the link?

Problem:

Here is the eror message we get each time we click on join online meeting link in outlook to join a non-federated user's meeting.

For Lync 2010: "an error has occurred during online meeting"
For Lync 2013: "An error occured during the Lync Meeting"

Brief description of our network environment:

Our organization deployed a proxy auto-config file for all users as they access the Internet, firewalls and are doing inpections on all traffic. We do not open Lync federation because our Corporate Security Group declined all requests to do so. After many years of struggling, we resolved this issue without opening federation.

Resolution:

On a user's computer, using Lync 2010, open regedit and navigate to
HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator

Open in new window



Locate "DisableHttpConnect" and change the value of the REG_DWORD to 0.

By default it is set to 1. Use this new setting to enable the Lync …
0
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basically letting the management server know, “Hey I am still ok and here”, the interval is by default every 60 seconds, but this is customizable. When the guys checked these agents they were online and functioning with no apparent issues, so it made me think, the only thing it could be is stale alerts or something wrong with the agents.

Now I love automation and always having some excuse to use Orchestrator, so when the guys asked if I could make it easier for them to automatically get and repair these agents I jumped at it, literally.
System Center Orchestrator is Microsoft’s workflow management solution that allows you to automate the creation, deployment and monitoring in your environment, you will notice that I mention the word “Runbooks”, now runbooks contain the individual instructions for your automation process and each step is called an activity and each of these activities have configurable settings.

While creating mine I found this article from Nathan Olmstead: http://blogs.technet.com/b/systemcenterramblings/archive/2014/03/22/runbook-for-persisting-stale-heartbeat-alerts-in-scom.aspx
2
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how to install it alongside Office 2013 — at no cost!
125

Expert Comment

by:Haleem Abueshah
thank you brother , you are the best :)
0
LVL 67

Author Comment

by:Joe Winograd
You're welcome, Haleem, and my thanks to you for joining Experts Exchange today, reading my article, and endorsing it. Regards, Joe
1
The canonical version of this article is on my web site here:
http://iconoun.com/articles/collisions/

A companion presentation is available here:
http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
16
LVL 16

Expert Comment

by:DansDadUK
An excellent article.

I spent years persuading other people (in the Western world) to use the 8-bit ISO-8859-1 coded character set, rather than switching between various National Language Variants of the 7-bit US-ASCII coded character set in order to use (relatively common) accented characters.

Moving to UTF-8 is the way to go now that 256 characters (strictly 191 graphic characters plus 65 control codes) of an 8-bit encoding is no longer sufficient in our increasingly global environment.
0
LVL 72

Expert Comment

by:Julian Hansen
Great article - thanks Ray
0
MS Access 2003 or later To MySQL Migration Project

Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I find some time to write down my project experience on the same, thought some of you may get some help out of it!

Background Information/Available Alternatives  

The Database Application is built and developed in MS Access 2003, it is further splitted in Front-End and Back-End to perform in Multi-User environment. However, due to more concurrent users, slow network, increasing data etc. the existing architecture is resulting poor performance. To increase the backend stability, application performance and considering zero cost MySQL Server (http://dev.mysql.com/) is being opted.

Business Goals and Objectives      

The business goals and objectives for this project will focus on implementing MySQL backend that:
      
•      A faster Database.
•      Zero Cost.
•      Open Source.
•      Scalability (No more 2 GB Limitation).
•      Heavy Duty Multiple User Capability.
•      Portability for the Back-End Data (PC, Mac etc.)
•      Easy Installation.
•      Easy Maintenance.
•      Provides high levels of data security.
•      Provides an open, flexible, reliable technology base for the future.
•      Easy to Use.


Scope Definition
      
The Project will introduce new faster backend storing and querying technology; including the following:
      
 
•      …
0
This very simple solution applies to a narrow cross-section of the "needs to close" variety.
In this case, the full message in Event Viewer was in applog, Event ID 1000:

Faulting application iexplore.exe, version 8.0.6001.18702, faulting module msxml3.dll, version 8.100.1052.0, faulting address 0x000a1425

Original message was in French:
Application défaillante iexplore.exe, version 8.0.6001.18702, module défaillant msxml3.dll, version 8.100.1052.0, adresse de défaillance 0x000a1425

My user was on a fully patched Windows XP SP3 PC. One Windows update had been installed the previous evening, KB973904. Uninstalling it sped up IE performance, but did not solve the problem of the error message.

Uninstalling and reinstalling IE restored functionality to the user's web-based applications (some Flash and Java), but the error message still appeared when opening a session in the web-based app.

Solution: the error message was ultimately eliminated by going into Add/Remove Programs and repairing MSXML 4.0 SP2 (KB954430).

Hope this helps someone else out!
1

Microsoft Applications

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.