|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-to-use-excel-conditional-formatting-with-examples/
课程评论：没有评论
本课程名为“用7个实用问题学习Excel条件格式”，教授Excel和数据分析相关知识。课程涵盖范围广泛，已有超过25000名博客访问者和15000名成功学员。 课程主要内容包括： * **突出显示单元格规则：** 学习如何使用条件格式规则突出显示单元格。 * **顶部/底部规则：** 掌握使用顶部/底部条件格式规则。 * **数据条：** 学习如何实现数据条可视化。 * **色阶和图标集：** 学习使用色阶和图标集来增强数据可视化。 * **基于公式的条件格式规则：** 课程将通过7个实际案例，教授如何利用公式创建独特的条件格式，帮助学员成为公式条件格式的专家。每节课都配有练习题。 * **管理条件格式规则：** 学习如何有效地管理条件格式规则。 * **定位条件格式单元格：** 学习如何在工作表中快速找到应用了条件格式的单元格。 课程将不时更新，增加更多关于如何应对实际数据可视化问题的讲座。本课程适合希望通过实际问题学习Excel条件格式功能的学习者。
Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016Visualizing data is the core idea of all type of data analyzing. Excel conditional formatting is a very useful Excel tool to visualize numeric data. And Microsoft has updated this tool in every version of Excel. In this Excel conditional formatting crash course, we will discuss conditional formatting features using Excel 2013 version. Let's discuss now what you will learn from this course. High Light Cells Rules: At first you will learn how to highlight cells using conditional formatting rules.Top/Bottom Rules: Then you will work with Top/Bottom conditional formatting rules.Then you will use data bars.Then you will work with Color Scales and Icon sets.Formula based conditional formatting rules: Using formulas in conditional formatting rules will give you huge benefit to visualize data in unique ways. I have used total 7 practical examples to teach you formula based conditional formatting rules. And I have added some relevant practice problems with every lecture. If you watch the lectures and practice the problems, I can guarantee, you will be an expert in using formulas in conditional formatting rules.Then I have showed you how to manage conditional formatting rules.And finally I have showed you how to locate conditional formatting cells in a worksheet.Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel conditional formatting rules. So, if you are interested to learn Excel conditional formatting features with real life problems, then this course is for you. Thanks for reading. Enjoy the course!
