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 – https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
Free VBA course – https://bit.ly/excel-vba-course
Free Power Query Course – https://bit.ly/power-query-course
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial

Please take the opportunity to connect and share this video with your friends and family if you find it useful.