Excel Tutorial

All Levels ( Basic | Intermediate | Advanced ) + Test

Now days no matter on which profile you are working , from accountant to data analyst, HR to product manager, having Excel skills have huge benefits.

We can categorize Excel skills in 3 levels:

• Basic Excel Skills.
• Intermediate Excel Skills.
• Advanced Excel Skills.

Basic Excel Skills

Saving and Opening a Workbook

---

Saving and opening an Excel workbook is just like as you do in any other application.

When you click on the file tab it shows you the option to save the file.

And when you click on the save button it opens the save as dialog box from where you can specify the location and you can also select the file format to use.

Basically, Excel has different file extensions that you can use for saving a workbook. You can use the above steps if you are saving a file for the first time and if you have a file that is already saved in the system, you just need to press Control + S to save the changes. In the same way, if you want to open a file that is saved on your system you can go to the FILE tab and click on the open.

It shows you the open dialog box from where you can locate the file and open it.

Managing Worksheets

---

Every workbook consists of worksheets where you can add your data and analyse it and once you open an Excel workbook you can see there are tabs at the bottom of the window.

To insert a new worksheet simply click on the plus button or you can also use the shortcut key SHIFT + F11.

And if you want to delete a worksheet just right click on the worksheet tab and then select the delete option or you can also use the shortcut key Alt ➜ H ➜ D ➜ S.

But there’s one thing which you need to take care that once you delete a worksheet you can’t get it back.

Formatting Cells

---

In Excel, we have a bunch of options on the home tab for formatting.

• The font group gives you the options to format the font by making it bold, italic, and underline. You can change the font style, its size, and colour of the font and the colour of the cell as well.
• From the alignment group, you can define the alignment of the text, add indent, merge cells, and wrap the text.
• From the number group, you can apply formatting to the values like currency format, text format, number format, etc.

Apart from the above options, you can also open the format cell options by right-clicking on a cell and select the format option or you can also use the shortcut key Control + 1.

Printing

---

When you go to the FILE tab, you can find there is a print button that further includes all the printing options that you can use for printing data from a worksheet.

You can also use the shortcut key Control + P to open the print option and once you open it you can see the following options there:

• Print Area
• Range of Pages to Print
• Collision
• Orientation
• Page Type
• Margins
• Scaling

LIST OF TOP TEN BASIC EXCEL FUNCTIONS

---

The biggest power of Excel is its functions that you can use to perform a lot of calculations and below you have a list of top ten Basic Excel Functions:

1. SUM : With this function, you can sum values from multiple cells, or you can also input values directly into the function.
2. COUNT : This function returns the count of numeric values in a cell. You can refer to the cells where you have values or simply insert the values into it.
3. AVERAGE : It returns the average of numeric values. You can refer to the cells where you have the values or simply insert them into the function.
4. TIME : It returns a valid time serial number as per Excel’s time format. You need to specify hours, minutes, and seconds.
5. DATE : It returns a valid date (date serial number) as per Excel’s time format by using the day, month, and year specified.
6. LEFT : It extracts specific characters from a cell/string starting from the left (start). You need to specify the text and number of characters to extract.
7. RIGHT : It extracts specific characters from a string starting from the right (last). You need to specify the text and number of characters to extract.
8. VLOOKUP : It looks up for a value in a column and can return that value or a value from the corresponding columns using the same row number.
9. IF : IF function (tests a condition) returns a value when the specific condition is TRUE and returns another value if that condition is FALSE.
10. NOW : It returns the current date and time (using your system’s settings) in the cell where you insert it.

Thank You !
Feel free to contact us.