Excel is a paid Microsoft software while the equivalent which is available for free is Google Sheets.
Learn to use Excel or Sheets to organize data and create charts, tables, etc. for presentation or analyzing patterns and trends. This can help you, your organization or company see the big picture, make informed decisions, and solve problems efficiently.
In a world where job competition is high, mastering Microsoft Excel will excel your career and position you as a valuable employee. It doesn't matter if you are a student or what your careered is. You can even use it for your personal finance.
Memorizing and practicing these shortcuts will dramatically save you time and money, while increasing efficiency and productivity.
Numbers
CTRL + 1 Format Cells
CTRL + 2 Bold font
CTRL + 3 Italic font
CTRL + 4 Underline
CTRL + 5 Strikethrough
CTRL + 6 Show/Hide an Object
CTRL + 7 Show/Hide the Toolbar
CTRL + 8 Toggle Outline Symbols
CTRL + 9 Hide Rows
CTRL + 0 Hide Columns
Letters
CTRL + A Select All
CTRL + B Toggle BOLD (font)
CTRL + C Copy
CTRL + D Fill Down
CTRL + E Flash Fill
CTRL + F Find
CTRL + G Go To
CTRL + H Find and Replace
CTRL + I Toggle Italic (font)
CTRL + J Input line break (in Find and Replace)
CTRL + K Insert Hyperlink
CTRL + L Insert Excel Table
CTRL + M Not Assigned
CTRL + N New Workbook
CTRL + O Open
CTRL + P Print
CTRL + Q Quick Analysis
CTRL + R Fill Right
CTRL + S Save
CTRL + T Insert Excel Table
CTRL + U Toggle underline (font)
CTRL + V Paste (when something is cut/copied)
CTRL + W Close the current workbook
CTRL + X Cut
CTRL + Y Redo (Repeat last action)
CTRL + Z Undo
Keys
CTRL +’ Copy a Formula from the Cell Above
CTRL +” Copy a Value from the Cell Above
CTRL + < Copy a Formula from the Cell Above
CTRL + > Copy a Formula from Cell to Left
CTRL + Tab Next Workbook
CTRL + Backspace Jump to the Active Cell
CTRL + Spacebar Select an Entire Column
CTRL + Insert Copy
CTRL + Home Go to Beginning of Worksheet
CTRL + Page Up Go to Previous Worksheet
CTRL + Page Down Go to Next Worksheet
CTRL + Delete Delete
CTRL + End Go to the Intersection of the Last used Row and Column
Symbols
CTRL + ` Toggle Formula
CTRL + ~ General Format
CTRL + ! Number Format
CTRL + @ Time Format
CTRL + # Date Format
CTRL + $ Currency Format
CTRL + % Percent Format
CTRL + ^ Exponential Format
CTRL + & Outside Borders
CTRL + * Select Current Region
CTRL + ( Unhide Rows
CTRL + ) Unhide Columns
CTRL + - Delete
CTRL + _ Remove Border
CTRL + + Insert
CTRL + = Insert
CTRL +; Insert Current Date
CTRL +: Insert Current Time
Functions
CTRL + F1 Collapse the Ribbon
CTRL + F2 Print Preview
CTRL + F3 Name Manager
CTRL + F4 Close
CTRL + F5 Restore Window Size
CTRL + F6 Next Workbook
CTRL + F7 Move Window
CTRL + F8 Resize Window
CTRL + F9 Minimize Workbook
CTRL + F10 Maximize Workbook
CTRL + F11 Insert a Macro Sheet
CTRL + F12 Open a File
Extras
CTRL + Tab = Next Workbook
CTRL + Shift + Tab = Previous Workbook
CTRL + Backspace = Jump Back to Active Cell
CTRL + Spacebar = Select Entire Column
CTRL + Shift + Spacebar = Select All
CTRL + Insert = Copy
CTRL + Home = Beginning of Worksheet
CTRL + Page Up = Previous Worksheet
CTRL + Page Down = Next Worksheet
CTRL + Delete = Delete
CTRL + End = Intersection of Last used Row and Column
CTRL + Shift + L = Toggle filters on/off.
CTRL + Shift + $ = Apply current formatting
CTRL+ Enter = Fill Selected Range with Current Entry
Alt + Enter: Start a new line within a cell.