Excel Top-10 | #3 – Paste Special

This video demonstrates using Excel’s **Paste Special** feature to efficiently adjust budget data by applying operations like **multiplying, adding, or subtracting** values across multiple cells without using complex formulas.

Excel Top-10 | #8 – Using a New IFS Function

Find out how to calculate results based on multiple conditions. Episode 8 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #5 – Auditing

Learn how to quickly discover and repair errors in an Excel spreadsheet. Episode 5 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #1 – FlashFill

How to make Microsoft Excel automatically populate data? Episode 1 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #2 – Tables and Filters

Become a proficient user of filters in just 15 minutes. Learn how to set filters, keyboard shortcuts, slicers and more advanced settings. Episode 2 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #4 – Go To Special

Learn to quickly select the data you need and perform functions faster. Episode 4 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | Bonus: #11 – CountIFS and SumIFS

Learn the best way to count or sum data from a table based on custom criteria. Bonus episode 11 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #7 – Goal Seek and Nested Functions

Learn how to get the answers you need, quickly. Episode 7 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #9 – Index Match or XLOOKUP

Learn how to quickly find the information you need in a large set of data with Index Match or XLOOKUP functions in Excel. Episode 9 of the Excel Top-10 series by PowerConcepts.

Excel Top-10 | #6 – Named Ranges

Make formulas that automatically update when data is added or removed. Episode 6 of the Excel Top-10 series by PowerConcepts.