VLOOKUP &BASIC EXCEL FORMULAS FOR DAY TO DAY WORK
Introduction Microsoft Excel is a spread sheet developed by Microsoft for Windows, macOS, Android and iOS. It is an industry leading spreadsheet program powerful data visualization and analysis tool. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basics for Applications. VLOOKUP is one of the best formulas used in MS Excel worldwide. BASIC MS EXCEL FORMULAS The below are the most common used BASIC EXCEL FORMULAS 1.SUM. The sum function used to aggregate values from a selection of columns or rows of a selected range. Formula is =SUM(RANGE) 2.Average. The average function used to calculate the average vale of a particular selected range. Formula is =AVERAGE(RANGE) 3.COUNT. The Count function used to calculate the total numeric numbers count of a particular selected range. Formula is =COUNT(RANGE) 4.COUNTA. The COUNTA function used to count the total entries in particular selected range.IT counts even dates, texts,...