Basic shortcuts Of Microsoft Excel for working professional

Get all the essential microsoft excel shortcut in one place.

1. Mastering Excel: 20 Essential Shortcuts
Unlock Your Productivity with Excel

2. Table of
Contents
01The Power of Excel Shortcuts
02Shortcut #1: Select All (Ctrl + A)
03Shortcut #2: Open Format Cells (Ctrl + 1)
04Shortcut #3: Fill Down (Ctrl + D)
05Shortcut #4: Open AutoSum (Alt + = )
06Shortcut #5: Create Chart (Alt + F1)
07Shortcut #6: Move between Worksheets (Ctrl + Page Up/Page Down)
08Shortcut #7: Insert Hyperlink (Ctrl + K)
09Shortcut #8: Go to Specific Cell (Ctrl + G)
10Shortcut #9: Repeat Last Action (Ctrl + Y)
11Thank You for Joining Us!

3. 1
The Power of Excel Shortcuts
•
In this tech-driven world, efficiency is key. Excel shortcuts can be a game changer for data
management.
•
Using shortcuts not only speeds up your workflows but also reduces the strain of repetitive tasks.
•
Imagine completing your work in half the time—it’s all possible with Excel’s powerful shortcuts!
•
These tricks can free you up for more strategic thinking and decision-making.
•
Let’s dive into the top 20 shortcuts that will transform your Excel experience.

4. 2
Shortcut #1: Select All (Ctrl + A)
•
Quickly select your entire worksheet using Ctrl + A.
•
This simple command enhances data manipulation and analysis, saving you valuable seconds.
•
An essential starting point for any Excel user looking to streamline their workflow.
•
Perfect for those who handle large datasets regularly.
•
Next, let’s discover another time-saving shortcut.

5. 3
Shortcut #2: Open Format Cells (Ctrl + 1)
•
Access the Format Cells dialog box instantly with Ctrl + 1.
•
This allows you to adjust number formats, fonts, borders, and more with ease.
•
Custom formatting helps in making your data visually appealing and easier to read.
•
A vital shortcut for anyone presenting data professionally.
•
Onwards to the third crucial shortcut!

6. 4
Shortcut #3: Fill Down (Ctrl + D)
•
Quickly copy data from the cell above with Ctrl + D.
•
This feature is perfect for filling formulas or repeated values without hassle.
•
It reduces the risk of errors from manual input.
•
An absolute must-know for repetitive data entry tasks.
•
Let’s keep the momentum going!

7. 5
Shortcut #4: Open AutoSum (Alt + = )
•
Speed up your calculations with AutoSum by pressing Alt + = .
•
Automatically add up numbers in a row or column—time-saving magic!
•
Ideal for budget tracking and financial reports.
•
Make your data analysis efficient and effortless.
•
What’s the next shortcut on our list?

8. 6
Shortcut #5: Create Chart (Alt + F1)
•
Generate a quick chart from your data using Alt + F1.
•
Visual representation of data is crucial for insights and presentations.
•
This shortcut makes data visualization fast and accessible.
•
Great for quick reports and side discussions.
•
Let’s move to the sixth time-saving hack!

9. 7
Page Up/Page Down)
Shortcut #6: Move between Worksheets (Ctrl +
•
Navigate between your Excel worksheets seamlessly with Ctrl + Page Up/Page Down.
•
Quick switching enhances multi-sheet management efficiency.
•
Perfect for those handling extensive data across multiple sheets.
•
Stay organized and focused as you research or analyze.
•
What’s the seventh shortcut?

10. 8
Shortcut #7: Insert Hyperlink (Ctrl + K)
•
Easily insert hyperlinks into your spreadsheets with Ctrl + K.
•
Linking to resources can enhance your data’s usability and accessibility.
•
Keeps important information at your fingertips.
•
A must for collaborative projects and reports.
•
Let’s explore the eighth one!

11. 9
Shortcut #8: Go to Specific Cell (Ctrl + G)
•
Quickly move to a specific cell using Ctrl + G, or F5.
•
An invaluable tool when working with extensive spreadsheets.
•
No more endless scrolling—get where you need to be in an instant.
•
Boost your efficiency and responsiveness while working in Excel.
•
Almost there, let’s check the ninth shortcut!

12. 10
Shortcut #9: Repeat Last Action (Ctrl + Y)
•
Avoid redundancy by repeating your last action with Ctrl + Y.
•
This allows for faster editing and formatting tasks.
•
Perfect for users who frequently modify similar data.
•
Improves workflows by minimizing repetitive steps.
•
Now, let’s wrap up with our last slide!

13. 11
Thank You for Joining Us!
•
We hope these 20 Excel shortcuts will empower you to work smarter, not harder.
•
Time is your most valuable asset—use it wisely and efficiently.
•
For more tips on productivity and business tools, stay connected with us.
•
A special thanks to HubSpot for sponsoring this presentation.
•
Let’s conquer Excel and embrace a more productive workflow!