This article describes what Key Tips are and how you can use them to access the ribbon. It also lists Ctrl combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013.
Portfolio Archives: CategoriesBasic Operations
Previous versions of Excel have had an option for viewing two spreadsheets side-by-side. However, Excel 2013 now makes it easier by allowing you to snap each
As you may know, Microsoft Excel has built-in features that allow you to control who can edit data,
In Microsoft Office, you can use passwords to help prevent other people from opening or modifying your documents, workbooks, and presentations
When you are working with your data, you may want to enlarge what you see on the screen without actually changing the font size used by Excel. For instance,
To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can either freeze specific rows or columns in one area to lock them in place,
In Excel 2010, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations.
Outlining and grouping, which allow you to make large quantities of data minimize so that complex spreadsheets are easier to navigate.
Before analyzing how to use scenario manager in Excel 2013, it is better you get some idea about the limitations of one and two variables data tables.
Goal Seek is used to get a particular result when you’re not too sure of the starting value. For example, if the answer is 56, and the first number is 8, what is the second number?