Advanced functions and techniques
In this subject, students will learn how to use advanced functions and techniques in Excel to perform complex data analysis and calculations. Here are the key learning points:
Advanced Formatting: Students will learn how to create and apply custom number formats to present data specifically and clearly. This includes the use of custom formatting rules to display currencies, percentages or custom text formats, for example.
Advanced conditional formatting: This module covers the application of complex conditional formatting to automatically highlight data based on specific criteria. Participants will learn how to combine and apply multiple rules to visually support their data analysis.
Application of functions from different categories: Students will learn how to use advanced functions from the logic, statistics, financial math, and math categories.