Learn four must do steps when creating a Pivot Table. Then instead of recreating multiple reports learn how to copy that “perfect” source pivot table to create multiple reports quickly and easily. Download this practice file to follow along and master your skills. https://student.powerconcepts.ca/resources/view/1783642212636-8be5f6108d138c88
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
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
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!
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.
Find out how to calculate results based on multiple conditions. Episode 8 of the Excel Top-10 series by PowerConcepts.
Learn how to quickly discover and repair errors in an Excel spreadsheet. Episode 5 of the Excel Top-10 series by PowerConcepts.
How to make Microsoft Excel automatically populate data? Episode 1 of the Excel Top-10 series by PowerConcepts.
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.
