Excel 2013 Tricks from Microsoft Office Specialist

Microsoft Excel has variety of features and it can do much better than the previous Excel. The list of Excel will give you correct and precise answers on how to make and use formulas in Excel.  The list keeps on increasing so it is always better to check them continuously.

Microsoft Excel 2013 Tricks from Microsoft Office Specialist:

Copy a Pattern of Numbers or even Dates:

Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you intend to populate.

Tab between Worksheets:

Jumping from worksheet to worksheet does not mean you have to take your hand off the. CTRL + PGDN are for jumping right to worksheets and CTRL + PGUP for jumping left.

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+.

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.

Add or Delete Columns Keyboard Shortcut:

Managing columns and rows in your spreadsheet is an all-day task. CTRL + “-“will delete the column where your cursor is in and CTRL + SHIFT + ‘=’ will add a new column.

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 + `.

Jump to the Start or End of a Column Keyboard Shortcut:

You are tens and thousands of rows deep into your computer data set and want to get to the first or last cell. The quickest way is to utilize the keyboard shortcut CTRL + ↑ to jump to the most effective cell, or 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.

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.

The New Year 2014 has appeared with new opportunities and competition. The high paying industries only wants the professionals with certifications. With the Microsoft’s certification that are related to one’s work is hugely acceptable in the high paying fields as one gets many recommendations after passing the certification exams. Prep nerds help the individuals in getting the certifications.