Excel Quick Analysis Tool is Definitely Worth Checking Out🔥

Рет қаралды 5,613

Күн бұрын

Excel has a Quick Analysis Tool that can help you access commonly used features in one place. It gives you access to features such as conditional formatting or charts or calculations such as SUM, COUNT, or AVERAGE.
In this video, I will show you how to use the Quick Analysis Tool with various examples.
00:00 Intro
00:23 Overview of Quick Analysis Tool in Excel
02:45 SUM and COUNT with Quick Analysis Tool in Excel
05:03 Running Total with Quick Analysis Tool in Excel
05:49 Highlight Greater Than or Less Than in Excel
07:24 Highlight Dates in Excel
07:54 Highlight Cells that Contains Text in Excel
08:25 Highlight Duplicates or Uniques in Excel
08:54 Insert Charts using Quick Analysis Tool
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 19

@trumpexcel 5 ай бұрын

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@PaulEBrownbill Ай бұрын

I like the quick analysis toolbar, will be very useful thanks Paul

@IvanCortinas_ES 5 ай бұрын

Excellent tool, essential in the company to analyze data. Thanks for the explanation, Sumit.

@StepByStepExcelTutorials 4 ай бұрын

this is really useful stuff!

@trumpexcel 4 ай бұрын

Glad you found it useful 🙂

@Satwant2463 5 ай бұрын

Thanks a lot. Very useful.

@trumpexcel 4 ай бұрын

Glad to you found the video helpful Satwant 🙂

@DDX01 4 ай бұрын

Wow amazing video👌👌👌

@vikaasb2016 5 ай бұрын

Awesome 🎉

@wilsonvelez8712 5 ай бұрын

Excellent 👌🏼

@npc2856 4 ай бұрын

Fantastic video! Another clear and concise explanation.

@trumpexcel 4 ай бұрын

Glad it was helpful!

@alexrosen8762 5 ай бұрын

Excellent 👌

@gerhardredecker3907 5 ай бұрын

Great tools. Thanks for sharing

@trumpexcel 4 ай бұрын

Thanks... I have been using it a lot lately and find it quite a time saver

@montusaha4986 5 ай бұрын

Thanks for the tips and tricks Sumit bhai❤❤

@trumpexcel 5 ай бұрын

Thanks Montu... Glad you're finding the videos helpful 🙂

@nickwhite2996 4 ай бұрын

Hi, I'm looking for a way to format a cell (say with a green font) if its value is lower (or equal) than the cell above (ie to track when I lose weight rather than when I gain it). I believe conditional formatting is the likely route, but cannot determine the formula that will enable me to use this?, Can you or any other members help?