Skip to main content

Motivational Quotes


Comments

Followers

Popular posts from this blog

Most useful shortcut keys in PowerPoint

                                         Shortcut Keys                       Most useful shortcut keys in PowerPoint F5 Runs the presentation  (View > Slide Show) Shift + F3 Toggles between lowercase, mixed case and uppercase on the selection Shift + F9 Toggles the display of Guide Lines Shift + Enter Enters a line break (Soft break) Ctrl + A Selects all the objects on the active slide Ctrl + T Displays the  (Format > Font)  dialog box Ctrl + Shift + Tab Toggle between the Slides and Outlines tabs (Normal view) Ctrl + Shift + G Group the currently selected objects / shapes Ctrl + Shift + H Ungroups the currently selected object / shape Alt + Shift + F4 Closes all the presentations (saving fi...

The Basics of Microsoft Excel

Table of Contents 1 Introduction 1 1.1 Spreadsheet Basics ..........................................................................................................   1 1.2 Screen Elements ..............................................................................................................   2 1.3 Data Selection ..................................................................................................................   2 1.4 Spreadsheet Navigation ....................................................................................................   3 2 Data Entry and Revision 4 2.1 Cut, Copy, and Paste ........................................................................................................ 5...

Excel Keyboard Shortcuts

Keyboard Shortcuts 1. ALT+= Inserts a SUM formula. 2. CTRL+TAB switches between open Excel windows. 3. CTRL+A – this has various scenarios: a. If you are in regular data range and press CTRL+A all the data is selected. b. If you press CTRL+A a second time in the same range selects the entire spreadsheet. c. If you are in a table then pressing the CTRL+A key selects the data excluding the total row AND titles. d. If you press the CTRL+A key a second time it selects the data, titles, and total row e. It does not make any difference whether the spreadsheet contains data or not, if you are outside the data area, in a blank area with no directly adjacent cells containing data, CTRL+A selects the entire sheet. f. If you have one or more objects e.g. Charts, selected then pressing CTRL+A selects them all. 4. CTRL+1 Displays the Format Cells dialog box. 5. CTRL+SHIFT+" Copies the value from the cell above the active cell into the cell or the Formula Bar. 6. F4 Repeats an action, or if...