Login
Register
Corporate
Introductory Courses

Excel Tips – Advanced Conditional Formatting

This video demonstrates using advanced Excel formulas, conditional formatting, and slicers to effectively track and manage equipment availability, ensuring users avoid scheduling conflicts efficiently

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.

Create a Dynamic Dropdown Menu in Excel

You shouldn’t copy–paste cell values from one table to another. Create a dropdown menu that corresponds to and autoupdates with the original table in 30 seconds.

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.

Optimizing a Pivot Table

Microsoft Master Instructor Frank Byl teaches seven valuable tips on how to optimize your pivot tables on Microsoft Excel

Excel Top 10 | #10 – VLOOKUP with Two Variables

Learn how to quickly find the intersection of a row and column in a dataset. Episode 10 of the Excel Top-10 series by PowerConcepts.

MS Excel – Use Filters to Create Reports

Do you need to create reports in Microsoft Excel 2010? Check out this quick video explaining how to use Filters. You can find more great Microsoft Office 2010 video tutorials on our channel, and even more at www.powerconcepts.ca