Microsoft Excel Tutorial

Microsoft Excel

Microsoft Excel is a spreadsheet program introduced in the Microsoft Office suite of applications. Spreadsheets exhibit tables of values arranged in rows and columns that can be managed mathematically with the help of both basic and complex arithmetic operations and functions.
Excel also offers programming support through Microsoft's Visual Basic for Applications (VBA)- The ability to access data from external sources through Microsoft's Dynamic Data Exchange (DDE), and extensive graphing and charting capabilities.

Features of Microsoft Excel

1. Conditional Formatting -
Conditional formatting changes the format of a cell depending on the range of cells, or another cell or cells in the workbook. Conditional formatting helps users to focus on essential aspects of a spreadsheet quickly or to highlight errors and to identify important sequences in the data.
The conditional format can apply basic font and cell formattings such as- number format, font colour and other font attributes, cell borders and cell fill colour. Besides, there is a range of graphical conditional formats that helps with visualising data by using icon sets, colour scales, or data bars.
2. PivotTables - PivotTables gives an outline of large amounts of Excel data from a database that is formatted where the first row contains headings, and the other rows include categories. The way the data is briefed is flexible, but usually, the Pivot Table will hold values summed over some or all of the groups.
3. Basic Math - At the heart of an Excel spreadsheet are the numbers within the data. Using essential math functions to manage those numbers is one of the features that makes Excel so convincing.
Simple calculations are entered into the formula bar. As with all formulae in Excel, start an estimate with the = sign. The calculation to be performed is directly introduced into the cell or the formula bar and when Enter is pressed the answer will be shown in the cell.
4. Add Multiple Rows - Adding multiple rows is one of the most frequently carried out activities in a spreadsheet. Ctrl Shift + is the shortcut that is used, but actually, it takes longer, so Right Click is what's been recommended.
5. Absolute References - The dollar in front of the letters fixes the column-the dollar sign in front of the number sets the row F4 to switch through the four desirable combinations.
6. Print Optimisation - There are a few components that help you print what you intended to print in Exel such as print preview, fit to one page, adjust margins, print selection, printing headers, portrait vs landscape and spreadsheet design.
7. Extend formula across/down - The Excel is easily scalable. If you get the formula right, the Excel will churn out the right calculation a million times. By double-clicking + crosshair will take it all the way down if you have continuous data.
8. Flash Fill - Excel has its own mind. If there two columns of names and you need to construct email addresses for all of them, you just need to do it for the first row, and Excel will do it for the rest.
9. INDEX-MATCH - This is one of the most potent features of Excel functions. It is used to look up a value in a big table of data and return a corresponding value in that table. For example, if a company has 5000 employees and there is a spreadsheet with all of them in it with lots of information. But If you are only interested in 20 of them. INDEX-MATCH will help you look up the value of those 20 members in that table and return the desired information.
10. Sorting and Filtering - Excel spreadsheets help us understand large amounts of data. To quickly find what you need, you can reorder the data or pick out the data you need, based on parameters you set within Excel. Sorting and filtering the information you will save time and make the spreadsheet more effective.