TurboCharge your Outlook Calendar
Learn ten tips on how to navigate and use your calendar more effectively. Part 2 of our 5 part series on how to use Outlook more effectively…
Also in Outlook
Video library
37 short training videos from our instructors, most under five minutes. Free to watch, no sign-up.
Prefer to read? The same material is written up in our guides — start with Excel slicers or XLOOKUP vs INDEX MATCH. To learn this properly with an instructor, see the course categories.
Recently added
New on the channel since the last time somebody filed these by hand, so the category shown may be a rough one. They appear again under their category below.
Key Outlook Configuration Tips for Busy Managers
The First Outlook Change I Make for Busy Managers
Also in Outlook
Excel
Covers: Filters · Formatting · Macros · Managing Data · Power Query · Tips · Top-10
Connecting and disconneting slicers to multiple pivot tables
By connecting a slicer to mulitple pivot tables or pivot charts it forms a foundation for building an interactive dashboard and making it easy to compare tables. Download the practice file and learn this skill https://student.powerconcep…
Also in Mastering Microsoft in Two Minutes
Stop Rebuilding 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…
Excel Advanced Filtering
Learn how to use Excel’s Advanced Filtering to filter for otherwise impossible scenarios. Be sure to download the practi…
Also in Mastering Microsoft in Two Minutes
Benefits of Tables in Excel - Part 1
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…
Also in Microsoft, Mastering Microsoft in Two Minutes
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.
Excel Tips - Advanced Conditional Formatting
This video demonstrates using advanced Excel formulas, conditional formatting, and slicers to effectively track and mana…
Excel PowerQuery - Keeping Manual Entries
If you have added a column for manual entries to a PowerQuery table you may have discovered that when you refresh the qu…
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 | #10 - VLOOKUP with Two Variables
Learn how to quickly find the intersection of a row and column in a dataset. Episode 10 of the Excel Top-10 series by PowerConcepts.
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.
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 | #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.
Excel Top-10 | #6 - Named Ranges
Make formulas that automatically update when data is added or removed. Episode 6 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 | #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.
Excel Top-10 | #3 - Paste Special
This video demonstrates using Excel’s **Paste Special** feature to efficiently adjust budget data by applying operations…
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 Top-10 | #1 - FlashFill
How to make Microsoft Excel automatically populate data? Episode 1 of the Excel Top-10 series by PowerConcepts.
Optimizing a Pivot Table
Microsoft Master Instructor Frank Byl teaches seven valuable tips on how to optimize your pivot tables on Microsoft Excel…
Excel 2016 Power Query Get Data From Folder
This short video will show how to use power query tool to set up the steps to get data from a folder which is constantly added with monthly files…
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 autoupdat…
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…
MS Excel 2010 - Creating a Basic Macro
What is a macro in Microsoft Excel 2010 and when should I use one? Answer that question and more with this instructional video on how to create, save, and find a basic macro in Microsoft Excel 2010. More great videos and courses on Micro…
MS Excel 2010 – Use Filters to Create Reports
Do you need to create reports in Microsoft Excel 2010? Check out this quick video explaining how to use Filters. You can find more great Microsoft Office 2010 video tutorials on our channel, and even more at www.powerconcepts.ca…
Word
Covers: Navigation · Tips
MS Word 2010 - Mail Merge: Switches
Create switches in your Microsoft Word 2010 Mail Merge fields so that your merged data appears the way you want it to! This easy to follow tutorial will show you how use switch codes to make your currency and date fields look like actual…
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…
MS Word 2010 - How to Create and Modify a Style
Check out this short Microsoft Word 2010 video from PowerConcepts website: www.powerconcepts.ca. To learn more about how to create and modify your own Styles in Microsoft Word 2010 or to learn quick and easy tips about Microsoft Office 2…
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 Micros…
Mastering Microsoft in Two Minutes
Connecting and disconneting slicers to multiple pivot tables
By connecting a slicer to mulitple pivot tables or pivot charts it forms a foundation for building an interactive dashboard and making it easy to compare tables. Download the practice file and learn this skill https://student.powerconcep…
Also in Excel
Excel Advanced Filtering
Learn how to use Excel’s Advanced Filtering to filter for otherwise impossible scenarios. Be sure to download the practi…
Also in Excel
Benefits of Tables in Excel - Part 1
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…
Also in Excel, Microsoft
General
Covers: Announcement
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…
Intro to OneDrive
Frank provides a basic introduction to OneDrive, Microsoft’s cloud storage service. Learn how to install OneDrive, creat…
Also in Microsoft
Microsoft
Covers: Announcement · Office 365
Benefits of Tables in Excel - Part 1
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…
Also in Excel, Mastering Microsoft in Two Minutes
Intro to OneDrive
Frank provides a basic introduction to OneDrive, Microsoft’s cloud storage service. Learn how to install OneDrive, creat…
Also in General
OneNote
Covers: OneNote Tools
OneNote Action Items become Outlook Tasks
Learn how to seamlessly transfer OneNote action items into Outlook tasks. This tutorial demonstrates creating a shared t…
Arranging and organizing inserted files in OneNote
Use a table to organize and sort multiple inserted files in a OneNote file
PowerPoint
Covers: Tips · Videos
MS PowerPoint 2010 - Insert a Video from YouTube into a Presentation
Insert or embed a video from YouTube into any Microsoft PowerPoint presentation. More instructional videos and Microsoft Office 2010 Courses visit the Powerconcepts' website at: www.powerconcepts.ca.
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…
Project
Covers: Glossary
MS Project - Creating a 2w Look Ahead Report
This step by step will show you how to create a report that will automatically update to show only activity in the next 2 weeks. This is part of our MS Project Training. This topic is in course 3 out of a series of four 4-hour courses…
Outlook
Covers: Announcement · Tips
TurboCharge your Outlook Calendar
Learn ten tips on how to navigate and use your calendar more effectively. Part 2 of our 5 part series on how to use Outlook more effectively…
Key Outlook Configuration Tips for Busy Managers
The First Outlook Change I Make for Busy Managers
All of these are on our YouTube channel, and this page is rebuilt from it every week, so new videos turn up here on their own. If a topic here is something your team needs properly, corporate training covers it in depth on your own files.