Display the Text That Contains dialog box to conditionally format cells whose text contains the text set in the rule. Display the Above Average dialog box to conditionally format cells that are above the average in the selected cell range.

Display the Bottom 10 Items dialog box to conditionally format cells that rank within the bottom values in the selected cell range. Display the New Conditional Formatting Rule dialog box, with the Format only top or bottom ranked values rule type selected.

Display the Top 10 Items dialog box to conditionally format cells that rank within the top values in the selected cell range. Display the Below Average dialog box to conditionally format cells that are below the average in the selected cell range. Default settings are: 1 2 decimal places, 2 separator, and 3 minus – sign for negative values. Default settings are: 1 2 decimal places, 2 separator, and 3 negative values within parentheses.

Function name must have already been typed and insertion point must be to the right of the function name. May not work in certain particularly newer versions of Excel by default. In those cases, you can usually enable the shortcut by modifying the language bar hotkey settings and changing the setting e. Go to last cell cell in lowest used row and right-most used column of worksheet.

Add non-adjacent 1 Cells to current cell selection; or 2 Sheets to current sheet selection. Within a table: 1 First time shortcut is pressed selects active column within table; 2 Second time shortcut is pressed selects active column header if any ; and 3 Third time shortcut is pressed selects active column of worksheet.

When End mode is on: 1 Use arrow keys to go to edge of current data area; 2 Use Home to go to last cell cell in lowest used row and right-most used column of worksheet; 3 Use Enter to go to last non-blank cell to the right. When a command or control is selected, the Help Task pane displays the Help topic associated with the command or control. If no Help topic is associated, the Home of the Help Task pane is displayed.

Switch between panes in the following order: worksheet, Ribbon, Task pane, Zoom controls. Extend Selection mode allows you to extend the current selection using only the arrow keys. Switch between panes in the following order: worksheet, Zoom controls, Task pane, Ribbon. I may cover some of these topics in future tutorials within Power Spreadsheets. If you want to receive an email when I publish new material in Power Spreadsheets, please make sure to register to our Newsletter by entering your email address below:.

Overall, this first method of converting a PDF file to Excel leaves some things to be desired. The following are, in my opinion, its 2 biggest drawbacks:. There are some situations in which you may not have any other option for purposes of converting a PDF file to Excel. This is the case if, for example, you don’t have access to any of the tools that are required to apply the other methods that I explain below. In any case, as long as you have access to a recent version of Microsoft Word or to Word Online, the following method may help you achieve better results when converting a PDF file to Excel.

In broad terms, the logic behind converting a PDF file to Excel is the same regardless of which of the above versions of Word you use. You, basically, follow these 2 simple steps :. In both cases, I use the same sample table as above, which you can find in page 22 of the Working Paper from the European Central Bank titled Inflation forecasts: Are market-based and survey-based measures informative? You can open the PDF file you want to convert using any of several methods , including the following After you’ve asked Word to open the file, a dialog box such as the one below is displayed.

This dialog box informs you about the following:. As mentioned above, the conversion may take a while, so you may have to wait a little before proceeding to the next step.

Once you’ve completed step 1 and if necessary step 2 above, Word displays the original PDF file as an editable Word document. When you have the editable Word document, select the section that you want to take into Excel. In the example below, I select the same table as in the previous method:.

Once you’ve selected the relevant information in the editable Word document, copy it. For these purposes, you can use any of the following methods:. By now, you have the information you need in an editable format. Therefore, you can go to Excel and paste it by using, among others, any of the following methods:. In some cases, including this example, the conversion from PDF to Excel isn’t perfect. Notice, for example, how Word hasn’t been able to convert the values in the first section of the table Mean error to an editable form.

In this case, those values are pasted as an image. Therefore, you must use another method including those described in this Excel tutorial to bring them into Excel before being able to work with them. If you encounter problems while using Word to convert a PDF file to Excel, you can always try one of the other methods I describe in this blog post.

Even though the process for converting a PDF file to Excel using Word Online is substantially similar to that I followed when using the desktop version of Word, there are a few small differences. Once Word online has opened the PDF file, convert it into an editable document by clicking on the Edit in Word button in the upper part of the screen.

Word online displays a dialog box informing you that it will make a copy of the PDF file and convert it into an editable Word document. Confirm by clicking on the Convert button on the lower part of the dialog box. Once Word online has finished the conversion, it displays another dialog box informing you changes in the layout of the PDF file may have occurred. Click on the Edit button on the lower right corner of the dialog box. Once Word online has converted the PDF file to an editable document, the screen looks roughly as follows.

The actual document will most likely be different in your case. Go to the section of the editable document that you want to bring into Excel, and select it. In the screenshot shown below, I select the same table I use for the previous examples within this Excel tutorial:.

If you have problems when trying to copy from Word online, you can use the desktop version of Microsoft Word in your computer to continue with the process. To do this, click on the Open In Word button that appears to the right of the Ribbon tabs. If you choose to open the editable file in Microsoft Word, the desktop version of Word is launched.

You can then follow the steps I describe in the previous section to copy the relevant data. Once you’ve copied the data, go back to Excel and paste it by using among others one of the following methods:. The following screenshot shows the resulting table in Excel after I’ve adjusted the column width :.

Not surprisingly, the results are almost identical as those obtained by opening the PDF file with a recent version of Microsoft Word explained above.

Just as when opening the PDF file with Microsoft Word, you’ll notice that the results aren’t always perfect although in some cases they will be. In the case of the example displayed above, for example, all the Mean errors first section of the table are pasted as an image. In order to be able to manipulate those values in Excel, you’ll need to bring them using another method such as the other ones explained in this blog post or type them directly in Excel. If you have to constantly convert PDF files to Excel or want to avoid the shortcomings of the other 2 methods described above, it may be a good idea to use a PDF converter.

Even if you don’t end up using Able2Extract, you may want to steer clear of online PDF conversion services when converting sensitive or confidential PDF files. As when explaining the other methods above, I use the table within the European Central Bank Working Paper titled Inflation forecasts: Are market-based and survey-based measures informative? Once Able2Extract displays the Open dialog box, use it to browse to the folder where the file you want to convert is located.

Once you’ve located the PDF file to be converted, select it and click the Open button on the lower right corner of the Open dialog box. Able2Extract opens the PDF file you want to convert. Some tasks need to be performed multiple times and repetition of all the actions would consume time. In these scenarios, Macros helps in automating these tasks. A macro is a set of actions that we can run as many times as required to perform a particular task.

When a macro is created, the whole mouse clicks, and the keystrokes get recorded. For example: suppose for every month, a report is to be created for all the teachers of a school.

As it is a repetitive task, macros can come into action here. In the dialog box, enter the name of the macro in Macro name. There are some other options also in the dialog box, i. They can be filled accordingly. There are different methods by which a macro can run. Some of the methods are discussed here in this article. It is one of the easiest ways to run a macro is to create any shape in the worksheet and use it for running the macro.

The work is done! Now the shape would work as a button and whenever you click on it, it will run the assigned macro. While the shape is something you can format and play with it, a button has a standard format.

Microsoft word 2013 cheat sheet pdf free. Office cheat sheets

 
This tab contains the most-used Word features, such as tools for changing fonts and font microsoft word 2013 cheat sheet pdf free, customizing paragraphs, using styles, and finding and replacing text. Now, untick the one that says ‘Apply to just this picture’, I’m going fdee get it to apply to all адрес страницы pictures, and I pick a size, I’m going to go down to microsoft word 2013 cheat sheet pdf free size’, click ‘OK’, hit ‘Save’, and check your file size, it will be a lot smaller. For example, on the Page Layout tab you set indents and spacing between paragraphs, адрес страницы on the Home tab you set paragraph alignment and spacing between lines. This tab lets you work with a document’s overall design, from choosing freee pre-designed template or theme читать полностью customizing colors, fonts, paragraph spacing and more. New to Word are alignment guides, which make it easier to place photos, graphics and charts precisely where you want them. No matter which way you fre to the graphics, when you find one you want to insert, click it and select Insert, and the graphic is здесь directly into your document. Chrat Insider Sign Out.

Word cheat sheet | Computerworld – Handy cheat sheets with tips, tricks, and shortcuts.

This means you do not have to spend heavily on your international calls. It is indeed a vital tool developed by Microsoft to help edit or resize your images. You can resize your picture according to the dimensions you wish and increase or decrease the brightness and contrast of the image.

The Microsoft Publisher is yet another desktop publishing application predominantly used for designing broachers, calendars, banners, greeting or visiting cards, newsletters, company letter pad, and pamphlets etc.

You can download this application for free. As the name suggests, it is a project management Microsoft Office Programs that can help develop network charts and Grant charts. You can also keep a track record of the projects.

Microsoft is effective in providing some useful apps for your smartphones, specifically for office purpose. You can have easy access to them while you are not at your workplace. A few of them include-. With the help of this unique app, you can convert your mobile phone into a remote control for the desktop versions of Word, Excel and so on.

This application is mainly used for scanning images. First, you need to take a picture of the document or image through your mobile camera and then straighten the image. You can copy a file or image paste it into the word doc or the Microsoft Office Excel sheet and other desktop applications. The history of the Microsoft Office Application takes us back to the year when three different applications for Windows 3. However, later on, MS Office 1. The Microsoft Office 3.

It had all the major office applications such as Word 2. A year later the Microsoft introduced the Microsoft Office Professional with additional features like Microsoft Access 1. Microsoft 4. One of the significant aspects of this application was that it excelled from 2. Now it is important to remember that Microsoft kept on updating the versions, and hence very soon in the next year, it brought Microsoft Office 4.

The version for the Word processor was similar, but it increased to 5. Microsoft Office came into existence from August In fact, the company also released its logo in the same year with the introduction of Office 95, and it was later used in Office 97, and XP. Here the version of each and every application was raised to 7. In fact, it was available in twin versions- Office 95 Standard and Office 95 Professional.

The only dissimilarity between the two was that the 95 Professional contained an additional Microsoft Access 7. This Operating System was also available on a CD. Version 8. It was here that the computer operators could see a much improved and advanced in the applications. A number of new features were also added. The user was provided with more options by the addition of new menus and tools in MS Word and Microsoft Office Excel etc.

It also had Natural Language Systems and grammar checking,. The Microsoft Office came up with a more updated version of 9. It had adaptive menus and more options for the users.

For the first time, the Microsoft Company took a significant step by introducing the digital signature to eliminate the security threats related to large-scale viruses. When the Microsoft Office XP was launched in the year , it becomes a huge success as by then the number of people using MS office had incredibly increased worldwide.

Therefore, one could see XP being installed in a number of desktops as Operating Systems. This was version It introduced the option of Safe Mode for the first time, which enabled the users to boot the applications in case of any failure.

This was an effective and useful feature which could identify the problem and then repair it. Another useful and effective tool added in the Windows XP was the addition of Smart tag, a technology to reduce errors in typing.

Microsoft also introduced the Product Activation policy for the first time with an intention to curb the piracy which had spread throughout the world. As time moved on, Microsoft kept on launching newer and faster versions of the MS office, and the Microsoft Office was the next in this series.

The version was released with a new logo, and more importantly, two new applications were added to the suite. It also brought Windows XP style icons. The MS Outlook was made more functional, which made the task of the users much easier.

Credit goes to Microsoft for continuously offering new and advanced versions of the MS Office. The Microsoft Office , which is still relevant and used widely today, is the The Microsoft Office is the It provides a number of new features such as collaboration of the tools, customizable ribbon, backstage file menu and much more. It is available in both variants- 32 and 64 bit. When Allow editing directly in cells is turned off, moves the insertion point to the Formula Bar.

Within cell of Formula Bar, complete cell entry and by default go to the cell above. Tab is also under the Navigation and Selection and Formulas and Functions categories.

Toggle between 1 displaying cell values and 2 displaying formulas in worksheet. The Paste all merging conditional formats option is only enabled when copying a range that contains conditional formatting.

Display the Format Cells dialog box with the Number tab and the Accounting category selected. Display the Merge Styles dialog box to merge copy cell styles from another workbook.

Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill. Display the New Conditional Formatting Rule dialog box, with the Format all cells based on their values rule type selected. Display the A Data Occurring dialog box to conditionally format cells whose date occurs within the time period set in the rule.

Display the Between dialog box to conditionally format cells whose value is between the values set in the rule. Display the Duplicate Values dialog box to conditionally format cells with duplicate or unique values in the selected cell range. Display the Equal To dialog box to conditionally format cells whose value is equal to the value set in the rule.

Display the Greater Than dialog box to conditionally format cells whose value is greater than the value set in the rule. Display the Less Than dialog box to conditionally format cells whose value is less than the value set in the rule. Display the New Conditional Formatting Rule dialog box, with the Format only cells that contain rule type selected. Display the Text That Contains dialog box to conditionally format cells whose text contains the text set in the rule. Display the Above Average dialog box to conditionally format cells that are above the average in the selected cell range.

Display the Bottom 10 Items dialog box to conditionally format cells that rank within the bottom values in the selected cell range. Display the New Conditional Formatting Rule dialog box, with the Format only top or bottom ranked values rule type selected. Display the Top 10 Items dialog box to conditionally format cells that rank within the top values in the selected cell range. Display the Below Average dialog box to conditionally format cells that are below the average in the selected cell range.

Default settings are: 1 2 decimal places, 2 separator, and 3 minus – sign for negative values. Default settings are: 1 2 decimal places, 2 separator, and 3 negative values within parentheses.

Function name must have already been typed and insertion point must be to the right of the function name. May not work in certain particularly newer versions of Excel by default. In those cases, you can usually enable the shortcut by modifying the language bar hotkey settings and changing the setting e. Go to last cell cell in lowest used row and right-most used column of worksheet. Add non-adjacent 1 Cells to current cell selection; or 2 Sheets to current sheet selection.

Within a table: 1 First time shortcut is pressed selects active column within table; 2 Second time shortcut is pressed selects active column header if any ; and 3 Third time shortcut is pressed selects active column of worksheet. When End mode is on: 1 Use arrow keys to go to edge of current data area; 2 Use Home to go to last cell cell in lowest used row and right-most used column of worksheet; 3 Use Enter to go to last non-blank cell to the right.