Login
Register
Corporate
Introductory Courses

Benefits of tables

When working with many sets of data it is wise to turn them into tables. This video shows how to turn it into a table and then some of benefits including automatically appending columns and rows, auto fill formulas, sorting and filtering in numerous ways. Download the file from here. https://student.powerconcepts.ca/resources/view/1781816653663-88c14a952df93181

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

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 | #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.