Bjorn Meijer

Bjorn Meijer

At My Playground

  • Home
  • About me
  • Wiki
  • Useful
    • 4-20mA calculator
    • ASCII table
    • Translations Excel functions EN-NL
    • Excel keyboard shortcuts
  • Trainings
    • Topography
  • Contact
  • Language
    • en_USEnglish
    • nl_NLNederlands
    • de_DEDeutsch
Download and install Power BI

Download and install Power BI

Power BI
Door Bjorn Meijer November 28, 2023 1

In the previous article, we explained that Power BI is a powerful data analysis and visualization tool developed by… Read more

Power BI: The Basics and Benefits

Power BI: The Basics and Benefits

Power BI
Door Bjorn Meijer November 21, 2023 0

In today's data-driven world, access to effective data analysis and visualization tools is essential. Power BI, developed by Microsoft,… Read more

What is the difference between .Text, .Value and .Value2

What is the difference between .Text, .Value and .Value2

Excel VBA
Door Bjorn Meijer November 15, 2023 0

There are three ways to use VBA in Excel to extract the value from a cell using the Range object… Read more

Automation Garbage Bin Reminder Home Assistant

Automation Garbage Bin Reminder Home Assistant

Home assistant
Door Bjorn Meijer November 9, 2023 0

This article will show you how to create an automation in Home Assistant to receive reminders for… Read more

Everything you need to know about the VLOOKUP() function in Excel

Everything you need to know about the VLOOKUP() function in Excel

Excel Excel formulas
Door Bjorn Meijer November 2, 2023 0

Whether you're analyzing financial data, preparing a sales report, or managing a list of customer information, it's often essential to… Read more

Display WiFi network password via netsh wlan command

General
Door Bjorn Meijer July 20, 2023 0

Windows stores your wireless network profiles. The login details of the WiFi network are then also saved. This is useful if… Read more

How does the VI editor work?

How does the VI editor work?

General Home assistant
Door Bjorn Meijer December 13, 2022 0

The VI editor is a handy tool and comes standard in almost all Linux distributions. It also comes standard… Read more

Modify Configuration.yaml via Home assistant Supervisor CLI

Modify Configuration.yaml via Home assistant Supervisor CLI

Home assistant
Door Bjorn Meijer December 7, 2022 0

It can happen to you (I succeeded too ;-)), you have adjusted a setting (for example the port) in the… Read more

Using Quick Fill in Excel

Using Quick Fill in Excel

Excel
Door Bjorn Meijer November 30, 2022 0

Since Excel 2013, Microsoft has added a new useful feature, QuickFill. As soon as Excel recognizes a pattern, the… Read more

Does a date fall on a weekend in Power BI

Does a date fall on a weekend in Power BI

Power BI
Door Bjorn Meijer November 17, 2022 9

Sometimes it can be useful to know whether a certain date falls on a weekend or not. It's possible… Read more

Posts pagination

1 2 … 4 Next

Categories

  • General (4)
  • domoticz (6)
  • Excel (17)
    • Excel formulas (7)
    • JSON (2)
    • VBA (4)
  • Home assistant (3)
  • Power BI (4)

Tags

rounding errors API CLI command-line configuration.yaml dates database edit data Docker domoticz dos excel Excel programming excel functions formulas error messages function data analysis format data merge data split data Hassio Home Assistant Installation manual json macro network power BI Power BI beginners Power BI Desktop Power Query powershell Report raspberry pi hotkey SQLite text editor vba translationsearch vertical search VI editor visualization weekday weather data Wi-Fi

Recent messages

  • Download and install Power BI
  • Power BI: The Basics and Benefits
  • What is the difference between .Text, .Value and .Value2
  • Automation Garbage Bin Reminder Home Assistant
  • Everything you need to know about the VLOOKUP() function in Excel

© Copyright 2020 bjorn-meijer