Microsoft Excel Data Visualised and Data Formatting
In this Microsoft Excel Data Visualised and Data Formatting training course, delegates will learn how to quickly interpret and analyse data sources using Excel. After completing this course delegates will be able to:
Course Files
Less Than and Greater Than
FREE PREVIEWLess Than, Greater Than and Equal To
Multiple Less Than, Greater Than and Equal To
Between
Equal To
Text That Contains
Date Occuring
Duplicates
Above and Below Average
Top and Bottom Items
Top and Bottom Percentage
Managing and Clearing Rules
Multiple Examples of Data Bars
Multiple Examples of Colour Scales
Multiple Examples of Icon Sets
Date Conditional Formatting Formulas - Example 1
Date Conditional Formatting Formulas - Example 2
Duplicate Rows Formatting - COUNTIF Function
Empty Cell Formatting - AND Function Formulas
Multiple Nested Functions - IF, AND, OR
Target Setting - Standard Formulas
Text Formatting - Average Function
Wingdings Formatting - Chart Function
Data Validation Lists and Conditional Formatting
Conditional Formatting and Paste Special
Linked Data and Conditional Formatting
Sparklines - Formatting and Modifying
Sparklines and Linked Picture - Dashboard
Richard Walters
Senior Microsoft Application Instructor
Bundles
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.