Get Excel worksheet caption & name (or Object name or Codename) using VBA Macro. This is a readonly property and cannot be renamed using code without giving access to VBA Project Model.
Power BI – DAX
July 07, 2021
What is DAX? DAX stands for Data Analysis eXpressions and is the language behind Power BI. DAX is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. With the help of DAX, analysts discover ways to analyze data and come up with great ideas and insights […]
SUM and Average of Top N Values in Excel
July 07, 2021
In today’s world, the data sets we have is huge and we can have so many criteria to be followed on the data For Example: Sum Average etc. Let us say we have N products in our superstore and we have to find the total number of sales made in […]
Dynamic Host Configuration Protocol
July 07, 2021
Introduction The Dynamic Host Configuration Protocol is also known as DHCP, It is a network management protocol used on Internet Protocol(IP), wherein Dynamically assigning an IP address to other network parameters so the device can easily communicate with other IP networks. A DHCP server enables the device to request IP […]
Dream11 IPL 2020 – Points Table – Team Positions
July 07, 2021
DIPL2020 Points Table – Season 13 – Dubai Let’s see how the points table stands now. Pos Team Pld Won Lost Tied N/R Net RR Pts Q Mumbai Indians MI 14 9 5 0 0 1.107 18 Q Delhi Capitals DC 14 8 6 0 0 -0.109 16 Q Sunrisers […]
IPL 2020 Points Table PDF – Winners List
July 07, 2021
Dream 11 – IPL 13 2020 Points Table IPL13 is proving to be tougher than any other season. New teams are coming up at the top of the points table. It’s only the starting. Let’s see who finishes in the top 4 positions. Pos Team Pld Won Lost Tied N/R […]
Database Management System
July 07, 2021
What is DBMS? DBMS stands for Database Management System which is a software used to manage databases. For Example, MySQL, Oracle, etc. are some of the popular commercial DBMS today, it primarily functions as an interface between users and the database at the same time managing the data in order […]
Excel Sheet Protection Check
July 07, 2021
Detect Sheet Protection Whenever working with a worksheet ever wondered why some menu buttons are not working or ribbon icons are greyed out and no functionality doesn’t work, this happened to me and because of a silly mistake. I can’t say how many times this has happened to me while […]
Queues Interface in Java
July 07, 2021
Queue Interface: The Queue Interface in Java Collections provide functionality as a Queue in the real-life, it extends the collections interface. It represents real-world queues where people queue in waiting line in front of the Supermarket where new people add up at the end of the line (queue) and the […]
LET( ) Function in Excel
July 07, 2021
What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate results of some calculations, values, name of some functions defined inside a formula. These name only apply within the scope of […]
