Description
Learn to use Conditional Formatting and Comparative Analysis to read and analyze data, and to use and create Excel templates—all in under 30 minutes! When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our Excel in 30 Minutes series can help you get started. By the end of this course, you will be able to use Conditional Formatting and Comparative Analysis Formatting to easily read and analyze data, as well as access and create templates for predefined formatting. This course is one of 10 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Basics” course.
Objectives
- Use Conditional Formatting to make it easy to read and analyze your data
- Apply Conditional Formatting to Text and Dates to easily identify certain values or duplicates
- Apply Comparative Analysis Formatting to add Data Bars, Color Scales, and Icon Sets to your worksheets
- Access built-in Templates and create your own Custom Templates to use predefined formatting
Certificate
By completing/passing this course, you will attain the certificate POK Microsoft Skills Certificate
Learning Credits
Badges
{{ badge.name }}
{{ vm.helper.t('lup.gamification.value') }}
{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}
{{ badge.name }}
{{ vm.helper.t('lup.gamification.value')}}
{{ vm.helper.t('lup.gamification.achieved') }}
Shopping Cart
Your cart is empty