Microsoft Excel is one of the most widely used tools in any industry. While some enjoy playing with pivotal tables and histograms, others limit themselves to simple pie-charts and conditional formatting.
Once we write correct formula, we can expect automatic calculations. Excel helps to organize and easily access data. It helps to format, filter and sort data of table. We can edit, undo or use error-checking tools to help remedy those mistakes. We can analyze data and create charts, graphs and reports to help visualize our data analysis.
The most common business uses for spreadsheet applications include the following:
1. Data entry and Storage.
2. Comparing large datasets.
3. Modelling and Planning.
4. Flowcharts for business processes.
5. Statistical Analysis.
Workbooks are represented as .xlsx file.
Open Microsoft Excel and click “Blank Workbook”.
Each worksheet is made up of lot of rectangular boxes called cells. These cells can contain text, numbers, formulas and calculation results. One important thing to note here is that, cells are always referenced by their column letter first, then their row number.
To open a sample file, click “File”. Here we can create a new workbook, or open, save or print a workbook.
Next step is selecting a single column or row which is done simply by selecting the letter at the top of the column, or the number to the left of the row.
If we need to select contiguous columns then we can select one column is press Shift + right key or left key to select contiguous columns. And similarly for rows, it becomes Shift + up arrow or down arrow.
But if we want to select non-contiguous rows or columns then we use “ctrl + select the column required”.
Reading Excel keyboard shortcuts:
Sharpen your Excel skills and build a foundation of knowledge of data analytics. It will serve you well!