Tag: excel

Categories
Excel Training

Microsoft Excel Course 2013: Suggested Charts through Quick Analysis –

So many times people pick the wrong chart type for their data. There’s a time and a place for pies, and lines aren’t for everyone. Picking the right one takes a bit of thought.

The Charts option in the Quick Analysis gallery, a new feature for Excel 2013, allows the user to quickly view and analyse data by choosing a variety of chart types. Excel will predict which chart types will best suit your selected data. Scroll through the different chart types until you’ve found one that works for your message.

Charts through Quick Analysis

How to: Highlight some Excel data in a table and look for the Quick Analysis tag to float over the bottom-right corner of your selection. Put your mouse over this icon to explore the options.

For more tips and features on Excel 2013 and other versions, browse Microsoft Excel course from STL, available London and UK wide. Our instructor-led training ranges from introduction to advanced Excel and also Excel VBA.

Categories
Excel Training

Excel 2013: Conditional Formatting through Quick Analysis

new feature for microsoft office 2013If you’ve got a lot of data, it’s not always easy to spot trends and to easily analyse your figures. Conditional Formatting can instantly show you patterns in your data by highlighting cells that meet certain conditions. So for example you might want to flag up sales below a certain threshold in red, or bold occurrences of a certain word. This feature has been present in Excel for years, but in Excel 2013 there’s a faster way to get to visualise patterns.

Excel 2013 has introduced Formatting through Quick Analysis. In the below example, Colour Scale Formatting is used to look for high and low spots and highlighting them as such.

Colour Scale Formatting for Excel 2013

How to: Highlight some Excel data in a table and look for the Quick Analysis tag to float over the bottom-right corner of your selection. Put your mouse over this icon to explore the options.

Icon Set is another option available under Quick Analysis formatting. For example totals meeting a target display a green arrow or a red arrow if they don’t.

Suggested options not doing it for you? You can always create your own Conditional Formatting rules.

How to: Conditional Formatting > Manage Rules (to define the target criteria)

Conditional Formatting in Excel 2013

For more tips and features on Excel 2013 and other versions, browse Excel courses online from Best STL, available London and UK wide.