ELearnExcel |

[...] box. Try it out in the your worksheet: Now the best part, combining the above list with conditional formatting to achieve out desired result. For example when a user selects Cancelled from the [...]

[...] that there are 5 possible options. Formatting The formatting option, allows you to apply conditional formatting options without having to go to the HOME tab and choosing Conditional formatting. Very [...]

[...] Format Painter is a great tool, it can be used in any of the Office Applications, it allows you to copy [...]

[...] , insert, delete, protect etc.. and then click on the plus + button to insert new sheets. Quick Analysis Tool When you select data in Excel, you will now see a little smart tag appearing on the bottom [...]

[...] The Quick Analysis tool as the name suggests allows us to select data on our sheet and then quickly analyse it [...]

[...] , we can now download apps for our office applications too. Excel 2013 has this option in the INSERT tab. In order to use this option, you will need a Microsoft account, if you don’t have one, [...]

[...] without having to change the tabs to locate the tools.       The Ribbons On the INSERT tab we have the following new icons in 2013:   Recommended Pivot tables: Gives you [...]

[...] a second conditional format to the cells. Highlight the cells to be formatted, B2:B12. On the Home tab, click on Conditional Formatting To format the text Cancelled, click on Highlight Cell Rules, [...]

[...] in this row: Select the cell that has the formatting and then Click once on the Format painter (Home Tab, Clipboard group) Now highlight the cells that don’t have the formatting, cells B1 to L1, [...]

[...] option, allows you to apply conditional formatting options without having to go to the HOME tab and choosing Conditional formatting. Very quickly you can apply the options of data bars, colour [...]

[...] clearly to the user that the project or course etc. has not been given the go ahead. What is Data Validation? The data validation feature in Excel can be very useful when creating forms or reports. It [...]

[...] easy to use and very intuitive, give a couple of them a go and see what you think!   The post Excel 2013 – New feature: Apps for Office appeared first on eLearnExcel. [...]

[...] to save the file as a PDF/XPS or as other excel file types as listed       The post Excel 2013 – The New Features at a glance appeared first on eLearnExcel. [...]

[...] . Once the Sparkline is created further options can be accessed through the Sparklines tab. The post Excel 2013 – New Features: Quick Analysis Tool appeared first on eLearnExcel. [...]

[...] to the cells B2:B12: Highlight the cells to be formatted. On the Home tab, click on Conditional Formatting To format the text Level 1, click on Highlight Cell Rules, then select Equal To… Type [...]