How fast do you work on MS Excel? This short video will show you tricks

Please check your E-mail inbox or spam to confirm.

Excel is a spreadsheet developed by Microsoft, as generally known. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

JOIN US FOR MORE ON:
or

The software package is used to create grids of text, numbers and formulas specifying calculations which is extremely valuable for many businesses as regard recording expenditures and income, planning budgets, computing chart data and succinctly presenting fiscal results.

The video below shows few tricks and shortcuts needed to quicken your operations;

Video originally tweeted by GIDITRAFFIC (@Gidi_Traffic) on November 3, 2020.

HEY THERE: Are you looking for a WhatsApp TV where you can find great memes, funny videos, and trending gists, even with several opportunities with cash prizes? Then look no further. LOP TV is here to bring to you this top-rated content. JOIN LOP TV now

Below are some basic general shortcuts;

  • Ctrl+N: Create a new workbook
  • Ctrl+O: Open an existing workbook
  • Ctrl+S: Save a workbook
  • F12: Open the Save As dialog box
  • Ctrl+W: Close a workbook
  • Ctrl+F4: Close Excel
  • F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
  • Shift+F11: Insert a new worksheet
  • Ctrl+Z: Undo an action
  • Ctrl+Y: Redo an action
  • Ctrl+F2: Switch to Print Preview
  • F1: Open the Help pane
  • Alt+Q: Go to the “Tell me what you want to do” box
  • F7: Check spelling
  • F9: Calculate all worksheets in all open workbooks
  • Shift+F9: Calculate active worksheets
  • Alt or F10: Turn key tips on or off
  • Ctrl+F1: Show or hide the ribbon
  • Ctrl+Shift+U: Expand or collapse the formula bar
  • Ctrl+F9: Minimize the workbook window
  • F11: Create a bar chart based on selected data (on a separate sheet)
  • Alt+F1: Create an embedded bar chart based on select data (same sheet)
  • Ctrl+F: Search in a spreadsheet, or use Find and Replace
  • Alt+F: Open the File tab menu
  • Alt+H: Go to the Home tab
  • Alt+N: Open the Insert tab
  • Alt+P: Go to the Page Layout tab
  • Alt+M: Go to the Formulas tab
  • Alt+A: Go to the Data tab
  • Alt+R: Go to the Review tab
  • Alt+W: Go to the View tab
  • Alt+X: Go to the Add-ins tab
  • Alt+Y: Go to the Help tab
  • Ctrl+Tab: Switch between open workbooks
  • Shift+F3: Insert a function
  • Alt+F8: Create, run, edit, or delete a macro
  • Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Click to see full shortcuts. Kindly share for others to benefit.

VALENTINE PROMO: Push your business to the face of over 8,000 people from as little as #800.

LOP Valentine Promo


DISCLAIMER: Do not pay or release sensitive financial details to any organizer/recruiter unless futher verified from your end.
Easter Hunt Sale
Easter Sale
ACEworld Publishers

About the Author: ACEworld Publishers

At ACEworld Publishers, we publish Latest Opportunities, Jobs & Free Online Courses. Join us on Twitter .

Got a question/Suggestion? Let's talk!

LATEST OPPORTUNITIES:

🕛 Feb 08, 2023
Kaduna State Government Kashim Ibrahim Fellowship for Young Nigerians 2023 (Fully-funded)
in Fellowships | for Graduates

🕛 Feb 09, 2023
Apply: Concordia University 2023 Undergraduate Scholarships
in Scholarships | for Undergraduates

🕛 Feb 10, 2023
Daily Trust Foundation 2023 Undergraduate Scholarship Scheme For Nigerian Students
in Scholarships | for Nigerians

🕛 Feb 10, 2023
Green Spaces in the City: Flash Fiction and Poetry Competition 2023
in General Competitions | for Writers & Poets

🕛 Feb 10, 2023
LEAP Africa 2023 Youth Leadership Programme for Nigerian Students
in Trainings and Workshops | for Nigerians

🕛 Feb 10, 2023
PivotAfrica Fellowshp Program for Young Africans 2023(Cohort 5)
in Fellowships | for Africans

🕛 Feb 10, 2023
Spanish Government 2023 MAEC-AECID Scholarship for Developing Countries
in Masters Programs | for Post Graduates

🕛 Feb 10, 2023
SSRC-APN Individual Research Fellowships for African Countries 2023
in Fellowships | for Africans

🕛 Feb 12, 2023
BBC 2023 International Radio Playwriting Competition
in General Competitions | for Writers & Poets

🕛 Feb 12, 2023
Study in USA: Boise State University 2023 Undergraduate Global Excellence Scholarship
in Scholarships | for Undergraduates

1 2 3 4 5 6 7 8 9 10 11 12