How to Recover an Unsaved Word Document

Does this situation sound similar to you? You were working in a Word document and suddenly the computer crashed. Maybe it crashed because of technical reasons or the loss of electric power. Or, you closed the document without thinking and now you don’t know how and if is it possible to retrieve it. Luckily, it is possible! Find out how to recover unsaved Word document and save your hard work.

 

There are two different types of unsaved documents:

 

  • A document that was originally saved but some of its updated versions wasn’t saved. In other words, you worked in a Word document and you saved one version. After some time you added more data in the same document but something went wrong and the latest version of your work wasn’t saved.
  • A document that was never saved at all. You were working in a document and you didn’t save it at all. This is more complex situation.

 

So let’s start from the first situation!

 

No matter what version of MS Word you are using, there is a way to retrieve unsaved document. The following guide explains how to recover unsaved Word document in versions 2010, 2013 and 2016.  All these three versions of Word have the same process. Later on in the text, we will explain how to recover unsaved Word document in older versions Word 2007, 2003 and 2002.

 

How do I retrieve a document that was not saved?

 

how to recover unsaved word document

Although sounds impossible, MS Office made it quite easy to recover documents. Just click on the File menu and you will see a list of recent documents as well as some additional documents options, such as Save as, Export, Print etc. If you don’t see that list, click on the Recent button.

 

At the bottom of the document you will see the option to Recover Unsaved Documents. By clicking on it, a list of recent unsaved documents will appear, and you just need to click on the document you need.

 

How do I recover an unsaved Word 2007 document?

 

Older versions of Word, such as Word 2007 don’t have this option to recover unsaved documents with the click of a button. The steps are a bit complex compared to newer versions.

First you need to click on the Office button and then the Word options button.

Click the Save button you will find in the Navigation Pane.

Have a look at the path of the file, that is placed in the AutoRecover file location box.

word 2007

 

Now close everything and head to that location to find the lost file. The file will have an .asd extension because it is an autorecover file. As soon as you find the file, open it and save it.

 

How to recover unsaved Word document in Word 2002/03?

 

These old versions of Word have a totally different procedure compared to newer versions.

Start by clicking on the Tools and then on Options.

 

In the File locations tab, click on Auto-recover files.

 

The following steps are the same as with the Word 2007. So close everything after you had a look at the file path and then find the file by following that path. Again, the file you are looking for will have an .asd extension because that is an extension for autosaved files.

 

Have in mind, if you don’t see the whole file path, click the bottom arrow in the folder name in the Modify location dialog.

 

Where does Word save AutoRecover files?

 

Word saves AutoRecover files in recent files box – for Word 2010, 2013, 2016.

In Word 2010, autorecover files can be found in Autorecover file location box. In Word 2002 and 2003 you will find such files in File locations tab, under autorecover files.

 

As for the exact location of such files, you can actually choose it or change the default location of autorecover files.

 

For Word 2010, 2013, 2016, click on the File tab>Options.

A window will pop up, find the Save menu on the left.

 

In the Save section you will see an option (as shown on the image below) where you can set up the location.

autorecover files

Click the Browse button to change the location where autorecover files will be saved and then click OK to confirm the changes.

 

What else can you change here?

 

It is set up by default that files are saved automatically every 10 minutes. You can change the timeframe and have your files saved every 5 minutes or so. These setting is available in the same window above the autorecover file location, see an image above.

As you can see Word saves documents by default, when they are closed without saving. As long as this option is ticked, rest assured you can recover unsaved documents.

But, what about situation two, when you were working in a document for the first time, and it was never saved before?

The same rules apply here under condition you have the abovementioned option checked- Save Autorecover information every…minutes.

You can find the autorecover files in the same way, just follow one of the guidelines above.

 

Temporary and Backup Files in Word

 

But, there is more. Did you know that apart from autorecover files Word has temporary and backup files?

 

Word saves backup files only if you have ticked, or it has been ticked by default the option Always create backup copy.

 

In newer versions of Word (2010, 2013, 2016), that option can be found in the same window we mentioned above. Click File and Save to open that window. Then click the Advanced option and tick the box Always create backup copy.

create backup copy

In Word 2007, the same options you can find when you click the Office button.

 

Did you know? Backup files have .wbk extension.

 

There are different method to search for backup files. You can either search in the search box of Windows, or directly via Word.

 

If you want to search your computer, just type the extension in the search box and all files of that nature will show up.

Another way is to open Word and search for all files. In the list of files, look for files with .wbk extension.

The step for opening all files in Word, is pretty much the same for all versions, or with slight differences. You need to click on Open and then Files of type> all files.

 

And what about temporary files?

 

Temporary files have a .tmp extension and that is what differs them from other files. Word chooses when such files will be created. The name speaks for themselves, files are on your computer only temporarily.

 

What is good, if the document you were working on and closed it without saving, was saved automatically as a temporary file, you can find it and save it as a regular file.

 

You can use the search box again and type this extension name in it. All the temporary files will be listed and hopefully the file you need will be there.

 

Conclusion

 

Even if you are careful enough when working in Word, and make sure your document is saved before closing, you cannot control certain situations. Your computer might stop working due to a power loss or some technical issues, and the document you were working at the time, is at risk of losing precious data. Fortunately, Microsoft Word has solutions to help such situations pass without serious consequences. Hope that this guide on how to recover unsaved Word document gave you enough insight into the problem and its solutions.

 

How to Double Space in Word

How skilled are you at text formatting? If you are using Word for business or school purposes, you should know how to format your document properly. Content does matter, but the way it is presented in a document is equally important. A well formatted document is easier for reading and reviewing. If you need to send your Word document to your boss or teacher for a review, double check if your text was formatted well. Here you will learn how to double space in Word and have your text presented in a more visible way.

 

What do you mean by double spaced?

Double space refers to the text formatting option in Microsoft Word, that actually makes space between text lines. For instance, if you want to use the printed version of a Word document, it would be better to make wider space between lines so you write comments under specific part of the text. Also, when there is double space between the lines, your text will be easier to read.

 

How do you double space words in Word?

For Word 2007 and 2010 users

 

In the Styles section, right-click with your mouse on the Normal style first.

Next step is to open the Modify option and choose the Double space button and then click OK.

double space

By following these steps you will set double space for the whole document. If you want to format only the part of Word document, first select the text you want to format. Then in the Paragraph section, choose Line Spacing. Once you click on 2.0 option the selected text will have double space.

double space in word

Note: first set up spacing and then write in a document, so the changes will apply to the whole document. If you want to double space in Word document that already has some text, make sure you have selected the whole document. Only in that way the new settings will be applied to the previously written text.

 

How to double space in Word 2016 ?

 

For 2013 users as well

 

Click on the Design tab first, which is next to the Insert tab.

how to double space in word

Click on the drop-down menu called Paragraph spacing and choose Double option.

double space in word

Again, if you want to apply these settings to specific paragraphs of the text, first select the part of the text and then do the rest.

 

How do you double space between paragraphs?

 

If you want to change spacing between paragraphs, you can use the following guidelines. Have in mind that if you want to apply these settings to one paragraph only, you need to select that paragraph first.

 

For Word 2007, 2010 users:

 

Go to the Page Layout tab and in the Paragraph section find Spacing options. You have two fields to fill in, before– if you want to change default spacing before a paragraph and after it.

For Word 2016, 2013 users:

 

Again, go to the Design tab and Paragraph Spacing. Then click on the Custom Paragraph Spacing and the window will pop up (see the image below).

 

In the Paragraph spacing section, fill in the fields “before” and “after”.

 

This guide on how to double space in Word is just one tip for using text formatting settings to make your document look professional. Microsoft Word offers a wide range of formatting options and it is only a matter of time and practice when you will adopt all these skills.

How to Delete a Page in Word

No matter how often do you use Microsoft Word, you have probably encountered the following problem at least once. Even though it sounds pretty easy to solve, it is always frustrating when you need to delete a page in Word, especially when it is a blank page. So how to delete a page in Word document?

There are different ways to do that and you can choose the right one depending on the position of your (blank) page. A (blank) page can usually be found at the end of the document, but also in the middle of it. Blank pages usually emerge when you make a page break or when your document contains empty paragraphs which you don’t see. Before you start removing the page you should figure out why the blank page is showing up.

 

You don’t know why the blank page appears

 

Follow this short tutorial to discover why there are blank pages in your document:

Use keyboard commands CTRL+SHIFT+8  to have the paragraph marks turned on, or click the Show/Hide ¶ option on the right top side of the Home tab.

 

how to delete a page in word

 

What does this sign  ¶ mean?

 

That is the sign for an empty paragraph on the blank page. You can select the empty paragraph with the left mouse click and press the Delete key to remove the paragraph.

 

How to Delete a Page in Word That is Completely Blank

 

Quick solution when a page contains empty paragraphs

 

If you have a blank page in a document, that probably means that your document contains empty paragraphs. To get rid of it, click with your mouse at the end of the document and press backspace key as long as the blank page doesn’t disappear. Sometimes, you will need to press the key only once where there is only one empty paragraph. Oftentimes you will need to press that key multiple times, because of multiple paragraphs showing up in the blank page. If you prefer to use keyboard press CTRL and End at the same time and then Backspace key.

 

See How It Works with the Navigation Pane

 

Open the navigation pane by ticking the checkbox Navigation Pane that is placed in the View menu under the Show tab. Click on the blank page thumbnail and then on the Delete key. The same as in the first example, you may need to press the key more than once.

thumbnails

 

Your blank page is a result of manual page break

 

Blank pages usually appear at the bottom, but like we said, sometimes they can appear in the middle of a document. The most probable reason for that is a manual page break. When you manually add a page break, it may result in a blank page showing up. To remove this page just left click on your mouse before the page break and press the Delete key.

You don’t see manual page break

 

If you cannot see the page break and a blank page is there in the middle of your document,  you can turn paragraph marks, which we have already explained how it is done.

 

How to Delete a Page in Word that is not Blank

 

If the page you want to remove from the document contains text, guidelines are a bit different. Start with the left mouse click at the beginning of the content you want to remove, then press and hold the SHIFT key on the keyboard, and finally click at the end of the content. By using these three-step process, you will be able to select the content and to remove it.

The final step is to press the Delete on your keyboard, but before you do so, make sure you have selected the right piece of content.

Note: when you accidentally remove a page in Word, which you didn’t plan to, just click on the Undo button.

 

Your blank page is a result of section page break

 

Section page breaks are divided into three categories: next page, odd page and even page. In all three cases, a blank page can occur. In the same way as with a manual page break, click before the section break and then press the Delete on the keyboard. This solution is applicable to the situations when a blank page is at the end of a document. If a blank page appears somewhere in the middle of a document, due to the section page break, you need to be more careful so as not to make a mess with the document formatting.

 

Your blank page is a result of an empty table

 

So far you have probably learned how to delete a page in Word but it may happen that your blank page is still there although you were trying to remove it. That thing that can cause you troubles apart from page breaks, is a table. If you inserted a table in a Word document, and that table is spread across the whole document, there will be an empty paragraph right after the table and you won’t be able to remove it. This is just a Word feature. Of course, there is a way to resolve the issue if you want to delete a blank page:

Hide the empty paragraph at the bottom of a document!

To do so, first find the paragraph mark and select it with a click of the mouse. Press CTRL and D keys on the keyboard simultaneously and the Font dialog will be opened. Tick the Hidden box to hide the paragraph or change the font size to 1 point to make that  paragraph smaller. When you finish, you can turn off the paragraph mark by following these steps:

font changes

Click the Show/Hide button on the Ribbon OR press CTRL, SHIFT, 8 at the same time.

 

How Do You Delete Multiple Pages

 

You can delete one page at the time, to make sure everything goes well. In that case, follow some of these rules above to remove a blank page or a page with content.

However, if you want to save time and to delete multiple pages at once, keep reading the guide.

Note: This may come in handy when you are dealing with large documents, with a lot of pages.

 

You want to delete multiple pages at the same time, and those pages are in a consecutive order.

 

This is easy, you can use the left mouse click to select the pages and then press Delete.

 

You want to delete multiple pages but not all of them are in a consecutive order.

 

This is a bit tricky. Let’s say you a have a document with 80 pages and you want to delete pages from 25 to 28, then from 43 to 47 and then from 78 to 80. You cannot delete all these pages at once, but at least you can delete those pages that are in consecutive order.

Here are the steps:

Press F5 on your keyboard and the Find and Replace dialog will appear.

 

delete multiple pages

 

In the Go to tab, type the page number (the number of the first page in a range) and click on the Go to button.

Press F8 button to extend the document, and again F5 to repeat the first step. This time, type the number of the page that first comes after the last page you want to delete. For instance, if you want to delete pages from 25 to 28, you will type 29 here.

When you click on the Go to button again, the chosen pages will be selected and ready to be removed.

How to Convert OXPS to PDF

convert oxps to pdf

Converting files from one format to another is nowadays very easy task to do because of PDF conversion tools. However, there are some file formats that are harder to convert to another format or simply users are less familiar with those types of conversions. It is safe to say that .oxps to PDF conversion is on that list. One cannot convert oxps to PDF with every regular PDF converter and the same goes for xps to PDF conversion.

 

What is an Oxps file extension?

Oxps file is actually xps file format, that is created on Windows 8. OXPS stands for Open XML Paper Specification format. You can create .oxps file with almost any Windows application. However, you can view .oxps files only with Microsoft XPS viewer.

What kind of file is Oxps?

Xps and oxps are very similar to PDF because content can be preserved and the layout is fixed. You can sign oxps files and you can search through them. You can also zoom in and out the file. Unlike PDF, oxps file are not so popular and used. Maybe that’s why it is hard to find tools that will easily manipulate this type of file.

How do you print to PDF?

Since PDF files are more convenient for usage than xps files in general, you will probably need to print oxps or xps files to PDF. When you create a PDF file, you will be able to edit it further or to convert it to multiple other formats.

In order to convert oxps to PDF you need to download PDF Converter Elite on your computer. Once you download the program, PDF Converter Elite virtual dispatcher will also be downloaded on your computer. You will use it to print oxps or xps file to PDF.

First start XPS viewer and click on the File menu and then Open. Locate xps or oxps file you want to print to PDF and click on Open again. Again, click on the same File menu and this time Print button will be available. Print window will show up when you click on the Print button and there you will see PDF Converter Elite print dispatcher.

Select PDF Converter Elite print dispatch and click the Print button to convert oxps to PDF. With PDF file you will be able to extract or edit data more easily.

 

How to Split Cells in Excel

When working with Excel, you may encounter many difficulties that will slow down your work. Luckily, there are many Excel tips available online and you can find them and use them very easily. Whereas solutions to common Excel problems can be found quickly, solutions to those less common Excel problems are harder to find. One such difficulty you may experience while working with tabular data is to split cells in Excel. Oftentimes wrong data is placed together in one cell and you need to make more cells in order to split that data.

Unfortunately, there is no such option in Excel that can divide one cell into multiple smaller cells but still, there is a way to split cells in Excel. If you follow the steps below you will be able to divide content and place it in separate cells.

Firstly, select the cells you want to split. By clicking on the Data menu, a toolbar like this one shown on the image below will appear.

split cells in excel

In the Data Tools tab, click on Text to Columns and then on Delimited option. When you click on Text to Columns, a window will show up asking you to choose between Delimited and Fixed Width.

split cells

Then click Next and another set of options will appear.

At the top of the window you will see a set of delimiters options, and you should tick one delimiter  that is the most suitable. You can choose more than one delimer and in that case, tick the box Treat consecutive delimiters as one. The data preview panel shows how the data will look like when it is split in multiple cells.

cells in excel

When you click Next button one more time, you will be able to format column data, by setting up the options in Column data format area.

split cells

When you are done with formatting just click the Finish button.

Additional notes:

If you are working with big data it is required to make a copy of the spreadsheet first and then to split cells in Excel.

If you are asked to replace the content of destination cells, cancel that operation, select different delimiter and modify data in the original column.

No matter how often do you work with Excel, learning new Excel skills can only help you with data analysis and other data manipulation tasks.

 

 

 

 

How to Add Page Numbers in Word

Many Microsoft Word users don’t know how to add page numbers in Word. Even if they knew how to insert numbers, the problem arises when a document would have the introduction or a table of contents. That first introductory part of the document shouldn’t include numbers which means that a user must skip a couple of pages at the beginning. Since Word has automatic number labeling, a user must set up page numbering manually.

The following guide applies to Word 2016, 2013, 2010 and 2007. First, we will show you how to add page numbers in Word and then we will share with you some advanced techniques.

 

Guide 1: How to Add Page Numbers in Word

 

First, open the exact page in the document from where you want to start page numbering. Then click on Insert menu and then on Page Number option in the Header & Footer tab.

insert page number in word

You can have a closer look at the Page Number option, on the image below.

how to add page numbers in word

 

You can add page numbers at the top or bottom of the page, page margins or from the current position. For instance, if you click on Top of Page, a wide range of numbering styles will appear and you need to choose from one of these.

 

Guide 2: Add Page Numbers in Header or Footer

 

If the header or footer of your document contains text such as the name of the book chapter or the head name and you want to add page numbers as well, the above guide won’t be of any help. For that purpose, you need to apply a bit complex settings.

First thing first, double mouse click on the header of footer area and the Design menu will open. Click on it and then in Position tab, select Insert Alignment Tab.

header and footer tools

 

You can place your numbers on the left, right or centrally. Below is shown how the Alignment Tab looks like.

 

add page number

 

Don’t close the Design mode but select the Quick Parts option from the Insert tab. Choose Field option.

 

quick fields

 

In the field name find the Page and then in the Field properties choose the proper number formatting.

 

page number formatting

 

Click OK and then close the Header and Footer tools.

 

Guide 3: Set up Page X of Y Format

 

Follow the guide 1 to insert page numbers and upon choosing the location where you will put the numbers, choose the style. One of the styles is Page X of Y which offers three different types of bold number.

If your header or footer contains additional text, you need to follow the guide 2 and upon opening the Quick Parts tool and Field option apply these steps below:

Under the Field names list, choose NumPages name and then click OK.

From the Header & Footer tab, select Format Page Numbers and then choose the preferred format of numbers.

 

choose number format

 

Guide 4: Use Different Numbers Formats in the Same Document

 

Follow this guide if you want to use different number formats such as i, ii, iii and 1, 2, 3. Click on the page in the document where you want to start page numbering with different format.

From the Layout menu, in the Page Setup tab, select the Breaks option.

In the Section Breaks click on Next Page and then double click in the area where you want to insert a number.

The Design tab will open again and this time, you should click on Link to Previous button. By doing so, you will unlink the page numbering from a previous section and this part of the document will have different page numbering.

To set up the new format of page numbering, just follow the guide 1.

 

Start Page Numbering with Different Number

 

In some cases,  you may want to use some other number as a starting number and not the number 1. Following these steps to start page numbering with a different number:

Click on the Format Page Number option in the Header & Footer tab.

In the drop-down menu Start at, type the number you want to be your starting page number.

 

page numbering in word

 

How to Embed a YouTube Video in PowerPoint

With over 30 million presentations created every day, Microsoft PowerPoint is without any doubt the most popular slideshow creator on Earth. Used extremely frequently both in business and in education, this software allows users to expeditiously manage their presentations, which can later be applied to a wide array of possibilities.

Another interesting fact is that 120 million people use PowerPoint for business, and more than 6 million teachers depend on it for classroom lectures. A relatively new feature to PowerPoint is that you can embed YouTube videos onto a presentation, which can be more than convenient at times.

As the world’s largest free video hosting service YouTube doesn’t really require any kind of special introduction, so if you require embellishing your presentation with a YouTube video and you’re not sure how to do it, continue reading this post!

 

So, how exactly to embed a YouTube video in PowerPoint?

 

Firstly, it is important that you own a 2016, 2013 or 2010 version of PowerPoint, because otherwise the embedding won’t work.

 

  1. The beginning step is to open the YouTube video you require embedded with your browser. It’s also vital to note that YouTube is the only streaming website that is supported by PowerPoint, so you cannot use other stream-based sites.
  2. Select the Share option on that specific YouTube page. You will find the Embed button exactly below it. Just copy the highlighted code (with the right click mouse button, or with Ctrl+C on your keyboard).

how to embed a youtube video in powerpoint

  1. Open PowerPoint and select the specific slide you wish to add the video on. Click on the Insert tab, where you’ll see the Video button among other options.

embed video in powerpoint

Click on it and select the Online Video option. In case you’re using the 2010         PowerPoint version, click the Video from Website button.

  1. The next step is to select the Paste embed code here option, or you can just use the Ctrl+V, or right click your mouse and press Paste. Then click on the arrow to insert a video into PowerPoint.

how to embed a youtube video

  1. Once you’ve completed these steps, the video will emerge on your slide. Most probably it’ll just appear like a black box, but do not fret, because this is normal.
  2. The next phase is to select the Playback tab, which will open all the options for the video. Click the Start drop-down list and choose how the video will play. It’s very important that you select one of these given options, because the video won’t work without it.

insert video in powerpoint

  1. When you are planning to present your PowerPoint presentation, make sure that you have a reliable Internet connection, which is a mandatory requirement for the YouTube videos to be played.

How to Insert a PDF into a Word Document

Regardless of your job occupation, document management is an inevitable part of every work day. If you often work with MS Office documents such as Word, Excel or PowerPoint, you probably know that there is an option to insert different objects into that document. Not only can you add illustrations and tables, but you can also add images and PDF documents. It is particularly convenient when you want to add data from a different document. Since most documents are preserved in PDF, converting that PDF to Word and then copying the data in Word document you are working with, can result in losing the formatting. Moreover, it can altering the formatting of the working document as well. For that reason, it is more safe to insert PDF into Word. To do so you just need to follow the instructions below:

Insert PDF into Word

 

Open a Word document you are working with and click on the Insert menu. It is placed next to the Home menu.

ms word insert menu

Click on the Object button and then on Create from File tab. You will find Object button in the Text tab as shown on the image below.

insert pdf into word

When you open the Object window, it will look like this:

Continue reading >>

How to Convert Scanned PDF to Word

Did you know? Managing documents can have direct and huge impact on your productivity. Imagine you have received a document via email and you cannot open it or the formatting is lost because you and the person who sent the document don’t use compatible programs. If you deal with paper documents, it may probably happen that you cannot find the paper document you need or your desk is covered with a pile of papers. There are many examples that prove that going paperless is a must and adopting your business to paperless method of document management, necessarily involves dealing with scanned documents.

Why people use scanned documents?

The answer is simple. Long time ago, everything was kept on paper. When business turned to paperless technology, they couldn’t start from scratch and just forget about paper documents. They had to be transferred in a digital form. The only way to do that is via scanner and the result is a scanned document. Scanned documents are usually saved in PDF format. The problem arises when you need to edit a scanned document, because not all PDF conversion tools can successfully convert scanned PDF files.

How to Edit Scanned PDFs?

If you need to edit a scanned PDF first you need to convert it to editable file format such as MS Word, Excel and other. After the conversion you just need to open a converted file in one of these programs and edit its content. If you convert a scanned PDF to Word and the conversion result cannot be edited, that means you converted a file from one format to another, for example, from PDF to Word, but it is still unusable- the text is still locked within an image. That means, the PDF converter you use doesn’t have the OCR technology. OCR stands for Optical Character Recognition, and only if a PDF converter has an integrated OCR, it can convert scanned PDFs.

How to Convert Scanned PDF to Word?

There are three ways to convert a PDF to Word: online- by using PDF to Word online, offline- using desktop PDF Converter Elite program, on your mobile phone- using some of the numerous PDF mobile apps on the market. You can convert scanned PDFs with both tools mentioned above, because they have integrated OCR technology.

To convert a PDF to Word online:

  1. Click here and tap on Choose File button.

convert pdf to word

  1. Enter your email address where you want to receive the download link to your file.
  2. Click Start button and within a few minutes expect a converted file in your inbox.

pdf to word

To Convert a PDF to Word with PDF Converter Elite:

 

  1. Download the program here.
  2. Run the program and click the Open icon to locate a scanned PDF you wish to convert.
  3. Click the Edit menu and tick Convert Using OCR option. You will find it in OCR Options section. In that way, you are turning on the OCR engine.
  4. Click the Word icon to convert a scanned PDF to Word.

scanned pdf to word

  1. On the right side panel, choose one of three selection options. You can select the whole document, only an area of the document or the certain pages.
  2. Choose the conversion mode and click the Convert button.

Types of Excel Charts Used in the Classroom

classroom

Although there are many education technology tools that teachers use, and a vast number of them is tailored for any imaginable occasion, most teachers still don’t want to leave MS Office behind. It is widely known that PowerPoint and Word are the most popular programs among teachers because they can use them for research papers, essays, lesson presentations and handouts. However, a widespread use of Excel cannot be ignored. Some people think that Excel is only for accountants and auditors but the truth is, even teachers can use it. For instance, Excel charts can be very well employed into daily activities of one teacher. There are different types of Excel charts and each of them has different purpose in the classroom.

Most Used Types of Charts

excel charts

Anchor Chart

Anchor chart is not a default Excel chart you can add in your spreadsheet but there are tons of Excel templates of anchor charts in Excel. Anchor charts are actually a powerful learning tool that help teachers not to lose track of the lesson and to help students remember the most important things. Anchor charts are usually printed out and displayed in the classroom for future revision and they can be used for all subjects.

Treemap Chart

These kind of charts can be used by students to present their family teachers or they can help language teachers with vocabulary lessons. Generally, they can help to any kind of writing.

Pie Chart

These charts are one of the most popular because of their visual look. They are usually colorful and represent the percentage. In elementary classroom it is especially convenient to use the pie charts when learning kids math basics and fractions.

Flow Chart

There is no default flow chart you can just insert into Excel spreadsheet but you can learn how to create a flow chart in Excel here. Flow charts are explanatory charts that give step-by-step guide to the students. Teachers can use them to further explain complex processes in physics, biology, history etc. Flow charts improve students’ organization skills and the learning process.

Bonus chart for busy teachers: Learn how to create bullet charts in Excel. Bullet charts are also necessary for teachers but not available in Excel. In other words, you need to make them by yourself.