if given the chance to reprogram excel, what modifications will you recommend for its future versions to improve its functionality
Share
if given the chance to reprogram excel, what modifications will you recommend for its future versions to improve its functionality
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Master the Shortcuts
Master the ShortcutsYou can save precious time by learning some keyboard shortcuts. Even though most computer and Internet users today cannot imagine navigating online without a mouse or at least a touchpad, you can save a great deal of time by using only the keyboard. You are probably already familiar with using the functions of Ctrl+C and Ctrl+V to copy and paste. Other useful shortcuts that can come in handy include Ctrl+Z, to undo the last action, Ctrl+PgUp to switch between worksheet tabs, Ctrl+A for selecting the entire worksheet, Ctrl+F to find items and Ctrl+K to insert hyperlinks. Here is a complete list of Excel keyboard shortcuts from Microsoft itself.
Import Data from a Website
Import Data from a WebsiteLearning how to import data is an essential function that can greatly speed up your workflow. If you come across a website with tons of data that you find useful for one of your projects, you can convert it into a worksheet by clicking File > Import External Data and click New Web Query. When you click this tab, a new window opens that displays your browser homepage with the URL of the page highlighted. Choose the webpage you want to display, then copy and paste the link into the Address box. Click OK and voilà! Your data is imported into an Excel worksheet!
Import Data from a WebsiteLearning how to import data is an essential function that can greatly speed up your workflow. If you come across a website with tons of data that you find useful for one of your projects, you can convert it into a worksheet by clicking File > Import External Data and click New Web Query. When you click this tab, a new window opens that displays your browser homepage with the URL of the page highlighted. Choose the webpage you want to display, then copy and paste the link into the Address box. Click OK and voilà! Your data is imported into an Excel worksheet!Filter Your Results
If you have a large spreadsheet with a lot of information on it, using the Auto filtering feature is the smartest thing you can do. To do that, click Data > Filter > Autofilter. You can then click one of the small boxes and filter the results according to your own needs.
Calculate the Sum
Calculate the SumUsing shortcuts to calculate the sum of an entire column or range of cells can save you a great deal of time, especially if you use Excel regularly. Instead of manually entering the formula, simply use the shortcut Alt + = after you have selected the first empty cell in the column (the one located at the end of the numbers). After you execute this command, press Tab, and Excel shows you the result.
AutoCorrect and AutoFill
AutoCorrect and AutoFillYou need to learn how to type less if you want to save even more time when working in Excel. There are two ways to do this: AutoFill and AutoCorrect. AutoCorrect automatically corrects misspelled words and typos. To enable AutoCorrect, click the Tools tab and select AutoCorrect.
Display Formulas
Display FormulasWith just a single keystroke, you can toggle between Excel’s standard normal display and the display mode, which shows you how the formulas appear in the system. The formula is Ctrl + ~. Press this combination once when you are in a spreadsheet and Excel will display formulas instead of the results of these formulas.
Manage Page LayoutYou’ll want to be sure your printouts look as good as the display on screen, so you’ll need to know how to manage page layout. You’ll find these options by clicking the Page Layout tab. Consider playing around with options like page numbering, columns, and page borders to see how they work, then branch out.