18 Cheat Sheets to Master Microsoft Office [Students Edition]

The rapid development of information and communication technology over the last few years has affected most, if not all, areas of our lives. Its influence is particularly apparent in the education sector. Students today usually don’t visit libraries to conduct their research or write essays by hand. Pens and papers have been replaced by computer programs like Microsoft Office, the most popular option for students and educators.

Students struggle figuring out Microsoft Office.

Luckily for you, our team has compiled this excellent cheat sheet for Microsoft Office. We’ve gathered the most useful tips and keyboard shortcuts for the various Microsoft programs. With their help, you’ll be able to use Microsoft Office in your studies without any issues.

⌨️ Crucial Keyboard Shortcuts for Students

As we’ve already mentioned, Microsoft Office is the most popular office suite. It’s used extensively in business and education. MS supports the education sector by providing a free Microsoft Office 365 version for students and educators.

Most people have Microsoft Office software on their computers, so we’ve decided to offer a list of essential, universal keyboard shortcuts for this program. These are useful for those who deal with computer programs in general, and they’ll definitely assist you with MS.

Essential keyboard shortcuts for Windows and Mac.

In the rest of the article, we’ve provided shortcuts for Windows. However, as you can see, they’re helpful for Mac as well. All you’ll have to do is to replace the Ctrl button with Cmd.

✍️ Word Cheat Sheets

The first Microsoft Office program that the majority of students use is MS Word. This is where most essays and other academic papers are written. If you’re not using it already, you will likely be dealing with Word throughout your education. So, it will be beneficial to learn cheat sheets for this program.

In the following sections, we have presented a list of valuable tips that will make your experience better.

1. Basic Keyboard Shortcuts

To work in Word without a struggle, you should begin by learning the keyboard shortcuts. There are dozens of configurations, and you can also create your own. Here we’ll list the basic shortcuts that will help you work efficiently with your documents.

ShortcutWhat It Does
Ctrl+N Opens a blank document.
Ctrl+O Opens a document.
Ctrl+S Saves your document.
F12 Opens the Save As window.
Ctrl+W Closes your document.
Ctrl+P Prints your document.
Arrow Keys Moves cursor.
Ctrl+Left/Right Arrow Key Moves cursor one word.
Ctrl+Up/Down Arrow Key Moves cursor one paragraph.
F1 Opens Help.

2. Essential Keyboard Shortcuts: Editing Text

After looking at the basic shortcuts, let’s get to the good part. Knowing how to work with text is fundamental to using Microsoft Word. The combinations listed here are essential to quickly and efficiently edit your document, which is crucial for effective academic writing.

ShortcutWhat It Does
Ctrl+B/I/U Make your text bold/italics/underlined.
Ctrl+Shift+W Underlines only words.
Ctrl+Enter Inserts page break.
Ctrl+K Inserts hyperlink.
Ctrl+E Centers the text.
Ctrl+]/[ Makes your font bigger/smaller.
Ctrl+Shift+A/K Implements uppercase/lowercase to your text.

3. Working with Tables: Key Tricks

Besides working with text, Microsoft Word is also useful for creating tables. These are multifunctional tools helpful in storing large amounts of information. Here we have outlined the best ways to insert, organize, and manage your tables.

How to Create a Table

There are several ways of creating a table in your Microsoft Word document. Start with going to the Insert tab on the ribbon bar at the top. Locate the Tables menu and click on it

You will immediately notice that there are several options available:

  • You can insert a table via the grid. This method is helpful to visualize what the result will look like. Unfortunately, the maximum size of the table you can insert this way is 10×8 cells.
  • If you need a bigger table, your best option is the Insert Table menu. Here you can manually indicate the number of rows and columns. The maximum size of a table inserted this way is 63×63 cells.
  • If your table is not standard and you need room to play with rows and columns, Word has options for you. If you head into the Draw Table menu, your cursor will transform into a pencil. Using your mouse, you can easily draw a table with the dimensions that you need. Left-click and drag down for columns; drag sideways for rows.

Table Tools Layout Tab

Microsoft Word is a powerful tool for creating and managing custom tables. In this section, you’ll find out how to format and change its content and layout. Below, we have listed some functions that will be useful in your work.

  1. Table Properties:
    • Table – Essentially, a table is a grid made up of rows and columns. It is useful for storing and managing information.
    • Row – The horizontal line in a table.
    • Column – The vertical line in a table.
    • Cell – The intersection of a row and column.
    • Alt Text – A text-based description of the contents of the table. This is useful for people with visual impairment or in cases where the table doesn’t load. To add alternative text into a table, right-click the cell and navigate to Table Properties. In the dialog box that appears, click Alt Text and fill in the description.
  2. Insert row or column – Navigate to the Layout tab. Click on Insert Below/Insert Above to add a row. Click on Insert Left/Insert Right to add a column.
  3. Delete row or column – Navigate to the Layout tab. To delete the selected row, click on Delete – Delete Rows. To delete the selected column, click on Delete – Delete Columns.
  4. Alignment – To adjust the position and alignment of text, navigate to the Layout tab. Select the needed cells and choose an option from the Alignment group.
  5. Merge – Cells can be merged or split up. To do so, navigate to the Layout tab and find the Merge Cells/Split Cells option.
  6. Convert text to a table (and vice versa) – Make sure that the data in the text is separated. Use commas or tabs to indicate where to divide into columns and paragraphs to indicate rows. Pick the text you wish to convert into a table, then click Insert – Table – Convert Text to Table. Adjust the options in the dialog window. If you want to convert a table back into text, select the information first. Navigate to the Layout tab and in the Data group, click on Convert to Text.
  7. Autofit – – Automatically adjust the size of your table. Go into the Layout tab and click on Autofit. Select the option that works best for your needs.

Table Tools Design Tab

After you finish with the content and the layout of your table, you can change its design. Spending time on this may not be in your plans. However, the right design can raise your work to the next level.

Here, you can check a description of the design features for your table.

FunctionHow to Use It
Table Style Options Navigate to the Design tab after clicking on your table. In the Table Style Options group, check the elements you want.
Table Styles Navigate to the Design tab. Browse through the Table Styles group and select one from the gallery.
Shading Select a cell. Navigate to the Design tab and click on Shading in the Table Styles group. Choose a color.
Borders Select a table. Navigate to the Design tab and click on Borders in the Tables Styles group. Select a border style.

4. How to Format: 10 Critical Rules

Every educational institution has its requirements for the formatting of text documents. You can find out how to work with a variety of styles. There are precise guidelines for such popular formats as MLA, APA, and Harvard on different websites.

Here, see the ways you can format text in Word:

  1. Create lists. You can either make a bulleted style list or a numbered list. Find the Paragraph group in the Home tab. You will find three Bullets buttons: a bulleted list, a numbered list, and a multilevel list. Browse through the style gallery and select one.
  2. Align paragraphs. Select a paragraph. Click on the alignment option in the Paragraph group in the Home tab. Any section of your text can be left-aligned, center-aligned, or right-aligned.
  3. Change fonts, sizes, and colors. Under the Home tab, find the Font group. Select the text that you need to change or choose an option before you start writing. Browse through the lists of available font styles, sizes, and colors. You can also input a custom number for the font size and select a custom color under More Colors.
  4. Clear or copy formatting. First, select the text. Then, find the Format Painter button in the Clipboard group of the Home tab and click on it. Then, select the text you want the format to be applied to. To clear formatting, click the Clear Formatting button.
  5. Use headers and footers. These are additional sections that you add either at the top or the bottom of a document. Typically they are used to indicate extra information, such as the title of the paper, date of creation, etc. To add a header or footer, navigate to the Insert tab. Click either the Header or Footer option under Header & Footer group.
  6. Make use of tab stops. There are four types in Microsoft Word: left-aligned, right-aligned, center-aligned, or decimal-aligned. They are used to align text in a document. To set up a tab stop, click on the place in the paragraph where you want to add it. Then, open up the Paragraph group’s dialog box and click on the Tabs button. You can adjust the tab stop position from there.
  7. Pick your margin size. Margins refer to the empty spaces at the sides of the document. To adjust their size, you will have to navigate to the Page Layout tab. Click on the Margins button under the Page Setup group. You can pick the preset one or create your own in Custom Margins.
  8. Display page numbers. Go to the Insert tab and click the Page Number button under Header & Footer group. Numbers can be displayed both at the top and at the bottom of the page.
  9. Use and format columns. Word allows you to split the text up into columns. You can find these under the Page Layout tab in the Page Setup group. Click on Columns and select the needed style. As a result, they will be applied to the whole document. However, you can adjust this under More Columns.
  10. Set the spacing. You can change line spacing and paragraph spacing. To do so, select the text that you want to change. Under the Paragraph group in the Home tab, find the Line Spacing option and adjust accordingly. To adjust paragraph spacing, navigate to the Paragraph group’s dialog box. In the Indents and Spacing tab, find the Before and After values.

📊 Excel Cheat Sheets

Many research papers, especially on technical subjects, require calculations and the handling of significant data volumes. Microsoft Excel is a perfect solution for these goals. Students can use this software in multiple ways, and our cheat sheets from the following sections can show you how. You can also check how to write a research paper for additional tips.

There are two terms that you should learn before you start:

Differences between functions and formulas in Excel.

5. Key Excel Functions & Tricks for Students

A function in Excel is a formula that helps with mathematical, statistical, and logical operations. It is a quick way to find the sum, average, count, maximum value, and minimum value. Students should master just some of them as it will significantly help them in their academic life. The rest of the Excel functions can be helpful in business or at work.

Excel Functions You Need to Know

As a student, you will find these functions useful:

  1. SUM is one of the most frequently used functions in Excel. It sums up values from several columns or rows. For instance, =SUM(A1:C1) is a selection that sums the value of rows. You can also turn the function into a formula.
  2. IF is used when you want to arrange your data in a particular manner. You can also include formulas and functions into it if it serves your purpose. For example, =IF(A2<D4, “TRUE,” “FALSE”).
  3. SUMIF sums up the values in a range that meets specific criteria. For instance, a column contains numbers, and you want to calculate only the values equal to 1: =SUMIF (A2:A45, “=1”).
  4. VLOOKUP stands for “vertical lookup.” This function does a search in the sheet for a certain number or value in a column. It brings the matter from different columns into the same row. For instance, =VLOOKUP(“London,” A1:C90,2, TRUE).
  5. INDEX/MATCH are two functions that are usually combined for advanced lookups. To use this formula, type =INDEX($B$2:$B$8, MATCH(H12,$C$2:$C$8,0)).
  6. MAX/MIN are other vital functions in Excel. MAX helps you find the highest, while MIN – the smallest number in a range. While searching, the functions will miss empty cells. Here is how you can use them: =MIN (or MAX) (number 1, {number2}, …)
  7. COUNT in Excel counts numbers in a given range. It can look like this: =COUNT(B1:B20).
  8. COUNTA will count cells that contain information. To use this function, you need to determine the cells that you want to include. For instance: =COUNT(A1:A7)
  9. COUNTIF is a statistical function. It counts cells in a range that meets a specified condition. For instance, it can count the number of times some information appears on the sheet. Here is an example: =COUNTIF(A1:A5, “1990”). This function can help you understand how many times “1990” is mentioned in the spreadsheet.
  10. AVERAGE in Excel will find the average of the numbers or values. It adds all the figures and then decides the result by the overall amount of values. Here’s an example: =AVERAGE(B1:B10).

Tricks for Using Functions Like a Pro

Mastering functions are an essential part of understanding how to use MS Excel like a pro. Here, you’ll discover how you can use the functions that we’ve discussed:

  1. Use ALT+= to enter a sum automatically. Select the column and keep pressing ALT. Then, type + and =. It will quickly give the sum of the column’s contents.
  2. Click CTRL-` to demonstrate formulas in a worksheet. Press the control key and at the same time click “`”. This way, you’ll see all the formulas. To hide them back, click the same combination again.
  3. Try the Automatic Calculation. Be careful using this trick. Every time you change something on the spreadsheet, Excel will recalculate the formulas. It is very convenient, as it means your data is up-to-date. If you want to switch off the Automatic Calculation, go to options and select formulas to view the Calculation options.
  4. Consider using the Quick Aggregation Tool. It can demonstrate aggregated statistics, such as Average, Numerical Count, Max, Min, Sum, and Count. For that, just select the rage without entering any formula. Excel will show these stats automatically.
  5. Convert numbers to a range. The LOOKUP function can help you to convert numbers to ranges for simplifies summary. To convert numbers, you should use [range_lookup]. For instance, you have some values in a Column, and you want to convert them into specific ranges. For that, follow simple steps: create a table and its fields, and enter the function.
  6. Count numbers in a range. If you want to count how many numbers fall into a specific range, you can try several methods: fixed and dynamic. Imagine you have a range of numbers in B1 to B100, and you want to know how many values are between 10 and 30. For that, enter the function into the formula bar, =COUNTIFS(B1:B100, “>=10”, B1:B100, “<=30”). However, a dynamic method is better. You can change values, and Excel will update the count. The formula for the dynamic count is COUNTIFS(B1:B100,”>=“&C2, B1:B100,”<=“&B3).

6. Helpful Excel Cell References

If you want to nail MS Excel, you have to learn more features than just functions. In this section, we’ve explained cell references. They will help you navigate Excel better and use it more efficiently.

To use autofill in Excel, you need to know about cell references. Below, you can see combinations of letters and numbers. A letter represents a column, and a number represents the row.

Cell references in Excel.

For instance, you want to change a simple reference in your cell into a relative consideration. For that, press F4. It will change the reference from A1 to $A$1.

7. Excel Keyboard Shortcuts That You Need

In any Microsoft program, knowing key combinations can make your life easier and your work process – faster. There are many of these combinations in Excel. You probably know most of them already simply by using Word and other programs.

In the following table, we’ve gathered some Excel specific shortcuts:

ShortcutWhat It Does
=Starts a formula.
Ctrl+` Goes back and forth between formulas and cell values.
Ctrl+’ Copies and pastes the formula from the cell into the current one.
Shift+F3 Inserts a function.
Ctrl+Shift+U Collapses or expands the formula bar.
F9 Calculates the worksheets in all opened workbooks.
Shift+F9 Calculates the worksheet.
Alt+= Inserts an Autosum function.
Shift+PgDn / Shift+PgUp Extends the selection down one screen/up one screen.
Ctrl+Shift+Home Extends the selection to the beginning of the worksheet.
Shift+Arrow key Extends the selection by a single cell.
Shift+Home Extends the selection to the beginning of the row.
Ctrl+A or Ctrl+Shift+Spacebar Selects an entire worksheet.
Shift+Spacebar Selects a row.
Ctrl+Spacebar Selects a column.

8. Excel Formulas: Top Tips

The correct application of formulas is the key thing you have to learn. In this section, we will give you several tips on creating them in Excel successfully.

Not to make typos and mistakes in the formulas, you should remember this:

  1. Use (brackets).
    You can avoid many mistakes if you follow this simple tip. Many errors happen with mathematical operations. Using brackets allows you to see each part of your formula separately and thus, exclude mistakes. Here is an example: =(B1+C2)/A5
  2. Include line breaks for complex formulas.
    Getting lost and making unnecessary mistakes is a part of learning MS Excel. Thankfully, you can avoid numerous errors by just adding line breaks to your formulas. This way, it will be more manageable for you to detect all the mistakes and typos.
  3. Utilize the Fill Handle to copy the formula to different cells on the spreadsheet.
    You can select the Fill Handle and drag it down to the rows. It is the small square on the bottom right. If you use it, Excel will apply a function from one cell to all the other cells you dragged it.
  4. Delete duplicate rows.
    You can go into the Data menu and click on Remove Duplicates. To select a range that you want to remove the duplicates from, click Ctrl+A. Hit okay and enjoy the lack of copies.
  5. Add leading zero.
    Sometimes you need to add zeros to a number. To simply do it, use the following formula: =TEXT(A1, REPT(“0”,9)). The formatted number will have a text length of 9 characters.
  6. Create named ranges.
    If you have a large number of rows, it is helpful to give names to the ranges. It will allow you to refer to them using their titles instead of clicking and selecting them. To provide names, do as follows:
    • Click on the Formulas menu.
    • Click on create from selection button.
    • Select the ranges and name them.
  7. Add double quotes.
    One of the best ways to include double quotes is the CHAR function. It will keep your formula readable and concatenated. ASCII Table can help you see what number you want to join.
  8. Count unique values from a range.
    Sometimes you need to see a count of unique values in a range. You can use a method of deleting duplicates. However, there is a quicker way to do it. For instance, you have your classmates’ names in A1:A20. In an empty cell you type a formula, =SUM(1/COUNTIF(A1:A20, A1:A20)). Instead of hitting Enter Key, you press Ctrl+Shift+Enter on Windows. It will create an arrow formula. You will see the desired result of how many unique names are in your class.

📝 OneNote Cheat Sheets

Today using a pen and paper for note-taking is not a common practice anymore. Students are switching to built-in text editors and online tools. Microsoft OneNote is especially popular. It allows you to structure the entire educational process, share notes, and change formatting by pressing several keys.

There are two versions of OneNote that can be used on one device:

Differences between OneNote 2016 and OneNote for Windows.

In the following sections, we’ll share tips for using OneNote. Keep in mind that there is also a free version of the tool. Although it doesn’t contain all the features of the Microsoft Office subscription, almost all of our cheat sheets will apply to it.

9. OneNote Keyword Shortcuts to Ease Your Studies

As with any other Microsoft Office program, OneNote can use standard shortcuts like Ctrl+V and Ctrl+C. Some sets may be unfamiliar for you, though. Yet, they are absolutely irreplaceable.

These OneNote keyboard shortcuts will save you a lot of time:

ShortcutWhat It Does
Alt+Shift+T Adds current time.
Alt+Shift+D Adds today’s date.
Alt+Shift+F Adds current time and date.
F7 Searches fors pelling mistakes.
Ctrl+Alt+Shift+N Inserts a subpage under the current page at the same level of indentation.
Ctrl+K Adds a hyperlink.
Ctrl+Alt+N Adds a new page under the current page at the same level of indentation.
Ctrl+N Adds a new page at the end of the current section.
Ctrl+Shift+E Sends selected pages via an email message.
Ctrl+1 Marks, clears, or pplies To Do tag.

10. Crucial Tips for Students Using OneNote

We are sure that all of you will know how to take notes. If you are not a professional yet, you can read about effective note-taking. In the following section, we’ll show you how you can improve this process using OneNote.

To make your life easier, try the following note-taking strategies:

  1. Try hand-writing and drawing your notes.
    Firstly, this will help you to memorize the material better. Secondly, this tip is beneficial when you need to plot a graph, chart, scheme, etc. To try it, create a new page, choose the View tab, select one of the available ruled lines, and enjoy your note-taking process.
  2. Use page templates.
    OneNote offers a variety of built-in templates (to-do lists, planners, schedules, etc.). Use them to save your time. Besides, with them, you can create an appealing background and a consistent layout. You can also add your personal template, customize it, and save it for future use. If you want to apply one, create a separate page for it. OneNote does not allow using templates on the excising document.
  3. Record audio and video.
    Audio and video recording is a unique feature of digital note-taking. With it, you won’t miss anything important. You can just come to your class, start recording, and relax. The entire lecture will be available for you, so you can relisten as many times as you need.
  4. Work with different ongoing projects.
    Take advantage of the wide variety of features OneNote offers you. Use tags to categorize and prioritize your notes. Share your documents with other people in real-time and edit them. Keep track of your projects, and don’t be afraid to get lost in your notes.
  5. Take advantage of Outlook Flags.
    Integration of OneNote and Outlook is the best thing for managing your deadlines and keeping track of your assignments. Create Outlook Tasks and add them to your notes. You will see how easily you can manage your tasks by setting reminders, marking them as completed, prioritizing them, etc.
  6. Add rule lines and grid lines.
    Do you miss an actual notebook with rules or grid lines? OneNote has a solution! In this app, you can add rule or grid lines. Plot your graphs and charts like you’re writing on the paper.
  7. Employ Quick Notes.
    Getting overwhelmed with all the tasks you have to complete? In this case, quick notes can help you. Take notes anywhere on any device. Type on your smartphone while on a bus, on a laptop while attending a class, etc. Your notes will synchronize and be available on each of your devices.

11. OneNote Class Notebook: How It Can Help You

OneNote Class Notebook is an improved version of the standard OneNote app. It is designed for use in the classroom and contains a wide range of useful features. For instance, students can collaborate and work on the assignments in groups and privately submit their papers. Besides, instructors can mark academic works and track their progress online.

Basically, OneNote Class Notebook includes all the features of the OneNote app and has some additional characteristics:

OneNote Class Notebook features and requirements.

As a responsible student, you may suggest your instructor install OneNote Class Notebook. This will make your, your tutor’s, and your classmates’ life easier. Besides, it’s free for educational purposes.

Probably, at the very beginning, this program may seem too complicated to you. The tips below will help you to learn the basic principles of the OneNote Class Notebook:

  • Inspect the content library regularly. It is the place where the professors can upload and store class materials for students. You can always access it and discover the materials. Check the library regularly to make sure that you don’t miss anything crucial.
  • Save a copy of the lecture. To stay on track and always have access to the materials, you can record the entire class. Right-click on the title and select Save a Copy.
  • Copy and paste PowerPoint slides. Instructors tend to display presentations while explaining the study materials. With OneNote Class Notebook, you don’t have to transfer the content to the pages in the app. Just copy and paste the entire slide.
  • Share your notes with others. Sharing is caring! So, don’t forget to send your notes to your classmates. With OneNote Class Notebook, you can do it with one click.
  • Break large assignments into sections. OneNote Class Notebook will help you to break huge tasks into small, more manageable ones. This way, you can study with much less stress.
  • Enjoy your improved search feature. It allows you to search on a specific page, section, or even find a particular word. It will greatly save your time!
  • Add questions to your page. Are you hesitating to contact your professor directly? Leave the comments and questions on your page as you complete the assignment. Your instructor will later see them and reply to you.

Pro Tip:

Microsoft Office provides many training videos on using OneNote and Class Notebook in particular. They are designed for teachers, but students can also master the program with their help.

📽️ PowerPoint Cheat Sheets

Plenty of people all around the world have to deal with presentations in their professional and educational lives. Professors and students alike use visual aids in demonstrating and organizing their material. There are hundreds of programs made for creating presentations. However, none of them are as popular, multifunctional, and straightforward as Microsoft Office PowerPoint.

We have prepared a guide with tips and tricks to using PowerPoint. We’ve also listed some keyboard shortcuts for editing and presenting. You can also check topics for successful presentations that can come in handy later.

12. PowerPoint Tips You Should Remember

Before we go any further, let us begin by giving you essential advice in creating content for your presentation. You need to realize how your slides should look like before we can move on to bigger things.

To create a memorable presentation in MS PowerPoint, you can follow these tips:

  1. Be consistent with your design and colors. While it is good to experiment, remember that a presentation must be clean and professional. Keeping a consistent theme allows your audience to focus on the message you are trying to convey.
  2. Add more images than text. A presentation is primarily a visual medium. Some text is essential, but filling up your slides with paragraphs will be distracting. Try to rely on images and use text only as guidance.
  3. Know who you’re creating it for. This is a crucial step in preparing any material. Your audience will frame the sort of design, layout, and content you use. Keep your target in mind when preparing your slides. Convey the information that will interest them.
  4. Display only essential, clear, and short texts. As mentioned before, words are less central than images in PowerPoint. Yet, they are still important. The information is best organized in bullet points, written in single sentences.
  5. Choose the font and size that can be viewed from afar. Your fonts should be readable and look professional. More importantly, though, they should be visible. You have to make sure that the font size you choose will be seen from afar.
  6. Use charts and graphs when possible. An effective way of organizing your information in an accessible fashion is via charts or graphs. Not only will it save you time, but it will also give your audience an easier way to interpret the data.

13. How PowerPoint Works: Key Tricks

We have covered how to organize your content. In this section, we will be moving on to how to create the actual presentation using the PowerPoint features.

Below, we have outlined some of the most useful functions that you can find in PowerPoint:

  1. Convert any document into a PowerPoint presentation.
    Any Word document can be converted into a PowerPoint. This is an excellent function for saving time and organizing your information. Microsoft uses the Heading styles in Word to convert them to presentation. For example, Heading 1 will be converted into a slide title.
    To use this function, navigate to Home and then New Slides – Slides from Outline. Find the file that you want to be converted into a PowerPoint in the dialog box.
  2. Animate a flowchart (but not too much).
    Flowcharts are visual representations of a step-by-step process. They are an effective way of categorizing complex information. An animated flowchart will allow you to discuss each point in detail as you go along, making your presentation dynamic.
    To achieve this, select the first element of your flowchart. Navigate to the Animations tab and choose the desired animation. Plus, you can adjust the effect and timing for each step. Repeat this until every element of your flowchart is covered. Remember to keep it simple. You don’t want flashy animations to distract from the subject matter.
  3. Add audio files.
    PowerPoint is a powerful tool, and it has many functions some people never use. Plenty of students are unaware that it can support and play audio files. From background music to voice recordings, audio files in a presentation elevate the whole experience.
    Click the Insert tab and go to Audio. You can choose an audio file directly from your computer. Or you can browse the Internet for a link. You can also set it up to play in the background or to play on click. The audio file will not play in the editing mode, so you will have to start the presentation to check if everything is in order.
  4. Embed your fonts.
    We have already mentioned the importance of a consistent design, so this presents an issue. To avoid that, PowerPoint has the option to embed fonts.
    Navigate to the File tab and find Options. In the dialog box that appears, find Save and check Embed fonts in the file. Now all the fonts you used will be available to everyone who has the file.
  5. Select multiple objects at the same time.
    While designing a presentation, you might find that you need to move multiple things. Imagine you decided to add in an image. Now your text and flowchart don’t fit where they used to.
    You can easily select multiple objects of different types (text, images, shapes, etc.) by holding down CTRL and clicking on them. You can also choose separate text in a single textbox. For that, hold down CTRL as well. This comes in useful when you want to emphasize certain words or phrases.
  6. Modify different pictures on one slide.
    Working with multiple images on a single slide can prove to be tricky. It becomes incredibly frustrating to adjust every image manually. Thankfully, there is a solution.
    Select the images you want to work with by holding down CTRL and clicking on them. You can also pick all of the elements on the slide by pressing CTRL+A. You will see a Picture Tools menu appear. Underneath it, you will find the Format tab. Then, in the Picture Styles group, you will find Picture Layout. Browse through the library of available styles.
  7. Align everything to establish symmetry.
    Symmetry is an essential aspect of any effective design. Not only is it pleasant to look at, but it will also add professionalism to your presentation. We know that adjusting every element on every slide can be tiresome. This is why PowerPoint has an effective solution to align everything without hassle.
    Hold down CTRL and choose the objects you want to align. Or you can press CTRL+A to select everything. In the Format tab, find the Arrange group. Click on the Align button and choose a suitable option.
  8. Add invisible hyperlinks.
    Hyperlinks can look particularly distracting in a presentation. This is precisely why it’s a handy trick. Making a link invisible will ensure that it doesn’t get in the way of your professional look.
    We have to think outside the box to make this work. Go into the Insert tab, then Shapes, and add a small rectangle. In the Format tab, set the Shape Fill to No Fill and Shape Outline to No Outline. Now you have an invisible button, so to speak. You can either right-click or press CTRL+K to add a hyperlink.
  9. Take advantage of the Format Painter button.
    Nothing saves you time designing your presentation as much as the Format Painter function. It provides a quick alternative to painstakingly changing every element on every single slide.
    Select the first object that you want to copy the format of. Click on the Format Painter button under the Home tab in the Clipboard group. Then, click on the second object. The design will be instantly copied over. If you want to change the format of more than one element, double-click the same button.

14. Top PowerPoint Keyboard Shortcuts: Formatting & Editing

Without a doubt, the making of a presentation is a long process. Knowing your way around keyboard shortcuts can save you a ton of time. Below, you will find a list that will make your PowerPoint experience much more enjoyable and efficient.

ShortcutHow to Use It
TabPress Tab to select an element on a slide. Doing it again will move you to the next element.
Shift+TabPress it to select an element on a slide. Doing it again will move you to the previous element.
Ctrl+Up/Down ArrowClick on a slide thumbnail. Use Ctrl+Up Arrow to move a slide up. Use Ctrl+Down Arrow to move it down.
Ctrl+Shift+Up/Down ArrowClick on a slide thumbnail. Use Ctrl+Shift+Up Arrow to move to the beginning of the presentation. Use Ctrl+Shift+Down Arrow to move to the end.
Ctrl+E/L/RUse the respective combination to center-align/left-align/right-align text.
Ctrl+KSelect an element on the slide, such as a shape, image, or text. Use Ctrl+K to add a hyperlink.
Ctrl+MClick it to add a new slide to the presentation.
Ctrl+B/I/USelect text. Use the respective combination to bold/italicize/underline it.

15. Keyboard Shortcuts That Will Save Your Slideshow

Editing and formatting a presentation is a complicated, time-consuming task. However, for a lot of students, the most stressful part comes after everything is done.

The process of presenting can be a nerve-wracking experience. This is precisely why these keyboard shortcuts will be invaluable to you during your slideshow.

ShortcutWhat It Does
F5 Starts the slideshow.
N Moves to the next slide.
P Moves to the previous slide.
Right Arrow/Down Arrow/Spacebar/Enter Plays the next animation.
Left Arrow/Up Arrow/Backspace Plays the previous animation.
Slide Number + Enter Goes to the slide number that you typed in.
B Displays a black screen.
W Displays a white screen.
Esc Exits the slideshow.

🙋‍♂️ Microsoft Teams Cheat Sheets

At the onset of the COVID-19 pandemic, schools and universities searched for ways to continue providing education. Lectures and classes can transpire online but not without a specialized program. This is why Microsoft Teams became a real life-savior for numerous students and instructors alike.

What students use Microsoft Teams for.

Thankfully, it is easy enough to figure Microsoft Teams out – especially for tech-savvy students. However, we can still offer you some tips and tricks to make your experience smoother and more enjoyable.

16. General Microsoft Teams Keyboard Shortcuts

MS Teams is relatively different from other Microsoft Office programs. The typical set of keyboard shortcuts that you know won’t be of much use here. Here we have gathered new combinations to help you navigate much quicker.

ShortcutWhat It Does
Ctrl+, Opens settings.
Ctrl+/ Shows commands.
Ctrl+E Goes to Search.
Ctrl+N Starts a new chat.
Ctrl+Shift+F Opens filter.
Ctrl+= Zooms in.
Ctrl+- Zooms out.
Ctrl+0 Resets zoom.
F1 Opens help.

Pro Tip:

MS Teams has a wide variety of keyboard shortcuts, and not all of them could fit into this list. However, there are several ways of finding them in the app:

  • You can press CTRL+. (period) to open a list of all available shortcuts.
  • Alternatively, you can press CTRL+E to open Search and type in /keys.
  • Finally, you can click on the ellipses in the upper-right corner that open Settings and go to Keyboard shortcuts.

17. MS Teams Tricks from Experts

Just like most Microsoft Office programs, MS Teams has a very user-friendly interface. Despite that, it can get overwhelming for new users to discover all the functions this program provides.

We’ve assembled a list of tips that will further improve your time with MS Teams:

  1. Modify your notifications. It’s okay if you don’t wish to be bombarded by alerts. To modify your notifications, select your profile in the top right corner. Navigate to the Notifications tab. You can change the appearance and sound of your alerts, their type, and even the emails you receive.
  2. Unsee some messages. Sometimes, you don’t have the time to address a question right away. MS Teams has a function for you to remember these messages – marking them as unread. Click on the three dots next to a message and Mark as unread in the drop-down menu. This way, it’ll be as though you’ve never seen it in the first place.
  3. Change your background. When joining a video call, it is essential to remain professional. This becomes tricky in a home setting. You can change your background to a custom image by clicking the ellipsis and selecting Show background effects. You will have a selection of images to choose from. Alternatively, you can click on Blur my background to make your surroundings less defined.
  4. Search everywhere. You can go to Search by pressing Ctrl+E. Type what you are looking for, and press Enter to look at the results. You can also use filters by switching between People and Files. If you can’t remember the wording of what you are looking for, you can try adding these before your search term:
    In: Channel name or group chat name.
    From: Person.
    Sent: Date of the message.
    Subject: Keyword from the message.
  5. Try out Together Mode. It is a feature that places everyone in a shared background. This makes it appear as though all the participants are sitting in one place. It resembles a classroom or an auditorium. This mode is in the in-call background settings.
  6. Send urgent messages. Sometimes, a simple message just isn’t enough. You might need to ask a critical question or discuss a pressing matter. Instead of sending forty ignored messages in a row, check Important or Urgent below the text box. Once the message is sent, the person will receive a notification every two minutes for the next 20 minutes.
  7. Use the @mention function. It allows you to message someone directly. Add the @ symbol and type the name of the person you want to talk to. You can send them a quick message without having to open your conversation. You can also check out the messages sent to you. Navigate to the Activity feed, click on the Filter button, and select @mentions.
  8. Share documents with others. You will likely have to send and receive plenty of files over the Internet. Microsoft’s SharePoint is already integrated into MS Teams. It is a platform for sharing documents, and you can access it by going into Files. When the file is shared, other people can work on it too.

18. Organization Tips for Microsoft Teams

When you join a lecture or class in MS Teams, you don’t have to worry about running it. However, sometimes you will be assigned group projects. Or you might want to meet up with your classmates to study effectively. Whatever the case, you can organize your own online meetings.

Here, we’ll explain how to manage these events to ensure everything runs smoothly:

Organization TipsExplanation
Group team members Keep track of who is doing what by assigning tags to team members. Add and change them in the MS Teams Options.
Title your chats and meetings Titling makes it easier to come back to a chat and search through it. Click on the pencil next to the names to type in a title.
Create Polls Polling helps quickly establish opinions. Select the Forms icon to create a poll. Write the question and answer choices. You can allow Multiple answers and Anonymous responses.
Add to favorites Keep conversations you access most at the top by marking them as favorite. Press on the ellipsis and select Favorite.
Try subject lines Adding subject lines makes messages easier to find. Find them in the expanded view pane in the rich text editing by clicking Format.
Attach tabs Tabs help connect users with essential files in other applications. Click Select (+) at the top of the channel and choose the one you need. Follow the steps listed, and the tab will appear at the top of the channel.

We hope that you found these Microsoft Office cheat sheets helpful, whether it is for your studies or other projects. If you think that these tips and tricks could be useful to someone else, make sure to share them around.

Thank you for reading!

🔗 References

Comments