Top 20 Microsoft Excel Tips & Tricks - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Overland
Thank you, that was very useful. one of my favourite tips is to use the -Customise Quick Access Toolbar- at the top of the ribbon, add your most frequently used icons so that you don't need to keep going through the ribbon to find them, you can add via the -more commands- section in the drop down or simply right mouse click and -Add to Quick Access Toolbar-. This saves me so many extra clicks in a day :)
reply
Thank you, that was very useful. one of my favourite tips is to use the -Customise Quick Access Toolbar- at the top of the ribbon, add your most frequently used icons so that you don't need to keep going through the ribbon to find them, you can add via the -more commands- section in the drop down or simply right mouse click and -Add to Quick Access Toolbar-. This saves me so many extra clicks in a day :)
reply
Richard
I have pdf's with several pages with over the different pdf's the same data. first page gives identification, the other 8 pages give higher and lower limit and the measured data. I want to merge them in one page with the ident on the top and the measured value beneath. In the left the measurement text of the measurement value of each page, This must then be taken from all pdf's. How can I do that.
reply
I have pdf's with several pages with over the different pdf's the same data. first page gives identification, the other 8 pages give higher and lower limit and the measured data. I want to merge them in one page with the ident on the top and the measured value beneath. In the left the measurement text of the measurement value of each page, This must then be taken from all pdf's. How can I do that.
reply
Loide
HI Kevin. I've been trying to use excel on the web, but it looks like the free version doesn't have all the features you showed in the video above. For instance, at 2.12 minute you mention the function Idea, but I can't find it. Could you please clarify whether or not some features are exclusive to the paid version? Thank you
reply
HI Kevin. I've been trying to use excel on the web, but it looks like the free version doesn't have all the features you showed in the video above. For instance, at 2.12 minute you mention the function Idea, but I can't find it. Could you please clarify whether or not some features are exclusive to the paid version? Thank you
reply
Ingrid
beautiful! Now I know what my colleague meant by he can set update automatically. As before not knowing fast anything in tech tools and yet landed in a IT project(of course not in a tech position), your Kanal helped me a lot. Still a long way to go but it's reassuring to find out that it can be learned.
reply
beautiful! Now I know what my colleague meant by he can set update automatically. As before not knowing fast anything in tech tools and yet landed in a IT project(of course not in a tech position), your Kanal helped me a lot. Still a long way to go but it's reassuring to find out that it can be learned.
reply
Andrew
Something better than macros. Using two tables and connect the relevant columns that would allow you to reproduce all the cookie types for each country for the third table. Any additional countries can be added to the relevant table and refresh to be updated in the third table!
reply
Something better than macros. Using two tables and connect the relevant columns that would allow you to reproduce all the cookie types for each country for the third table. Any additional countries can be added to the relevant table and refresh to be updated in the third table!
reply
Sheila
Hi Kevin, thanks for all the tips. Could you show me how to put together a spreadsheet that will pull in data pertaining to the cost of a particular item online with different sellers and other details related to that particular item? I appreciate all the advice!
reply
Hi Kevin, thanks for all the tips. Could you show me how to put together a spreadsheet that will pull in data pertaining to the cost of a particular item online with different sellers and other details related to that particular item? I appreciate all the advice!
reply
Patty
As always great tips- I them all, especially Concatenate and flash fill- is there one for separating the name? So in one cell it says Cookie Monster and I want to separate it into 2 separate columns? I recall seeing it someone but can not find it
reply
As always great tips- I them all, especially Concatenate and flash fill- is there one for separating the name? So in one cell it says Cookie Monster and I want to separate it into 2 separate columns? I recall seeing it someone but can not find it
reply
Wj76
I have to say you could have made any one of these into one video-would help people find that specific trick easier when trying to figure out how to accomplish something -AND more views for you I would think -
reply
I have to say you could have made any one of these into one video-would help people find that specific trick easier when trying to figure out how to accomplish something -AND more views for you I would think -
reply
Richard
Oh I didn't say thanks for all the videos. I just bought a new Samsung galaxy Pro 360 which is driving me crazy -. I downloaded one of your recommended essentials. - thanks
reply
Oh I didn't say thanks for all the videos. I just bought a new Samsung galaxy Pro 360 which is driving me crazy -. I downloaded one of your recommended essentials. - thanks
reply
Marty
Is there a way to quickly update formulas that were originally created using the default row column cell references to use defined names created after creating the equation?
reply
Is there a way to quickly update formulas that were originally created using the default row column cell references to use defined names created after creating the equation?
reply
Add a review, comment
Other channel videos
