Sistema de blogs Diarium
Universidad de Salamanca
Pablo Gallardo's Blog
My professional web log about IT, Cybersecurity & Project Management
 
Archive | Microsoft Office RSS feed for this section

How to set the default format on Outlook messages

This post was written on May 2022 and assumes you are using the Outlook version of Office 365. Steps to set the default format on Outlook messages Set default styles in Outlook When we say ‘styles’ here, we mean color palette and fonts. Color palettes are shared among Office 365, so you may have a […]

Comments { 0 }

How to prepare a Word template

This post summarizes the steps to prepare a Word template. The final objective of this post is to create a .dotx (macro-disabled) or .dotm (macro-enabled) file, that enables reusability of the format we have created. This post was written in April 2022 and assumes you are using the 365 version of Microsoft Word.   Steps […]

Comments { 0 }

How to remove Password from VBA Project in Excel

Step-by-step procedures For XLSM files Open the XLSM file with 7-Zip (right click -> 7-Zip -> Open archive). Copy the xl/vbaProject.bas file out of the file (you can drag and drop from 7-Zip), don’t close 7-Zip Open the vbaProject.bas file with HexEdit Search for “DPB=” and replace it with “DPx=” Save the file Copy this file back into […]

Comments { 1 }

Mockups, wireframes, prototypes on Microsoft Visio

Microsoft Visio is globally known as an application that allow users to create diagrams. But it is less known that among this diagramming powerness there is also specific funtionality that allows to create your own mockups, wireframes or prototypes for software development. This functionality currently only available on latest desktop versions (Visio 2019, Office 365) […]

Comments { 0 }

How to Unblock Unsafe Attachments in Microsoft Outlook

When receiving an executable file on your Outlook mailbox, you may find that you cannot download the attached file(s) and that you get this text  ”Outlook blocked access to the following potentially unsafe attachments” instead…   It is possible to get rid of this message just by following the tutorial below. https://www.sitepoint.com/outlook-unblock-unsafe-attachments/+&cd=3&hl=es&ct=clnk&gl=es   Source: “How […]

Comments are closed

How to change display language on Microsoft Office 2007

Check these links: https://support.office.com/en-us/article/Enable-another-language-in-the-display-of-Office-programs-b6e07a09-8ad1-4162-a5aa-3ffb933daa9f?CorrelationId=e165e61b-09c0-471d-bb11-2d58d3e5127d&ui=en-US&rs=en-US&ad=US https://technet.microsoft.com/en-us//library/cc179091(v=office.12).aspx#

Comments are closed

INDEX and MATCH as alternative VLOOKUP in Excel

VLOOKUP is a very useful and powerful Excel formula. It has however, its limitations: for example, the searched word must be obligatory in the first column of the search matrix. This article provides an alternative to VLOOKUP. The alternative would be to use a combination of the formulas INDEX and MATCH instead. There are plenty […]

Comments { 0 }

How to permanently turn off Track Changes in Microsoft Word

Sometimes it is required that local applications in Windows (i.e., Excel) and SAP client use the same decimal formatting (for example, either dot or comma). Following these steps we will get to align both system, and avoid decimal conversion processes: Check Windows Regional OptionsWindows configuration can be changed / displayed in the following path (Windows […]

Comments { 0 }

How to import mail from Outlook to Thunderbird

I have come out to the need to recover some e-mails that were stored in a .pst file (easily read by Outlook, more difficulty imported to other mail client), so I needed to learn how to import mail from Outlook (2010) to Thunderbird (17). Ensure that Outlook is already displaying the e-mails from .pst file. […]

Comments { 0 }

How to create a Gantt chart in Excel 2007

Today I had to spend a several minutes just to find a proper tutorial about how to create a Gantt chart in Excel 2007 (most of them concerned only previous versions). When I found Microsoft’s official instructions, it turned out that they where incomplete and incorrect at some point. This video tutorial was the best […]

Comments { 0 }
Política de privacidad
Studii Salmantini. Campus de excelencia internacional