Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are some basic techniques to learn excel?

user-image
Question added by Imran Ahmed , Manager-Planning & Delay Analyst , Nesma United Industries (NUI) Saudi Arabia
Date Posted: 2016/08/17
Azzam Bakri
by Azzam Bakri , Insurance Broker / سمسار تأمين , For my account

Any job need the excel .. So you should to know this basic 1. Quick Access Toolbar 2. Ribbon 3. Formula Bar 4. Spreadsheet Grid 5. Status bar

فدوى ahmed
by فدوى ahmed , سكرتيرة , الجمعية الخيرية لتحفيظ القرآن

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

Abdrabou Sharafeldin
by Abdrabou Sharafeldin , Education Consultant , Educational Services

I recommend watching tutorials and apply what you learn.

Muhammad Waleed
by Muhammad Waleed , Assistant Manager Finance , Turnotech (Private) Limited

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.

Bassam Ali Mohammed Al-mamari
by Bassam Ali Mohammed Al-mamari , مساعد الرصد والتقييم , برودحي سيستمز

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.

Daniil Shilov
by Daniil Shilov , Marketing and Business Development Lead , Henderson International LLC

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.

Ehab Mohamed Hamad Hufi
by Ehab Mohamed Hamad Hufi , office administrator & network administrator , Afaq for Facilities management services

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. 

sohail farooq
by sohail farooq , Safety Officer , Abu Dhabi Oil Refining Company(Takreer)

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.

khaled Ibrahim CertIFR CMA Candidate
by khaled Ibrahim CertIFR CMA Candidate , finance manager , Mulkia Investment Company

Pivot Table - Add More Than One New Row or Column - Remove Duplicates - Transpose - Text to Columns - Simple Calculations - Conditional Formatting Formula - IF Statement - Dollar Signs

Mahmoud  Ali
by Mahmoud Ali , Financial Manager , Ayadi Al-Madina Est

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

Wasi Mohammad
by Wasi Mohammad , RF Drive Test Professional , Swedtel Arabia LTD

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.

More Questions Like This