EXCEL advanced functions

array formulas, template lambda functions

This course primarily focuses on new array formulas or programming formulas, requiring an OFFICE 365 or WPS software environment. such as MAP, BYROW, TOCOL, SEQUENCE, CHOOSECOLS, LAMDBA, LET  etc.

What you’ll learn

• Master advanced Excel formulas..
• Become an array formula expert..
• Acquire the skills to create complex charts..
• Acquire the proficiency to craft dynamic templates..

Course Content

• Array Formulas –> 30 lectures • 4hr 13min.

Requirements

• This course primarily focuses on new array formulas or programming formulas, requiring an OFFICE 365 or WPS software environment. such as MAP, BYROW, TOCOL, SEQUENCE, CHOOSECOLS, LAMDBA, LET  etc.

• The course materials are sourced from mainland China, summarizing and refining real-world spreadsheet problems encountered across various industries—such as logistics, manufacturing, agriculture, real estate, human resources, and more, along with their solutions. While you may not have encountered these issues before, the Chinese approach to solving them may broaden your perspective and provide new insights.

• This course is not suitable for absolute beginners but is highly recommended for those transitioning from an intermediate to an advanced level. And Some formulas in this course can be directly applied to similar scenarios by adjusting the cell reference ranges, without requiring thorough comprehension.

• The course videos feature an English interface and audio narration, though the narration is delivered in non-native English. Please refrain from purchasing if this is a concern.
• The course will be updated periodically, but the price will remain unchanged at its most affordable level in the long term. The course progresses from simple to complex, gradually increasing in difficulty. It will includes 40 recorded lessons and more, each averaging between 8 to 15 minutes in length.