1 / 19

How can i become an advanced excel user quickly - Advance Excel Training in chandigarh

How can i become an advanced excel user quickly - Advance Excel Training in chandigarh

abhishekdogra
Download Presentation

How can i become an advanced excel user quickly - Advance Excel Training in chandigarh

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How can I become an advanced Excel user quickly?

  2. Why is it so important to become an Excel guru? Because everybody in the world uses Excel. You can either be the person asking for help or you can be the person helping. The best part about being an Excel guru is that you can bring your skills with you wherever you go.

  3. Even if where you’re going isn’t hiring you for your advanced Excel skills, it’s a great icebreaker and you’ll quickly become everybody’s new best friend. Here is the ways you can teach yourself how to become the Excel guru that everybody relies on.

  4. 1) Apply diagonal borders If you’ve got a table that needs labels for both the row and column headers in the same cell, use diagonal borders. Click More Borders at the bottom of the borders drop-down menu (on the Home tab of the ribbon), and the diagonal buttons are by the box corners.

  5. 2) Insert multiple rows and columns You probably know you can select a row or column then add a new one via the Insert drop-down under Home. What you might not be aware of is if you select multiple rows or columns to begin with (like 5 or 10), then Excel adds in that many extra gaps in your sheet. Watch now https://www.youtube.com/watch?v=3SNSlj5uEkM

  6. 3) Turn columns into rows (or vice versa) If you have data in columns that should be in rows or the other way around (whether through your own fault or someone else’s), all is not lost. Copy the original block of cells, then right-click on the destination cell, and choose Paste Special then Transpose.

  7. 4) Hide individual cells Excel has a trick for ‘hiding’ cells. With the cells selected, right-click, choose Format Cells and then set the format as Custom under the Number tab. Enter ;;; (three semicolons) as the format. The cell contents disappear but they’re still there and can be used in formulas.

  8. 5) Save time with Flash Fill If you’re reformatting data (like the names above) in an adjacent column, Flash Fill will recognize patterns and fill out the rest of the details for you. Just give Excel a few examples at the top. You should see suggestions in gray, so hit Enter to accept.

  9. 6) Freeze row and column headings One of the simplest and oldest Excel tricks is to freeze row and column headings so they’re always in view while you scroll around. Place the cursor in the top-left cell where the actual data starts, then choose Freeze Panes and Freeze Panes from the View menu.

  10. 7) Add comments to your formulas Add a space then +N(“your comment here”) to leave comments by your formulas, either for your own reference or to help other people understand your spreadsheet. Comments don’t appear in the cell but do show up in the Formula bar, and they’re searchable too.

  11. 8) Quickly add up figures It’s likely that you’re going to be doing a lot of addition with Excel, but you don’t have to type out SUM formulas. Highlight the cell at the end of the row or the bottom of the column you want to add up, then hit Alt+= (equals) or Cmd+Shift+T on a Mac.

  12. 9) Rotate heading text If you need to add headers to very narrow columns, you can rotate the text to fit. The button you need is labelled Orientation and is on the Home tab alongside the other text formatting options. With the right cells selected, click it once and make your choice.

  13. 10) Add decimal points automatically You don’t have to waste time manually inserting decimal points because Excel can do it for you: click File, Options, Advanced and the option is near the top. There are various other handy settings on this page too, covering program behavior, number formats and more.

  14. 11) Add your own graphics to charts You don’t have to settle for the colored blocks that Excel gives you by default when it comes to creating charts. Double-click on a bar, then click the paint bucket to change the fill options: you can switch to a gradient, a pattern, or load in an image file from disk.

  15. 12) Save your charts as templates Here’s another handy chart-related trick. When you’ve found a combination of layout and colors that you’re really keen on, save it as a template so you can use it again. Simply right-click on any chart you’ve created and you’ll see the Save as Template option.

  16. 13) Add the Calculator (or something else) to Quick Access Open up the Quick Access Toolbar (to the right of the save and undo commands on the title bar), choose More Commands, and you can add a Calculator shortcut to the menu, or something else, like a shortcut to the Windows Camera or Ink apps, or the zoom controls. 14) Select everything at once A useful shortcut you might not yet have discovered. That little box where the row headings and column headings meet can be used to select the entire sheet, if you click on it. Alternatively, just press Ctrl+A (or Cmd+A) on your keyboard for the same end result. Website - https://goo.gl/XHP8GJ

  17. You Can contact us from below links - • 09988741983, 0172-5031983 • counselor.cbitss@gmail.com SCO: 23-24-25, Sector 34A, Chandigarh (UT), India.

  18. THANK YOU

More Related