Frank Byl, Author at Power Concepts

Stop rebuilding Excel reports from Scratch

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

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!