Advance excel

Introduction to Microsoft Excel 101

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program that is utilized to record and break

down numerical information. Think about a spreadsheet as an accumulation

of sections and columns that frame a table. In sequential order letters are

normally doled out to sections and numbers are generally appointed to columns.

The point where a segment and a column meet is known as a cell.

The address of a cell is given by the letter speaking to the segment and the

number speaking to a line. How about we delineate this utilizing

the accompanying picture.

For what reason Should I Learn Microsoft Excel?

We as a whole manage numbers in a single manner or the other. We as a whole

have day by day costs which we pay for from the month to month pay that we win.

For one to spend astutely, they should know their wage versus consumption.

Microsoft Excel proves to be useful when we need to record, break down and store

such numeric information.

1. Right click on the ribbon and select Customize the Ribbon. The dialogue window shown above will appear
2. Click on new tab button as illustrated in the animated image below
3. Select the newly created tab
4. Click on Rename button
5. Give it a name of Guru99
6. Select the New Group (Custom) under Guru99 tab as shown in the image below
7. Click on Rename button and give it a name of My Commands
8. Let's now add commands to my ribbon bar
9. The commands are listed on the middle panel
10. Select All chart types command and click on Add button
11. Click on OK

Your ribbon will look as follows

Setting the colour theme

To set the color-theme for your Excel sheet you have to go to Excel ribbon, and click on à File àOption command. It will open a window where you have to follow the following steps.

1. The general tab on the left-hand panel will be selected by default.
2. Look for colour scheme under General options for working with Excel
3. Click on the colour scheme drop-down list and select the desired colour
4. Click on OK button

Settings for formulas

This option allows you to define how Excel behaves when you are working with formulas. You can use it to set options i.e. autocomplete when entering formulas, change the cell referencing style and use numbers for both columns and rows and other options.

If you want to activate an option, click on its check box. If you want to deactivate an

option, remove the mark from the checkbox. You can this option from the Options dialogue window under formulas tab from the left-hand side panel

Proofing settings

This option manipulates the entered text entered into excel. It allows setting

options such as the dictionary language that should be used when checking for

wrong spellings, suggestions from the dictionary, etc. You can this option from the

options dialogue window under the proofing tab from the left-hand side panel

Save settings

This option allows you to define the default file format when saving files,

enable auto recovery in case your computer goes off before you could save

your work, etc. You can use this option from the Options dialogue window under save tab from the left-hand side panel

Important Excel shortcuts

Ctrl + P	used to open the print dialogue window
Ctrl + N	creates a new workbook
Ctrl + S	saves the current workbook
Ctrl + C	copy contents of current select
Ctrl + V	paste data from the clipboard
SHIFT + F3	displays the function insert dialog window
SHIFT + F11	Creates a new worksheet
F2	Check formula and cell range covered

Best Practices when working with Microsoft Excel

1. Save workbooks with backward compatibility in mind. If you are not using the latest features in higher versions of Excel, you should save your files in 2003 *.xls format for backwards compatibility
2. Use description names for columns and worksheets in a workbook
3. Avoid working with complex formulas with many variables. Try to break them down into small managed results that you can use to build on
4. Use built-in functions whenever you can instead of writing your own formulas

Summary

• Microsoft Excel is a powerful spreadsheet program used to record, manipulate, store numeric data and it can be customized to match your preferences
• The ribbon is used to access various commands in Excel
• The options dialogue window allows you to customize a number of items i.e. the ribbon,