Microsoft Office | Summa Lai

How to Use “IF”, “ELSEIF”, “ELSE” and “IF NOT” in Excel VBA

Posted on January 2, 2022January 2, 2022 by Summa Lai

VBA If Statement Ref: https://www.automateexcel.com/vba/else-if-statement

How to Export a Table from Power BI Desktop to Excel

Posted on December 26, 2021December 26, 2021 by Summa Lai

There are some ways to export Power BI Desktop data in Excel. You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel. This way is good for a small volume of data. Go to Date View and select the table you want to export, select Copy Table and then paste it in Read More

Hot to Move Dataflows Across Workspaces With the Power BI REST API

Posted on December 14, 2021December 14, 2021 by Summa Lai

Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but also isolate refreshes to avoid dependencies of refresh failures from different sources. Same as for your data sources, Read More

How to Send an Email With Other From Address in Outlook

Posted on December 10, 2021December 10, 2021 by Summa Lai

What to Know Select From in the header of an Outlook new message, reply, or forward. Choose Other Email Address. Select an address or type one in and select OK. This article explains how to send an email with any From address in Outlook for Office 365, Outlook 2019, 2016, 2013, and 2010. How to Send an Email With Read More

What Is the XLOOKUP Function in Excel? How to Use It?

Posted on December 6, 2021December 6, 2021 by Summa Lai

The XLOOKUP function is useful when you need to find something in a table or range. Learn how to use the XLOOKUP function in Excel. If you use Excel a lot, you have probably used LOOKUP functions quite often. If you’re not familiar, the LOOKUP function is used to search through a single row or Read More

How to Do Lookups with Returning Multiple Column Values

Posted on November 23, 2021November 23, 2021 by Summa Lai

This is the first post in a series where we’ll talk about how to use the FILTER function as an alternative to lookup functions including VLOOKUP. Why? Well, as we’ll discover in this series, the FILTER function offers several key benefits. For example, FILTER supports: Multiple return columns Multiple lookup columns Multiple matching row values In this first post, we’ll see Read More