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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial
6 авг 2024
