Amazing! Every time when I watch your video, I am amazed of how much valuable and useful information I have gained! I hated Excel before, and now I am looking forward to working in Excel
Your explanations are so clear and direct, not rushed and hard to follow. (The only thing I misunderstood is that F3 is only for *pasting* a named cell.) Amazing stuff, possibly the best on the web for this lifelong learner! Can't wait to watch more of them. Thank you!
Tons of great Excel tidbits in there. I love named cells/ranges because you don't have to modify formulas if you change the location of data - just modify the named cell info.
Your videos have helped me doing a crash course in office 365 creating my yearly workbook of 10 separate sheets that link to summary page the column totals. 1.) do you know of a place we’re I could print most of the common keyboard commands and tape to bottom of screen while editing and creating pages. Like the command after clicking @sum and instead of scrolling up thru 640 col to be at top immediately like you explained in a prior video. It Be similar to list of piano keys for different notes. The command key and many off the letters used make no common sense memory cues, much like many of the icons for a person like me that only uses the 27” 2019 IMac to do yearly taxes. 2.). I found different ways to print using different keys. I had to create a table, download 2019 checkbook register, sorted them. Then listed Each item that could be used for medical expenses in separate columns across the top to put expenses in rows below for each category. I spent 6 hours trying to print it landscape, using the page number command, added top rows to repeat on each page , selected print are by col, row tried without and without page breaks and only way it print without tons of columns. On separate sheets together was by turning a 2 page sheet was turning it into a 18 page sheet. I finally called free excel support and the techs windowed in and tried every thing I had done. I had even tried to no avail using printer software. The techs came to same solution I was going to do. Take a screen capture and it printed all on one page, small text, but filled up the entire page. Luckily when I faxed it to folks requesting information it went thru clear enough to read. Did Microsoft do away with the windows 7 Excel option of pulling up the page and using interactive margins and page separation. The techs were as frustrated after a 2.5 hour phone call trying everything possible to get it to print larger which it had plenty of room to fit and allow the fonts to be larger. Either we all missed something or the new excel printing options leave much work to be done to make it more user friendly when it takes longer to set up undesirable, but barely usable printing features. Going to have to go thru and set up every page of the workbook to print a hard copy and it’s taking longer to get it to correctly print that it did to download and either import or copy and paste the data, I appreciate any help you could give. The printing videos you have done hold no secrets I can find to make it simple.
Hi, Got a suggestion, it would be great if you provide us with a project to do, and then after a period of time you could provide the answers for the project or the best of solving the project. For example, create a budget sheet and ensure the sum of the totals are updated automatically, or create a time sheet that once the date is entered (Ctrl + ;) other data in the cells are automatically entered. Thank you for your well-presented videos, and just started to support in your Patreon account.
Thanks for this tutorial, I learned a number of ways to use Excel that I wasn't aware of. It was very easy to understand. Frankly, what I was looking for is whether or not it is possible to name the column (i.e, column A becomes "First Name", column B becomes "Last Name", etc.). I have lists with thousands of business plus over 40 columns of info for each business in the list. What I'd like to be able to do is scroll through the list and know what it is that I'm looking at. If you know how to do this, I'd sure appreciate learning how do to it.
Hello, Is it possible to vlookup a formula. Example : I have a calculation sheet which has height and width. and cell for type of item. when i select the type i want the formula cell to vlookup the formula in another sheet corresponding to the type. like type plain is height+width, and type folded is height * 2 + width * 2
does this keep the formulas accurate if you need to move the cell, or does the name reference the now blank cell. i have a reference cell that i want to move to a more organized area of my spreadsheet, but i don't know if it'll ruin all the formula i put in
I’ve used cell naming for years but occasionally run into a problem that is inconvenient and confusing where named cell references do not update when a workbook is copied or saved to a new name! The cells seem to hold the old contents until I select the cell and hit enter. I haven’t been able to find a way to force excel to refresh all name cell references in the workbook. Any ideas???
Hi, want to know how to sort a sheet by name of cells. Say I have some cells named 'X' and I want to see the sheet(both rows an volume) containing only cells named 'X'.