Popular Localities

Bangalore

Delhi

Noida

Gurgaon

Mumbai

Hyderabad

Kolkata

Chennai

Pune

Ahmedabad

Chandigarh

Online Services

Student Enquiries

Jobs

loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!
Microsoft Excel Training

Microsoft Excel Training

+ Follow 7,848 Followers

Share

Showing 51 to 75 of 98
Sort By: 
K

Khushbu 17 Mar in  Microsoft Excel Training classes

Show previous answers

Anil replied | 18 Jul

Press ALT + E + L together to delete any worksheet.

0 0

Himaghiri Thanayan replied | 19 Jul

There are many ways to do it. You can also do it from the home tab. Please refer the image attached.

0 0

Answer

You can add upto 6 Images

H

Hardik 18 Mar in  Microsoft Excel Training classes

Which is the default style for new data keyed in a new MS Excel workbook?

0 0 4

Show previous answers

Magesh replied | 09 Jun

The default style is 'Normal'.

0 0

Magesh replied | 09 Jun

The default style is 'Normal'

0 0

Answer

You can add upto 6 Images

V

Vikas 18 Mar in  Microsoft Excel Training classes

What will happen if you insert an Excel file into a Word document?

0 0 3

Show previous answers

Anand replied | 16 May

It will simply attach to it. There are 2 ways to attach. One by its relative location or 2nd by its absolute position.

0 0
H

Hemendra Pratap Singh replied | 02 Jun

Insert like image or in other format

0 0

Answer

You can add upto 6 Images

D

Dhanshri 17 Mar in  Microsoft Excel Training classes

Show previous answers

Deepak replied | 10 Jun

Hi Dhanshri.....Use short cut Alt+ohr.

0 0

Himaghiri Thanayan replied | 19 Jul

Double click the worksheet name, then replace the existing name with a new name and press the enter key

0 0

Answer

You can add upto 6 Images

M

Mohd Rayyan 17 Mar in  Microsoft Excel Training classes

How do I add a new worksheet in MS Excel?

0 0 3

Show previous answers

Kamia replied | 17 Mar

insert sheet in home menu

0 0

Prosenjit replied | 17 Mar

1. Right click on any worksheet-tab on the bottom left of excel screen.
2. Click on 'Insert...'
3. Having the 'Worksheet' icon selected, click 'OK'

0 0

Answer

You can add upto 6 Images

Z

Zainab 17 Mar in  Microsoft Excel Training classes

I am using MS Excel and I want to import a spreadsheet into MS PowerPoint without the gridlines. Is this possible?

0 0 3

Show previous answers

Prabhas replied | 25 Mar

Yes it is Possible

0 0
H

Hemendra Pratap Singh replied | 02 Jun

Un check grid line View -> Grid line -> Uncheck

0 0

Answer

You can add upto 6 Images

P

Pritty 17 Mar in  Microsoft Excel Training classes

How we can view a cell comment?

0 0 4

Show previous answers

G replied | 18 Mar

usually when you hover mouse around the comment written shows up. else alternate methods you cud try are - (1) right click on the specific cell and choose the option 'show comment' (2) go to REVIEW tab and choose the option "show all comments" (4) go the excel option by clicking on the excel icon. on this pop-up presented by the system : Advanced -> display -> for cells with comments....  more»
usually when you hover mouse around the comment written shows up. else alternate methods you cud try are - (1) right click on the specific cell and choose the option 'show comment' (2) go to REVIEW tab and choose the option "show all comments" (4) go the excel option by clicking on the excel icon. on this pop-up presented by the system : Advanced -> display -> for cells with comments. (choose the approp option) here. «less

0 0
A

Aifa replied | 15 Jul

Move cursor over that cell

0 0

Answer

You can add upto 6 Images

A

Anand 16 Mar in  Microsoft Excel Training classes

How do I resize a column in Excel?

0 0 4

Show previous answers

H

Hemendra Pratap Singh replied | 06 Jun

Through Drag cell

0 0

Mahesh replied | 08 Jun

To do so just by keyboard:
- Press ctrl+space bar (to select the column or range of columns)
- Press the right click button (available on most keyboards these days)
- Press W (to select column width option) & set the width you want by increasing or decreasing the number therein

0 0

Answer

You can add upto 6 Images

P

Praveen 16 Mar in  Microsoft Excel Training classes

How do I wrap the text within a cell of MS Excel?

0 0 4

Show previous answers

H

Hemendra Pratap Singh replied | 06 Jun

Right click cell -> Format cell-> alignment -> Wrap text

0 0

Excelytics replied | 08 Jun

Select the cells you want to wrap.. Home tab ---> Alignment Group ---> Wrap Text

0 0

Answer

You can add upto 6 Images

S

Sajini 16 Mar in  Microsoft Excel Training classes

How will I find a feature that was used in Excel 2003 or Excel 2007, if i am not able to find it in recent version?

0 0 4

Show previous answers

Prabhas replied | 23 Mar

Microsoft has given the privilege to use the keyboard shortcuts which you used to use in previous versions of MS Office and the same is still carried to the current versions ( i.e 2007/2010/2013/2016) as well.

0 0

Nachiketa replied | 25 Jun

Excel shortcuts in earlier versions can be used in the recent versions as well. If you are looking for a specific feature, find it out in the help section. Mostly newer versions are backward compatible which means most of features are still available in newerversions

0 0

Answer

You can add upto 6 Images

N

Nageswara 15 Mar in  Microsoft Excel Training classes

How do I hide or show the Ribbon in MS Excel?

0 0 3

Show previous answers

Excelytics replied | 23 Mar

Open Excel --> On the Right Top Corner --> You will find Ribbon Display Options --> You can choose any option from the list.

0 0

Aspirations Institute replied | 26 Mar

Use combination of Control and F1. It will show / hide the ribbon. Use this combination again for reverse action i.e. hide/ show.

0 0

Answer

You can add upto 6 Images

S

Sreedhar 15 Mar in  Microsoft Excel Training classes

How will I save my files to make sure they are compatible with older versions of Excel?

0 0 3

Show previous answers

Excelytics replied | 23 Mar

Excel older versions (97 - 2003) file format is .xls, if you are using an advance version like 2007 or later versions, the defaults file format is .xlsx which is not supported by the older versions of Excel. If you want to save a file which should be compatible with older version, then use Save As (97-2003 Excel workbook format) .xls file format. By the way .xls can store macros as well.

0 0
H

Hemendra Pratap Singh replied | 06 Jun

Save as file in different format even older version..

0 0

Answer

You can add upto 6 Images

S

Shashi Ranjan 15 Mar in  Microsoft Excel Training classes

How can I get help within Microsoft Excel?

0 0 3

Show previous answers

Excelytics replied | 23 Mar

Every application has inbuilt help. Most of the applications have a shortcut to get help that is F1. You can use F1 to get help.

0 0
H

Hemendra Pratap Singh replied | 06 Jun

Just Press F1

0 0

Answer

You can add upto 6 Images

M

Murugan 15 Mar in  Microsoft Excel Training classes

How do I run a Spelling and Grammar check on my MS Excel spreadsheet?

0 0 3

Show previous answers

Apoorva replied | 15 Mar

Go to Review button in excel then in Proofing group click on spelling...

0 0

Excelytics replied | 23 Mar

Spell check which is a very common feature available in all MS-Office applications. Which enables the user to check/correct the spellings. Shortcut for spell check is F7 and also one can use it from Review Tab-->Proofing Group-->Spelling.

0 0

Answer

You can add upto 6 Images

U

User 14 Mar in  Microsoft Excel Training classes

How can I create shortcuts to these Excel functions?

1 0 4

Show previous answers

Sasi replied | 31 Mar

Key

Description

CTRL+PgUp

Switches between worksheet tabs, from left-to-right.

CTRL+PgDn

Switches between worksheet tabs, from right-to-left.

CTRL+SHIFT+(

Unhides any hidden rows within the selection.

CTRL+SHIFT+)

Unhides any hidden columns within the selection.

CTRL+SHIFT+&

Applies...  more»
Key

Description

CTRL+PgUp

Switches between worksheet tabs, from left-to-right.

CTRL+PgDn

Switches between worksheet tabs, from right-to-left.

CTRL+SHIFT+(

Unhides any hidden rows within the selection.

CTRL+SHIFT+)

Unhides any hidden columns within the selection.

CTRL+SHIFT+&

Applies the outline border to the selected cells.

CTRL+SHIFT_

Removes the outline border from the selected cells.

CTRL+SHIFT+~

Applies the General number format.

CTRL+SHIFT+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

CTRL+SHIFT+%

Applies the Percentage format with no decimal places.

CTRL+SHIFT+^

Applies the Exponential number format with two decimal places.

CTRL+SHIFT+#

Applies the Date format with the day, month, and year.

CTRL+SHIFT+@

Applies the Time format with the hour and minute, and AM or PM.

CTRL+SHIFT+!

Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+SHIFT+*

Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).

In a PivotTable, it selects the entire PivotTable report.

CTRL+SHIFT+:

Enters the current time.

CTRL+SHIFT+"

Copies the value from the cell above the active cell into the cell or the Formula Bar.

CTRL+SHIFT+Plus (+)

Displays the Insert dialog box to insert blank cells.

CTRL+Minus (-)

Displays the Delete dialog box to delete the selected cells.

CTRL+;

Enters the current date.

CTRL+`

Alternates between displaying cell values and displaying formulas in the worksheet.

CTRL+'

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

CTRL+1

Displays the Format Cells dialog box.

CTRL+2

Applies or removes bold formatting.

CTRL+3

Applies or removes italic formatting.

CTRL+4

Applies or removes underlining.

CTRL+5

Applies or removes strikethrough.

CTRL+6

Alternates between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+8

Displays or hides the outline symbols.

CTRL+9

Hides the selected rows.

CTRL+0

Hides the selected columns.

CTRL+A

Selects the entire worksheet.

If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.

When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.

CTRL+B

Applies or removes bold formatting.

CTRL+C

Copies the selected cells.

CTRL+C followed by another CTRL+C displays the Clipboard.

CTRL+D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+F

Displays the Find and Replace dialog box, with the Find tab selected.

SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.

CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.

CTRL+G

Displays the Go To dialog box.

F5 also displays this dialog box.

CTRL+H

Displays the Find and Replace dialog box, with the Replace tab selected.

CTRL+I

Applies or removes italic formatting.

CTRL+K

Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

CTRL+N

Creates a new, blank workbook.

CTRL+O

Displays the Open dialog box to open or find a file.

CTRL+SHIFT+O selects all cells that contain comments.

CTRL+P

Displays the Print dialog box.

CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.

CTRL+R

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

CTRL+S

Saves the active file with its current file name, location, and file format.

CTRL+T

Displays the Create Table dialog box.

CTRL+U

Applies or removes underlining.

CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.

CTRL+V

Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.

CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.

CTRL+W

Closes the selected workbook window.

CTRL+X

Cuts the selected cells.

CTRL+Y

Repeats the last command or action, if possible.

CTRL+Z

Uses the Undo command to reverse the last command or to delete the last entry that you typed.

CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

Top of Page

Function keys

Key

Description

F1

Displays the Microsoft Office Excel Help task pane.

CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.

ALT+F1 creates a chart of the data in the current range.

ALT+SHIFT+F1 inserts a new worksheet.

F2

Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.

SHIFT+F2 adds or edits a cell comment.

CTRL+F2 displays the Print Preview window.

F3

Displays the Paste Name dialog box.

SHIFT+F3 displays the Insert Function dialog box.

F4

Repeats the last command or action, if possible.

When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references.

CTRL+F4 closes the selected workbook window.

F5

Displays the Go To dialog box.

CTRL+F5 restores the window size of the selected workbook window.

F6

Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.

SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon.

CTRL+F6 switches to the next workbook window when more than one workbook window is open.

F7

Displays the Spelling dialog box to check spelling in the active worksheet or selected range.

CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.

F8

Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.

SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.

CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.

ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.

F9

Calculates all worksheets in all open workbooks.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

CTRL+F9 minimizes a workbook window to an icon.

F10

Turns key tips on or off.

SHIFT+F10 displays the shortcut menu for a selected item.

ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.

CTRL+F10 maximizes or restores the selected workbook window.

F11

Creates a chart of the data in the current range.

SHIFT+F11 inserts a new worksheet.

ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).

F12

Displays the Save As dialog box. «less

0 0

Excelytics replied | 01 Apr

Creating shortcuts for Excel features is not possible as they already exists in Excel. We can use QAT to get the quick access to those features.

Thanks,
Team Excelytics
Ameerpet, Hyderabad

0 0

Answer

You can add upto 6 Images

J

Show previous answers

Lokesh replied | 13 Jun

You can perform these functions using File tab or Office button.

0 0

Mahesh replied | 13 Jun

Keyboard shortcuts are Ctrl O for Open, Ctrl S for Save and Ctrl P for Print.

0 0

Answer

You can add upto 6 Images

P

Prashant 14 Mar in  Microsoft Excel Training classes

How many years of experience should a good Excel trainer need?

0 0 4

Show previous answers

H

Hemendra Pratap Singh replied | 06 Jun

Nothing It is like learning new things only

0 0

Mahesh replied | 08 Jun

It's depth of understanding and usage rather than years of experience that matters the most.
But, as that is highly subjective (and cannot be judged upfront), you should go with the trainer who has maximum experience (within the available options). I have an in depth experience of using excel tools (for 16 years).

0 0

Answer

You can add upto 6 Images

K

Kajol 14 Mar in  Microsoft Excel Training classes

What is the Ribbon in MS Excel?

0 0 3

Show previous answers

Excelytics replied | 23 Mar

Ribbon is available from 2007 version of MS-Office applications. Ribbon is the place where you can find all features of Excel. Tabs located on ribbon are Home, Insert, Page Layout, Formulas, Data, Review, View and Developer (Developer tab needs to be enabled)

0 0

Lokesh replied | 13 Jun

Ribbon is a given name to a bar at the top of the excel window that contains the options needed to perform any task.
Just check out the attached screenshot.

0 0

Answer

You can add upto 6 Images

A

Ankit 13 Mar in  Microsoft Excel Training classes

What all things should I keep in mind while choosing MS Excel Trainer?

0 0 3

Show previous answers

Nand replied | 14 Mar

Anyone can teach you content. Go for someone who present it in such a way that you can understand and that makes a lot of difference!

0 0

Gopal replied | 17 Jun

Working & Training Exposure.

0 0

Answer

You can add upto 6 Images

T

Tashiruddin 13 Mar in  Microsoft Excel Training classes

What are the qualifications needed for MS Excel trainer?

0 0 3

Show previous answers

Parkus replied | 31 Mar

Qualification for MS Excel trainer is he/she must know to work in Advanced MS Excel, Reporting and VBA Macros

0 0

Excelytics replied | 01 Apr

Good understanding about Data. Good knowledge on RDBMS. Because data is the most important thing to work with Excel. And also some Excel features like Formulas, Pivot Tables, Charts, Data Validation, Conditional Formatting etc.,

Thanks,
Team Excelytics
Ameerpet

0 0

Answer

You can add upto 6 Images

V

Vruthi 13 Mar in  Microsoft Excel Training classes

What are the qualities needed for Microsoft Excel tutor?

0 0 4

Show previous answers

Nachiketa replied | 10 Jun

To be a Microsoft Excel Trainer, you need to have in-depth knowledge in your subject and be clear with the fundamentals. Every question that students ask has an answer and it's not necessary to know everything but you should know what to find where anad how. Love your subject, be confident in your field and always be ready to learn new things in Excel as the more you dig in the...  more»
To be a Microsoft Excel Trainer, you need to have in-depth knowledge in your subject and be clear with the fundamentals. Every question that students ask has an answer and it's not necessary to know everything but you should know what to find where anad how. Love your subject, be confident in your field and always be ready to learn new things in Excel as the more you dig in the more you realize how vast it is. If you are well familiar with your subject, go ahead and get the Microsoft Excel Certification for Expert and Advanced. Trainers with recognized Certification in their field gets edge. Good Luck... «less

0 0

Lokesh replied | 13 Jun

First you need to develop a passion towards this amazing program by Microsoft and start solving queries posted on multiple online forums e.g. Urbanpro, Microsoft community etc. After developing sufficient knowledge and hold on this technology you can go ahead and share your knowledge. All the Best !!

0 0

Answer

You can add upto 6 Images

P

Praveen 12 Mar in  Microsoft Excel Training classes

How many days it will take to learn the basics of Microsoft Excel?

1 0 4

Show previous answers

S

Shreel replied | 17 Jun

Excel is an art which improves wurh practice... to take you thru Excel will take 10 days

0 0

Himaghiri Thanayan replied | 19 Jul

Less than 2 weeks

0 0

Answer

You can add upto 6 Images

S

Sayed 12 Mar in  Microsoft Excel Training classes

What are the benefits of taking Excel coaching classes?

0 0 3

Show previous answers

Excelytics replied | 06 Apr

Now a days Excel became an essential application to enter into any company as all companies track their information is spreadsheets. So, Excel is widely used for this reason.

Please contact us if you need more information.

Thanks,
Team Excelytics
Ameerpet, Hyderabad

0 0

Mahesh replied | 16 Apr

You will improve on quality and accuracy of your work and MIS. You can save a lot of time spent on repetative tasks which can be automated. You can also use nice conditional formating, charts and sparklines to improve look n feel. Ultimately you can improve your work life balance.

0 0

Answer

You can add upto 6 Images

H

Hema 12 Mar in  Microsoft Excel Training classes

Can I study Microsoft Excel myself?

0 0 3

Show previous answers

G

Ganesh replied | 13 Mar

Yea, you can, if you are interested and able to understand the terms or features of excel , then you can learn by self studues.... if any difficulties ask to experts

0 0
R

Ravindra replied | 14 Mar

yes..u can...

0 0

Answer

You can add upto 6 Images

D

Deepashri 12 Mar in  Microsoft Excel Training classes

I am an MBA student? Is it necessary for me to take MS Excel training?

0 0 4

Show previous answers

Intransure replied | 16 Mar

It will be a plus point to learn MS excel. If you are willing to start your professional career in Analytics. Most of the companies or MNC's working on data analytic prefer candidates who are proficient with MS excel (base and advanced)

0 0

Excelytics replied | 23 Mar

It's very hard to find a company without Excel. So, it would be a plus in your resume while attending interviews. All the very best.

0 0

Answer

You can add upto 6 Images

Previous1234Next

About UrbanPro

UrbanPro.com helps you to connect with the best Microsoft Excel Training classes in India. Post Your Requirement today and get connected.

Microsoft Excel Training classes in:

Have a Question?

Thousands of expert tutors are available to answer your question

Looking for Microsoft Excel Training classes?

Find best Microsoft Excel Training classes in your locality on UrbanPro.

FIND NOW

Do you offer Microsoft Excel Training classes?

Create Free Profile Now »

Top Contributors

Lokesh

33 Answers

Umasankar

33 Answers

Excelytics

29 Answers

Nachiketa

20 Answers

G Venkat

20 Answers

Nitin

19 Answers

Hemendra Pratap Singh

18 Answers

Raja

15 Answers

Chetan

15 Answers

Sponsored

Find Best Microsoft Excel Training classes?

Find Now »