Find the best tutors and institutes for Microsoft Excel Training
Search in
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.
Recent Updates
Looking for Microsoft Excel Training classes?
Post your Learning requirement and get connected
Trending Lessons in Microsoft Excel Training classes
Recommended Articles
Why Should you Learn Microsoft Office
Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...
What is Applications Engineering all about?
Applications engineering is a hot trend in the current IT market. An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...
8 Hottest IT Careers of 2014!
Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...
Looking to teach?
Join UrbanPro and connect with more than 25 Lakh students on the platform. Create a strong profile and grow your network.