In the digital age, data is often referred to as the new oil. However, much like oil, it must be refined before it becomes truly valuable. For millions of professionals worldwide, the primary tool for this “refining” process is Microsoft Excel. Far from being a mere spreadsheet application for accounting, Excel has evolved into a […]
Previous post: Sum Cells Text Numbers MS Excel 2016 What is Edit Custom Lists in Excel ? In Microsoft Excel “Edit Custom Lists…” is extremely powerful and helpful when we need to Create lists for use in sorts and fill sequences. Where do you locate the Edit Custom Lists button in Excel? You can […]
Add Numbers Text of multiple cells Excel 2016 Previous Post: SumIf function of Formulas tab in Microsoft Excel 2016 This post guides us on about Sum Cells Text Numbers. The prior post, illustrates about the SumIf function. It is part of the Math Trig functions of the Formulas tab. This function helps users to add numbers on […]
SumIf function Formulas tab MS Excel Previous Post: Concatenate function of Text functions in Microsoft Excel 2016 Before we jump to know about this function in detail, let us understand few things. The SumIf function is very important in Microsoft Excel. Specifically, two functions i.e. “Sum” and “If” are combined together. It is part of the Math Trig functions […]
Concatenate function Text functions Excel 2016 Previous Post: Mid function of Formulas tab in Microsoft Excel 2016 In the last post we’ve discussed, it was about the Mid function. This function is helpful for extracting words or letters from the middle. For example, in a list of names having First, Middle and Last names, this function is quite […]
Mid function Formulas tab MS Excel 2016 Previous Post: Right function Function Library group Microsoft Excel 2016 The previous post was about on the Right function. It is part of the Text functions of the Formulas tab. Almost similar to the Left function, but a little bit different, it works from the right side. Ok, now let us […]
Stay Connected
Connect with us on the following social media platforms.