Advanced excel course online -
Topic covered (basic excel training)
1. Microsoft excel window overview.
2. Creating/ Saving/Opening Worksheet.
3. Basics of excel sheet.
4. Selecting.
5. Basics of excel Rows and columns.
6. cells.
7.Basics of excel Page layout.
8. basics of excel Printing.
9.Calculations
10.Insert
11. Various shortcuts.
1. Microsoft excel window overview.
Below is the basic overview of Microsoft excel.
2. Creating/ Saving/Opening Worksheet in ms excel.
To create a new worksheet simply right click on the desktop or window.
From new Menu select Microsoft excel worksheet.
New Microsoft excel file will form, you cand edit its name as in below picture.
Excel worksheet is renamed to Tutorial 1.
New excel window will open having blank worksheet.
You can do your desired work in the workspace.
Click on the files to save your work and simply using save and save as option you can save your work.
To delete your file simply right-click on it and click delete option.
3. Sheets in Excel.
In excel sheets are same as new pages or new books, for example, we have different books for different record similarly we can make different sheets on same worksheet. as you can see in below worksheet has six sheets.
In excel you can do various operations with these sheets, as you can see when we right-click on the sheets we got various menu.
As in menu, we can insert new worksheet, delete our sheet, rename it, move or copy it, protect it, can change its color and also hide it.
Let us copy sheet 6, to do that simply click on the move or copy option and select the sheet you want to copy as shown in below picture.
Now check the create a copy box to create a copy of sheet 6.
AS you can see we obtain a copy of sheet 6 similar operation can be do for moing our sheet.
Below picture shows how can we make new book from our worksheet without copying it.
As you can see below new book is formed using move or copy option.
Now you can also change the colors of each sheet tab by clicking tab color
Sheet 6 is colored now
Sometimes it is required to hide some sheets you can hide them also, as shown in below picture.
As you can see sheet 6 is hidden you can simply unhide it after clicking unhide in the menu.
So these are the basic operations which we can do on sheets.
4. Selecting.
In Excel selecting a data is also an important thing to learn, we can simply select data on the worksheet by just clicking and dragging our cursor to the desired location . as shown in below picture.
You can also select the sheets in your worksheet, simply press Ctrl and select the desired sheets
You can select Rows and column also.
Press Cntrl and you can select the specific desired data also.
There are many shortcuts to select data which will be shared shortly.
5. Rows and columns.
The horizontal cells are called Rows and Vertical cells are called columns in excel.
6. cells.
The small rectangular boxes in the worksheet are called cells.
7. Page layout.
As the name suggests you can adjust layout of your sheet or page according to your requirement.
From the ribbon applications select page layout.
Here you can change margins of your page.
The orientation of your page:- Landscape or portrait
And many other works also.
Sometimes it is required to change the layout of our pages in that time this function is required mostly.
8. Printing.
Printing of document required some special information also.
When we select print option we found so many new menus including printer, copies, settings, we will study some mostly used functions only.
check the print select area and select according to your requirement, as if you want to print active sheet, entire workbook or selected area.
Also, you can change the orientation and scaling of your document.
Page setup option also has many important functions you can see them also one by one.
9.Calculations
we will study this in detail letter with the separate topic of formulas.
10.Insert Tab In MS Excel
Sometimes we need to insert some other data or documents in our sheet. for this we can use the insert function.
We can insert new charts and tables from the option given there.. detail about the charts will study later.
We can insert picture also by clicking the picture in the insert tab.
To add special shapes and character use the shapes tabs.
If you want to add in row or column in the current table click on the table and select insert tab.
You can also insert rows and column in the original document as shown in below pictures.
Insert tab is so useful in managing data and to present data in useful manner you will learn various important tools in this tab later.
11. Various shortcuts.
Thanks for the scroll.
