This post explains some aspects of the product Microsoft Office.
Microsoft Office Tools
Basic products within Microsoft Office Suite:
- Word
- Excel
- PowerPoint
Additional Microsoft Office tools, usually not deployed as default:
- Visio
- Project
- Publisher
Microsoft Office products that have a year after the name (e.g., Microsoft Office 2016) are standalone products that have a lifecycle.
Office 365 is the cloud or software as a service (SaaS) version of Microsoft Office. You can read more about Office 365 on this post.
Microsoft Office Hints
These sections offer some hints for using Microsoft office, classified by product.
General Microsoft Office Hints
You can read how to choose the color palette for the Microsoft Office suite on this post.
To create your own theme, first create a template in Word (as you can read below), export the theme and import it to the different Office products.
To create a Gantt chart, you need to embed an Excel sheet in PowerPoint or Word and then follow the corresponding steps that apply for Excel, as it can be read on this post.
Microsoft Word Hints
You can read about how to create a template (and the corresponding them) in Word on this post.
You can read about how to change the display language in Microsoft Word 2007 on this post.
Microsoft Excel Hints
You can read about how to create a Gantt chart in Excel on this post.
You can read about how to compare cells containing numbers in Excel on this post.
You can read about how to remove Password from VBA Project in Excel on this post.
You can read about how to solve a system of linear equations in Excel on this post.
You can read about how to use INDEX and MATCH as a more flexible alternative to VLOOKUP in Excel on this post.
You can read about how to refer to an array dynamically on this post.
Data segmentation is an Excel functionality that allows to create more advance filters.
DAX
Power Query
Power Pivot is a solution that is different to Excel.