Excel 2016 Advanced Tutorial

I am trying to get a whole of your usable example files but they all are in PDF. Please advise on how to get. Great video

Excel 2016 beginner to advanced are by far the best of excel series that covers excel in detail

Hi Sean! Thank u for the knowledge u put in there.
I just noticed that in this third video, your drop down menus are invisible. I can't figure out y.
Anyway big up

Thank You Learnit Training!

I failed to download exercise files. Please give me link to exercise file.

Does anyone get this message when trying to use Solver - " objective cell contents must be a formula " - its pissing me off, if anyone knows the solution please help

Thanx

Thanks for it's.

Starting a new job and I will highly be using all these functions, so thank you for teaching us all well.

I have been searching for this kind of video for a long time. This is fantastic! Thank you. Is anyone else having a problem downloading the exercise file? I can only view the file but cannot edit.

How can I get softcopy of the worksheet please to practice alongside

I love the teacher, could you please explain to me how can see the arrow with the name standard and holiday in 1.00. thank you so much

What formula did you input for the Total Shipping costs, I have been stuck here for two weeks. I have joined the learning community and I don't know my way around there. Please just tell me the formula you used. Thank you.😭

How do I do the background in text functions before I input the first name and the last name

You are great and amazing Thank you so much

Really useful.
And from your videos people learn how to use these softwares & as a by-product u also learn how to teach / present topics.

Hello... the excercise files are in view only. Can someone help me?

Incredible. Helped a lot.

How do u get the template

This is a great tool for learning Excel. The lessons are very engaging and easy to comprehend. Thank you

how I can change seq. in a column for example if : EKT-0001-E in one cell then next cell i want EKT-0002-E how i can ?

Excellent presentation. This is very helpful materials. It has broaden my knowledge in excel.

Uhh explanation is the best that I have ever heard but vlookup topic the audio is jumpy and I miss some words which are of great importance

Best Excel training ever. You are the best

I love your training but 365 doesn't work with solver and I can't find a solution. Thanks Sean

thank you, Sean Bugler.

The solver tool segment should come before the complex solver tool segment.

Hey Guys I need a huge favor- Can someone put in the comments how to divide two columns in a pivot table
I know there has to be a way.

could you please provide the Exercise Files and Manuals?

This is brilliant

This video is really good and precise on giving information that everybody can easily understand what to do. Well demonstrated compare to other Excell videos here in you tube. And the guy speaking articulately clear on the way that the viewers can understand and catches of what he was talking. And i just found out that his name was Sean. Its look like that you are sitting on his classroom listening on his lecture. With this regards it makes me log in on my account and subscribed to his channel. Thanks well done.

nice video❤️🧡💛

Beautiful

at scenario part, found that southern expansion "show result ", didn't follow original forecast figure, ie only south forecast shd be changed, the others shall remain std scenario, and how to go back to original file if not to copy file first at side

This is great. The Pears Company example bonuses didn't account for the amended $10K. Shouldn't the existing bonuses and the no bonus sales ppl received the $850?

It’s a good tutorial, but when you do something you call ADVANCED, please talk as you were talking to that public, not to 10 year old students. Waaay sloooww, as if the public never heard of excel before. You could explain all that in 38min, not 2h38min

Explain why cells appear locked when CLEAR ALL is used. How to replace cell in the cleared area after?

Thanks for a great tutorial man. Tone was great!

Thanks a lot, You're awesome

nice

the best video so far

Great job. Average if function, I guess that average of any selected criteria should be calculated based on the entire range of data not getting the average of total expenses. e.g. Criteria such as Rent, existing in four rows, and values in 12 cells as we have data for Feb, Mar, and Apr, therefore calculating the average for the total sales will represent summing the four total expenses divided by 4 (Result: 17790), while averaging the values of the expenses for Rent criteria which existing in 4 rows, will be summing 12 values existing in 12 cells divided by 12. (Result: 5930). Does this make sense? Please correct me if I am wrong. Thanks :-)

i watch minecraft why is this in my recommended

Very useful content. Thanks for sharing this.

Thanks for this wonderful presentation. I highly recommend this tutorial to anyone who wants to use Microsoft Excel productively.