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

MS Word 2010 – Intro to Styles

Formatting a large document can be a breeze when you take advantage of the Styles feature in Microsoft Word 2010. Watch this short video from www.powerconcepts.ca to see how to assign and quickly make changes to the Styles in your Microsoft Word 2010 documents. For more Microsoft Office 2010 training and videos visit powerconcepts.ca or […]

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.

MS PowerPoint 2010 – Insert a Video into a Presentation

Adding a video to your Microsoft PowerPoint presentation is easy and quick! Check out this tutorial to see how to insert a video from a file into your presentation in PowerPoint 2010. For more videos and courses on Microsoft Office 2010 programs visit our Powerconcepts’ website at: www.powerconcepts.ca.