Skip to content

Gorilla BI

  • Blog
  • Videos
  • Contact
  • About
Gorilla BI
  • Blog
  • Videos
  • Contact
  • About

Excel

7 ways to open Multiple Instances of Excel - Featured Image

7 Ways to Open Multiple Instances of Excel

17th October 2021 by Rick de Groot Categories Excel

This post describes how to open a new instance of Excel. When working with multiple workbooks in Excel, you may sometimes experience issues. During a …

Read more

Categories Excel

2 Awesome Tips on How to Use the SWITCH Function in Excel

2nd January 2021 by Rick de Groot Categories Excel

The SWITCH Function is one of Excel’s logical functions that can function as an alternative to the conditional if-statements. Many excel users use if-statements to …

Read more

Categories Excel
Featured Image - Add references to cells in bulk

Advanced Hack: Add References to Cells in Bulk

18th July 2020 by Rick de Groot Categories Excel

There are times when you want a set of cells to reference a parameter. For example, you’re budgeting and the result needs to be dynamic. …

Read more

Categories Excel
Featured Image - Sumproduct Multiple OR Criteria Part 2 - Final

SUMPRODUCT with Multiple OR Criteria – Part 2/2

21st June 2020 by Rick de Groot Categories Excel

In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. The approach results in a long and difficult to maintain formula. …

Read more

Categories Excel
Featured Image - SUMPRODUCT Multiple OR Criteria Part 1

SUMPRODUCT with Multiple OR Criteria – Part 1/2

21st June 2020 by Rick de Groot Categories Excel

Previous posts (here and here) introduced you to filtering with SUMPRODUCT. It shows that SUMPRODUCT is a very powerful formula for filtering several AND criteria …

Read more

Categories Excel
Featured-Image- Excel-Cube-Functions

An Intro to Cube Functions for Power Pivot in Excel

21st July 2020 by Rick de Groot Categories Excel

In an earlier post I wrote about the advantages of using the Data Model in Power Pivot. Not only does it save you time by …

Read more

Categories Excel
Page Image - How to use the data Model in Excel

How to Use the Data Model in Excel

4th August 2020 by Rick de Groot Categories Excel

Excel can analyze data from many sources. But are you using the Data Model to make your life easier? In this post you learn how …

Read more

Categories Excel
Featured Image - SUMPRODUCT Multiple AND Criteria

How to Use SUMPRODUCT With Multiple AND Criteria

18th July 2020 by Rick de Groot Categories Excel

There are situations where several criteria are required to add up the right numbers. That’s straightforward if the numbers are found in a single column …

Read more

Categories Excel
Page Image - Beginner Guide How to Use the SUMPRODUCT Function

Beginners Guide: How to Use the SUMPRODUCT Function in Excel

2nd January 2021 by Rick de Groot Categories Excel

SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and returns the sum of those products. It is different from most Array formulas in …

Read more

Categories Excel
Excel - How to Round A number To Nearest 1000 - 0. Featured Image

How to ROUND a Number to the Nearest 1000

21st June 2020 by Rick de Groot Categories Excel

Financial reports can sometimes be very messy to look at. Whereas consumers want to understand the big picture, sometimes the numbers are so detailed, they …

Read more

Categories Excel

Stay in the Loop

Get the latest Excel and BI advice, tips and in-depth tutorials delivered straight to your inbox.

Subscribe to my Channel

Youtube subscribe button

Want Some Help

As well as being a blogger, I’m an independent consultant with a passion for Excel and Power BI. I have background in Finance and work with customers to find business solutions that increase insight and quicken decision making. I’d be happy to work on interim assignments.

For more details see:

Linkedin Image

Recent Posts

  • List.Accumulate in Power Query (Explained with Examples)
  • Create Date Table with Dynamic Language in Power Query
  • Creating Tables in Power Query M (40+ Examples)
  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

Tags

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

Categories

  • DAX
  • Excel
  • Power BI
  • Power Query

About BI Gorilla®

BI Gorilla is a free resource site for Excel and Power BI enthusiasts. BI Gorilla was founded in 2018 by Rick de Groot. The main goal of this site is to provide quality tips, tricks, hacks, and other resources that help you advance with Power BI and Excel.

RECENT POSTS

  • List.Accumulate in Power Query (Explained with Examples)
  • Create Date Table with Dynamic Language in Power Query
  • Creating Tables in Power Query M (40+ Examples)
  • Comparing Licenses in Power BI
  • Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

TOPICS

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

SOCIAL

  • YouTube
  • Twitter
  • LinkedIn
  • Facebook

© 2022 Gorilla BI