Register now or log in to join your professional community.
There are 5 important areas in the screen. 1. Quick Access Toolbar: This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name). 2. Ribbon: Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data. 3. Formula Bar: This is where any calculations or formulas you write will appear. You will understand the relevance of it once you start building formulas. 4. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active spreadsheet. To see more rows or columns you can use the scroll bars to the left or at bottom. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down). 5. Status bar: This tells us what is going on with Excel at any time. You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can change this by right clicking on it and choosing which summaries to show
I recommend watching tutorials and apply what you learn.
For learning excel, I suggest that a mix approach should be followed. different functions and options on the excel ribbon should be applied to set of data. for a function which is diificult to understand or apply, one should google it and may find very helpful material on that. Besides this, one can view others worksheets and apply the same functions, formats and layouts to learn.
according to me, basic techniques to learn excel are:
1-if you know why you need to learn excel(prupose), definitly you will know your start point of learning.
2-Practice on templetes and sample example excel files.
3- ask yourself questions. like what if , how (formula), and from what menu i can get it?
4-refere some text and visual tips and trickes related to excel.
The best strategy is learning by doing after looking up all the formulae you would need for your Excel assignment.Creating a table is as easy as typing in the data you need; test all the formulae on it to see the effects.Get friendly with CTRL-C, CTRL-V/copy-paste commands for bigger sheets to save time.
So many things you have to know about Microsoft Excel, but as a beginer you will start with such afew basics things like: Excel data input, insert a new line into cell, how to creat function, copy and past, find and replace, of course data validation and it is very important, because it's let you making a drop down list, so you don't need to type details and it's look professionaly in office process.
The basic technique to learn Excel is to start with one thing an focus on it for some time, and I will recommend to start with, how to use formulas for automation in excel, like =sum(Row1col3 +Row4col3).
Then you should go for pivot tables and other advance levels.But learn one thing at a time and then move to the next is the art to master Excel.
First you must know the main fundamentals in creating tables
Second coordination
Third, learn some simple equations within excel as (addition, subtraction, multiplication, division)
Fourth try to download some simple examples uncomplicated
Fifthly sense of creativity in design tables
When we are talking about techniques then the words "Short Cut" comes in mind. Therefore knowing common shortcut keys then the knowledge of formulas and using the ToolBar available in ribbon (known as Menu bar formally) for editing, formatting or manipulating data according to user requirement will speed up learning Excel. All these techniques becomes habit for a regular user and "Quick Fingers" on keyboard is an added advantage which makes it even more simpler to learn Excel.