LEN is an excel formula that is used to count the character length in a cell. It can be used to count numbers/texts in given cells. Formula: =LEN(text) Below is an example: In the example, the LEN formula is being used to count the number of characters present in the cell. As you can see we have…
Navigate Worksheets [Arrow Keys] Navigate by one cell at a time in any direction [Page Down]/[Page Up] Move one screen down/ up [Alt]+[Page Down]/[Page Up] Move one screen right/ left [Tab]/[Shift]+[Tab] Move one cell to the right/ to the left in a worksheet [Ctrl]+[Arrow Keys] Move to the edge of next data region (cells…
COUNTA is an excel formula that is used to count, the number of cells in a range that have values or data in a given/selected range. It can be used to count numbers/texts in columns, rows or in multiple selected cells. Formula: =COUNTA(Value1,Value2,…) Below are examples of the simple usage of the COUNTA formula. In Formula Bar, you will…
COUNT is an excel formula that is used, as suggestive it can be, to count, the number of cells in a range that have numbers in a given/selected range. It can be used to count numbers in columns, rows or in multiple selected cells. Formula: =COUNT(Value1,Value2,…) Below are examples of the simple usage of the COUNT formula.…
SUM is an excel formula that is used for addition of values in given/selected cells. It can be used to add numbers in a columns, rows or in multiple selected cells. Formula: =SUM(Cell1,Cell2,…) Below are examples of the simple usage of the SUM formula. In Formula Bar, you will be able to see the SUM formula…
By profession, I’m a Business Analyst. In my career, I’ve worked as an employee, freelance, and also consultant in my spare time. My job greatly revolves around researching new tech in a given industry, research for locations for a new startup, marketing/product placement strategies, analytics, and automation. While doing so I have always tried my…
Every working professional starts his/her career with a few goals, objectives, and dreams of achieving greatness. Some choose careers to earn for their lifetime of happiness and some aspire to be the greatest in their domain of interest. Just like the saying goes, “There are no free lunches”, you can believe it when someone says…