BCTI

@UCJUBAwstZo0MjQdQeDLAJhw - 12.8K subscribers

Focusing on tips, tricks, new, and lesser-known (yet powerful) features of Microsoft Office applications (Excel, Word, Outlook, PowerPoint) as well as data cleansing using Power Query and data visualization using Power BI.

Home Videos Live Playlists

Microsoft Excel - Top 100 Features - Beginner to Advanced

Microsoft Excel - Top 100 Features - Beginner to Advanced BCTI

660 views - 17 hours ago

Microsoft Excel - Create Custom Data Types with (Excel's) Power Query

Microsoft Excel - Create Custom Data Types with (Excel's) Power Query BCTI

1.7K views - 1 week ago

Power Query - 3 Ways to Correct Unexpected Results when Removing Duplicates

Power Query - 3 Ways to Correct Unexpected Results when Removing Duplicates BCTI

1.1K views - 2 weeks ago

Microsoft Excel - Using Emojis and Icons as Formula Responses

Microsoft Excel - Using Emojis and Icons as Formula Responses BCTI

1.3K views - 3 weeks ago

Microsoft Excel - Data Table Selection Tools (Select Data Like the PROs)

Microsoft Excel - Data Table Selection Tools (Select Data Like the PROs) BCTI

2.3K views - 4 weeks ago

Microsoft OneDrive - Use Symbolic Links to Backup ANY Folder or File

Microsoft OneDrive - Use Symbolic Links to Backup ANY Folder or File BCTI

1K views - 1 month ago

Power Query - GROUPBY Comparer Function Argument (Creating Bin Ranges)

Power Query - GROUPBY Comparer Function Argument (Creating Bin Ranges) BCTI

1.7K views - 1 month ago

Microsoft Excel - Pivot Table Paste Values and Formatting "BUG"

Microsoft Excel - Pivot Table Paste Values and Formatting "BUG" BCTI

1.2K views - 1 month ago

Microsoft Excel & Power Query - Dynamic Plain Table Ranges (Using TRIMRANGE - Dot Operator)

Microsoft Excel & Power Query - Dynamic Plain Table Ranges (Using TRIMRANGE - Dot Operator) BCTI

2.2K views - 1 month ago

Microsoft Excel - New IMPORT Functions (IMPORTCSV and IMPORTTEXT)

Microsoft Excel - New IMPORT Functions (IMPORTCSV and IMPORTTEXT) BCTI

1.6K views - 1 month ago

Power Query - Preserve Post-Query Columns (i.e., Notes Column)

Power Query - Preserve Post-Query Columns (i.e., Notes Column) BCTI

2.8K views - 1 month ago

Microsoft Excel - Create Categories from Keywords

Microsoft Excel - Create Categories from Keywords BCTI

6.2K views - 1 month ago

Microsoft Excel - Sum Embedded Values using Dymanic Array Functions

Microsoft Excel - Sum Embedded Values using Dymanic Array Functions BCTI

1.2K views - 1 month ago

Power Query - SUM Mixed Data (numbers mixed with text)

Power Query - SUM Mixed Data (numbers mixed with text) BCTI

1.1K views - 1 month ago

Microsoft Excel - Random Password Generator (with character-based color coding)

Microsoft Excel - Random Password Generator (with character-based color coding) BCTI

999 views - 3 months ago

Microsoft Excel - FILTER by Missing Data (plus, cool "sort by last name" trick)

Microsoft Excel - FILTER by Missing Data (plus, cool "sort by last name" trick) BCTI

2.1K views - 3 months ago

Power Query - Separate Blended Data (with Date Grouping Tricks)

Power Query - Separate Blended Data (with Date Grouping Tricks) BCTI

2.8K views - 3 months ago

Microsoft Excel - Center on Page for the Ribbon (FREE Add-In)

Microsoft Excel - Center on Page for the Ribbon (FREE Add-In) BCTI

1.4K views - 3 months ago

Microsoft Excel - Create Phantom Calculations with the LET Function

Microsoft Excel - Create Phantom Calculations with the LET Function BCTI

2.7K views - 4 months ago

Power Query - Remove All Blank Rows and Columns Dynamically (3 Methods)

Power Query - Remove All Blank Rows and Columns Dynamically (3 Methods) BCTI

1.7K views - 4 months ago

VBA - Excel "Conditional Formatting" for Sheet Tabs

VBA - Excel "Conditional Formatting" for Sheet Tabs BCTI

933 views - 4 months ago

Microsoft Outlook - Automatic ("Out of Office") Replies - More Features Than You Realize

Microsoft Outlook - Automatic ("Out of Office") Replies - More Features Than You Realize BCTI

33K views - 4 months ago

Microsoft Excel - Dynamic Chart Axis Bounds (plus, Building a "Last 30 Days" Stock Value Report

Microsoft Excel - Dynamic Chart Axis Bounds (plus, Building a "Last 30 Days" Stock Value Report BCTI

1.6K views - 5 months ago

Microsoft Excel - ERROR.TYPE: The Key to Better Error Responses

Microsoft Excel - ERROR.TYPE: The Key to Better Error Responses BCTI

1.3K views - 5 months ago

Power Query - Find Largest/Smallest by Group (with Parameters)

Power Query - Find Largest/Smallest by Group (with Parameters) BCTI

1.4K views - 5 months ago

Never Let an Inkjet Printer Get Clogged Again

Never Let an Inkjet Printer Get Clogged Again BCTI

637 views - 5 months ago

Power Query - Fuzzy Match (Improve lookup accuracy when working with inaccurate data)

Power Query - Fuzzy Match (Improve lookup accuracy when working with inaccurate data) BCTI

3K views - 5 months ago

Microsoft Excel / Copilot - Formula Completion (New, Upcoming Feature)

Microsoft Excel / Copilot - Formula Completion (New, Upcoming Feature) BCTI

899 views - 6 months ago

Power BI - Visual Calculations (Easy Mode for Writing DAX Formulas)

Power BI - Visual Calculations (Easy Mode for Writing DAX Formulas) BCTI

1.1K views - 6 months ago

Power Query - (NO VBA Version) Use Excel Slicers as Power Query Parameters

Power Query - (NO VBA Version) Use Excel Slicers as Power Query Parameters BCTI

4.4K views - 6 months ago

Power Query - Use Excel Slicers as Power Query Parameters

Power Query - Use Excel Slicers as Power Query Parameters BCTI

3K views - 6 months ago

Microsoft Excel - Prevent Duplicate Entries in Table Columns (plus VBA Automation)

Microsoft Excel - Prevent Duplicate Entries in Table Columns (plus VBA Automation) BCTI

1.1K views - 6 months ago

Power Query - 7 Methods to Get Data From Excel Files

Power Query - 7 Methods to Get Data From Excel Files BCTI

2.7K views - 7 months ago

Microsoft Excel - New Ways to Resize Columns (by Percentages)

Microsoft Excel - New Ways to Resize Columns (by Percentages) BCTI

580 views - 7 months ago

Microsoft Word - Multilevel Lists (Outlines) - Comprehensive Guide

Microsoft Word - Multilevel Lists (Outlines) - Comprehensive Guide BCTI

1.2K views - 7 months ago

Microsoft Excel - Split Pivot Table Caches (plus Creating Custom Ribbons)

Microsoft Excel - Split Pivot Table Caches (plus Creating Custom Ribbons) BCTI

1K views - 7 months ago

Power Query - AND OR Logic (Simple and Complex Examples)

Power Query - AND OR Logic (Simple and Complex Examples) BCTI

1.6K views - 8 months ago

Microsoft Excel - AGGREGATE (19 Functions & 8 Behaviors in 1 Function)

Microsoft Excel - AGGREGATE (19 Functions & 8 Behaviors in 1 Function) BCTI

2.1K views - 8 months ago

Power BI & Excel - Creating a Dedicated Measures Table

Power BI & Excel - Creating a Dedicated Measures Table BCTI

1.9K views - 8 months ago

Microsoft PowerPoint - Presenter's View (Taking Control of Presentations)

Microsoft PowerPoint - Presenter's View (Taking Control of Presentations) BCTI

1.1K views - 8 months ago

Microsoft Excel - Pivot Table Auto Refresh - New Feature

Microsoft Excel - Pivot Table Auto Refresh - New Feature BCTI

3.1K views - 8 months ago

Microsoft Excel - Show Values As (Extra Calculations for Pivot Tables)

Microsoft Excel - Show Values As (Extra Calculations for Pivot Tables) BCTI

4K views - 8 months ago

Power Query - Setting a Default Data Type (M Code Optimization)

Power Query - Setting a Default Data Type (M Code Optimization) BCTI

1.6K views - 9 months ago

DAX for Humans (amazing new book by Greg Deckler)

DAX for Humans (amazing new book by Greg Deckler) BCTI

1.1K views - 9 months ago

Microsoft Excel - Dynamic Currency Formatting (plus, Custom Number Format Code Discovery Trick)

Microsoft Excel - Dynamic Currency Formatting (plus, Custom Number Format Code Discovery Trick) BCTI

1.5K views - 9 months ago

Microsoft Excel - File Formats: Differences, Pros, and Cons

Microsoft Excel - File Formats: Differences, Pros, and Cons BCTI

2.7K views - 9 months ago

Microsoft Excel - All Chart Types Explained (with templates)

Microsoft Excel - All Chart Types Explained (with templates) BCTI

2.2K views - 9 months ago

Power Query - MODE Function (with 2 ways to display results)

Power Query - MODE Function (with 2 ways to display results) BCTI

2K views - 10 months ago

Power Automate - Send an Automatic Daily Events Email to Yourself

Power Automate - Send an Automatic Daily Events Email to Yourself BCTI

4K views - 10 months ago

Microsoft Excel - Create Collated & Uncollated Lists to Build Tables

Microsoft Excel - Create Collated & Uncollated Lists to Build Tables BCTI

2.8K views - 10 months ago

Microsoft Excel - Building a Multi-Language Image Query

Microsoft Excel - Building a Multi-Language Image Query BCTI

1.2K views - 10 months ago

Microsoft Outlook - Recover Twice Deleted Emails (and other Outlook items)

Microsoft Outlook - Recover Twice Deleted Emails (and other Outlook items) BCTI

8.3K views - 10 months ago

Microsoft Excel - Fill Across Worksheets (plus cool paste tricks)

Microsoft Excel - Fill Across Worksheets (plus cool paste tricks) BCTI

2K views - 10 months ago

Power Query - Split Text into Rows (the 3 Delimiter Problem)

Power Query - Split Text into Rows (the 3 Delimiter Problem) BCTI

3.1K views - 11 months ago

Power BI - Custom Tooltips (Complete Guide)

Power BI - Custom Tooltips (Complete Guide) BCTI

5.6K views - 11 months ago

Microsoft PowerPoint - Sections (3 Features in 1 Tool to Manage Slides)

Microsoft PowerPoint - Sections (3 Features in 1 Tool to Manage Slides) BCTI

686 views - 11 months ago

Microsoft Word - The Amazing Ruler That Microsoft Hid Away

Microsoft Word - The Amazing Ruler That Microsoft Hid Away BCTI

921 views - 11 months ago

Microsoft Excel - Reduce File Size by 99% When Working With Pivot Tables

Microsoft Excel - Reduce File Size by 99% When Working With Pivot Tables BCTI

5.6K views - 1 year ago

Power Query - Get Data (PREVIEW Feature)

Power Query - Get Data (PREVIEW Feature) BCTI

2.1K views - 1 year ago

Power Query - Create Custom Function Documentation

Power Query - Create Custom Function Documentation BCTI

3.4K views - 1 year ago