Excel 简明教程

Tabs − They appear across the top of the Ribbon and contain groups of related commands. Home, Insert, Page Layout are the examples of ribbon tabs.

Groups − They organize related commands; each group name appears below the group on the Ribbon. For example, group of commands related to fonts or group of commands related to alignment etc.

Commands − Commands appear within each group as mentioned above.

Normal Layout view − This displays the page in normal view.

Page Layout view − This displays pages exactly as they will appear when printed. This gives a full screen look of the document.

Page Break view − This shows a preview of where pages will break when printed.

Compatibility Mode − If the sheet is not a native excel 2007/2010 sheet, a Convert button appears here, enabling you to easily update its format. Otherwise, this category does not appear.

Permissions − You can use this option to protect the excel sheet. You can set a password so that nobody can open your sheet, or you can lock the sheet so that nobody can edit your sheet.

Prepare for Sharing − This section highlights important information you should know about your sheet before you send it to others, such as a record of the edits you made as you developed the sheet.

Versions − If the sheet has been saved several times, you may be able to access previous versions of it from this section.

Move upward by one line by clicking the upward-pointing scroll arrow.

Move downward by one line by clicking the downward-pointing scroll arrow.

Move one next page, using next page button (footnote).

Move one previous page, using previous page button (footnote).

Use Browse Object button to move through the sheet, going from one chosen object to the next.

Just press Ctrl + S keys to save the changes.

Optionally, you can click on the floppy icon available at the top left corner and just above the File tab. This option will also save the changes.

You can also use third method to save the changes, which is the Save option available just above the Save As option as shown in the above screen capture.

Row runs horizontally while Column runs vertically.

Each row is identified by row number, which runs vertically at the left side of the sheet.

Each column is identified by column header, which runs horizontally at the top of the sheet.

You can go to the last row by clicking Control + Down Navigation arrow.

You can go to the last column by clicking Control + Right Navigation arrow.

To copy and paste, just select the cells you want to copy. Choose copy option after right click or press Control + C.

Select the cell where you need to paste this copied content. Right click and select paste option or press Control + V.

All − Pastes the cell’s contents, formats, and data validation from the Windows Clipboard.

Formulas − Pastes formulas, but not formatting.

Values − Pastes only values not the formulas.

Formats − Pastes only the formatting of the source range.

Comments − Pastes the comments with the respective cells.

Validation − Pastes validation applied in the cells.

All using source theme − Pastes formulas, and all formatting.

All except borders − Pastes everything except borders that appear in the source range.

Column Width − Pastes formulas, and also duplicates the column width of the copied cells.

Formulas & Number Formats − Pastes formulas and number formatting only.

Values & Number Formats − Pastes the results of formulas, plus the number.

Merge Conditional Formatting − This icon is displayed only when the copied cells contain conditional formatting. When clicked, it merges the copied conditional formatting with any conditional formatting in the destination range.

Transpose − Changes the orientation of the copied range. Rows become columns, and columns become rows. Any formulas in the copied range are adjusted so that they work properly when transposed.

Within − Specifying the search should be in Sheet or workbook.

Search By − Specifying the internal search method by rows or by columns.

Look In − If you want to find text in formula as well, then select this option.

Match Case − If you want to match the case like lower case or upper case of words, then check this option.

Match Entire Cell Content − If you want the exact match of the word with cell, then check this option.

To access the spell checker, Choose Review ➪ Spelling or press F7.

To check the spelling in just a particular range, select the range before you activate the spell checker.

If the spell checker finds any words it does not recognize as correct, it displays the Spelling dialogue with suggested options.

Ignore Once − Ignores the word and continues the spell check.

Ignore All − Ignores the word and all subsequent occurrences of it.

Add to Dictionary − Adds the word to the dictionary.

Change − Changes the word to the selected word in the Suggestions list.

Change All − Changes the word to the selected word in the Suggestions list and changes all subsequent occurrences of it without asking.

AutoCorrect − Adds the misspelled word and its correct spelling (which you select from the list) to the AutoCorrect list.

Choose Review » Comments » New Comment.

Right-click the cell and choose Insert Comment from available options.

Press Shift+F2.

Select the cell on which the comment appears.

Right-click the cell and choose the Edit Comment from the available options.

Modify the comment.

Choose Insert » Text Box » choose text box or draw it.

Fill − Specifies the filling of text box like No fill, solid fill. Also specifying the transparency of text box fill.

Line Colour − Specifies the line colour and transparency of the line.

Line Style − Specifies the line style and width.

Size − Specifies the size of the text box.

Properties − Specifies some properties of the text box.

Text Box − Specifies text box layout, Auto-fit option and internal margins.

From the Quick access tool-bar » Click Undo.

Press Control + Z.

From the Quick access tool-bar » Click Redo.

Press Control + Y.

Right Click on the cell » Format cells » Number.

Click on the Ribbon from the ribbon.

General − This is the default cell format of Cell.

Number − This displays cell as number with separator.

Currency − This displays cell as currency i.e. with currency sign.

Accounting − Similar to Currency, used for accounting purpose.

Date − Various date formats are available under this like 17-09-2013, 17th-Sep-2013, etc.

Time − Various Time formats are available under this, like 1.30PM, 13.30, etc.

Percentage − This displays cell as percentage with decimal places like 50.00%.

Fraction − This displays cell as fraction like 1/4, 1/2 etc.

Scientific − This displays cell as exponential like 5.6E+01.

Text − This displays cell as normal text.

Special − Special formats of cell like Zip code, Phone Number.

Custom − You can use custom format by using this.

Right click on cell » Format cells » Font Tab

Press Control + 1 or Shift + Control + F

Bold − It makes the text in bold by choosing Home » Font Group » Click B or Press Control + B.

Italic − It makes the text italic by choosing Home » Font Group » Click I or Press Control + I.

Underline − It makes the text to be underlined by choosing Home » Font Group » Click U or Press Control + U.

Double Underline − It makes the text highlighted as double underlined by choose Home » Font Group » Click arrow near U » Select Double Underline.

Strike-through − It strikes the text in the center vertically.

Super Script − It makes the content to appear as a super script.

Sub Script − It makes content to appear as a sub script.

Left − Aligns the cell contents to the left side of the cell.

Center − Centers the cell contents in the cell.

Right − Aligns the cell contents to the right side of the cell.

Fill − Repeats the contents of the cell until the cell’s width is filled.

Justify − Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line.

Top Aligns the cell contents to the top of the cell.

Center Centers the cell contents vertically in the cell.

Bottom Aligns the cell contents to the bottom of the cell.

Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.

Choose Merge & Center control on the Ribbon, which is simpler. To merge cells, select the cells that you want to merge and then click the Merge & Center button.

Choose Alignment tab of the Format Cells dialogue box to merge the cells.

Merge Across − When a multi-row range is selected, this command creates multiple merged cells — one for each row.

Merge Cells − Merges the selected cells without applying the Center attribute.

Unmerge Cells − Unmerges the selected cells.

Number − You can set the Format of the cell depending on the cell content. Find tutorial on this at MS Excel - Setting Cell Type.

Alignment − You can set the alignment of text on this tab. Find tutorial on this at MS Excel - Text Alignments.

Font − You can set the Font of text on this tab.Find tutorial on this at MS Excel - Setting Fonts.

Border − You can set border of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades.

Fill − You can set fill of cell with this tab. Find tutorial on this at MS Excel - Borders and Shades.

Protection − You can set cell protection option with this tab.

Print Area − You can set the print area with this option.

Print Titles − You can set titles to appear at the top for rows and at the left for columns.

Print − Gridlines − Gridlines to appear while printing worksheet. Black & White − Select this check box to have your color printer print the chart in black and white. Draft quality − Select this check box to print the chart using your printer’s draft-quality setting. Rows & Column Heading − Select this check box to have rows and column heading to print.

Page Order − Down, then Over − It prints the down pages first and then the right pages. Over, then Down − It prints right pages first and then comes to print the down pages.

Choose Page Layout » Page Setup » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting.

These options are also available when you choose File » Print.

Portrait − Portrait to print tall pages (the default).

Landscape − Landscape to print wide pages. Landscape orientation is useful when you have a wide range that doesn’t fit on a vertically oriented page.

Choose Page Layout » Page Setup » Orientation » Portrait or Landscape.

Choose File » Print.

Choose Page Setup dialog box » Header or Footer tab.

&[Page] − Displays the page number.

&[Pages] − Displays the total number of pages to be printed.

&[Date] − Displays the current date.

&[Time] − Displays the current time.

&[Path]&[File] − Displays the workbook’s complete path and filename.

&[File] − Displays the workbook name.

&[Tab] − Displays the sheet’s name.

Different First Page − Check this to specify a different header or footer for the first printed page.

Different Odd & Even Pages − Check this to specify a different header or footer for odd and even pages.

Scale with Document − If checked, the font size in the header and footer will be sized. Accordingly if the document is scaled when printed. This option is enabled, by default.

Align with Page Margins − If checked, the left header and footer will be aligned with the left margin, and the right header and footer will be aligned with the right margin. This option is enabled, by default.

Remove a page break you’ve added − Move the cell pointer to the first row beneath the manual page break and then choose Page Layout » Page Setup » Breaks » Remove Page Break.

Remove all manual page breaks − Choose Page Layout » Page Setup » Breaks » Reset All Page Breaks.

You can insert a Shape, WordArt, or a picture on your worksheet and then adjust its transparency. Then copy the image to all printed pages.

You can insert an object in a page header or footer.

Select the First row or First Column or the row Below, which you want to freeze, or Column right to area, which you want to freeze.

Choose View Tab » Freeze Panes.

Select the suitable option − Freeze Panes − To freeze area of cells. Freeze Top Row − To freeze first row of worksheet. Freeze First Column − To freeze first Column of worksheet.

If you have selected Freeze top row you can see the first row appears at the top, after scrolling also. See the below screen-shot.

Highlight Cells Rules − It opens a continuation menu with various options for defining the formatting rules that highlight the cells in the cell selection that contain certain values, text, or dates, or that have values greater or less than a particular value, or that fall within a certain ranges of values.

Top/Bottom Rules − It opens a continuation menu with various options for defining the formatting rules that highlight the top and bottom values, percentages, and above and below average values in the cell selection.

Data Bars − It opens a palette with different color data bars that you can apply to the cell selection to indicate their values relative to each other by clicking the data bar thumbnail.

Color Scales − It opens a palette with different three- and two-colored scales that you can apply to the cell selection to indicate their values relative to each other by clicking the color scale thumbnail.

Icon Sets − It opens a palette with different sets of icons that you can apply to the cell selection to indicate their values relative to each other by clicking the icon set.

New Rule − It opens the New Formatting Rule dialog box, where you define a custom conditional formatting rule to apply to the cell selection.

Clear Rules − It opens a continuation menu, where you can remove the conditional formatting rules for the cell selection by clicking the Selected Cells option, for the entire worksheet by clicking the Entire Sheet option, or for just the current data table by clicking the This Table option.

Manage Rules − It opens the Conditional Formatting Rules Manager dialog box, where you edit and delete particular rules as well as adjust their rule precedence by moving them up or down in the Rules list box.

Mathematical operators, such as +(for addition) and *(for multiplication) Example − =A1+A2 Adds the values in cells A1 and A2.

Values or text Example − =200*0.5 Multiplies 200 times 0.15. This formula uses only values, and it always returns the same result as 100.

Cell references (including named cells and ranges) Example − =A1=C12 Compares cell A1 with cell C12. If the cells are identical, the formula returns TRUE; otherwise, it returns FALSE.

Worksheet functions (such as SUMor AVERAGE) Example − =SUM(A1:A12) Adds the values in the range A1:A12.

column C : =SUM(C3:C8)

column D : =SUM(D3:D8)

column E : =SUM(E3:E8)

column F : =SUM(F3:F8)

column G : =SUM(G3:G8)

No arguments − Examples − Now(), Date(), etc.

One argument − UPPER(), LOWER(), etc.

A fixed number of arguments − IF(), MAX(), MIN(), AVERGAGE(), etc.

Infinite number of arguments

Optional arguments

Text Functions LOWER − Converts all characters in a supplied text string to lower case UPPER − Converts all characters in a supplied text string to upper case TRIM − Removes duplicate spaces, and spaces at the start and end of a text string CONCATENATE − Joins together two or more text strings. LEFT − Returns a specified number of characters from the start of a supplied text string. MID − Returns a specified number of characters from the middle of a supplied text string RIGHT − Returns a specified number of characters from the end of a supplied text string. LEN − Returns the length of a supplied text string FIND − Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).

Date & Time DATE − Returns a date, from a user-supplied year, month and day. TIME − Returns a time, from a user-supplied hour, minute and second. DATEVALUE − Converts a text string showing a date, to an integer that represents the date in Excel’s date-time code. TIMEVALUE − Converts a text string showing a time, to a decimal that represents the time in Excel. NOW − Returns the current date & time. TODAY − Returns today’s date.

Statistical MAX − Returns the largest value from a list of supplied numbers. MIN − Returns the smallest value from a list of supplied numbers. AVERAGE − Returns the Average of a list of supplied numbers. COUNT − Returns the number of numerical values in a supplied set of cells or values. COUNTIF − Returns the number of cells (of a supplied range), that satisfies a given criteria. SUM − Returns the sum of a supplied list of numbers

Logical AND − Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise OR − Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise. NOT − Returns a logical value that is the opposite of a user supplied logical value or expression i.e. returns FALSE if the supplied argument is TRUE and returns TRUE if the supplied argument is FAL

Math & Trig ABS − Returns the absolute value (i.e. the modulus) of a supplied number. SIGN − Returns the sign (+1, -1 or 0) of a supplied number. SQRT − Returns the positive square root of a given number. MOD − Returns the remainder from a division between two supplied numbers.

Place a cursor on the Header Row.

Choose Data Tab » Filter to set filter.

Click the drop-down arrow in the Area Row Header and remove the check mark from Select All, which unselects everything.

Then select the check mark for Size 36 which will filter the data and displays data of Shoe Size 36.

Some of the row numbers are missing; these rows contain the filtered (hidden) data.

There is drop-down arrow in the Area column now shows a different graphic — an icon that indicates the column is filtered.

Select the Column by which you want to sort data.

Choose Data Tab » Sort Below dialog appears.

If you want to sort data based on a selected column, Choose Continue with the selection or if you want sorting based on other columns, choose Expand Selection.

You can Sort based on the below Conditions. Values − Alphabetically or numerically. Cell Color − Based on Color of Cell. Font Color − Based on Font color. Cell Icon − Based on Cell Icon.

Clicking Ok will sort the data.

C24 − A range that consists of a single cell.

A1:B1 − Two cells that occupy one row and two columns.

A1:A100 − 100 cells in column A.

A1:D4 − 16 cells (four rows by four columns).

Press the left mouse button and drag, highlighting the range. Then release the mouse button. If you drag to the end of the screen, the worksheet will scroll.

Press the Shift key while you use the navigation keys to select a range.

Press F8 and then move the cell pointer with the navigation keys to highlight the range. Press F8 again to return the navigation keys to normal movement.

Type the cell or range address into the Name box and press Enter. Excel selects the cell or range that you specified.

Click the row or column border to select a single row or column.

To select multiple adjacent rows or columns, click a row or column border and drag to highlight additional rows or columns.

To select multiple (nonadjacent) rows or columns, press Ctrl while you click the row or column borders that you want.

Select the cell or range.

Choose Data » Data Tools » Data Validation. Excel displays its Data Validation dialog box having 3 tabs settings, Input Message and Error alert.

Any Value − Selecting this option removes any existing data validation.

Whole Number − The user must enter a whole number.For example, you can specify that the entry must be a whole number greater than or equal to 50.

Decimal − The user must enter a number. For example, you can specify that the entry must be greater than or equal to 10 and less than or equal to 20.

List − The user must choose from a list of entries you provide. You will create drop-down list with this validation. You have to give input ranges then those values will appear in the drop-down.

Date − The user must enter a date. You specify a valid date range from choices in the Data drop-down list. For example, you can specify that the entered data must be greater than or equal to January 1, 2013, and less than or equal to December 31, 2013.

Time − The user must enter a time. You specify a valid time range from choices in the Data drop-down list. For example, you can specify that the entered data must be later than 12:00 p.m.

Text Length − The length of the data (number of characters) is limited. You specify a valid length by using the Data drop-down list. For example, you can specify that the length of the entered data be 1 (a single alphanumeric character).

Custom − To use this option, you must supply a logical formula that determines the validity of the user’s entry (a logical formula returns either TRUE or FALSE).

Number format

Font (type, size, and color)

Alignment (vertical and horizontal)

Borders

Pattern

Protection (locked and hidden)

Select a cell and click on Cell styles from Home Tab.

Click on New Cell Style and give style name.

Click on Format to apply formatting to the cell.

After applying formatting click on OK. This will add new style in the styles. You can view it on Home » Styles.

Click on the save current theme option under Theme in Page Layout Tab.

This will save the current theme to office folder.

You can browse the theme later to load the theme.

View Macros − Opens the Macro dialog box where you can select a macro to run or edit.

Record Macro − Opens the Record Macro dialog box where you define the settings for your new macro and then start the macro recorder; this is the same as clicking the Record Macro button on the Status bar.

Use Relative References − Uses relative cell addresses when recording a macro, making the macro more versatile by enabling you to run it in areas of a worksheet other than the ones originally used in the macro’s recording.

Use MS Excel’s macro recorder to record your actions as you undertake them in a worksheet.

Enter the instructions that you want to be followed in a VBA code in the Visual Basic Editor.

Choose View Tab » Macro dropdown.

Click on Record Macro as below.

Now Macro recording will start.

Do the steps of action, which you want to perform repeatedly. Macro will record those steps.

You can stop the macro recording once done with all steps.

Choose Insert Tab » Shapes dropdown.

Select the shape you want to insert. Click on shape to insert it.

To edit the inserted shape just drag the shape with the mouse. Shape will adjust the shape.

Choose Insert Tab » SmartArt.

Clicking SmartArt will open the SmartArt dialogue as shown below in the screen-shot. Choose from the list of available smartArts.

Click on SmartArt to Insert it in the worksheet.

Edit the SmartArt as per your need.

Choose Insert Tab » Clip Art.

Clicking Clip Art will open the search box as shown in the below screen-shot. Choose from the list of available Clip Arts.

Click on Clip Art to Insert it in the worksheet.

Choose Insert Tab » WordArt.

Select the style of WordArt, which you like and click it to enter a text in it.

lookup_value − It is the user input. This is the value that the function uses to search on.

The table_array − It is the area of cells in which the table is located. This includes not only the column being searched on, but the data columns for which you are going to get the values that you need.

Col_index_num − It is the column of data that contains the answer that you want.

Range_lookup − It is a TRUE or FALSE value. When set to TRUE, the lookup function gives the closest match to the lookup_value without going over the lookup_value. When set to FALSE, an exact match must be found to the lookup_value or the function will return #N/A. Note, this requires that the column containing the lookup_value be formatted in ascending order.

Choose File » Print (which displays the Print pane), and then click the Print button.

Press Ctrl+P and then click the Print button (or press Enter).

The Print screen in Backstage View, displayed when you choose File » Print.

The Page Layout tab of the Ribbon.

Active Sheets − Prints the active sheet or sheets that you selected.

Entire Workbook − Prints the entire workbook, including chart sheets.

Selection − Prints only the range that you selected before choosing File » Print.

Choose File » Save and Send. It basically saves the document first and then the emails.

Click on Send using E-mail if your email system is configured. MS Outlook will open with the file as attachment in the New Email Window. You can send mail this workbook to anyone with valid email address.

Select the content, which you want to translate to a different language.

Choose review tab » translation.

It will open the pane from which you can select the language to which you need to translate.

You need to have an internet connection for performing translation. It will translate using the Microsoft Translator.

Click on Insert to apply translation changes.

Worksheet protection − Protecting a worksheet from being modified, or restricting the modifications to certain users.

Workbook protection − Protecting a workbook from having sheets inserted or deleted, and also requiring the use of password to open the workbook.

Requires a password to open the workbook.

Prevents the users from adding sheets, deleting sheets, hiding sheets, and unhiding sheets.

Prevents users from changing the size or position of windows.

Choose File » Info » Protect Workbook » Encrypt With Password. Excel displays the Encrypt Document dialog box.

Type a password and click OK.

Type the password again and click OK.

Save the workbook.

Choose Review » Changes group » Protect Workbook to display the Protect Workbook dialog box.

In the Protect Workbook dialog box, select the Structure check box and Windows check box.

(Optional) Enter a password.

Click OK.

Column labels − A field that has a column orientation in the pivot table. Each item in the field occupies a column.

Report Filter − You can set the filter for the report as year, then data gets filtered as per the year.

Row labels − A field that has a row orientation in the pivot table. Each item in the field occupies a row.

Values area − The cells in a pivot table that contain the summary data. Excel offers several ways to summarize the data (sum, average, count, and so on).

Column − Column chart shows data changes over a period of time or illustrates comparisons among items.

Bar − A bar chart illustrates comparisons among individual items.

Pie − A pie chart shows the size of items that make up a data series, proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data.

Line − A line chart shows trends in data at equal intervals.

Area − An area chart emphasizes the magnitude of change over time.

X Y Scatter − An xy (scatter) chart shows the relationships among the numeric values in several data series, or plots two groups of numbers as one series of xy coordinates.

Stock − This chart type is most often used for stock price data, but can also be used for scientific data (for example, to indicate temperature changes).

Surface − A surface chart is useful when you want to find the optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values.

Doughnut − Like a pie chart, a doughnut chart shows the relationship of parts to a whole; however, it can contain more than one data series.

Bubble − Data that is arranged in columns on a worksheet, so that x values are listed in the first column and corresponding y values and bubble size values are listed in adjacent columns, can be plotted in a bubble chart.

Radar − A radar chart compares the aggregate values of a number of data series.

Select the data for which you want to create the chart.

Choose Insert Tab » Select the chart or click on the Chart group to see various chart types.

Select the chart of your choice and click OK to generate the chart.

You can select the different data for chart input with Right click on chart » Select data. Selecting new data will generate the chart as per the new data, as shown in the below screen-shot.

You can change the X axis of the chart by giving different inputs to X-axis of chart.

You can change the Y axis of chart by giving different inputs to Y-axis of chart.

Ctrl + A − Selects all contents of the worksheet.

Ctrl + B − Bold highlighted selection.

Ctrl + I − Italicizes the highlighted selection.

Ctrl + K − Inserts link.

Ctrl + U − Underlines the highlighted selection.

Ctrl + 1 − Changes the format of selected cells.

Ctrl + 5 − Strikethrough the highlighted selection.

Ctrl + P − Brings up the print dialog box to begin printing.

Ctrl + Z − Undo last action.

Ctrl + F3 − Opens Excel Name Manager.

Ctrl + F9 − Minimizes the current window.

Ctrl + F10 − Maximize currently selected window.

Ctrl + F6 − Switches between open workbooks or windows.

Ctrl + Page up − Moves between Excel work sheets in the same Excel document.

Ctrl + Page down − Moves between Excel work sheets in the same Excel document.

Ctrl + Tab − Moves between Two or more open Excel files.

Alt + = − Creates a formula to sum all of the above cells

Ctrl + ' − Inserts the value of the above cell into cell currently selected.

Ctrl + Shift + ! − Formats the number in comma format.

Ctrl + Shift + $ − Formats the number in currency format.

Ctrl + Shift + # − Formats the number in date format.

Ctrl + Shift + % − Formats the number in percentage format.

Ctrl + Shift + ^ − Formats the number in scientific format.

Ctrl + Shift + @ − Formats the number in time format.

Ctrl + Arrow key − Moves to the next section of text.

Ctrl + Space − Selects the entire column.

Shift + Space − Selects the entire row.

Ctrl + - − Deletes the selected column or row.

Ctrl + Shift + = − Inserts a new column or row.

Ctrl + Home − Moves to cell A1.

Ctrl + ~ − Switches between showing Excel formulas or their values in cells.

F2 − Edits the selected cell.

F3 − After a name has been created F3 will paste names.

F4 − Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.

F5 − Goes to a specific cell. For example, C6.

F7 − Spell checks the selected text or document.

F11 − Creates chart from the selected data.

Ctrl + Shift + ; − Enters the current time.

Ctrl + ; − Enters the current date.

Alt + Shift + F1 − Inserts New Worksheet.

Alt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.

Shift + F3 − Opens the Excel formula window.

Shift + F5 − Brings up the search box.