Office

How to open Control Panel in Windows 10

The Control Panel application is the primary place for various Windows settings controlling Windows looks and feel, and behavior of other software. The Control Panel applets configure field and number separators in Excel (you can switch semicolon to comma, comma to semicolon, comma to point, etc.) or measurement system in PowerPoint.

Importing and Exporting ribbon customization settings

From time to time you need to change a computer or laptop no matter what, e.g., a breakdown or upgrade. To keep the habitual work environment, you need to backup and restore personal ribbon customizations.

How to change decimal symbol and digit grouping symbol in Windows 10

When you work with numbers and amounts in Microsoft Word or Microsoft Excel, you can have some issues with decimal symbol or digit grouping symbol. Both symbols can be changed in the settings of the Windows system.

Excel

Creating and using named ranges

Named ranges are a powerful Excel feature that allows you to assign a symbolic name for the cell or the range of cells for later use as a convenient replacement for cell/range address in formulas.

Creating a simple thermometer chart

A thermometer chart is a kind of progress chart that shows the current completed percentage of the task or the value of any metric relative to the predefined value. E.g., the thermometer scale can display the sales plan status or client satisfaction rate.

How to create a funny dog breeds lifespan chart in Excel

Span chart, also known as a range bar graph (range column graph), floating bar graph, difference graph, high-low graph, used to display the specific variable value range. Span charts are ideal for comparing ranges, and typically, each variable represents a particular category. All values for the selected category fall between minimal and maximal values that correspond to lower and upper bounds of the interval.

Outlook

How to change the Stationery in Outlook

Stationery provides an easy way to create a visual Outlook template with custom background color and image, fonts, bullets, colors, and effects. Unlike an email message template that includes both visual appearance and text, the stationery consists of visual appearance only. The default stationery applies to new emails, replies, and forwards. Thus, if you need an Outlook template for branded messages, you should use the custom stationery instead of the email template.

How to repair Outlook Data File (.pst) on Windows PC

Corruption of Outlook data files (.pst) renders the mailbox data inaccessible. It is practically impossible to get back the complete mailbox data from corrupt PST files with the help of built-in utilities, as it often happens to large size PST files. Outlook PST repair tool from Stellar Repair for Outlook effectively fixes large inoperable or severely corrupt Outlook data files.

How to view the total number of responses to the meeting request

After creating and sending a meeting request by email, the organizer needs to know the status of responses, and the total number of people accepted, declined, or stated their tentative status for the meeting. You can quickly check these numbers in the Calendar view.

PowerPoint

How to insert Greek symbols very quickly

When you create a presentation for a graduate thesis or dissertation, often, you need to insert Greek letters into the slide. Mathematical symbols and Greek letters are pervasive today and used everywhere, from physics to social science. You may use the equation block for inserting those symbols, but this block will have different format settings than the rest of your text, and you will not be able to edit it in older versions of Microsoft Office. If you need to insert just a symbol, use the Symbol dialog box or Alt+code shortcuts.

How to reduce ribbon size in PowerPoint

After recent updates, the ribbon in Microsoft PowerPoint can take up to 1/3 of the available screen space. Microsoft Office help tells that you can hide or unhide your ribbon, but you cannot reduce the size of your ribbon, or size of the text or the icons. False! You can change the mode and remove unnecessary white space around buttons, and, thus, reduce the ribbon size.

How to change the size of slides in Microsoft PowerPoint

When you prepare your presentation, you should adapt it to the device which will be used for projecting it. Some devices or even laptops can have different sizes, so you can need to change the sizes of your presentation.

Word

How to use different page orientations inside one document

Page orientation defines the direction for printing or displaying the document in Word. Sometimes the page orientation for a particular page has to be different from the rest of the material. E.g., usually, the whole article, paper, or report is printed in the Portrait mode, but for a page with the big table, it is more convenient to use the Landscape mode.

How to do anything with paragraph format with keyboard

No matter what you are writing, a fictional book, a story for kids, a user manual, or a technical report, jumping between the text and ribbon buttons for formatting distracts from the work. Shortcut Keys or Hotkeys for changing the paragraph alignment, style, etc. without mouse movements come to rescue.

Using the Organizational Chart Tool

The organizational chart, or organigram, is a diagram of the structure and relationships of the company or other organization. If you have Visio, you can build a huge organization histogram up to 1000 shapes with a very complex structure. SmartArt diagrams are much simple and recommended for smaller organizations, but you can add many visual effects and use Office theming for your organization diagrams. Using Microsoft Word built-in tools, you can easily create and share functional, divisional, or matrix org charts. A killer feature of SmartArt graphics templates is that you simply type and paste the text and the template positions and re-arranges the blocks automatically.