Shortcut keys useful in Microsoft excel

 Bonus - My Favorite Shortcuts 

Ctrl + S – save the active workbook with its current file name and location.

 Ctrl + Z – undo the last action .

Ctrl + Y - redo the last action (undo an undo!) .

Ctrl + C – copy the selected cells .

Ctrl + X – cut the selected cells.

 Ctrl + V – pasted the copied cells .

Ctrl + B – add or remove bold formatting .

Ctrl + I – add or remove italic formatting.

 Ctrl + D – copy the above cell into the below selected cells.

 Ctrl + R – copy the left cell into the right selected      cells .

Ctrl + F – open the find dialog box .

Ctrl + H – open the find and replace dialog box.

Essential tips and tricks useful in excel

  Microsoft excel

                                                 Learn Excel Visually

The ‘Learn Excel Visually’ Journey Excel is relevant for all aspects of a business and it’s not hard to learn, but even apparently smart people can have trouble mastering Excel. Why is this? Well - Excel provides the tools,but doesn’t tell you how to use them. You can read about the functionality of Excel and try and figure out what to use, but how do you know what to apply and when? The Learn Excel Visually (LEV) journey is here to take you through the essentials of the Excel process; set up your spreadsheet, capture and structure data efficiently, cleanse it, analyse it meaningfully and present it with visual oomph.

                                            

 Quick glossary

Most of you will already understand the basic elements of Excel but I want to use this section to clarify some key Excel terminology to ensure we are on the same page.

Menu = The list of items along the top of the screen; for example, file, insert, page layout etc.… 

Ribbon = Ribbon is like an expanded menu. It depicts all the features of Excel in an easy-to-understand pictorial form. Since Excel has 1000s of features, they are grouped into several ribbons. For example, the ‘insert’ ribbon has functions grouped into, clipboard, font, alignment, number, styles etc.…

Name box = Just underneath the Ribbon you have a white box on the left-hand side – it shows the cell reference (default A1) or if you have specified a name for a cell or range of cells, it will show that name.

Formula bar = Next to the Name box, also underneath the Ribbon. The formula bar shows you the contents of a selected cell, particularly useful if you want to see a calculation within a cell and not just the output of the calculation.

Spreadsheet = A method of spreading information across a sheet of paper - the screen represents a piece of paper with grid lines.

Workbook = the file you create in Excel.

Worksheet = A page within the Workbook. By default, an Excel Workbook contains 3 worksheets; they are the viewed using tabs along the bottom.

Cells = The grid lines make rectangular boxes - known as cells. Referred to as a letter and a number.

Columns = Cells down a spreadsheet are columns - letters. 

Rows = Cells across the spreadsheet are rows - numbers.

Hide  &  Unhide ➪ Hide Columns from the drop-down menu (or you can just press Alt+HOUC)

Name that ranges in Microsoft excel

 

Name that range!

1. Select all the cells in the range that you intend to name. You can use any of the cell selection techniques that you prefer. When selecting the cells for the named range, be sure to include all the cells that you want selected each time you select its range name.

 2. Click the Name box on the Formula bar. Excel automatically highlights the address of the active cell in the selected range.

3. Type the range name in the Name box and then press Enter. As soon as you start typing, Excel replaces the address of the active cell with the range name that you’re assigning. As soon as you press the Enter key, the name appears in the Name box instead of the cell address of the active cell in the range.

Selecting cells with Go to in Microsoft excel

 

Selecting cells with Go To

1. Select the first cell of the range. This becomes the active cell to which the cell range is anchored.

 2. On the Ribbon, click the Find & Select command button in the Editing group on the Home tab and then choose Go To from its drop-down menu or press Ctrl+G or F5. The Go To dialog box opens. Book II Chapter 2 Worksheets Formatting 3. Type the cell address of the last cell in the range in the Reference text box. If this address is already listed in the Go To list box, you can enter this address in the text box by clicking it in the list box.

4. Hold down the Shift key as you click OK or press Enter to close the Go To dialog box. By holding down Shift as you click OK or press Enter, you select the range between the active cell and the cell whose address you specified in the Reference text box.

Formatting Worksheets in Microsoft excel

 

 Formatting Worksheets

✓ Selecting cell ranges and adjusting column widths and row heights

 ✓ Formatting cell ranges as tables

✓ Assigning number formats

✓ Making alignment, font, border, and pattern changes

✓ Using the Format Painter to quickly copy formatting

 ✓ Formatting cell ranges with Cell Styles

✓ Applying conditional formatting

 

Keys usage in Microsoft excel

 

Keys

Enter                =         Moves the cell pointer down one cell in the selection (moves one cell to the right when the selection consists of a single row)

Shift+Enter        =     Moves the cell pointer up one cell in the selection (moves one cell to the left when the selection consists of a single row)

Tab         =       Moves the cell pointer one cell to the right in the selection (moves one cell down when the selection consists of a single column)

 Shift+Tab         =        Moves the cell pointer one cell to the left in the selection (moves one cell up when the selection consists of a single column)

Ctrl+period (.)        =        Moves the cell pointer from corner to corner of the cell selection.

Saving the Data

 One of the most important tasks you ever perform when building your spreadsheet is saving your work! Excel offers three different ways to invoke the Save command:

✦ Select the Save button on the Quick Access toolbar (the one with the disk icon).

✦ Press Ctrl+S or F12.

Planning your workbook in Excel

 

Planning your workbook

✦ Does the layout of the spreadsheet require the use of data tables

✦ Do these data tables and lists need to be laid out on a single worksheet or can they be placed in the same relative position on multiple worksheets of the workbook (like pages of a book)?

✦ Do the data tables in the spreadsheet use the same type of formulas?

✦ Do some of the columns in the data lists in the spreadsheet get their input from formula calculation or do they get their input from other lists (called lookup tables) in the workbook?

 ✦ Will any of the data in the spreadsheet be graphed, and will these charts appear in the same worksheet (referred to as embedded charts), or will they appear on separate worksheets in the workbook (called chart sheets)?

✦ Does any of the data in the spreadsheet come from worksheets in separate workbook files?

 ✦ How often will the data in the spreadsheet be updated or added to?

 ✦ How much data will the spreadsheet ultimately hold?

✦ Will the data in the spreadsheet be shared primarily in printed or online form?

 

 

 

 

 

Finalizing your workbook design

 

✦ Enter the title of the data table in the first cell, which forms the left and top edges of the table.

 ✦ Enter the row of column headings in the row below this cell, starting in the same column as the cell with the title of the table.

 ✦ Enter the row headings down the first column of the table, starting in the first row that will contain data. (Doing this leaves a blank cell where the column of row headings intersects the row of column headings.)

✦ Construct the first formula that sums columns of (still empty) cell entries in the last row of the table, and then copy that formula across all the rest of the table columns.

✦ Construct the first formula that sums the rows of (still empty) cell entries in the last column of the table, and then copy that formula down the rest of the table rows.

✦ Format the cells to hold the table values and then enter them in their cells, or enter the values to be calculated and then format their cells. (This is really your choice.)

Shortcut keys useful in Microsoft excel

 

For formula tab

(File➪ Options➪ Formulas or Alt+FTF)

are divided into Calculation Options, Working with Formulas, Error Checking, and Error Checking Rules.

open a file

Press Ctrl+O to open a file for editing and the Save As screen.

save a new workbook.    

 When you press Ctrl+S or select the Save button on the Quick Access toolbar to save a new workbook.

Calculate Now (F9).

Calculate Sheet (Shift+F9).

Close the excel file

Close it right away by pressing Ctrl+W, 

choosing File➪ Close, or pressing Alt+FC

Save the file

Click the Save button on the Quick Access toolbar (the one with the disk icon), or choose

 File➪ Save  

from the File menu button, or press Ctrl+S

Pinning Excel to the Windows 7

 Pinning Excel to the Windows 7 Start menu If you use Excel all the time, you may want to make its program option a permanent part of the Windows 7 Start menu. 

To do this, pin the program option to the Start menu: 

1. Start Excel from the Windows Start menu. 

To launch Excel, use the appropriate method for your version of Windows, as I outline earlier in this chapter. After launching Excel, Windows adds Microsoft Office 2010 to the recently used portion on the left side of the Windows Start menu. 

2. Click the Start menu and then right-click Microsoft Office Excel 2013 to open its shortcut menu. 

3. Choose Pin to Start Menu from the shortcut menu. After pinning Excel in this manner, the Microsoft Office Excel 2013 option always appears in the upper section of the left column of the Start menu. You can now launch Excel simply by clicking the Start button and then clicking this option.

Tips to remember in Microsoft excel

 1.#REMEMBER#

Don’t forget the Ctrl+Page Down and Ctrl+Page Up shortcut keys for selecting the next and previous sheets, respectively, in your workbook. 

You can also click the Next Sheet and Previous Sheet button marked by the ellipsis (…). 

The Next Sheet button is the one with the ellipsis on the right side of the sheet tabs immediately left of the New Sheet button.

The Previous Sheet button is the one with ellipsis on the left side of the sheet tabs to the immediate left of the first visible sheet tab. If your workbook contains too many sheets for all their tabs to be displayed at the bottom of the Worksheet area, use the Sheet tab scroll buttons to bring new tabs into view (so that you can then click them to activate them). 

You click the Next Scroll button (the one with the triangle pointing right) to scroll the next hidden sheet tab into view on the right and the Previous Scroll button (the one with the triangle pointing left) to scroll the next hidden sheet into view on the left. 

You Ctrl+click the Next Scroll button to scroll the last sheet into view and Ctrl+click the Previous Scroll button to scroll the first sheet into view.

 2.#REMEMBER#

When quitting of Microsoft excel.

 Press Alt+FX or Alt+F4 on your physical or Touch keyboard. 

Select the Close button (the one with the x) in the upper-right corner of the Excel program window. 

 Click the Excel program button (the green one with the x on a partially opened book to the immediate left of the Save button on the Quick Access toolbar) followed by the Close option on its drop-down menu.

 3.#REMEMBER#

The options in the When Creating New Workbooks section of the popular tab of the Excel Options dialog box include only these four combo

1.     Use This as the Default Font.

2.     Font Size.

3.     Default View for New Sheets.

4.     Include This Many Sheets.

 4.#REMEMBER#

Don’t forget about the shortcut keys:

Ctrl+B for toggling on and off bold in the cell selection,

Ctrl+I  for toggling on and off italics, and

Ctrl+U for toggling on and off underlining for quickly adding or removing these attributes from the entries in the cell selection.

 

 

 

 

Microsoft Excel 2013 tips and information

 

✦ File tab   contains

Info, New, Open, Save, Save As, Print, Share, Export, Close, and Account, as well as Options, which enables you to change Excel’s default settings.

✦ Quick Access toolbar: You can click the Save, Undo, and Redo buttons to perform common tasks to save your work and undo and redo editing changes. You can also click the Customize Quick Access Toolbar button to the immediate right of the Redo button to open a drop-down menu containing additional common commands such New, Open, Quick Print, and so on, as well as to customize the toolbar, change its position, and minimize the Ribbon.

✦ Ribbon: Most Excel commands are contained on the Ribbon. They are arranged into a series of tabs ranging from Home through View.

✦ Formula bar: This displays the address of the current cell along with the contents of that cell.

✦ Worksheet area: This area contains all the cells of the current worksheet identified by column headings, which use letters along the top, and row headings, which use numbers along the left edge, with tabs for selecting new worksheets. You use a horizontal scroll bar on the bottom to move left and right through the sheet and a vertical scroll bar on the right edge to move up and down through the sheet.

✦ Status bar: This bar keeps you informed of the program’s current mode and any special keys you engage, and it enables you to select a new worksheet view and to zoom in and out on the worksheet.

 

 

Ripping through the Ribbon

 

✦ Tabs: Excel’s main tasks are brought together and display all the commands commonly needed to perform that core task.

✦ Groups: Related command buttons can be organized into subtasks normally performed as part of the tab’s larger core task.

 ✦ Command buttons: Within each group you find command buttons that you can select to perform a particular action or to open a gallery. Note that many command buttons on certain tabs of the Excel Ribbon are organized into mini toolbars with related settings.

✦ Dialog Box launcher: This button is located in the lower-right corner of certain groups and opens a dialog box containing a bunch of additional options you can select

You can minimize the Ribbon by doing any of the following:

 

✦ Click the Collapse the Ribbon button (the button with the caret symbol in the lower-right corner of the Excel Ribbon).

✦ Double-click a Ribbon tab.

 ✦ Press Ctrl+F1.

✦ Click the Shows Tabs item on the Ribbon Display Options button’s dropdown menu

 

Keeping tabs on the Excel Ribbon

The very first time you launch Excel 2013 and open a new workbook, the Ribbon contains the following seven tabs, proceeding from left to right:

✦ Home: Use this tab when creating, formatting, and editing a spread1] sheet. This tab is arranged into the Clipboard, Font, Alignment, Number, Styles, Cells, and Editing groups.

 ✦ Insert: Use this tab when adding particular elements (including graph [1]ics, pivot tables, charts, hyperlinks, and headers and footers) to a spreadsheet. This tab is arranged into the Tables, Illustrations, Apps, Charts, Reports, Sparklines, Filter, Links, Text, and Symbol groups.

✦ Page Layout: Use this tab when preparing a spreadsheet for printing or reordering graphics on the sheet. This tab is arranged into the Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange groups.

✦ Formulas: Use this tab when adding formulas and functions to a spread1] sheet or checking a worksheet for formula errors. This tab is arranged into the Function Library, Defined Names, Formula Auditing, and Calculation groups. Note that this tab also contains a Solutions group when you activate certain add-in programs, such as Conditional Sum and Euro Currency Tools — see Book I, Chapter 2 for more on Excel add-ins.

✦ Data: Use this tab when importing, querying, outlining, and subtotaling the data placed into a worksheet’s data list. This tab is arranged into the Get External Data, Connections, Sort & Filter, Data Tools, and Outline groups. Note that this tab also contains an Analysis group if you activate add-ins, such as the Analysis Toolpak and Solver Add-In — see Book I, Chapter 2 for more on Excel add-ins.

✦ Review: Use this tab when proofing, protecting, and marking up a spreadsheet for review by others. This tab is arranged into the Proofing, Language, Comments, and Changes groups. Note that this tab also contains an Ink group with a sole Start Inking button if you’re running Excel on a Windows tablet or smartphone or on a laptop or desktop computer that’s equipped with some sort of electronic input tablet.

 

✦ View: Use this tab when changing the display of the Worksheet area and the data it contains. This tab is arranged into the Workbook Views, Show, Zoom, Window, and Macros groups.

 

Adding the Developer tab to the Ribbon If you do a lot of work with macros (see Book VIII, Chapter 1) and XML files in Excel, you should add the Developer tab to the Ribbon. This tab contains all the command buttons normally needed to create, play, and edit macros as well as to import and map XML files. To add the Developer tab to the Excel Ribbon, follow these steps:

1. Click the File menu button followed by the Options item in the backstage view (Alt+FT). The Excel Options dialog box opens in the worksheet view.

2. Select the Customize Ribbon option in the Excel Options dialog box and then click the Developer check box under Main Tabs in the Customize the Ribbon list box on the right. Click OK to finish.

 

The easiest method for selecting commands on the Ribbon — if you know your keyboard at all well — is to press the keyboard’s Alt key and then type the letter of the hot key that appears on the tab you want to select.

Press

Ctrl+C to copy the selection

 Press

 Ctrl+V when you’re ready to paste it.

 

 

 

Adjusting to the Quick Access toolbar

 When you first begin using Excel 2013, the Quick Access toolbar contains only the following three or four buttons:

 ✦ Save: Saves any changes made to the current workbook using the same filename, file format, and location.

✦ Undo: Undo es the last editing, formatting, or layout change you made.

✦ Redo: Reapplies the previous editing, formatting, or layout change that you just removed with the Undo button.

✦ Touch/Mouse Mode (automatically added only to Excel running on touchscreen tablets and computers): Switches between the default mouse mode and touch mode, which puts more space between tabs and their command buttons to facilitate selection with a finger or stylus.

 

Inserting a text box using Microsoft word

 Inserting a text box 

✦ To create a text box, 

Go to the Insert tab,

 click the Text Box button, and use one of these techniques: 

✦ Choose a ready-made text box: Scroll in the drop-down list and choose a preformatted text box. 

✦ Draw a conventional text box: Choose Draw Text Box on the drop-down list, and then click and drag to draw the text box. Lines show you how big it will be when you release the mouse button

Short cut keys useful in Microsoft word

 

✦ F7: Run a spell-check

✦ Alt+F7: Scroll to the next misspelling

✦ Ctrl+F7: Get a word definition

✦ Shift+F7: Open the Thesaurus

Shortcut keys useful in Microsoft Word

1. Select                    Do This

        A word                                Double-click the word.

1.  A few words                       Drag over the words.
2. A paragraph                       Triple-click inside the paragraph (in Word and PowerPoint).

• A block of text                    Click the start of the text, hold down                                                           the Shift key, and click the end of the text.                                                 In Word you can also click the start of the                                                 text, press F8, and click at the end of the                                                     text.

1.  All text Press                      CTRL+A. 

WHAT IS MICROSOFT WORD? #MICOSOFT #GOOGLE #ANIME

 

Microsoft Word.

1. Create and Edit for text documents

2. Text alignment to custom table layouts

3. The program enables users to insert and format images and shapes

4. View and edit PDF files.