EXCEL FEATURES | BI & AI

2021-07-15 18:00:40 Open / Comment

2021-07-15 17:58:15 Why use array formulas?

Array formulas are often referred to as CSE (Ctrl+Shift+Enter) formulas because instead of just pressing Enter, you press Ctrl+Shift+Enter to complete the formula.
If you have an experience using formulas in Excel, you know that you can perform some fairly sophisticated operations. For example, you can calculate the total cost of a loan over any given number of years. You can use array formulas to do complex tasks, such as:

Count the number of characters that are contained in a range of cells.

Sum only numbers that meet certain conditions, such as the lowest values in a range or numbers that fall between an upper and lower boundary.

Sum every nth value in a range of values.

Enter an array formula

Select the cells where you want to see your results.

Enter your formula.

Press Ctrl+Shift+Enter. Excel fills each of the cells you selected with the result. Open / Comment

2021-07-14 18:55:09 Power BI vs Excel Dashboards

And the winner is...




Open / Comment

2021-07-14 17:38:26 How to EMBED / INSERT / LINK a PDF File in an Excel Cell

Several options have been reviewed in this video:



Open / Comment

2021-07-13 17:47:14 XLOOKUP FUNCTION

Use  XLOOKUP function to find things in a table or range by row. For example, to find an employee name based on his employee ID.

Explained in this video:



Open / Comment

2021-07-12 17:08:08 Excel can speak

https://youtube.com/shorts/q6LOhQThvB8?feature=share Open / Comment

2021-07-11 15:14:42 Open / Comment

2021-07-11 08:44:15 Modern interactive dashboard in Excel



Open / Comment

2021-07-10 15:55:53 Amazing video

Recommended

Watch until the end



Open / Comment