You’re Awesome!
You have already got your Excel basics in place and you’re well placed to take your Excel skills to the next level.
And just in case you haven’t seen it already, I have created three advanced Excel courses that I have made absolutely free for everyone. You can access these courses using the links below (these are on YouTube):
The truth is, there is no one who knows everything. As soon as you get a grip on one of the concepts in Excel, there’s another shiny new one waiting in the queue.
With this in mind, let’s make sure that the aim is to learn advanced Excel in a way that you get the maximum mileage out of it. If something doesn’t apply to your job/work, skip it and move to the next one that does.
I’ll continue to send you intermediate/advanced Excel tips, and I hope it would help you in getting the work done in the best possible way in the least amount of time.
Now, while I work on your learning plan, have a look at the Excel Ebook I created for you (I am sure you have it already, but putting a link here again). It’s full of amazing Excel Tips that you can start using right away. And if you get stuck somewhere, remember I am here to help.
In the comments section below, let me know your immediate Excel priorities, and stuff you would want to learn.
540 thoughts on “Let’s Take a Step Further”
Excellent resource for learning Excel, for beginners as well as experienced.
Well done Sumit !
I have grown to appreciate excel as you made it easy to follow
Thanks for the quick replies, book and video. I have already picked up a few things I was doing the hard way. Looking forward to continuing to learn.
It’s Awesome..
Very Helpful
Thanks a lot sir…
Excellent material
Thanks for the extremely helpful tips and shortcuts. You are making Excel look so simple. Love it.
Thank you again..
I had gotten stumped on calculating times in day groupings and hours. I was able to get most of the calculations, yet one just stumped me.
Thanks for your help,
Tammy
Thanks Sir
i need advancing Excel for the finance specialy excel calculation and excel formula.
3
Dear Sumit
many thanks for a wonderful trips I’m start learning them,
Dear Sumit,
Thank you so much, it’s help me these videos are very helpful for my day to day work life.
Thanks for your tips & tricks.
Hi S.B.,
Thank you so much. I am curios of programming through Excel. When I am putting new data in a workbook, I try to validate this data.
Thank you for your help
G.A.
I really enjoyed your ebook. Slice neatly prepared and straight to the point.
My work is mostly data analysis.
I hope to get more information to help me perfect my work.
Thank Sumit
Hi sumit
Thank you for Useful Tips , I want to start the Excel Dashboard Course
Hi Sumit,
Thanks for the free Excel courses. It’s very helpful to me. And my next plan is “Dashboard” course.
Hi Sumit. I would like to take this opportunity to thank you for all your hard work and help you offer to all of us. I am a great fan of Excel and I am always hungry for more knowledge. My next step is to master Power Query as it is an amazing and powerful tool in Excel, so I am going to start watching your free course and hopefully I will learn great stuff. By the way, I am going to start reading your ebook you sent me and I am excited to find some great tips and tricks. Thank you again .
Rachid.
I really appreciate the Ebook sent to me. It will answer a lot of query that will me in my daily verities.
I will like to have excel video on Finance field.
Dashboards, data analytics, formatting macros
Understanding programming Excel “If” statement in order to make comparisons and follow the selected option.
Could you pleases send me some exercises in advance Excel.
Dear Sumit Bansal,
You’re Awesome!
Thank you so much for your awesome materials.
Hi Sumit
I have gone through the helpful ebook you allowed me to download and am so grateful for the concise way you have used to explain difficult things. I am yet to explore the three courses you have listed above and am looking forward to a wonderful learning indeed. Great many thanks
I dont have a website yet, still learning how to develop one.
Many many thanks for your kind support and help.
Best Regards,
Hi Sumit,
Thanks for these valuable video clips, in which I have now gone through few of the VBA MACRO COURSE and once again thanks for them.
I have some experience in Pivot tables, but still I like to follow it from beginning and be a expert in same.
Appreciate if you can direct me for some videos.
I have downloaded your EXCEL EBook and will soon go through it.
Thanks
Claude
All excel relating to Data Management and Analytics
Thank you for an excellent book. It will be so useful to be able to look up bits I have forgotten or never knew. I am looking forward to following your courses and Youtube videos. Generally, I would like to thank you for the excellent education material you provide.
Sumit, Cảm ơn bạn vì ebook. Hiện tại tôi đang làm về mảng thống kê. Tôi có rất nhiều bảng biểu bị chùng lặp giá trị phải nhập đi nhập lại nhiều lần. Tôi có tìm hiểu trên mạng, được biết ngoài công thức excel ra còn có thêm mảng viết phần mềm VBA. Nhưng do thời đi học chưa được tiếp xúc với VBA, nên tôi đọc nhiều từ không hiểu. Excel tôi có học thêm rồi nên đọc cũng rễ hiểu hơn. Bây giờ mảng VBA tôi muốn nghiên cứu và học hỏi thêm để giúp thêm cho mình mảng thống kê. Không biết phải bắt đầu từ đâu và phải học như thế nào. Excel làm nhiều nên thành quen thấy nó đơn giản hơn khi học VBA.
Sumit, Thank you for the ebook. I have little knowledge of anything but the basics and find it very helpful. I am interested in creating dashboards. I have trie with PowerBI and struggle so I think excel will be a better place to start.
Hello Sumit,
I have just got into your Excel Tutorials, its interesting and easy to learn, thank you for making it easy for us to learn.
Really admiring your presentation and your thoughts. No Lags in the subject and Really awesome content. Hats off. Theses simple simple tricks very less known but very useful in our day to day work.
I subscribed your you tube channel too.
Interested in VBA, Power Query and Macros.
Thank you so much! I love the book – everything is laid out so clearly and makes it look so easy that I keep having these “Duh! Why didn’t I think of that!” moments. And that’s a wonderful thing! 🙂
Hello Summit!
I realy respect how manny hours you invested in creating this great content and im enjoying all of it too. Personaly interested in macross/VBA. Im using excel at work but mostly Catia, which has VBA too: since i dont know how to write code, are commands the same between programs? Thanks
Hello Sumit,
Thank you so much for sharing your experience, highly appreciated.
I am interesting in VBA & Macros.
Kind regards,
Thank you for the ebook! I just received it and have glanced over the topics. Just what I needed for now!
Thanks so much for sharing your experience with others! Blessings to you!
Thank you sir.
It is just what I needed for now.
Thank you so much for sharing your knowledge and experience with others.
Sir,
I loved it!
Very useful for your small Excel works.
Thank you for the great tips.
My biggest challenge is Excel VBA your assistance in this regard would be greatly appreciated.
Goodday Summit,
Your work is superb!!
I feel everyone who comes across your tutorials appreciates you .
My point is these are exactly same courses being offered virtually across the network and being charged exhorbitantly.
Well,only God can pay you back for your generosity!!
God bless you in all your endeavours!
Hello Sumit
Im interested in Vlookup, Sumifs formulars etc
Hi Sumit
I am very interesting to learn more about creating unique list an dynamic ranges to use in my work. I don’t want anything not dynamic, I hate hardcoded.
Thanks very much for your support Sumit.
Regards
Writing code. I have been learning R suite for importing CSV or XLSX to extract only relevant data by extracting a portion of text.
EG brakedisc, brakeline
Extract only items containing “brake”, or “disc “.
How can wild cards be used
Hello Sir I am a student and am interested in:
(1) coding, categorizing and analyzing my research project questinnaires(Primary data) for my final year using excel.
(2) How to edit recorded macro on excel perfectly.
(3) All accounting and finance exercises on excel, because am a finance student.
Would like to learn how to create a database.
Dear Sumit,
I really appreciate your help. Your e-book is fantastic.
Can you help me a bit more on the following?:
1. Excel functions.
2. Creating a macro (Advanced).
3. Using VBA.
Best regards,
Tasos
All the uses of pivot table and learn basics of VBA
I want to learn excel tips for finance
Hi Sumeet!
You excel tricks are excellent and the way you express is quite simplistic. I am using Vlookpup since 2004, and just graduated to index and Match because of certain better lookup facilities.
Besides,
your videos on power query are awesome!
Devender Pratap
Economist
Very helpful and clear. You guys are the best…
Greetings and many thanks for such great tips. I have downloaded Excel Ebook and will continue with that while working in office.
Many thanks again.
I enjoy your tips and tricks. They made me popular in my office
I can’t express my joy. I got good reputation after practicing and applying ur tips in my office work. I will surely practice intermediate & advanced tips from u which will help me alot in future. Thank you once again.
Very appreciated this course who did for all the excel learner.
Pivot tables and arrays.
Sumit, thank you for your very informative and oh so useful free training courses and tips! You are a real lifesaver. Your courses and tips are very userfriendly and address real Excell issues and questions that comes up when working with Excell.
Thank you so much!
Sumit, I was a bit sceptical at first due to all online scammers offering tips and free courses but you are the real deal! Your teaching is awesome and so user friendly. Always had excel but at times lazy to use and learn all the functionality but thanks to you, I am exploring and learning much, much more!!
Thank you and keep on keeping on!!
Your teaching is very well and can be easily understand to us and it is very interesting i am very liked it
Thank you
I am trying to use macros on OpenOffice. Before retirement used MS-Office at work. I have not tried all your tips. What I have tried are very good. Thank you.
I have been using Excel for about a year. The book gave me a lot of new tips saving me time and satisfaction.
Great tips… and all in an easy format. I am looking to get back into VBA writing.
ehehehehhehehrhrrhr
charts and how to work with macro
Thank you very much. My question is, when dealing with absolute cell reference the amount should only be with $USD sign or even without the dollar sign. I’m saying this because when calculating commission of 5% the keyboard shortcut is F4 which will put the dollar sign.
I just enjoy putting spread sheets together. I’m not in IT and I don’t work on spread sheets for a living but, when I use them I want them to do the heavy lifting. I find your information helpful.
Very nice and useful material sir. Very beneficiary. Thank you. I am interested in VBA.
vlook up, charts
Detailed but simple and coincide. Great resource. Thank you
Merging multiple excels
Comparing sheets
Thank you very much for your care, about us
Chciałbym nauczyć się pisać na zamówienie VBA dla Excela i generować sensowne wizualne pulpity nawigacyjne.
Heaving problem to run macro with advance filter with conditions. Mail of same problem along with workbook already sent to you. Please give me solution to resolve problem
I am interested in learning more on crearting charts and pivot tables. Thanks
Great book and thank you for everything. Soon or later I will be excelmaster through you.
Sums total formulas
VLOOKUP, PIVOT TABLES, MACROS, CHARTS etc
Pivot tables, how to. And what are Macros.
Thank you very much for getting your tips.. I work a lot pivot tables and any information would be great!! Keep up your good work!
Thank you for your help!
I would like to learn to write bespoke VBA for Excel, and generating meaningful visual dashboards.
Really worth while.you realise it when you use them. Good wishes iam 75 and a Sanskrit enthusiast.if you have any thing on string in string please send me
Dear Sumit,
I really appreciate your help. I have started studying the book yesterday but it takes a bit of time to complete it.
See if you can help me a bit on the following:
1. Excel functions.
2. Recording a macro.
3. Conditional formatting.
Best regards,
Shariff
I used Multiplan, then Excel since i was released on a daily basis and consider it the best software ever. But I find time calculations difficult, eg. average time consume in a log.
Can you cover using the slicer please
Pivot Tables – Using Multiple tables
Brilliant….Thank you so much!!
Can you print the tutorials?
I want to learn Data Analytics skills.
I do a lot of VBA and forms and how to pass data from one sub or function to another
Thank you for your analysis of Excel basics. I am following what you teach and I’m trying variations. I’ve learned a great deal from you.
I have also discovered that there are significant changes between Excel 2016 and Excel 2019. For example, in Excel 2019 a blank cell is sometimes treated as containing a zero (not as an undefined cell or #VALUE!), but not always logically evaluated as such. In a logical evaluation of =AND(A1, A2, A3), if A1 is blank/empty, A2 is B1 (B1=1), and A3 is a negative number (say, -6), the evaluation is TRUE. However, the logical evaluation of =AND(A1) is FALSE. In summary, when an empty cell is grouped with TRUE cells, the evaluation of AND is TRUE. The logical evaluation of an empty cell that is by itself in an AND equation, =AND(A1), or a cell that contains zero is FALSE.
Note that in Excel 2019, the logical evaluation of a negative number is TRUE.
How do we know that an empty cell is sometimes treated as containing zero even though that cell is not always logically evaluated as containing 0? Upon clicking on =AND(logical1, [logical2], [logical3], [logical4], …) for the above example =AND(A1,A2,A3), I am able to click on logical1 and a 0 appears as being the contents of the empty cell A1. For comparison, I click on logical2 and get ”B1”; for logical3, I get -6.
In conclusion an empty cell can be either logically evaluated as being TRUE if it is grouped with TRUE arguments in an AND relation, and the empty cell can be treated as containing 0 and be logically evaluated as being FALSE if there are no other arguments in an AND relation.
Thanks again for the details that you point out in Excel.
Amazing book, I need to learn VBA programming, from the beginning.
Great book. Thanks.
The book was simple, crisp and helpful! Thank you!!
Really helpfull Ebook. Thanks!!!
Loved your excel book, very well put together and easy to understand
Your Excel Ebook is done very well and is interesting.
Power query and Dax are my priority right now
I am very happy with the Excel Tips Ebook. Thank you.
I Just want to learn more about VBA programming.
i thank you so much for ebook and i am eagar to learn more from you regarding accounting reconciliation with cashbook to bank passbook in excel vba automatically.i am ready to pay for bank reconciliation application .Any way you are excellent ,i am happy knowing trump excel channel mr.sumit bansal
I thank you very much for your assistance. My problem now is how to use pivot table and formulae like lookups, excel dashboards, VBA, Conditional Formatting.etc that are suitable for me as an accountant
i would like to know more about the following
excel dashboards, VBA, Conditional Formatting, Pivot Tables and any Advance topics that would be good for every excel/accounting user
Your 51 tips is veru usful. New too late to go back to basics
i am an advanced excel user but I have learned a lot from your 51 tips. Thanks a lot
Having followed on of your examples, I was able to put this into practise and feel really proud of myself . Thank you
Sumif Formulas and Pivot Tables are my weakness
I’m really enjoying the course and am learning so many tips. Thank you!
A great reference. Print a form (like invoice) from fields entered and more on sharing variables between worksheets. Like a global variable
I am really learning a lot from all your video and tips. I want to learn more about lookup and index match.
Helo Sumit.
First of all I thank you for your ebook. I really love it.
I do need two very specific helps.
1. How to compare two work sheets.
2. How to print list of files in a folder. I want to create this list in excel and then print.
Please help me with instructions.
Romesh Kataria
I got all shortcut key n formulas it’s actually helpful
Thank you so much
Hi Bansal, to be honnest I’ve loved the matérialise. Everytime I study your matérialise I leatn a lot.
Create a pivot table
Thank Your very much. This is useful
Thank Your very much for providing the Excel knowledge.
My Role of working area is Project Planning, Monitoring & Control. here I want more logical / tricks to creating Pivot, plus MIS data, DashBoard, Auto update of planned data and easy monitoring system.
Your videos are so easy to understand. Your explanation makes it so easy. Wow!! Excel is amazing. During this lockdown,
Thanks once again.
VBA and Power Query
Mostly I am using it for analysis, and your books and channel are very helpful.
Thanks a lot.
The eBook is useful however I seek your help add, remove and use of criteria when using data entry forms
Thank for the ebook I have used the age help
The e book is very helpful and also useful for me. I now seek your help to remove blank lines when an if statement generates blank lines.
I want to learn more about advance pivot table and power query from scratch.
Hi….there is a competition going in my organization whereby i need to put up something unique idea of excel which can be used by accountants. Hence i saw ur video and it was very helpful to me. So i have thought of showing the solver and camera tool. But can you suggest if any unique trick is there in excel which can be used by accountants.
Hi….there is a competition going in my organization whereby i need to put up something unique idea of excel which can be used by accountants. Hence i saw ur video and it was very helpful to me. So i have thought of showing the solver and camera tool. But can you suggest if any unique trick is there in excel which can be used by accountants.
I liked the ebook and thank you for sharing. I was looking for highlighting the viewing line in a large worksheet which is what brought me to your website to begin with. I would like a refresher on pivot tables and budget worksheets.
Hi sir,
I would like to learn how to send bulk email by using VBA.
I would like to learn more about using different formulas in excel
Excellent presentation with crystal clear explanation
I have a lot of years using Excel after using Lotus for many years before that. However, with the new version of Excel, I am having problems with almost everything as “upgrading” has been a downgrade for me. Currently I am trying to relearn graphing techniques.
Thank you! I taught Excel to Jr. High students for 4 years and learned more than I knew before. I want to keep learning so I can apply the skills in my new position.
Thanking you! I am intermediate skilled, ….retired old man, …but wants to still keep with it! My children, in their 30’s, still ask the “old man” for ideas and tips, and I want to support them!
thank you! These tips are very useful, I feel that very few Excel users exploit full potential of this powerful package, one can enhance his/her productivity in office manyfold by enhancing knowledge of MS Excel.
Thank you , looking forward To using it and improving my excel knowledge. Thank you
this tips was of great help. I am an intermediate user of Excel. Would like to further expand my knowledge. Hope you could facilitate this Thanks
Teach my kids in excel
Thank you so much for your help, we will keep in touch if i need more inf.
My pain area is creating Pivot, plus MIS data. Besides, I also want to tell you how happy I am thay I came across your site. Your videos are so easy to understand. Your explanation makes it so easy. Wow!! Excel is amazing. During this lockdown, I am religiously watching one video everyday. At present I am watching the free excel 26 videos lesson 18. Thanks once again.
It’s really great to have your ebook,
My daiky work with a huge data and I need more efficient and fast with some formula in Excel.
Some tips & trick will be help.
Very Appreciate
For now i need all tips related to graphs plots,determine x axis value from given y axis value from a plot etc
51 Excel tips was of great help. I am an intermediate user of Excel. Would like to further expand my knowledge with lots of practices. Hope you could facilitate this
I do like it, however, it came in pdf file、I do hope you can send it in Excel spreadsheets.
Thank You!
Thanks for the help, it’s good stuff and very well explained. I’m looking for help building dashboards.
Tanks for you
Want to understand new exel features and Macros
Thanks for your support and the work you have done.
My immediate request is mastering VBA coding etc.
This is the best
i Know the basics. I am intermediate. Start from there
Tka for ur cooperation. It was wonderful experience with ur tips
plss send me intermediate course
i Know the basics. I am intermediate. Start from there.
Hello
I consider myself an Intermediate/Advanced Excel user.
Powerful set of excel tools,, thanks
Excel E Book — Cannot be found. Having some issues with Nested Xlookup.
Many thanks for this opportunity
Thank you, Very Useful – 51 tips! I’m a recently retired IT professional. I have been using Excel since it it was introduced, both at work and home. Even today I use Excel extensively in post retirement activity. Learned quite a bit from your videos on Dashboard, VBA, Power Query, ..
I am interested in learning more on Excel / BI
I am retired and am developing my Excel knowledge, so my interest is general. I found your 51 tips very interesting.
Macros
VBA
Powerful data crunching tools/commands
Dashboards
Very informative and I am sure it will assist in the future! Thank you very much .
Excellent content. Learning lots of new stuff.
I am using wps on an android some things do not work the same but thanks a lot
I enjoy working with Excel. With your eBooks and videos, it makes it much easier and more interesting as well. Thanks !
Excel Analysis Toolpack
I like what you have prepared, but I am still looking your program.
Videos are excellent and communication is also very good too helpful ,thanks
Amazing videos, I’ve been receiving great information and tips that I have never known before.
Thanks Sumit for your efforts.
I enjoy your various tutorials and videos. They’ve helped me a lot and are easy to follow.
Hi Sumit, your videos are wonderful and very very helpful, thank you.
Hi Sumit, Your free videos and resources are awesome, they have helped me massively. Keep up the good work.
I have many very complex spreadsheets that link to external data. Would love to learn more about how to structure my Excel workbooks to be more efficient at recalculating and refreshing data from external sources.
Thank you for all your help with Excel. The courses are really great and easy to understand and implement at work. I would like to learn and expand my knowledge in relation to pivot tables, charting and VBA basics.
I love and appreciate really your YouTube post that is very helpful! Thanks and see you again.
Linking many photos efficiently
you are awesome too.
l love your lessons and i encouraged my friends to follow your channel on YouTube.
im interested in HR, accounting and adminstration function.
God bless you ❤️.
Hazem. Syria
I wish to learn how do i make a report which should not contain zero values and its corresponding header in the reported sheet, when data is extracted from the master data
Found handy tips your eBook. I’m also keen to find some VBA tips and tricks. Nice to remind some features which are not any more in active memory.
A lot of useful and handy tips are found in your Ebook. Thank you! I’m currently interested in VBA, Solver, and Goal Seek. I look forward to learning Excel with you :))
I have gone through .It is very helpful since i am using worksheet from lotus 123 on wards. I have on doubt, ie once a pivot table is created and if any editing is done in the worksheet, does it reflect in the pivot table
sarma
You’re amazing. Thank you for the eBook and availing yourself to take me through this learning process.
Thank you for the material you sent. It is great! It is saved in my Archive. I am doing a fair amount of coding using VBA and always look for help!
I’m interested in mastering pivot tables and dynamic ranges/ formulas that allow to analyse lots of data.
Thanks!
Dear Sir,
what you send is useful for me and further i want to know matching of one sheet data with same data in other sheet for that i want to know simple formula’s . kindly mail that.
Thanks & Regards
Meenakshi
Is there any way with which I can make excel a real time data entry software from different locations.
Very interesting . It had been a great help. Still going through its contents. Your videos too prooved so helpful. I hope to master it.
Your Excel EBook is under study and I found it excellent.
I want to learn Power Pivot, Power BI, Power Query & VBA from beginner and I hope that you will send tips regarding with these topics.
Not sure what to learn yet. Mostly work with database. But find everything so interesting on excel. I learn these as my fun time, skipping netflix. You make it so doable and simple.
Sumit, you may classify some of your tips as beginner level, but the fact is I have skipped over many of them on my path to more advanced topics..
Thank you
Only browsed through it but plenty useful tips picked up. My areas of improvement are:
Database
Pivot Tables
Excel Tables
Advanced VBA
I am very pleased to find a person with great love for Excel.
Thanks for commenting Ivan.. I hope you’ll find a lot of value on the site and in my emails
Hey Sumit, you are awesome and thanks for teaching me excel, I want to get in depth of macros and vba, please help me understand both of them. You are great man, the way you teach is easy to understand.
Simple and easy to understand
Hi Sumit,
I would like to learn VBA and macros from the beginning please.
Pivot tables and Dashboards
Macros and pivot tables.
Formulas, macros and working with ranges, data bases and tables.
Require excel training
Really useful excel tips
I retired from a great career and now I teach 2 classes,per semester and I hold a town board Chairperson position. I want to learn how to produce excel charts that communicate year to date spending vs budget clearly and elegantly. I saw your example using superimposed columns. We’ll done. Would like to use this example in bar chart format. I have there questions but will stop here. Thank you for the ebook.
Excellent material and really useful ! Thank you very much!!!
Thank you very much. Really the book is very useful. The way of education methodology is very nice.
Very useful book you sent me. I am interested in learning about Macros and then pivot tables and graphs
The book is very useful and has many things I have been looking for. Also really appreciate all the content on your website, it helped me to make much better spreadsheets.
Just want to get familier with the newer versions of excel (16/19/365)
The way you introduce your help is amazing. Your approach is effective because I feel as if you converse with me. That makes the conversation friendly and polite. I grade U 10 out of 10.
The prvoius document you sent yesterdy was helpful.
Now I would like to priotize on VLOOKUP. I process surtax and I have to compare compiled returns with that generated in the system. In other words, tracking surtax. Therefore, I wish to compare the amounts in two excel sheets to idntify differences and balace up using VLOOKUP.
Help, thanks.
I’m impressed by the few tips I have reviewed so far. So much stuff hidden in plain sight – and I had completely missed it! And I have been using Excel for MUCH longer then you!!
I am looking for some help with a VBA project I’m working on at the moment – very basic stuff with userforms and underlying macros – but I hardly know where to start.
Many thanks for the tip, no doubt useful and good reference should the need arise,
Thank you. Very helpful.
Definately interested in formulas
Great template – really helpful
ebook is great thanks. It is difficult to rate your experience in Excel. In some areas I think I am intermediate to advanced but there are a lot of areas where I don’t even know the basics. I guess it’s just a matter of what you have been working on.
Your ebook is fantastic. Im digging deeper into excel more than before.
I am a Property Manager and am trying to, not only keep the rent roll but try to keep spread sheets on all spending throughout the year, Wages and purchases, etc… so that it can be turned in at tax time. We have 44 apartments in 3 separate locations and keeping all of the spending is quite difficult. Then if I need a figure for a single apt…i have to go thru & add it up. I wish I could just hit a button….Lol
Your E-book was a very nice surprise and so useful. I thank you!
Terrific
Very helpful collection of tips. Useful resource.
Thank you for the master piece
Your Excel E Book is very useful, and simplifying the work. Thank you very much for being so generous and sharing with us
This Excell ebook is really very awesome.I hope that this book is very helpful. I also thank you that yours tutorials are very clear to understand and your voice is very nice.
I really impressed and it was really helpful material, by the way it helped me out in my research. I encourage the concerned person to please keep giving us as such materials
Hi Summit,
Off course your e-book very helpful for me and my colleges. Keep it continue please.
Thanks for the Ebook. I shared it with my collegues, and will use it as a reference to do the things I need to do. I am now using the autopopulate to speed up the entry of data fields from a formatted file I get every day, to translate to another excel like application, but only in different column order.
Yes u want to learn early.
Hello Sir
Really the excel book is very useful. yes you are right that even after so much of experience, still there is a lot which i don’t know even.
There are number of things which i would like to learn from you like,
1. Vlookup
2. Index function
3. Match function
4. Pivot Table
5. How to use filter and sorting command with Conditional Formatting
and many more things which i will be asking you time to time.
For the time being, we can start up with these.
Thank you for the E Book. I will be using it for reference as I create worksheets for my club.
Hi Summit,
Thank you for the E-book. At present I took a break from Corporate Environment for completing my post-graduation course and soon wish to go back to the corp. culture with adequate touch base on Excel and for this reason your E-book and other reference materials are going to be immensely helpful in many ways to see myself get in to the job and performing the day to day work at ease along with my adequate practice.
I want to join your training course as well over a period of time after I started earning reasonable amount from the work front.
Keep encouraging us by providing excel tips without affecting your paid training courses / chapters.
Thanks & Regards
Sriram
Hi!
your book is very useful.
Thanks a lot !
I really liked the ebook. I am struggling with dependent data validation with multiple (and I mean MULTIPLE) levels and options
Hi Boss,
Thanks for the Ebook. I’m very grateful for your efforts and commitment to put this together.
Actually, I would like to start with VBA, Dashboard, Macros, Pivot Tables, Excel Query, etc
Thanks again.
Hi Summit,
Thank you for the Ebook, I’ve already applied some of the tips. I’ve been using Excel on a need to know basis, and will probably continue to do so in the future.
As you say, we won’t know everything about Excel, but it’s worth trying.
Dear Summit,
At the moment I am looking for formulas to select data, and for relatively simple statistical analysis. Data cleansing is the thing, but I want to keep all data so I can change selections and analyse data in other classes.
Kind regards, Frank
I am trying to learn the creation of energy management sheet for entire energy inputs and consumption sources (e.g. Electrical power consumption from raw source and DG, diesel consumption through Boiler, coal consumption in boiler, steam generation and costing, generation and distribution quantity/cost of Compressed air, Diesel consumption etc.
I want to be proficient in Excel, specifically in “IF” statements, macros and flow charts.
I want to be proficient in creating dashboard, macros, and better ways of managing my spreadsheet data.
This is a fantastic reference book – I have uploaded it to iBooks on my iPad as a ready reference should I need it. Thanks a lot.
Thanks very much for the free excel tips Ebook.
Please, I need to learn more on the application of the IF, and VLOOK UP functions.
I need to learn dashboard reporting as well as other shortcuts which people do not know
I need to learn dashboard reporting
please i need to develop how to create master data file with buttons link to my database or master file please… thanks and best regards
I very much need to learn management dashboard
Hi Sumeet
I am into Sales Analyst profile.
I am working outside India
Please suggest me any suitable course to enhance my Excel.
I have been using pivot tables for a couple of years, but would like to incorporate Power Query into my workflow. Also, I am having issues with Excel dropping my data model from my PowerPivot files, costing me hours of work, just to lose it again. Any help/fix would be appreciated
I checked intermediate to advanced but that’s only in certain area’s of Excel – I would really like help with setting up my spreadsheets in Visual Basics but I really don’t have the time to take a course. Thanks
I’m looking for learn how to doing my job automatically. Something help connect sql server with excel and connect to web, I’m not sure but something just like this. I think VBA can help me in this case, do you think so? Thank you
Array formulas, Importing data for Web Sites
Thanks for the book. It’s useful and really easy to understand.
Thank you so much. It’s so interesting to learns all Excel Formulas with example. Liked it Very Very much.
Thanks a Lot.
Urvesh Patel
This blog looks amazing. I trying to learn vba, macro, linking Ms Access to workbooks and advanced use of simple functions like sumproduct
Thank you so much. I have used excel but with 2010 and other lower versions. Now that excel has more added features in the newer version I needed to know and you have really brought light into it.
Thanks
Mary
Currently attempting to get a good/practical understanding of VBA. Thanks in advance for your tips
THANK YOU! I appreciate this. I believe the saying, “If you don’t use it you, lose it,” that is my level. Intermediate, haven’t used it. I am re-entering the workforce and need to get up to speed. It is true it can be remembered somewhat quickly. Even though it seems to get easier as the newer versions of Excel come out, I couldn’t do it without your help! THANKS!
I have gone through the e Book. It is good and helpful to all who want to learn Excel.
Hi Sumit, the Ebook is awesome and quite informative. I’ve added it to my arsenal of knowledge management tools. Was wondering have you any tips on using some of the standard Excel add-ins, such as Analysis ToolPak (basic and VBA), or setting up a data table. Even though it has taken me a while to come on board, I’m an avid follower of your works. Thanks, you are a genius!
I am now revising and learning further Excel after fifteen years when I was a trainer to advanced level. However due to age and health problems, I have forgotten a lot of it. Your recent offers, including the free tips have reignited my interest. Many thanks.
The 51 tips have changed me on my application to excel and have built in me enthusiasm in the program it self and hope to master in the Ifs and working within tables and ranges.
Hi Sumit
Thank you for the Excel book. I am looking forward to learning more. My immediate problem though is with removing duplicate values in a column, where neither of the 2 methods I use gets rid of ALL duplicates. It gets rid of some, but not ALL! Can you help?
Dear Sumit,
Thanks very much for the free excel tips.
Please, I need to learn more on the application of the IF, SUMIF and SUMIFS functions.
The 51 tips are excellent. Some I knew, but I do like the ALT + 7 and ALT + 9 for bullets. The keyboard shortcuts are good too and I’ll have to learn some more. I’ll have another look for other morsels again.
information on how to have spreadsheet in common drive that everyone accesses. I need help with the track comments
What is the easiest way to to learn quickly PivotTables?
want to learn validation rules
I used to teach Excel,Access etc 20 years ago. Things sure have changed. I use for Accounting. Your teaching is great. I love to learn new ideas etc. THANK YOU
I love it. thanks
Found it. Home tab is often forgot about.
Home, compare files,
I love your trainings and videos, very thorough.
I need to know how to compare 2 separate workbook (NOT SHEETS) columns for duplicates
i.e. UPC numbers
I haven’t as yet gone through everything as we are in the process of updating our server.
Will get back to you as soon as I am back on our internal server where my downloads reside.
Eleanor
Many thanks for your support to the excel community. We are forever grateful. I will need help in Advance Excel functionalities in addition to Power Query, Power Pivot, Power BI and Cube Functions.
A few years ago I was fairly proficient with Excel but then I didn’t use it very much except for basic check records and I forgot a lot of what I knew. I am 84 so much of what I knew is not quite in my brain anymore. I’ve never used any version beyond Excel 97 but I did a lot with Multiplan and Viscalc before that. When I first got acquainted with Viscalc, I thought it was magic what I could do with numbers. I only looked briefly at your stuff but it appears that you have really dug into it and created a great deal of valuable training material. I get most of my data as PDF files so I have tried to convert it to Excel and it works except for (whatever.) I refuse to spend the big bucks for one of the major programs so I am continuing to limp along with with the many “free” conversions that are available. I’m learning – but slowly.
I looked at your 51 tips. Some I knew from before, others were new but very useful.
Thank you.
Already found useful tips! Good job and thank you
Since I come from VisaCalc and Lotus 1-2-3, I have always used the + to begin a formula rather than an =! Much easier to locate on the numeric keypad!
Works fine, but not many know about the +!
ANOTHER FINE TIP!
Thank you so much for everything Sumit. There were many things in the book that I didn’t know. I would like to know more about pivot tables, dashboards, and getting to write macros well with the in built facility. However when I tried the count the non blank cells feature with the formula you have given, which happens to be =COUNTA(A1:A11)+ COUNTIF(A1:A11, “?*”) I get 22! I did not import the data, I just entered it. I don’t know what I am doing wrong. If we use just either one of the above terms, we get 11. Shouldn’t we be subtracting that =” ” term out? Why do we add? And I don’t quite understand why a cell which contains a formula should be treated as blank.
I’m looking to increase my ease with pivot tables (creating and using them) and I want to develop a dashboard in Exel
I need to learn formulas for my job
i would like to learn excel dashboard, excel vba as it relates to financial modelling
I have gone through the ebook you sent. To my surprise, I found that I knew only 5-6 tricks out of the 51 you have included, although a few of them may not be of much help to me due to my nature of Excel use.
I am impressed with the videos and the professional commentary.
Hi, thank you for this information on excel.
It is really helping me a great deal. I am looking forward to learning how to create a dashboard for finance.
Thanks for your book, there were some good tips in there for me, however I’m stumped as to my current problem, have you any suggestions please? I get a weekly updated spreadsheet which lists part numbers and their associated details, order dates, completion dates etc. I also have a similar spreadsheet (has the same headers plus extra columns containing additional data about the items which does not appear in the updated spreadsheet). I need to amalgamate these spreadsheets every week but different items are added and removed from each of the spreadsheets changing the row numbers where the part number and it’s data appears each week. Which would be the best function to use for this?
Thanks so much, I did take a look at your book and was happy to see that I knew most of it already. I would like to learn how to create a Dashboard.
Sumit, thank you so much for sharing your high quality tips and other material. I’ve been using Excel for some years now, but like you said, there is always more to learn. I like developing applications, plus a lot of other things in Excel.
Thank you for sharing the Excel eBook tips. I’m interested in learning more about Excel’s reporting and analysis features. For instance, Power Bi, Dashboard, and various charting features. I would also like more information on creating Macros. Thank you again. I look forward to learning more of Excel’s features.
Hi Sumit! Thank you for your tips and blog, which is super helpful!
I am interested in learning about data analysis and how to work with pivots and complex data.
great job !
As I move from job to job as a technical temp. The requirements change greatly. Some of the clients only require the re-entry of lost data while others require a higher level of excel to include pivot tables. Sometimes the database is huge and I need to get better at defining parameters. I have learned alot of short cuts watching your videos. It is an on learning process.
I work with very large spreadsheets and need ways to easily calculate numbers but also extract data.. and also making pivot tables which i am not familiar with. tq
Good place for new hints.
Im working with problem how to place a dropdown list from one file to many others files.
I’m looking for a way to Feed accounts receivables to sport team rosters (payment tracking), and feed accounts payable (official reimbursements) with game schedule. I also want to figure out how to automatically create a team schedule with number of weeks in the season, number & names of teams, date/day/times of schedule (I know, it’s a lot) The training is great!
I work with very large spreadsheets and need ways to easily calculate numbers but also extract data ( I know about pivot tables). One of my immediate wuestions is how I can remove 0 from rows that dont have data.
I want to know how I could enter the pricing data and the appropriate quantity data will be calculated and at the same time provide a demand and supply curves and indicate the equilibrium price and quantity. Use a dashboard to do this.
thanks
David
Excellent Excel Tips, I’ve only had a chance to browse through them so far and I am excited about trying many of them. Thank you for sharing this with us.
Finally….I signed up for Excel Tips that actually give me some things I don’t already know…love your presentations as well! I plan to open all of your emails….
I have had a great and enjoying learning experience with Excel. But I still have one problem. When I refer to a cell containing other links to other places, Excel recognises it as a Text. How can I rectify this?
advanced drop down menus and vlookups used together with IF statements, or other functions
I have not completed looking at all of the book yet, but I have found several new tips I had not heard about and also refreshes my memory on some other tips that I had forgotten about. All in all its a very good book. Thanks.
Really it is a very good platform which is helpful for easy to understand all excel function with the best Example.
I learnt a dozen of new Excel tricks I didn’t know…thanks for the E-book. I would love to learn more of switch function
Macro and VBA
Pivot Tables, Vlookup
Advanced excel pivot table and vlookup important
I would like learn more about Pivot Tables, Power Pivot, Power Query & how to data scrape using Power Query/ M coding.
I like the way you are explaining the topic which is very relevant and easy to understand. I would be interested in MIS Reports viz. How these can be designed, formatted, linked with other cells and sheets by using excel tricks.
Amazing and useful!
Hi…I am trying to put pix with the titles of patterns. Then I want to be able to sort in alphabetical order. I put the pix in the cell. Typed the title. I cannot delete entries and I cant sort.
Can u help me figure this out please? Maybe I cant use excel. I dont know.
Any help would be appreciated. I have not downloaded the tips yet but will in the next couple of days. Thank you so much!
Please get the Excel INVOICES link working. That would be a lot of fun to see it work for the simple stuff I do. Excel is addictive isn’t it?
I am very grateful, that I can receive such a very awesome free Excel Tips Ebook.
I agree, everyone who is expert in Excel, could never learn everything, because there are too many features in Excel. I often told my colleagues, that maybe I know only 1% of all Excel features, but on fact they considered me as a very advanced user.
Then, I read your tips (not finished yet), and surprisingly many of the tips are new to me. So, thank you very much for providing me the awesome free ebook!
Dear Sumit Bansal,
Kindly update me with excel tips relevant to BPO or for a Corporate company reports. Also help mw with few automated template for gaging the monthly performance of an associate.
Dear Sumit Bansal
Today we use open source Open Office in our daily activity; Can we use your Excell KPI’s guide for Open Office where any macro, addin in your program;
Thank you
I have been working with Excel for many years but as you say, you can always learn something new. I am just looking some improvements in my work and therefore I took a look at your tips, thank you for them.
I am not looking for training or a book, just looking at how others do their work and learn something from them.
Hi , Your excel training is awesome , Highly appreciated, thank you. I prefer video training .Please could you shed some light on Pivot Tables.
I am an advanced user of Excel. I just finished a basic&intermediate level book and I’ll upload it in two weeks to Amazon Kindle. I’m not interested in money, although I want to pay for the time I’ve spent. My essential interest is that users know Excel at their best. In addition, I collaborate with a website that we just launched, excelybi.com, and I would love to translate your knowledge into Spanish. Of course, with your permission (your credits and with the link to your site).
What do you think about the idea?
GOOD
Very helpful.
I like it
I am not a student. I am 77 years , retired person,keeping my self active and busy learning MS Office, — word and Excel from the tutorials available like what you have gifted. It appears to be very helpful, am in the process of reading and practicing.
Thanking you, may almighty give you more strength so as to provide such help to needy.
a b mehta.
AT 77 YEARS OF AGE! REALLY ENCOURAGING. WILL TRY NOT TO STOP MYSELF FROM LEARNING.
creating reminders and link them to outlook, creating a flashing cell, pivot tables
Power query, power pivort, VBA and Excell formulas n all
Hey,buddy I am the student of Rajshahi University of Engineering & Technology(RUET),Bangladesh . I am studying at Industrial & Production Engineerin. As an industrial engineering student, I think this will help in industrial purpose like data analysing , Quality Control, Operation management, Operation Research etc . So,I always appreciate it.
appreciated and thanks for your sharing
Glad you found it useful!
Thanks for your ebook, it’s really great.
Glad you found it useful!
NO You’re Awesome! – cheers for all of your help, it’s really appreciated
Thanks Rich! Glad you found the ebook and the website helpful
Many thanks for ur excel tips. it great help for my work
Glad it helped Bala!
Thank you for the e-book. I have already referenced it once and plan to keep it nearby in my work.
Good to hear that Barbara! Glad you found the ebook useful
Thanks a lot for your Excel ebook
Glad you found it useful!
Thank you very much for the Excel Ebook.
I have not found the time to read it yet…
I intend to consult it each time I encounter a problem…
Hope you find it useful Helen!
Useful document will help all whether beginners, intermediate and advance learners
Thanks Bijaya! I am glad you found it useful
Dash Board,Match Index etc
Have a look at these links:
https://trumpexcel.com/creating-excel-dashboard/
https://trumpexcel.com/excel-index-function/
https://trumpexcel.com/excel-match-function/
I love it , simply awesome tips and advanced techniques will help me further in my professional and personal life, thanq very much
Thanks for the kind words Sai! Glad you found it helpful 🙂
Just getting back to using excel for economic data analysis and presentation after a 8 year hiatus. Your ebook tips and tricks stimulated my memory and introduces new things in excel 2016. Very well written and presented material with clear steps and examples. Tells me the time and where to find a watch without detail of how to build a watch. Thank you. SAVAGE
VBA + Power query
You can find some useful stuff here Sailesh:
https://trumpexcel.com/excel-vba/
https://trumpexcel.com/category/power-query/
The tips are awesome….! Thank you so much !!
Thank you so much for this book of tips!
The Ebook was very informative and I didn’t knew there are simple ways to do. It was an eye opener. Keep it up.
Look ups, indexing, match function, pivots and macros
Thank you so much for this book. I love it.
Automating management accounts production in excel. I take a long time to produce my management accounts, like would to learn to automate them.
Good help for learners,
thank you for this e book its really amazing and helpful for every one
Glad you found it useful!
it looks like i am hinting treasure in your ebook, great!
Great initiative,
Please throw some light on
1. Handling large data in workbook without removing links or formula so that any subsequent change in any data updation takes up automatically.
2. Dashboards
3. Macros
4. VBA
To handle large workbooks, here are some tips:
— https://trumpexcel.com/reduce-excel-file-size/
— https://trumpexcel.com/suffering-from-slow-excel-spreadsheets/
Here are some other tutorials you asked for:
— https://trumpexcel.com/creating-excel-dashboard/
— https://trumpexcel.com/excel-vba/
Excellent hand holding experiences..
Glad you found it useful!
Excellent Sumit Ji..
VBA
Have a look at this – https://trumpexcel.com/excel-vba/
thank you Sir for the concern. I am currently the head of Business Intelligence and Data Analytics at my work place. I would like to learn more about handling big data and building dash boards using excel. Nice day
Hey Frank,
You may find these useful:
— https://trumpexcel.com/reduce-excel-file-size/
— https://trumpexcel.com/suffering-from-slow-excel-spreadsheets/
— https://trumpexcel.com/creating-excel-dashboard/
— https://trumpexcel.com/excel-vba/
Please let me know if you are going to send me your ebooks.
Thanks
I make lot of spreadsheets and love Excel but there are so many things- pivot tables etc.
Regards
Hey Harish, you can learn more about Pivot Tables here: https://trumpexcel.com/pivot-table/
I love working with excel and manage many of my work smartly with Excel Formulaes and Pivot Tables to meet diverse requirement of analysis and reporting using single database.
I am doing this with my self learning and feel there may be better way to do the same within excel.
I yet to put my hands on Macros or VB program, connecting excel to other databases etc. Would like to learn the same.
Thanks & Regards
You can learn more about VBA here: https://trumpexcel.com/excel-vba/
I’m interested in creating the time sheets, using hour and minutes separately
Maybe this can help: https://trumpexcel.com/excel-timesheet-calculator-template/
I’m interested in Excel dashboards. Thanks for the great materials!
This a good guide for Excel dashboards – https://trumpexcel.com/creating-excel-dashboard/
Thank you for sending me the free Excel templates .
I’m interested in the following topics:
1) Excel Dashboards
2) Excel Macros
3) Simple VBA
Best regards,
Mel
Hey Mel, Have a look at the following links:
— https://trumpexcel.com/creating-excel-dashboard/
— https://trumpexcel.com/excel-vba/
Hi Summit,
I would like to learn more about dashboards, I’m preparing myself to create a cost control dashboard for mining activities.
i want to learn the payroll system with tax deduction
Thanks for your cooperation
Thanks!
Your Excel tutorials are the best out there! Thank you. Currently, I’m searching for a way to create a dynamic financial statement that allows the user to filter by profit center as well as consolidated. The part I’m wrestling with is how to maintain subtotal lines in a standard P&L format.
Hi Sumit,
i need to learn how to make an excel table that records events with timestamps.
Brilliant book and the YouTube videos are the best.
Thanks for what look like it will be a treasure trove of good information. Just downloaded it.
FIRST THING.THANK YOU
SECOND THING.I HAVE EXCEL SHEET ABOUT 100 MB AND IT SO SLOW
I WANT SPEED IT UP BY SAFE WAY” I EXPECT THE FILE GROWS UP TO 150MB”
I would suggest you to please clear content for all your blank rows & columns. this will surely help you as I do the same if excel files goes big in size
Developing an easy place where my end user can select various tasks from a simple interface. Like a launch pad to access telephone message pad, a calendar, make notes on a customer file ….
Thank you very much for your time to teach us excel
Hi. Thanks for your e-book! I’d like to learn more about complex excel formulas,VBA, Macros and its features with example.
Yes I like it
Thanks for the Stuff Sumit, Loving with your amazing tips of Excel and really helpful for me. Thanks again
I would like to learn the uncommon tricks of Excel and the secrets of power pivot n query.
Great templates and classes. This is very professional and my co-workers have been IMPRESSED with what it can do for us. Thank you so much for making this available for everyone and for providing training to grow in knowledge. We all wish you the very best!
Macro, VBA, power query
Thanks for the Stuff Sir, Loving with your amazing tips of Excel
thanks Sumit. i would like to get tutorials on validating a column in mmddyyyy format
Pivot table, index match and comparison of 2 spread sheet using VBA.
I want to know more about power pivot and power query. Could you please help me if you some examples to understand more !!
I’m a beginner to VBA do have Notes for Object & Variables?
i want to learn more about VBA
want to create a multiple table in single worksheet and list one table at a time is it possible in excel without coding
i would like to learn more on pivot tables, dashboards, automating reports, data capturing and retrieving in a form of a report/summary, and formulas like vlookups, merging sheets with data similarity, etc.
Thanks for this wonder platform of learning excel, Here I am looking for the complex excel formula tutorial (index, Match etc..) and If possible can you please help with all the excel formula with example.
Super Tricks in e-book excel
Hi Sumit. Thanks for the e-book! I’d like to learn more about Macros and its features. Thanks.
Hey Sumit, Thnx for the eBook. I thought I knew Excel, and surprising to know that there are more basics I haven’t tried out. Your eBook is a real eye-opener. Thnx once again!! 🙂
With regard to my needs; I need to explore how to make Pivot more useful and automate via Macros etc. Also to develop dashboards using Pivots. Awaits your Pivot tutorial 🙂 🙂 Roy, Sydney
I am interested in learning
VB
Hi
I am endeavouring to develop VBA code in excel on a Mac. I want to have a button which saves the worksheet as a PDF and I am having problems with the code and the saving address.
I would want to explore VBA, Pivot tables,Vlookup,Macros, Sorting and other relevant stuff which can be utilised in accounting field.
Macros and VBA
thank you for the courses, but i want to learn more about developer mode
Thank you for the courses, but i want to learn more about developer mode
I am interested in having a live online spread sheet. That updates stock market quotes in real time. Any suggestions?
I want to learn about pivot table, charts, VBA,Macro..
I’m working with an Access database that reads Excel forms. The Excel data entry form allows my users (25-75/month) to report their hours & activities on specific projects. I’m good with all the basics, but am new to formulas & functions. From other internet searches I’ve built some drop down menus/auto-populate devises (using data validation & VLOOKUP) that point to info on a hidden worksheet, which allows me to ~control what the user sees and how they select their projects (although these are pretty complicated and I’m sure they can be simplified).
So, for my ‘first phase’ of learning – I need to a) simplify what I’ve done, b) learn to lock down the worksheet so folks cant overwrite what I have – as well as c) create some kind of a ‘create a new project’ devise (with my defined structure) w/o users hammering on the formulas I have in place…
I have the huge advantage of being married to a dB developer, so he’s created the Access side of things – but the more I can do on my own, the fewer ‘tech support’ calls I make to him!
One of your users posted this below –
want to learn how to add tabs to link different sheets. secondly I want to learn how I can set a workbook so that when data is entered in a row in one sheet, it is automatically captured in another sheet and rearranged/sorted by the later.
This would truly be a time saver if I could learn this. I’m all for learning more about macros, VBA, and pivot tables.
I also want to browse your web site and review some of the basics, like inputting your data into one of the smart charts or graphs.
Would you please continue sending me a pdf file for all excel learning and if you have vba and macros at the file it would be great and i really appreciate it. Thanks
Sumit,
Thanks for all your tips in excel it was great and amazing. I want to learn more about excel vba and macros and its structures.
One thing I’m interested in doing is embedding a countdown timer into a spreadsheet. I would like it to be semi-programmable to be set for 6 or 8 minutes, and have audible voice at each minute, then 30 seconds, then 15 seconds, then audible countdown from 10 seconds to 1, then have a loud audible buzzer when it gets to zero.
I’m interested in anything that will help to used Excel as a functional program to do things, including getting data from several computers into the same spreadsheet.
Macros, VBA & advanced pivot tables is my list or learning 🙂
I am interested in Excel VBA
I think most of your excel tips has helped me a great deal in learning more about excel. Thank you so much for taking the time to help us learn more a very easy way. em6032445@gmail.com
Thank you very much for the super useful tips. I am amazed at how much space for improvement Excel offers! Personally I would like to learn about macros and VBA in order to customize and automate my spreadsheets. Moreover I am also interested in data tools such as Power Pivot and Power Query. Thank you!
Hi Sumit, thanks for the downloads.
My interest is in how to use your files to the max and make amendments, mostly macros I think.
Example: I have downloaded the monthly absence tracker calendar, but would like to know how I can display all months on one page.
This way we can have a yearly overview of all personnel on one page.
I am afraid to update the macros and that it won’t work anymore.
I want to know excel macro…….
Hi Sumit:
I have loved your idea to help all those who use or want to use the goodness of Excel.
I think most of us only use the minimum of the functions offered by Excel,
because we use it empirically and we do not systematize learning.
That is why I consider what you do and I thank you for the time you spend on it.
I work in a laboratory that performs physical-chemical tests on water, wastewater and solid waste.
I use Excel a lot in the statistical processing of test results and in assuring the quality of those results.
However, I am very interested in automating a bit of processing, for example, in rejecting data according to reference values.
I hope I can count on your help.
With cordial greetings from Cuba
Ma. del C.
Hi, I have basic knowledge of Excel. What I now seek for is having tips for better analysis, creating dashboards and reports, etc. e.g : leave plan schedule
I want to learn more about vlookup, hlookup, Dashboard
Thank you so much. I want to learn more about Formulas.
How to make a template the right size in rows and columns and how to know where the created template is so that it can belied when creating a new workbook
currently want to learn about vlookup & pivot table
i want to learn VBA nd MICRO in excel
Great work done by Sumit Bansal.
Going forward I ‘d like to know more about Macros and VBA. Once learned I’d like to run a cricket leagues simulator of excel.
Thank you for freely sharing your knowledge and expertise. Remain blessed!
I want to learn more about Macros, VBA and Power Pivot.
Hi Sumit. I would like to learn more about Macros, Sensitivity and Scenario analysis.
hi Sumit, nice to meet you, amazing work you are doing, thanks!!! I like to learn more about excel accounting tips
i want to learn more about make a dashboard report for Financial Performance
Dear sir
Thank you.I want to learn my data tabulation for pivot table.my data looks like
2011 2012. 2013 2014
date |
season|
recovery
effect
colour
Extraction
stoppage
Actually there is lot of values ,numbers .not like only sales values which is easy for pivot .
Pl help me
Regards
Muhammad Iqbal
I know no one will believe me if they don’t own a Mac but, Microsoft Office for Mac is missing some processes and capabilities. Do you have anyone who can test everything on a Mac as well? I would also like to figure out how to stop everything i do on office 365 leasing program from going into the microsoft. Loud evsn whsn i save it only to my desktop. Thanks!
I am an Intermediate/Advanced Excel user but would like to learn more about Charting and Dashboards.
Macros, VBA and Power Pivot
I want to learn more on the following: Macros, Pivot Tables, VBA and dashboards
I want to learn more about Macros, VBA and Power Pivot
I am interested in macros, VBA & Powerpivot
i want that how excel sheet will be prepare for calculation of income tax for those who are in 30 % slab
I want to learn more abou Power Pivot, MS Query
Sure.. Will make some tutorials on it soon.
Hi Sumit Bansal
Thank you very much. Your Excel Tips Ebook is really a gold mine. Every page I read opens my mind and increases knowledge about Excel. It is really a helpful document. Many thank and all the best.
Ali
Glad you liked it!
I want to learn advance excel
Any specific topic in advanced Excel you want to learn?
Hello sumit. Really thank you for your efforts towards excel and vba. I know basics of excel and formulas related to index match offset vlookup like this. Im now in a hunt of vba macro. Got strucked near variables and loops. Request you to provide me the required material and please provide the index and match and offset examples as they are real time formulas to learn
Hi,
My work involves Revenue and cost analysis and would really love to learn how to extract Pivot Tables, DashBoards and working with VBA
Will create more tutorials on this.
Have a look at the following links also:
http://trumpexcel.com/a-step-further/
https://trumpexcel.com/creating-excel-dashboard/
https://trumpexcel.com/category/vba-tips/
I need to better understand writing formulas and all the different formula/functions available. I know pivots pretty well, I use slicers too.
You can have a look at different function here: https://trumpexcel.com/excel-functions/
There are many formula tutorials here too: https://trumpexcel.com/category/formula-hacks/
I want to learn how to create a drop down that allows multiple selections while preventing duplicatiyon of selections. And I want to be able to unselect, or remove, an item that was selected in error.
Thank you!!
Awesome! easy to follow. love it!
Hi Sumit, thanks very much for the guide. I have given it a quick look
and I like the format. I regard myself as an intermediate user but only
use Excel when needed (not on a daily basis). However I am shortly
going to do some data cleaning and therefore I have started to read your
“Data Analysis” section.
Thanks for all the time you dedicate to your site and therefore to us users :-).
Hi Sumit, I want to learn simple ways to make life easy for management in data management. This may include using pivot tables, dashboards and use of formulas/VBA macros. Thanks
i want to learn VBA macros and formulas which use in daily basis. so pls help.
I want to learn about Pivot Table, Dashboard and lookup functions.
Working with Excel for approximately 15 years now. The first thing I learned was using Countif and Sumif. A manager was kind enough to teach me these awesome formulas. 🙂 Luckely, I moved on since then…
Only so long ago as yesterday I looked at the ribbon and more precisely the formulas bar and the library. I questioned myself what are the formulas I know and use. So don’t ask me about:
1. Financial formulas at all
2. Trigonometry (spelled correct?) not so much (except the obvious ones, off course). Only recently (to my shame) discovered aggregate.
3. Statistical functions ( average, etcetera)
4. Cube: don’t have a clue what it can do
5. Engineering (really?)
6. Database functions I haven’t used much neither
=> Not bad for someone who followed several advanced courses. And I haven’t touched array formulas yet. 😉
On my to priority to learn list:
1. Goal seek, Scenarios and What if…
Hey.. Sure there is no need to know everything. Excel is vast and I learn something new everyday, and I only know very little I think. Here are tutorials on Goal Seek and other data analysis tool: http://trumpexcel.com/2014/11/one-variable-data-table-in-excel/
Hi Sumit, that was a bit my point. Even after 15 years I haven’t touched some functionalities of Excel, because there was no need to. Though your name suggest the sum(m)-it is to reach for. 🙂
Gonna check the tutorials out very soon. Thanks for those.
Hi Sumit,
I saw your video on creating a google search type combobox, i must say it was amazing because of the way you explained the whole process
Now i am trying to create a macro which would email selected cells, also i need two body in the email one the selected range and second the customized text for instance ” Please find below your receipt breakdown below” there is a excel cell showing the breakup
Have you created a tutorial for this ? if not could you create one ?
cheers!
Although I am more of the Advanced user of Excel (nested functions, etc.), my lack is in VBA. I have built some macros through the recordings, which is a great help. However, I lack the ability to edit them if there are issues. So, I tend to delete and start again, only to have the same issues. I realize, it is a language all to itself.
Dynamic Charts, Advanced Pivot Table, More on Look Up & Reference Functions(like, Vlookup, Offset, Match, Index), Advanced & Interactive Dashboard, More on Nested IF, Animation With Charts, Different Types of New Charts(like, Square Pie & Square Doughnut, Spie Chart, Circumplex Chart(https://www.youtube.com/watch?v=9U1RzHzCDWE) this is a link to tutorial of that chart, but i didn’t get it., Coxcomb Chart etc.
I have the following areas to understand more
1.pivot tables,how to use it to create various combinations
2.excel dash board
3. Vba macros, how to integrate it with our daily excel use
Thanks for your book,it was awesome
Hi sumit need clear understanding in using index formula m always confused
Hello Shishir.. Here is a detailed tutorial on INDEX function: http://trumpexcel.com/excel-functions/excel-index-function/
love the excel tips ebook… Thanks Sumit
I want to learn about vba with button link to another file. I mean when i input something to vba, it will be written on excel first sheed and automatic link to another first file at folder, when i input again it’ll be written on second sheed automatic link to second file at folder. Etc..
As per most of the comments, getting a better grip on pivot tables, macros and VBA would a big plus. Also some stats and analysis with Excel.
Macro and VBA
I want to learn more about Macros, VBA
am interested to learn more abt VBA and making small program automating our process
i want to learn anything about vba and file properties
I read your VLOOKUP tutorial, that is very good.
I want VLOOKUP function with two criteria and both criteria range is in column. In tutorial one criteria range is in column & another is in row.
But my data’s criteria range is in column. Pls help.
I read your VLOOKUP tutorial, that is very good.
I want VLOOKUP function with two criteria and both criteria range is in column. In tutorial one criteria range is in column & another is in row.
But my data’s criteria range is in column. Pls help.
Thank you, I tried following many tutorials on how to build color coded drop down list but was unsuccessful. They were easy to follow but when I went to enter them on my worksheet the designated colors would not come through.
Hello Lupe.. not sure what you mean by color coded drop down list. If you want to show colors in the drop down, I don’t think that is possible in Excel.
Hello Lupe.. not sure what you mean by color coded drop down list. If you want to show colors in the drop down, I don’t think that is possible in Excel.
Hi. I am interested in array formulas.
Hello Mathe.. Have a look at this: http://trumpexcel.com/category/formula-hacks/
I am an intermediate/advanced excel user and looking to learn more on
1. Cleaning of unprocessed and unstructured huge imported data using advanced Excel functions
2. VLookup, HLookup, IF-THEN-ELSE conditions and also
3. VBA programming using Excel [I have basic VB knowledge, so can pick up if directed]
4 How to use excel filters effectively
5 Google Sheets advanced functions
Hello Asha,
Here are some links you may find useful:
Functions: http://trumpexcel.com/excel-functions
Cleaning Data: http://trumpexcel.com/2014/08/clean-data-in-excel/
VBA Tutorials: http://trumpexcel.com/category/vba-tips/
Thank you very much for the resources. They are very useful.
Thank you very much for the resources. They are very useful.
Hi Mr.Bansal
I want to learn more about linking workbooks to getter.
I have lager in one workbook and every of my customer has one sheet in other workbook. Now when I write in my lager I want to write to every customer sheet it’s related data but I don’t know how do it. If it’s possible with excel please help me. Thank you
Hello,
I am an intermediate user of Excel. Thank you for your ebook, that was helpful.
I want to know if we can write an excel formula to search for a list of items from a sentence in one cell and then return on of the items as a value from the list based on the search.
Thank you,
Anup
REALLY HELP KINDLY HELP HOW TO USE DROP DOWN LIST IN DIFFERENT REPORT
hello Rahul.. have a look at this: http://trumpexcel.com/2015/11/create-drop-down-list-in-excel/
Hi Sumit,
Thanks for your help till now! I would like to learn more on complex formulas like Index, Hlookup and similar others. Also on VBA, PPT’s, Charts and creating various templates etc.
Hello Shalak, you can find Excel functions tutorials here: http://trumpexcel.com/excel-functions
I have been an Excel user for twenty seven years and now teach Hints and Tips to other users. Always like to pick up new tips shortcuts etc.
Great to connect with you Dave and welcome to trumpexcel.com. Would love to learn some tips from you
Great to connect with you Dave and welcome to trumpexcel.com. Would love to learn some tips from you
Looking for VBA and Macros.
Hello Hedge.. Have a look at some tutorials here: http://trumpexcel.com/category/vba-tips/
Method to automate weekly and monthly reports consisting of progress,financial and projections of a project (construction related).
Thanks alot Sumit Sir, i want to learn about power pivot.
I am seeking a formula to automatically move a row from one sheet to another onto a blank row when the task meets criteria of “complete”.
Hi Sumit,
Thanks for tips book. It is indeed unique. My priorities in excel are:
Having worked with pivots, table and table based formulas, match index…approximate, exact I have a few templates developed. My quest is now towards using Excel as a BI tool, using connections, more of security features, apt use of vba n macros…..being able to quickly tell a story from the data with a visual appeal. How to quickly weed out clarity out of a maize of ambiguity. I know its a gradual process….but am sure you have a few suggestions on how to go about more efficiently.
Hello Kaushik.. I will try and keep these in mind when I create more tutorials.
Here are some links you may find useful:
Excel Functions: http://trumpexcel.com/excel-functions
Pivot Table: http://trumpexcel.com/tag/pivot-table
Thanks a lot sharing the excel tips Ebook. I wanted to know more about preparing reports using macros in vba
Hello Santosh.. You can see some VBA tutorials here: http://trumpexcel.com/category/vba-tips/
You can also have a look at the VBA course I offer here: http://trumpexcel.com/excel-vba-jetpack-course
HI
Pivot tables!!
Hello Jan.. You can find Pivot Table tutorials here: http://trumpexcel.com/tag/pivot-table
Hi, I want to know more about formulas. is it possible to highlight/color the text or cell through a formula..?
Hello Asif.. You can learn more about formulas here: http://trumpexcel.com/excel-functions
Yes you can highlight cells based on a formula using conditional formatting. Have a look here: http://trumpexcel.com/2013/11/seven-wonders-of-conditional-formatting-in-excel/
I am delighted with the material am introducing a few friends to this and currently am looking for help in setting up macros using VB
Thanks Arvind.. You can find some good VBA tutorials here: http://trumpexcel.com/category/vba-tips/
I am interested in learning how to create multiple entries with line breaks in a single cell from a drop down menu. Your videos are excellent and appreciate the way they are explained in a step by step process.
Hello Mohan.. Have a look at this: http://trumpexcel.com/2014/02/insert-line-break-in-excel-formula/
I would like to learn VBA
Hello Park.. I have some VBA tutorials here: http://trumpexcel.com/category/vba-tips/
Will be creating more good stuff on it soon
Good work Sumit, please carry on.
Thanks for commenting and for the kind words 🙂
Thanks for sharing useful information and the presentation style is excellent..very easy to understand.
I would like to know more about DataModel and DAX
I want to learn more about pivot table and power pivot
Hello Indra.. I am currently creating Pivot Table tutorials. You can check this link: http://trumpexcel.com/tag/pivot-table
Dashboads
Have a look at this: http://trumpexcel.com/tag/dashboard
Only got the ebook a couple of days ago. Have scan read it, and there seems to be a lot of good, useful information in it. Will be glad when I have time to read it properly.
I want to learn more about vba excel and handling data with more efficient manner
Thanks for the tips you have sent. I want to design a beautiful and smart application for teachers/schools administration. Any suggestion?
I want to learn more about Macros, VBA
I would like to know about – option buttons – grouping option buttons and how to make each button in multiple groups act as an individual
Have a look at this tutorial: http://trumpexcel.com/2016/01/insert-use-radio-button-in-excel/
I consider myself an Intermediate / advanced Excel User I love this Ms Application and I have done quite a bit of work in with it, and my work is based on recorded Macros.
I have some experience in Basic Programming …. DOS days …. and now I am starting to understand the structure of VBA and I wrote some simple VBA routines which they include Input Boxes, Message Boxes and Error Handling, they work well and this is the field I would like to explore more in depth.
Thank you
i want to learn more about vlookup, hlookup, Dashboard
Hello Ruman.. Thanks for commenting.. while I plan to create more tutorials on dashboards, here are some links you may find useful:
>> trumpexcel.com/excel-functions/excel-vlookup-function
>> http://trumpexcel.com/excel-functions/excel-hlookup-function/
>> trumpexcel.com/tag/dashboard/
Thanks Bansal, I really appreciate this gesture. I will like to know more about chats. Furthermore.
Hello Franklyn.. Thanks for commenting.. Here are some tutorials on Charting – http://trumpexcel.com/category/charting/
I will create more on it soon
want to learn how to add tabs to link different sheets. secondly I want to learn how I can set a workbook so that when data is entered in a row in one sheet, it is automatically captured in another sheet and rearranged/sorted by the later.
Hello Musa.. Here is a tutorial on automatically sorting data in alphabetical order – http://trumpexcel.com/2015/02/sort-data-in-alphabetical-order-formula/
Hope you find this useful!
Formula and pivot table
I am on it. I am planning on creating a lot of tutorials on Pivot Tables.
On formulas, you may find the tutorials here useful:
http://trumpexcel.com/category/formula-hacks/
Macros & VBA
You got it.. Some good VBA tutorials coming your way 🙂
Pivot Tables
Thanks for commenting Patrick.. I am working on creating a whole section on Pivot Tables.. Will let you know soon!
controlling and managing pivot tables using vba
I want to learn more about Macros, VBA and Power Pivot.
I want to learn more about pivot table
Thanks for commenting.. I am working on creating Pivot Table tutorials. Will let you know whenever I publish new tutorials on this.
Any luck with the pivot tutorial?
Yup.. here is the link: http://trumpexcel.com/learn-excel/
Click on the Pivot Table tab and you’ll find the ones I have created so far