Advanced Filtering in Excel
Learn how to use Excel’s Advanced Filtering to filter for otherwise impossible scenarios. Be sure to download the practice file so that you can follow allong. https://student.powerconcepts.ca/resources/view/1783533290538-aa908729e0b902c6
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
PowerConcepts new web site tour
Our new website has many new features including Self Assessment tools, video library, Resource library, a new student dashboard and the option to subsubscribe to our new “Mastering Microsoft in 2-minutes” weekly newsletter. Take this 3 minute tour and then begin using our new site at https://powerconcepts.ca
Freezing Panes – Basic Excel Skills
When your data is larger than your screen you might lose sight of the headings on the top or on the left making if difficult to know what you are looking at. Here is a quick and easy way to over come that.
MS Word 2010 – Inserting a Table of Contents
If you ever need to create a Table of Contents for your Microsoft Word 2010 documents, look no further! This short Microsoft Word 2010 video from www.powerconcepts.ca will show you had to quickly and easily create a Table of Contents in Microsoft Word 2010 using Styles.
MS Excel 2010 – Conditional Formatting
Check out this short Microsoft Excel 2010 video on conditional formatting. At the Powerconcepts’ website: www.powerconcepts.ca you can view additional Microsoft Excel instruction on how quick and easy it is to get Microsoft Excel 2010 to highlight your cells for you and other great Microsoft Office 2010 courses!
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.