Sistema de blogs Diarium
Universidad de Salamanca
Pablo Gallardo's Blog
My professional web log about IT, Cybersecurity & Project Management
 
Archive | Office Suites 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 }

Presentation Templates Resources

This post list some useful resources and sites that offer presentation templates, in different formats like OpenDocument (odp) or PowerPoint (.pptx). Presentation Templates Slidesgo https://slidesgo.com/ Company in Spain. One of the co-founders sold Panoramio to Google. SlidesCarnival https://www.slidescarnival.com/ Free images FlatIcon https://www.flaticon.com/ Freepics This is not really about presentation but for images.

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 (or .bin) file out of the file (you can drag and drop from 7-Zip), don’t close 7-Zip Open the vbaProject.bas (or .bin) file with HexEdit Search for “DPB=” and replace it with “DPx=” Save the file Copy […]

Comments { 3 }

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 merge PDFs

Here there are some propositions about how to merge PDF documents. Tools to merge PDFs Online tools PDFMerge! Online tool. http://www.pdfmerge.com/ Windows There is a limit in Windows to print up to 16 files. If you need to print at the same time more than 16 files, do it in batches. To merge PDFs, use […]

Comments { 0 }

ProjectLibre Tutorials

ProjectLibre is an open-source and free tool for project management. Official documentation is not very extensive, so I created this post to summarize some useful tutorials about this tool.   ProjectLibre tutorials Project Libre Doc v0.3 https://pdfcoffee.com/projectlibre-doc-v03-pdf-free.html https://docs.google.com/document/d/1ZSldKw6gC8iuriQPdckHfaxaWvwQhYxP_Do-I-dnbHs/edit?usp=sharing   Slideshows by user Hezequias Vasconcelos http://www.slideshare.net/ProjectLibre/projectlibre-15-lesson-1-presentation-of-the-initiative http://www.slideshare.net/ProjectLibre/project-libre15-aula-2-installation-requirements http://www.slideshare.net/ProjectLibre/projectlibre-15-lesson-3-the-different-distributions-and-restrictions http://www.slideshare.net/ProjectLibre/project-libre15-aula-5-reportsenus      

Comments are closed

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 }
Política de privacidad
Studii Salmantini. Campus de excelencia internacional