Category: MS Excel

Advanced Excel Formula PDF

Advanced Excel Formula PDF Advanced Excel Formula PDF. All Formula Define Steps by Steps. 1. Average– This function is used to find out the average\ result of no. to find out the % =average(range of list) 2. Count– This function is used to count that numerical function. =count(List range) 3. CountA– This function is used […]

Ms Excel Introduction 2015

Ms Excel Introduction

Ms Excel Introduction Ms Excel Introduction A spreadsheet is essentially a matrix of rows and columns. Consider a sheet of paper on which horizontal and vertical lines are drawn to yield a rectangular grid. The grid namely a cell, is the result of the intersection of a row with a column. Such a structure is called a Spreadsheet. A […]

MS Excel Shortcuts Keys

MS Excel Shortcuts Keys MS Excel Shortcuts Keys What does Excel Shortcuts do? Ctrl+A Select all contents of a worksheet. Ctrl+B Bold all cells in the highlighted section. Ctrl+D Fill Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down) Ctrl+F Search current sheet. Ctrl+G Go to a certain area. […]