Sau khi hoàn thành các khóa học này, tôi cảm thấy tự tin khi tạo các trực quan hóa và bảng điều khiển chuyên nghiệp
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Mô tả khóa học
Yêu cầu tiên quyết
Chương trình học
Đề cương khóa học
1
A Primer on Conditional Formatting
Learn what conditional formatting is and how it can be used to emphasize the important data in a spreadsheet. We will discuss a variety of the built-in options you can use to apply conditional formatting rules to your data.
- A primer on conditional formatting50 XP
- Conditional formatting100 XP
- Additional rule100 XP
- Conditional formatting of top and bottom values50 XP
- Greater than100 XP
- Weight range100 XP
- Auditing an expense account100 XP
- Conditional formatting using dates50 XP
- Before last week100 XP
- All dates except June100 XP
- Dates100 XP
2
Custom Application of Conditional Formatting
In this chapter, you will learn how to apply conditional formatting in more flexible ways. We'll discuss a variety of functions you can use to create conditional formatting rules with custom formulas.
3
Conditional Formatting Hacks
Learn tricks to use conditional formatting in unique ways! In this chapter, you will learn more functions, build your own searches, and make interactive task lists with checkboxes.
4
Putting It All Together
In this chapter, you will use everything you have learned about conditional formatting to analyze a company's payroll. You will be working with dates, looking for duplicates, and checking for errors to create your report.
S
Định dạng có điều kiện trong Google Sheets
Hoàn
thành khóa học
