Wednesday, September 18, 2019

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.

basic excel tutorial / Microsoft excel overview

2. Creating/ Saving/Opening Worksheet in ms excel.

To create a new worksheet simply right click on the desktop or window.

basic excel tutorial / Microsoft excel

From new Menu select Microsoft excel worksheet.

basic excel tutorial / Microsoft excel Menu

New Microsoft excel file will form, you cand edit its name as in below picture.

basic excel tutorial / Microsoft excel overview

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.

Selecting rows ...



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

  Size of your page

  Background of your workspace.
  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.


basic excel tutorial / Microsoft excel overview


Thanks for the scroll.




2 comments:

  1. Advanced Excel Shortcut keys are an essential part of any excel user. These shortcuts help you to navigate through the excel application with ease, speed and accuracy.

    While in a specific workbook, if you can’t find a shortcut key that you need then it means that the key is not available in this workbook. One way around it is to go into “The Ribbon” and search for the shortcut key you need there.

    Advanced Excel Shortcut keys offer a lot of different benefits such as speeding up your workflow and saving time when working with formulas.
    want to Learn Free Excel Course?

    ReplyDelete
  2. Nice Post!! Thanks for sharing
    Get Excel VBA Consulting Services from College Africa Group. We specialized in Complete Spreadsheet Solutions. Hire an excel VBA expert Today!
    Click Here: Microsoft Excel Consulting

    ReplyDelete