Office

16 PowerPoint Shortcuts Every Student Will Appreciate

The life of a student in the 21st century is so much different from studying in the past. What did students need? Some ink, feathers, and papyrus. Later they were replaced by pens and paper. Everything was simple: students found their knowledge in textbooks and reflected it on paper.

Manage the Microsoft account

To use the desktop version of Microsoft Office 365, you need a Microsoft account. With a Microsoft account, you have access to Microsoft application settings on the Account page and in the Word/Excel/PowerPoint/Outlook Options dialog box.

Fill and outline options in Microsoft

Microsoft applications such as PowerPoint, Word, and Excel use the same approach to set up and fill with colors, gradients, pictures, textures, and patterns for various graphic objects and text. Microsoft uses the theme color of each element as a placeholder rather than a fixed color. Thus, it is easy to change colors by switching to a different color theme - a set of colors assigned to preset positions.

Excel

Show chart data for empty cells

If there are some gaps in source data for the chart, by default, Excel does not display them on the chart, and this looks odd. Excel offers a useful feature to display interpolated values instead of gaps in the chart. In addition, Excel allows you to process data with #N/A errors as empty cells.

Show chart data in hidden cells

Excel allows you to create charts and diagrams from different data sets, even those that contain hidden or empty cells. However, sometimes you may see unexpected results. For example, if there are hidden cells in the chart data, by default, Excel ignores such data and doesn't display the corresponding chart elements. You can easily force Excel to handle hidden data.

How to add a horizontal line to the chart

Usually, horizontal lines are added to a chart to highlight a target, threshold, limits, base, average, or benchmark. These lines, for example, can help control if a process is behaving differently than usual. Excel allows you to add a vertical line to an existing chart in several different ways, e.g., by calculating line values for a scatter, line, or column chart, but using error bars is the easiest way to add a vertical line to a chart:

Outlook

How to convert OST files to PST

Users of Microsoft email services are well acquainted with the OST format, which is used to store data in encrypted form. Converting OST files allows you to get rid of format restrictions, after which mailings will become available to the user for offline work in Outlook.

How to Use Marketing Automation Tools to Improve Your Campaign?

Technology made marketing different. Now, marketers can automate the critical processes and improve their email campaigns. Read this post for more details.

How to use a Desktop Alert

The Desktop Alert is an alert window that pops up when you receive a new email, a meeting request, or a task request to the Outlook default Inbox.

PowerPoint

SlideModel Review: Master the Art of Presentations

SlideModel is one of the biggest and most popular platforms for PowerPoint presentation templates on the internet. The platform is a go-to destination for individuals and businesses for ready-made, editable, and pixel-perfect PowerPoint templates.

How to crop a picture to fit a shape

Numerous books, blogs, and courses recommend using pictures instead of text in the presentation. Slides with pictures, charts, and diagrams can keep the audience focused on what you are talking about instead of diverting the participants' attention to reading the contents of the slides. Often pictures play the role of a distracting or, vice versa, enticing maneuver.

How to lock objects from moving and resizing in PowerPoint

PowerPoint has a handy feature that allows you to freeze an object on a slide. By locking objects from moving, you will not worry about hitting the wrong object when aligning, grouping, or resizing the rest of the slide elements. Locking will also allow you to more easily work with the object's content without fear of automatically resizing or displacing the object when you edit its content.

Word

Best Five Types of Legal Templates to Streamline Work

Why begin from zero each time when you're able to initiate any business with templates? Organizations can standardize operations, eliminate errors, and boost efficiency by using legal templates. After creating templates that suit your preferences, you can edit them to make them work for the assigned work. Now, to make your journey easier, the following segments cover every single aspect of the best five types of legal templates to streamline work.

How to Use Microsoft Word Effectively for Essay Writing

Are you yet to master the art of using Microsoft Word effectively for your day-to-day office functions? Join us in this intriguing episode as we unravel the secrets of using Microsoft Word like a pro!

How to make and use columns in a Word document

Typically, Word documents like books, reports, and letters have paragraphs that occupy the whole page width. In articles, newsletters, flyers, and brochures, all or only parts of the text may be arranged in two or more columns:

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more