Microsoft Excel 2013 has a number of special features which makes navigating, organizing, researching and presenting data simple and efficient for users. There are special settings that constitute the list of tips and tricks for Excel 2013 that the enthusiasts should know.
The New Excel Tips and Tricks for Expert Users:
VLOOKUP: Short for “vertical lookup,” VLOOKUP takes advantage of vertically-aligned tables to quickly find data of a value the user enters. If you know the name of a product, for example, and you wish to quickly determine its price, you can simply enter the merchandise name into Excel and VLOOKUP will find the purchase price for you. To the novice Excel user, however, setting up VLOOKUP will look like an intimidating process — but it needn’t be.
Conditional formatting: This handy tool will apply colors to a cell’s font and background with respect to the conditions you’ve set — if you wish to highlight any cell that includes a certain name or date, for example, or differentiate high, medium and low numerical values. Follow these directions to set up your own conditional formatting in a few simple steps.
Create pivot table timeline: Pivot table timelines allow you to quickly shift your pivot table according to dates and time, as well as zoom in and out of specific time periods. Fortunately, adding a timeline to your pivot table is forget about difficult than a few clicks of the mouse. Just follow these steps to have started.
Create pivot chart without pivot table: Sometimes you would like the flexibility and interactivity of a pivot chart without the hassle of creating a brand new pivot table. Fortunately, Microsoft Excel 2013 provides exactly that capability. In just a few simple steps, you can create a pivot chart from raw data.
Repeat a Formula to Multiple Cells: Create the formula you will need in the first cell. Then move your cursor to the low right corner of the cell and, when it turns into a plus sign, double click to copy that formula into the remaining cells. Each cell in the column will show the outcome of the formula utilizing the data.
Display Formulas with CTRL+: When you’re troubleshooting misbehaving numbers first consider the formulas. Display the formula utilized in a cell by hitting just two keys: Ctrl+.
Logic for Number Formatting Keyboard Shortcuts: Both SHIFT and 4 keys seem random, but they’re intentionally used because SHIFT + 4 may be the dollar sign. Therefore if we want to format as a currency, it’s simply: CTRL + ‘$. Exactly the same holds true for formatting lots as a percent.
The coming of 2014 has brought a great competition and wide range of opportunities for the people who solely rely on the high paying industries. However the certifications of Microsoft Excel has enabled most of the people for achieving success in those industries which are presently growing and becoming highly certified professionals.