Dhitos

08/02/2022

Intro to DAX in Power BI.

07/02/2022

Why to learn Advanced Excel?

Easy to organize information:
Once you know all basic and advanced features of Excel, it becomes easy for you to learn organizing information in a better manner so that it could be easier for everyone to take crucial decisions on the basis of that informed information.

27/01/2021

How to count specific character in cells using Substitute function in Excel?

How to count a character in cell using Substitute function in Excel?

23/01/2021

Creating user form with VBA

User form in VBA to create business wizards. , , , ,

22/01/2021

Nested loops in VBA and its applications...

How and when nested loops are being used?

10/01/2021

How to connect Power BI with SQL Server to pull data for a model and relationships?

How to pull data from SQL Server and perform relationships in PowerBI?

02/11/2020

How to use Sumproduct, Subtotal, Agreegate and worksheet protections?

How to use Sumproduct, Subtotal, Agreegate and worksheet protections?

13/10/2020

How to apply wildcards with Vlookup?

Vlookup with wildcards and an example of Vlookup with defined key

06/10/2020

Just joined the 100 subscribers on YouTube club. VIRTUAL HIGH-FIVE!

Dhitos is a global online and classroom professional training provider. We cater across industries for skills that help them grow with data driven decisions,...

05/10/2020

Some important Excel interview questions discussed with examples.
https://lnkd.in/emsK28u

Interview questions discussed and solved based on conditions and logicals

04/10/2020

Advanced Excel - Vlookup with wildcards and an example of Vlookup with defined key

Vlookup with wildcards and an example of Vlookup with defined key