In high school, I used to solve mathematical equations where I have the result of the equation but don’t have the input value.So, if you think about to solve the same kind of problems in Excel, you have a specific tool which can help you.Goal SeekIts basic idea is to find the input value which […]

➲ Continue ReadingUsing Different Formatting In Single Cell sometimes makes a difference. While creating some awesome reports, dashboards, tables, etc. a small thing we always try to do perfectly, that is formatting. Formatting is the face of our reports. Excel gives us lots of options to makeover our spreadsheets (Font color, cell color, bold, italic, etc.). Have […]

➲ Continue ReadingTo Create a table of content in excel with macro we have to use a Hyperlink.Add Function In VBA which is similar to the Excel’s Hyperlink Function. Use Hyperlinks.Add to insert a hyperlink in excel with VBA It is the part of Hyperlink collection method. Let’s have a look at Arguments of Add.Hyperlinks : hyperlinks.Add(Anchor, Address, […]

➲ Continue ReadingIn Excel, we have three specific functions to convert text from one case to another. Whereas there is another case for which we don’t have any function or any other option.That’s ==> Sentence CaseYou might be wondering: What sentence case actually is?Well, in sentence case, for an entire sentence, the first letter of the first […]

➲ Continue ReadingUsing calculation in the pivot table is like a custom calculation which not exists in the source data but works like other fields. In simple words, these are the calculations within the pivot table. Excel gives us two options for calculation in a pivot table, one is calculated field & other is calculated item. In […]

➲ Continue Reading