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 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.
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 […]
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.
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.