Learn Excel: Basics of Microsoft Excel, Beginner Tutorials, Intro

Any jobs in today’s world will require some basic excel skills. Some of those skills are – entering and formatting data, highlighting data, creating charts and reports, keyboard shortcuts, tricks for productivity, Excel ribbons, etc.
Today I will be sharing some of most fundamental and core Excel skills that will help you learn Excel for certain areas of your job.

Five most important regions in the screen.

1. Quick Access Toolbar:
All the necessary tools can be placed here. In the start, you will only see three buttons (Save, Redo, Undo). For ease of access, you have added more feature to Quick Access Toolbar.

2. Ribbon:
This is a type of Menu that is extended in length and height. It is made in an easy to learn format and has all the major features of Excel. With more than 1000s of features ribbons are made with groups and from those some important ribbons are – Insert, Page Layout, Data, Formulas and Home.

3. Formula Bar:
Every calculation you do will appear here once you start making formulas you will find its relevance.

4. Spreadsheet Grid:
This grid contains all the chart, data, numbers and drawings. One Excel file has several sheets inside. The grid of spreadsheet will only show those rows & columns that are active. You can scroll right and left to see more rows and columns. By clicking on the sheet names you can access other sheets or you, can use a keyboard shortcut (CTRL+Page-UP or CTRL+Page-Down).

5. Status bar:
This bar will keep you informed about the happenings if any calculation is going on or a macro recording or maybe you are creating a pivot report, all of this can be seen at this status bar. It also shows sum, minimum, cell counts, maximum values or selected cells. By right click, you will be able to choose which summaries you want to display.

The following infographic will explain how to apply absolute plus relative references, how to practice the ampersand plus combine cells, organize spreadsheets with cell coloring, how to manage the VLOOKUP function, and more.

Data entering and formatting, tables & numbers

Using an Excel means you are handling some data. Excel is excellent at handling and feeding data. With the structure of cells, the grid allows to manage thousands of data point easily. Options like cut, copy, paste, highlight, find, go to, styles, etc. make it easy to maintain data and all other processes.

Jaspal is a web designer and owns a web development company Web Seasoning. He is also an full-time online geek. Follow him on @twitter or sign-up for the email newsletter and get daily updates from this blog.