List of Functions SUM Function Count Function CountA Function LEN Function TRIM Function RIGHT, LEFT and MID Function VLOOKUP IF Statements SUMIF, COUNTIF, AND AVERAGEIF CONCATENATE Function 1. SUM Function The SUM function allows you to add 2 or more numbers together. Sum function can be directly applied to sets of numbers separated by a […]
Effective uses of MS Excel at workplace
MS Excel is one of the advanced tools for working with raw data, but people fear it too. The application seems complicated, and people think it as something that would take hours to figure out. This isn’t true at all. My students once asked me this question “Is there any possible way to make Microsoft […]
Complete List of Excel Shortcuts – 109 Shortcuts
Without moving your fingers off the keyboard and without touching the mouse, you can quickly and effeciently accomplish the action and ultimately saving time. Microsoft Excel is frequently used by finance and accounting professionals on a daily basis. Even users with a basic knowhow of Excel can become more efficient by learning keyboard shortcuts. I […]