Monday, January 29th, 2018 / by Excel Champ
Every day, millions of files around the world are created, opened, and edited in Microsoft Excel. As an original member of the Microsoft Office Suite, the cross-platform spreadsheet software has evolved over the decades to meet the demands of engineers, database programmers, accountants, administrators, educators, publishers, and other professionals. Because it’s natural for regular users to establish consistent work patterns, it’s possible that some of the software’s features, new and old, aren’t being used to their potential. A quick refresher might be in order to stay up-to-date with the program. Here are five Microsoft Excel training tips that could increase speed and efficiency.
Use the fill handle to quickly populate the spreadsheet with sequential values (like Monday, Tuesday, Wednesday or 4,5,6). This newer feature, called Flash Fill, can guess the type of data the user is planning to enter. For example, if an existing column lists email addresses that are stored in the user’s Outlook contacts, a new column of “first names” can guess the names using the email addresses already inside the sheet. Similar to auto fill, the flash fill fields will appear in gray until the user approves them with the enter key.
Some users aren’t aware there are three ways to tabulate numbers:
Working inside a spreadsheet often requires the selection of multiple cells, but some users have trouble learning how to do this without accidentally deleting data. Here’s how it works: Use the Ctrl key and Shift key to select more than one cell at a time. Holding down the Ctrl key allows selection of multiple individual cells. Holding down the Shift key allows selection of a continuous range of cells, but it’s a little tricky. First select the top of the range to be selected. Then hold the Shift key and, with the Shift key held down, select the bottom of the range to be selected.
Some users find it frustrating when data exceeds column width and the field entry is partially hidden, but there is an easy way around this problem. When the data typed into the fields exceeds the width of the column, hover the mouse at the divider line between columns. When the crosshairs appears, double click and Excel will change the column width to the widest entry in that column.
Sometimes it’s confusing to graph the information that’s already been typed into the spreadsheet. Excel can interpret the data and show you recommended charts. First, select the data to be graphed (it’s OK to select whole columns or whole rows). Next, click on Insert then Recommended Charts. Excel will present three charts of the data to pick from. It’s possible to view each of the three before making a final decision.
With these Excel Training Tips, working in a spreadsheet becomes more productive, easier, and can result in a more attractive and useful final product. Also don’t forget that handy keyboard shortcuts, the same as in other Windows programs, speed up routine tasks. Get in the habit of using Ctrl-X, Ctrl-C, and Ctrl-V to cut, copy, and paste.
Need more Excel Training assistance? Contact us today! We’d love to help.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.