Middlebury

Difference between revisions of "Microsoft Office"

(Excel: Formatting a list of ID numbers)
m
 
(122 intermediate revisions by 8 users not shown)
Line 1: Line 1:
[[Category:Helpdesk]]
+
'''Related link:''' [[Find_Microsoft_Office_Version_Information|How do I find my MS Office Version?]] <br><br>
==MS Word freeze-ups==
+
Information Technology Services (ITS) began installing Microsoft Office 365 on computers provided during the staff upgrade process in spring 2019.
* '''Due to unavailable network printer:''' If a network printer is configured as a default printer and the computer is connected to the internet but the printer is ''not available'' (for example, if the computer is off-campus), Word may hang when you open the Print dialog box. (Acc. some reports, may even cause Word 2003 to freeze on launching.) Solution: change default printer. PDFCreator [http://sourceforge.net/projects/pdfcreator/]?
 
* '''Due to unavailable mapped network drive:''' In MS Word, when you go to Save As..., Word tries to scan all mapped drives listed in the pulldown menu to determine whether they are available. If a mapped drive can't be reached, Word will keep trying to ping it until it finally times out and gives up - but it doesn't learn from this giving up for next time. Solution: Go to My Computer and unmap any unavailable drives - but make sure the user has a way of getting back to them again. (Shortcut on desktop?)
 
  
==Install and configuration==
+
=== Installation Details ===
 +
<br>
 +
===== College-Owned Computers =====
 +
Microsoft Office 365 is available for self service installation on both Mac and Windows '''college-owned''' computers.  <br><br>
  
====Application compatibility====
+
Refer to the appropriate link below for installation instructions:
MS Office versions don't always line up perfectly. Even if it says "MS Office Pro 2003", doesn't mean that your MS Office Pro 2003 disk will work. In many of these cases, the only fix is just to remove Office and reinstall it from scratch, making any needed modifications.
+
* '''Windows:''' Install "Microsoft Office 365 ProPlus" via [[KACE_FAQ#How_do_I_use_KACE_Self_Service_to_install_software_on_my_Windows_computer_myself.3F|KACE Self Service]].
 +
* '''Mac:''' Install "Microsoft Office 365 for Mac" via [[JAMF_Pro_Self_Service_FAQ#How_do_I_use_Self_Service_to_install_software_on_my_Mac.3F|JAMF Pro's Self Service]]  -- requires OS 10.12 (Sierra) or higher; OS upgrades are also available via the Self Service utility.
 +
<br>
  
====Corrupted install====
+
===== Personally-Owned Computers =====
Case: when you try to start Word, you get an error msg: "Word has failed to start in safe mode. Do you want to try to repair your installation?"
+
[http://go.middlebury.edu/o365 Office 365] is available for installation on personally-owned computers.  Visit [https://mediawiki.middlebury.edu/LIS/Microsoft_Office_for_Personal_Computers Microsoft Office for Personal Computers] for details.
 +
<br><br>
  
Reason for this is unknown. Solution is simply to click through the messages to repair / "clean" your MS Office installation; in at least some cases, you do not even need the Office install CD to do so.
+
=== How to Learn More about Office 365 ===
 +
<br>
  
====File formats====
+
===== Take a Short Course using LinkedIn Learning: =====
MS Office 2007 uses the .docx file format by default. People should '''avoid saving in this format''' for compatibility reasons. If user needs to open a .docx file, MS Office 2007 Compatibility Pack [http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en] can be installed (requires MS Office to be installed). Alternatively, OpenOffice.org [http://www.openoffice.org/] version 3 can also view and edit .docx files, although it cannot yet save to this format.
 
  
==Macros and viruses==
+
*For '''Windows''' (PC): [https://www.lynda.com/Office-365-tutorials/Office-365-New-Features/743154-2.html Office 365 New Features]
Word documents can contain ''macros'' which are small scripts that automatically perform complex or repetitive actions in MS Word. Unfortunately macros can also have extensive control over your computer, so they can be used to write viruses. Any system that can run macros in a MS Word document, is also vulnerable to macro-based viruses. Use and run macros with care.
 
  
==Excel==
+
&nbsp;
  
====Formatting a list of ID numbers====
+
===== Use Microsoft's Resources  =====
When you enter in a number like 00324328 into Excel, Excel usually deletes the leading zeros because they're "not important". Sometimes those zeros ''are'' important - for example, on a list of Midd student/staff ID numbers. You can set Excel to ''include'' those leading zeros in specific cells with the following steps.
+
* [https://support.office.com/en-us/article/Office-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb?ui=en-US&rs=en-US&ad=US Office Training Center]
# Click and drag to select the area of cells that you want to show leading zeros.
+
* [https://support.office.com/en-us/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e Office Quick Start Guides]- both online AND  downloadable guides
# Right-click in the selected area and choose '''Format Cells'''.
+
* [https://support.office.com/en-us/article/Office-2016-for-Mac-Quick-Start-Guides-5bccb480-0e5b-4b51-b072-66d3793ccad8?ui=en-US&rs=en-US&ad=US Office Quick Start Guides for Macs] - downloadable guides
# Under the '''Number''' tab, choose the Category '''Custom'''. (''In this area, you specify the way you want Excel to show cells. By choosing "Custom", you are saying that you want to manually specify the format to be used.'')
+
 
# In the '''Type:''' field, erase the default value "General" and enter in '''00000000''' (eight zeros). (''This tells Excel that every number value in these cells should display with at least eight digits, leading zeros by default.'')
+
[[Category:Helpdesk Documentation]]
# Click OK and verify that the fields formatted show any entered number shows leading zeros up to eight digits.
+
[[Category:Public Search]]
 +
[[Category:Microsoft Office]]
 +
[[Category:Training]]

Latest revision as of 10:40, 8 August 2019

Related link: How do I find my MS Office Version?

Information Technology Services (ITS) began installing Microsoft Office 365 on computers provided during the staff upgrade process in spring 2019.

Installation Details


College-Owned Computers

Microsoft Office 365 is available for self service installation on both Mac and Windows college-owned computers.

Refer to the appropriate link below for installation instructions:

  • Windows: Install "Microsoft Office 365 ProPlus" via KACE Self Service.
  • Mac: Install "Microsoft Office 365 for Mac" via JAMF Pro's Self Service -- requires OS 10.12 (Sierra) or higher; OS upgrades are also available via the Self Service utility.


Personally-Owned Computers

Office 365 is available for installation on personally-owned computers. Visit Microsoft Office for Personal Computers for details.

How to Learn More about Office 365


Take a Short Course using LinkedIn Learning:

 

Use Microsoft's Resources
Powered by MediaWiki