8.99K subscribers
86 photos
2 videos
24 files
140 links
SIMPLYEASYLEARNING 👩‍🎓
Download Telegram
Useful Excel Shortcuts:

● Ctrl + A: Select all contents of the page.
● Ctrl + B: Bold highlighted selection.
● Ctrl + C: Copy selected text.
● Ctrl + X: Cut selected text.
● Ctrl + P: Open the print window.
● Ctrl + F: Open find box.
●Ctrl + I: Italic highlighted selection.
● Ctrl + K: Insert link (Shortcut Keys and their Functions).
● Ctrl + U: Underline highlighted selection.
● Ctrl + V: Paste.
● Ctrl + Y: Redo the last action performed.
● Ctrl + Z: Undo last action.
● Ctrl + L: Aligns the line or selected text to the left of the screen.
● Ctrl + E: Aligns the line or selected text to the center of the screen.
● Ctrl + R: Aligns the line or selected text to the right of the screen.
● Ctrl + M: Indent the paragraph.
● Ctrl + Shift + F: Change the font.
● Ctrl + Shift + >: Increase selected font +1pts up to 12pt and then increases font +2pts.
● Ctrl + ]: Increase selected font +1pts.
● Ctrl + Shift + <: Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
● Ctrl + [: Decrease selected font -1pts.
● Ctrl + Shift + *: View or hide non printing characters.
● Ctrl + L: Moves one word to the left.
● Ctrl + R: Moves one word to the right.
● Ctrl + : Moves to the beginning of the line or paragraph.
● Ctrl + : Moves to the end of the paragraph.
● Ctrl + Del: Deletes word to right of cursor.
● Ctrl + Backspace: Deletes word to left of cursor.
● Ctrl + End: Moves the cursor to the end of the
document.
● Ctrl + Home: Moves the cursor to the beginning of the document.
● Ctrl + Spacebar: Reset highlighted text to the default font.
● Ctrl + 1: Single-space lines.
● Ctrl + 2: Double-space lines.
● Ctrl + 5: 1.5-line spacing.
● Ctrl + Alt + 1: Changes text to heading 1.
● Ctrl + Alt + 2: Changes text to heading 2.
● Ctrl + Alt + 3: Changes text to heading 3.
● Alt + Shift + D: Insert the current date.
● Alt + Shift + T: Insert the current time.

◉ Alt + F: File menu options in current program.
◉ Alt + E: Edit options in current program.
◉ F1: Universal Help in almost every Windows program.
◉ Ctrl + A: Select all text.
◉ Ctrl + X: Cut
◉ Shift + Del: Cut selected item.
◉ Ctrl + C: Copy selected item.
◉ Ctrl + Ins: Copy selected item.
◉ Ctrl + V: Paste selected item.
◉ Shift + Ins: Paste.
◉ Home: Goes to beginning of current line.
◉ Ctrl + Home: Goes to beginning of document.
◉ End: Goes to end of current line.
◉ Ctrl + End: Goes to end of document.
◉ Shift + Home: Highlights from current position to beginning of line.
◉ Shift + End: Highlights from current position to end of line.
◉ Ctrl + Left arrow: Moves one word to the left at a time.
◉ Ctrl + Right arrow: Moves one word to the right at a time.
🆒14👍128
IMG_4530.JPG
517.1 KB
SQL interview cheatsheet
2
👍2
1
2
1
Free Certification Courses to Learn Data Science in 2025:

1. Python
🔗 imp.i384100.net/5gmXXo

2. SQL
🔗 edx.org/learn/relation

3. Statistics and R
🔗 edx.org/learn/r-progra

4. Data Science: R Basics
🔗edx.org/learn/r-progra

5. Excel and PowerBI
🔗 learn.microsoft.com/en-gb/training

6. Data Science: Visualization
🔗edx.org/learn/data-vis

7. Data Science: Machine Learning
🔗edx.org/learn/machine-

8. R
🔗imp.i384100.net/rQqomy

9. Tableau
🔗imp.i384100.net/MmW9b3

10. PowerBI
🔗 lnkd.in/dpmnthEA

11. Data Science: Productivity Tools
🔗 lnkd.in/dGhPYg6N

12. Data Science: Probability
🔗mygreatlearning.com/academy/learn-

13. Mathematics
🔗matlabacademy.mathworks.com

14. Statistics
🔗 lnkd.in/df6qksMB

15. Data Visualization
🔗imp.i384100.net/k0X6vx

16. Machine Learning
🔗 imp.i384100.net/nLbkN9

17. Deep Learning
🔗 imp.i384100.net/R5aPOR

18. Data Science: Linear Regression
🔗pll.harvard.edu/course/data-sc

19. Data Science: Wrangling
🔗edx.org/learn/data-sci

20. Linear Algebra
🔗 pll.harvard.edu/course/data-an

21. Probability
🔗 pll.harvard.edu/course/data-sc

22. Introduction to Linear Models and Matrix Algebra
🔗edx.org/learn/linear-a

23. Data Science: Capstone
🔗 edx.org/learn/data-sci

24. Data Analysis
🔗 pll.harvard.edu/course/data-an

25. IBM Data Science Professional Certificate
imp.i384100.net/9gxbbY

26. Neural Networks and Deep Learning
imp.i384100.net/DKrLn2

27. Supervised Machine Learning: Regression and Classification
imp.i384100.net/g1KJEA