Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time.
Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells.
This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
Courtesy of GoSkills.
Worksheets and Workbooks
Within excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
View
Excel offers a diverse set of ways you can view your spreadsheets. From hiding select cells to entire rows and columns, there are a number of shortcut options you can take advantage of to get the most optimal view to complete your work.
Row and Column Selection
Mass edits can save you incredible amounts of time within Excel. Often you will want to control entire rows or columns in order use the data to create charts/graphs, or simply to move and edit many cells at once. Shortcuts within this section will help you control large quantities of data with ease.
See the rest of the story at Business Insider
from SAI http://ift.tt/2q3DGvp
via IFTTT
