Chúng tôi là một website tự động lấy content ở đa kênh và video trên youtube, để tránh những việc không đáng có xảy ra, hãy cân nhắc trước mọi hành động tới giao dịch. Chúng tôi sẽ không chịu trách nhiệm về nội dung trên trang và các vấn đề giao dịch. Nhắc lại một lần nữa đây là trang web tự động không phải website để giao dịch

Top 25 Excel 2016 Tips and Tricks



The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not …
Nguồn: Đào Tạo SEO KingSEO

22 thoughts on “Top 25 Excel 2016 Tips and Tricks

  1. Michał Łubek says:

    I wonder if there is an option for showing formulas, where it will show the exact amounts from cells which are in the formula instead of e.g. B25
    Like instead of =B25*D4 it would show =54*23 where 54 is the number from cell B25 and 23 number from cell D4

  2. Dan Bennett says:

    I love the features you chose to demonstrate in this video, but there are quite a few bits that are disappointing:
    – you skipped everything but the tick boxes on Filter, which is really simple but really powerful when you see all the options
    – Transpose is available as a paste option directly on the right-click menu, no need to go through the extra steps of Paste Special
    – you don't warn people that Goal Seek won't put a round number in the field (example: http://puu.sh/ECQkT/9656d38069.png)
    – in the VLOOKUP explanation you fill the formula down without setting an absolute reference to the table range, so if you change Joe to John in the right-hand list, it won't find him because the first row of the left-hand table is no longer in the lookup range
    – similar to Transpose, Paste Values is available as a paste option directly on the right-click menu, no need to go through the extra steps of Paste Special
    – I can see it might be interesting to use images in charts, but that's a niche requirement and is likely to distract users, and I can't believe that you used an image that didn't fill the full height of the column! I saw it with my own eyes and I can't believe that you thought this was a good demonstration.
    – for a simple function like IF there's no need to use the Function button or Arguments window, it will prompt you with a tooltip under the Formula Bar as you type anyway
    – hitting F4 will cycle through the various relative-absolute cell references, much quicker and easier than manually typing dollar signs, and you also didn't mention that you can "lock" only the row or the column or both – why only show the awkward and slow method that invites human error and mistyping?
    – WHY DO YOU SEND THEM THROUGH THE OPTIONS PANEL TO SHOW FORMULAS?! THERE'S A DEDICATED BUTTON TO TOGGLE THIS ON THE FORMULAS TAB OF THE RIBBON!! BUT YOU SHOW THE KEYBOARD SHORTCUT?! EVEN THOUGH YOU DON'T MENTION HITTING F4 FOR CELL REFERENCES?! HOW?! WHY?!
    – (also, I don't know if it's because I have a UK keyboard or Excel 2019/365 or something else, but it's Ctrl + ` not Ctrl + ~)
    – using the Clear Rules option will remove ALL conditional formatting rules from the selected cells, not just the current / most recent set, users should go through Manage Rules to delete the rules they don't want
    – why mention Power Pivot in a simple tips and tricks video if it's so complex and you don't even show a single example of what it can do?
    – on a video about basic tips and tricks to improve efficiency you should absolutely let people know that you can use the Tab key to auto-complete things like formulas in the Formula Bar

Comments are closed.