Excel Magic 6 - “Speaking” the 7 Languages in Excel

Excel Magic 6 - “Speaking” the 7 Languages in Excel

The course is presented in five parts.

First, the course reveals the fact Excel has as many as 7 languages that are needed for proper modeling!

Next, the course shows as many as 4 types of formulas in Excel. They are:

o Regular formulas

o Text formulas

o Table formulas

o Conditional formulas

Third, we explain in details how to decipher the custom formatting language, and proper ways of displaying in thousands, in color, or hidden in its entirety.

Fourth, we review the formulas of calculated fields and calculated items used in Pivot tables. Also, we demonstrate ways to build a dynamic named range for easy reference.

Last, we explore basic VBA codes, the M language and the DAX language in Excel. They include:

o For Next loop

o Conditional formula in M

o SUMX() and RELATED() in DAX

Course Search Keywords

- Table formula

- Conditional formula

- Custom formatting

- Calculated field

- Calculated item

- Dynamic named range

- VBA macro

- M language

- DAX language

- Relationship

Prerequisites and Advanced Preparation

● Basic Excel knowledge

● Example: be able to open one Excel file and connect to external data files, etc.

Learning Objectives

● Master 4 types of formulas to use in Excel

● Identify 2 methodologies to format a cell display

● Understand 2 calculation formulas built in a pivot table

● Discover ways to build a dynamic named range in Excel

● Explore basic VBA codes, M language, and DAX language in Excel

Mastering Excel's programming languages

Url: View Details

What you will learn

• Intermediate to Advanced Excel skills that will help you
• - to ace your Excel skills,
• - to find state-of-the art Excel functions,

Rating: 0

Level: Intermediate Level

Duration: 1.5 hours

Instructor: Lenny Wu, MBA, CPA, CGA