TLDR;
This YouTube video by Rojgar with Ankit Defence provides a comprehensive review of essential computer shortcut keys. The session covers shortcuts for MS Word, MS Excel, PowerPoint, web browsers, and Windows Explorer. The presenter explains the functions of each shortcut, offers tips for memorization, and clarifies common points of confusion.
- Covers shortcut keys for MS Word, MS Excel, PowerPoint, web browsers, and Windows Explorer.
- Explains the functions of each shortcut and provides tips for memorization.
- Clarifies common points of confusion and encourages viewers to note down new information.
Introduction [0:05]
The session begins with a warm greeting and an introduction to the topic of shortcut keys. The presenter emphasizes that the class will cover a range of shortcut keys, including some that viewers may not already know. The goal is to expand the viewers' knowledge and improve their efficiency in using various computer applications.
MS Word Shortcuts [1:34]
The presenter discusses several MS Word shortcuts, starting with the shortcut to remove formatting from selected text and revert it to the default format, which is Control + Space Bar. He also clarifies that Control + Q removes paragraph formatting, distinguishing it from the Control + Space Bar, which removes font formatting. The video also covers Alt + Shift + P to directly open the header and footer section in a Word document, Control + K for inserting hyperlinks, and Control + H to open the Replace dialog box. Additionally, Alt + Control + O is identified as the shortcut for opening a document in outline view mode, and F7 is used to directly open the Spelling and Grammar Check dialog box, while Shift + F7 opens the thesaurus.
MS Excel Shortcuts [14:02]
The presenter transitions to MS Excel shortcuts, beginning with the method to hide and show the formula bar, which is Control + Shift + U. He contrasts this with the shortcut to hide or unhide the ribbon, which is Control + F1. The video explains that Control + ; (semi-colon) inserts the current date, while Control + Shift + ; inserts the current time. The presenter also notes that pressing F4 makes a cell reference absolute by adding dollar signs before both the column and row. To quickly insert the current worksheet, the shortcut is Alt + Shift + F1 or Shift + F1, and to open the Name Manager dialog box, the shortcut is Ctrl + F3. The video also covers F9 to evaluate a formula, Alt + = for the auto sum function, Control + 1 to open the Cell Format dialog box, Control + 2 for bold, Control + 3 for italics, Control + 4 for underline, Control + 5 for strike through, and Shift + F3 to insert a function. Finally, Control + D implements the fill down command, while Control + R fills to the right.
MS PowerPoint Shortcuts [24:04]
Moving on to PowerPoint, the presenter explains that Control + M inserts a new slide, while Control + N creates a new presentation. Control + Shift + N duplicates a presentation. The video also notes that F5 starts the slide show from the beginning, while Shift + F5 starts it from the current slide. Alt + Shift + R starts rear timing, Alt + Control + 3 opens slide shortcut view, B brings up a black screen in presentation mode, and W brings up a white screen. Alt + Control + N opens the Notes page view, and Alt opens the transition pane. The presenter also shares that Alt + A opens the animation tab, Alt + C opens the Record tab, and Alt + S opens the Slide Show tab. Control + D creates a duplicate slide, and Alt + Shift + S opens Slide Master view.
Web Browser Shortcuts [31:37]
The presenter then discusses web browser shortcuts, starting with Control + Shift + N to open incognito mode. He notes that Control + L or Control + D quickly selects the address bar. F5 or Control + R refreshes the page, and Control + T opens a new tab, while Control + N opens a new window. Control + Shift + T restores recently closed tabs. Control + Shift + O opens the bookmark manager, and Control + J opens the downloads page. Control + H opens the history list, Control + U views the page source code, and Control + Shift + I opens developer tools. Control + Plus zooms in, Control + Minus zooms out, and Control + 0 resets the zoom to default. Control + Page Down or Control + Tab goes to the next tab, while Control + Page Up or Control + Shift + Tab goes to the previous tab.
Windows Explorer Shortcuts [37:47]
The final section covers Windows Explorer shortcuts, beginning with F2 to rename a file and F5 to refresh. Control + E, F3, or Control + F moves the cursor to the search box. Alt + Enter opens the File Properties dialog box, and Shift + Delete bypasses the Recycle Bin when deleting a file. Control + Shift + N creates a new folder, Control + X cuts a file or folder, and Control + V pastes. Window + E opens File Explorer. The presenter also notes that Window + L locks the PC, Window + R opens the Run command dialog box, Window + Shift + S takes a screenshot, and Alt + Control + Delete opens the task manager. Control + D deletes a file or folder to the recycling bin, F6 focuses the navigation pane, and Alt + P enables or disables the preview pane.
Conclusion [46:28]
In conclusion, the presenter encourages viewers to note down any new or incorrect information for future reference. He expresses hope that the class was enjoyable and informative, and he announces that the next session will be on Monday with a new practice set.