· Advanced Operations
· Excel - Data Filtering
· Excel - Data Sorting
· Excel - Using Ranges
· Excel - Data Validation
· Excel - Using Styles
· Excel - Using Themes
· Excel - Using Templates
· Excel - Using Macros
· Excel - Adding Graphics
· Excel - Cross Referencing
· Excel - Printing Worksheets
· Excel - Email Workbooks
· Excel- Translate Worksheet
· Excel - Workbook Security
· Excel - Data Tables
· Excel - Pivot Tables
· Excel - Simple Charts
· Excel - Pivot Charts
· Excel - Keyboard Shortcuts
Data Filtering in Excel 2010
Filters in MS Excel
Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.)
Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this. Follow the below mentioned steps to do this.
· 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.
Using Multiple Filters
You can filter the records by multiple conditions i.e. by multiple column values. Suppose after size 36 is filtered, you need to have the filter where color is equal to Coffee. After setting filter for Shoe Size, choose Color column and then set filter for color.
Data Sorting in Excel 2010
Sorting in MS Excel
Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.
To Sort the data follow the steps mentioned below.
· 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.
o Values − Alphabetically or numerically.
o Cell Color − Based on Color of Cell.
o Font Color − Based on Font color.
o Cell Icon − Based on Cell Icon.
· Clicking Ok will sort the data.
Sorting option is also available from the Home Tab. Choose Home Tab » Sort & Filter. You can see the same dialog to sort records.
Using Ranges in Excel 2010
Ranges in MS Excel
A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column letter and row number. For example, cell B1 is the cell in the second column and the first row.
A group of cells is called a range. You designate a range address by specifying its upper-left cell address and its lower-right cell address, separated by a colon.
Example of Ranges −
· 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).
Selecting Ranges
You can select a range in several ways −
· 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.
Selecting Complete Rows and Columns
When you need to select an entire row or column. You can select entire rows and columns in much the same manner as you select ranges −
· 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.
Data Validation in Excel 2010
Data Validation
MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid entry, you can display a custom message as shown below.
Validation Criteria
To specify the type of data allowable in a cell or range, follow the steps below, which shows all the three tabs of the Data Validation dialog box.
· 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.
Settings Tab
Here you can set the type of validation you need. Choose an option from the Allow drop-down list. The contents of the Data Validation dialog box will change, displaying controls based on your choice.
· 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).
Input Message Tab
You can set the input help message with this tab. Fill the title and Input message of the Input message tab and the input message will appear when the cell is selected.
Error Alert Tab
You can specify an error message with this tab. Fill the title and error message. Select the style of the error as stop, warning or Information as per you need.
Using Styles in Excel 2010
Using Styles in MS Excel
With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent.
A Style can consist of settings for up to six different attributes −
· Number format
· Font (type, size, and color)
· Alignment (vertical and horizontal)
· Borders
· Pattern
· Protection (locked and hidden)
Now, let us see how styles are helpful. Suppose that you apply a particular style to some twenty cells scattered throughout your worksheet. Later, you realize that these cells should have a font size of 12 pt. rather than 14 pt. Rather than changing each cell, simply edit the style. All cells with that particular style change automatically.
Applying Styles
Choose Home » Styles » Cell Styles. Note that this display is a live preview, that is, as you move your mouse over the style choices, the selected cell or range temporarily displays the style. When you see a style you like, click it to apply the style to the selection.
Creating Custom Style in MS Excel
We can create new custom style in Excel 2010. To create a new style, follow these steps −
· 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.
Using Themes in Excel 2010
Using Themes in MS Excel
To help users create more professional-looking documents, MS Excel has incorporated a concept known as document themes. By using themes, it is easy to specify the colors, fonts, and a variety of graphic effects in a document. And best of all, changing the entire look of your document is a breeze. A few mouse clicks is all it takes to apply a different theme and change the look of your workbook.
Applying Themes
Choose Page layout Tab » Themes Dropdown. Note that this display is a live preview, that is, as you move your mouse over the Theme, it temporarily displays the theme effect. When you see a style you like, click it to apply the style to the selection.
Creating Custom Theme in MS Excel
We can create new custom Theme in Excel 2010. To create a new style, follow these steps −
· 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.
Using Templates in Excel 2010
Using Templates in MS Excel
Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks.
Viewing Available Templates
To view the Excel templates, choose File » New to display the available templates screen in Backstage View. You can select a template stored on your hard drive, or a template from Microsoft Office Online. If you choose a template from Microsoft Office Online, you must be connected to the Internet to download it. The Office Online Templates section contains a number of icons, which represents various categories of templates. Click an icon, and you’ll see the available templates. When you select a template thumbnail, you can see a preview in the right panel.
On-line Templates
These template data is available online at the Microsoft server. When you select the template and click on it, it will download the template data from Microsoft server and opens it as shown below.
Using Macros in Excel 2010
Macros in MS Excel
Macros enable you to automate almost any task that you can undertake in Excel 2010. By using macro recorder from View Tab » Macro Dropdown to record tasks that you perform routinely, you not only speed up the procedure considerably but you are assured that each step in a task is carried out the same way each and every time you perform a task.
To view macros choose View Tab » Macro dropdown.
Macro Options
View tab contains a Macros command button to which a dropdown menu containing the following three options.
· 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.
Creating Macros
You can create macros in one of two ways −
· 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.
Now let's create a simple macro that will automate the task of making cell content Bold and apply cell color.
· 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.
Edit Macro
You can edit the created Macro at any time. Editing macro will take you to the VBA programming editor.
Adding Graphics in Excel 2010
Graphic Objects in MS Excel
MS Excel supports various types of graphic objects like Shapes gallery, SmartArt, Text Box, and WordArt available on the Insert tab of the Ribbon.Graphics are available in the Insert Tab. See the screenshots below for various available graphics in MS Excel 2010.
Insert Shape
· 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.
Insert Smart Art
· 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.
Insert Clip Art
· 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.
Insert Word Art
· Choose Insert Tab » WordArt.
· Select the style of WordArt, which you like and click it to enter a text in it.
Cross Referencing in Excel 2010
Graphic Objects in MS Excel
When you have information spread across several different spreadsheets, it can seem a daunting task to bring all these different sets of data together into one meaningful list or table. This is where the Vlookup function comes into its own.
VLOOKUP
VlookUp searches for a value vertically down for the lookup table. VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) has 4 parameters as below.
· 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.
VLOOKUP Example
Let's look at a very simple example of cross-referencing two spreadsheets. Each spreadsheet contains information about the same group of people. The first spreadsheet has their dates of birth, and the second shows their favorite color. How do we build a list showing the person's name, their date of birth and their favorite color? VLOOOKUP will help in this case. First of all, let us see data in both the sheets.
This is data in the first sheet
This is data in the second sheet
Now for finding the respective favorite color for that person from another sheet we need to vlookup the data. First argument to the VLOOKUP is lookup value (In this case it is person name). Second argument is the table array, which is table in the second sheet from B2 to C11. Third argument to VLOOKUP is Column index num, which is the answer we are looking for. In this case, it is 2 the color column number is 2. The fourth argument is True returning partial match or false returning exact match. After applying VLOOKUP formula it will calculate the color and the results are displayed as below.
As you can see in the above screen-shot that results of VLOOKUP has searched for color in the second sheet table. It has returned #N/A in case where match is not found. In this case, Andy's data is not present in the second sheet so it returned #N/A.
Printing Worksheets in Excel 2010
Quick Print
If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option.
· 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).
Adjusting Common Page Setup Settings
You can adjust the print settings available in the Page setup dialogue in different ways as discussed below. Page setup options include Page orientation, Page Size, Page Margins, etc.
· The Print screen in Backstage View, displayed when you choose File » Print.
· The Page Layout tab of the Ribbon.
Choosing Your Printer
To switch to a different printer, choose File » Print and use the drop-down control in the Printer section to select any other installed printer.
Specifying What You Want to Print
Sometimes you may want to print only a part of the worksheet rather than the entire active area. Choose File » Print and use the controls in the Settings section to specify what to print.
· 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.
Email Workbooks MS Excel 2010
Email Workbook
MS Excel allows you to email the workbook very easily. To email the workbook to anyone, follow the below mentioned steps.
· 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.
Translate Worksheet in Excel 2010
Translate Worksheet
You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or translate your whole file with MS Excel 2010.
Translation is available in the review tab of the ribbon in MS Excel 2010. You can quickly translate cell into different language with this option.
Performing Translation Step By Step
· 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.
Workbook Security in Excel 2010
Workbook Security
We can apply security to the workbook by the concept of protection available in the Review Tab of ribbon. MS Excel's protection-related features fall into three categories.
· 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.
Protect Worksheet
You may want to protect a worksheet for a variety of reasons. One reason is to prevent yourself or others from accidentally deleting the formulas or other critical data. A common scenario is to protect a worksheet, so that the data can be changed, but the formulas can’t be changed.
To protect a worksheet, choose Review » Changes group » Protect Sheet. Excel displays the Protect Sheet dialog box. Note that providing a password is optional. If you enter a password, that password will be required to unprotect the worksheet. You can select various options in which the sheet should be protected. Suppose we checked Format Cells option then Excel will not allow to format cells.
When somebody tries to format the cells, he or she will get the error as shown in the screenshot below.
To unprotect a protected sheet, choose Review » Changes group » Unprotect Sheet. If the sheet was protected with a password, you’re prompted to enter that password.
Protecting a Workbook
Excel provides three ways to protect a 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.
Requiring a Password to Open a Workbook
Excel lets you save a workbook with a password. After doing so, whoever tries to open the workbook, must enter the password. To add a password to a workbook, follow these steps.
· 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.
To remove a password from a workbook, repeat the same procedure. In Step 2, however, delete the existing password symbols.
Protecting Workbook’s Structure and Windows
To prevent others (or yourself) from performing certain actions in a workbook, you can protect the workbook’s structure and windows. When a workbook’s structure and windows are protected, the user may not Add a sheet, Delete a sheet, Hide a sheet, unhide a sheet, etc., and may not be allowed to change the size or position of a workbook’s windows respectively.
To protect a worksheet’s structure and windows, follow the below mentioned steps.
· 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.
Data Tables in Excel 2010
Data Tables
In Excel, a Data Table is a way to see different results by altering an input cell in your formula. Data tables are available in Data Tab » What-If analysis dropdown » Data table in MS Excel.
Data Table with Example
Now, let us see data table concept with an example. Suppose you have the Price and quantity of many values. Also, you have the discount for that as third variable for calculating the Net Price. You can keep the Net Price value in the organized table format with the help of the data table. Your Price runs horizontally to the right while quantity runs vertically down. We are using a formula to calculate the Net Price as Price multiplied by Quantity minus total discount (Quantity * Discount for each quantity).
Now, for creation of data table select the range of data table. Choose Data Tab » What-If analysis dropdown » Data table. It will give you dialogue asking for Input row and Input Column. Give the Input row as Price cell (In this case cell B3) and Input column as quantity cell (In this case cell B4). Please see the below screen-shot.
Clicking OK will generate data table as shown in the below screen-shot. It will generate the table formula. You can change the price horizontally or quantity vertically to see the change in the Net Price.
Pivot Tables in Excel 2010
Pivot Tables
A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers into a meaningful presentation of the data. Pivot tables are very powerful tool for summarized analysis of the data.
Pivot tables are available under Insert tab » PivotTable dropdown » PivotTable.
Pivot Table Example
Now, let us see Pivot table with the help of example. Suppose you have huge data of voters and you want to see the summarized data of voter Information per party, then you can use the Pivot table for it. Choose Insert tab » Pivot Table to insert pivot table. MS Excel selects the data of the table. You can select the pivot table location as existing sheet or new sheet.
This will generate the Pivot table pane as shown below. You have various options available in the Pivot table pane. You can select fields for the generated pivot table.
· 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).
After giving input fields to the pivot table, it generates the pivot table with the data as shown below.
Simple Charts in Excel 2010
Charts
A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude, but thy have improved significantly over the years. Excel provides you with the tools to create a wide variety of highly customizable charts. Displaying data in a well-conceived chart can make your numbers more understandable. Because a chart presents a picture, charts are particularly useful for summarizing a series of numbers and their interrelationships.
Types of Charts
There are various chart types available in MS Excel as shown in the below screen-shot.
· 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.
Creating Chart
To create charts for the data by below mentioned steps.
· 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.
Editing Chart
You can edit the chart at any time after you have created it.
· 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.
· Pivot Charts Excel 2010
· Pivot Charts
· A pivot chart is a graphical representation of a data summary, displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a pivot chart without a pivot table. All Excel charting features are available in a pivot chart.
· Pivot charts are available under Insert tab » PivotTable dropdown » PivotChart.
· Pivot Chart Example
· Now, let us see Pivot table with the help of an example. Suppose you have huge data of voters and you want to see the summarized view of the data of voter Information per party in the form of charts, then you can use the Pivot chart for it. Choose Insert tab » Pivot Chart to insert the pivot table.
· 
· MS Excel selects the data of the table. You can select the pivot chart location as an existing sheet or a new sheet. Pivot chart depends on automatically created pivot table by the MS Excel. You can generate the pivot chart in the below screen-shot.
· 
Keyboard Shortcuts in Excel 2010
MS Excel Keyboard Short-cuts
MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.
· 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.
·
