Тёмный
BCTI
BCTI
BCTI
Подписаться
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.
PowerPoint - Slide Masters (The Greatest Time Saver)
12:06
PowerPoint - Slide Masters (The Greatest Time Saver)
20 часов назад
Power BI - Custom Layouts for Data Models
6:54
Power BI - Custom Layouts for Data Models
14 дней назад
Excel - Dynamic QR Codes from a User Selection
8:03
Excel - Dynamic QR Codes from a User Selection
21 день назад
Power BI - 1-Click Complete Emails (with Dynamic Content)
11:14
Power BI - 1-Click Complete Emails (with Dynamic Content)
28 дней назад
Power BI - Hyperlinked Email Addressses
7:52
Power BI - Hyperlinked Email Addressses
Месяц назад
Excel - GroupBy with Multiple Aggregations (plus, Dynamic User Selection)
15:08
Excel - GroupBy with Multiple Aggregations (plus, Dynamic User Selection)
Месяц назад
Excel - Custom Chart Label Ranges (with User Switching)
19:11
Excel - Custom Chart Label Ranges (with User Switching)
Месяц назад
Power Query - Get Top N by Group
22:19
Power Query - Get Top N by Group
Месяц назад
Power BI - Custom Fiscal Calendars (plus cool formatting tricks)
19:03
Power BI - Custom Fiscal Calendars (plus cool formatting tricks)
Месяц назад
Power Query - Data from Email Attachment
11:45
Power Query - Data from Email Attachment
Месяц назад
Power BI - Clear File History
5:00
Power BI - Clear File History
2 месяца назад
Excel - 16 Features in 1 Project (Improving the User Experience)
28:34
Excel - 16 Features in 1 Project (Improving the User Experience)
2 месяца назад
Excel - Overcoming "Static" Conditional Formatting
18:00
Excel - Overcoming "Static" Conditional Formatting
2 месяца назад
Excel - Error Checking Dependent Dropdown Lists
6:45
Excel - Error Checking Dependent Dropdown Lists
2 месяца назад
Excel - 1 to Many: Dependent Dropdown List
7:34
Excel - 1 to Many: Dependent Dropdown List
2 месяца назад
Outlook - 1 Click Email Response (Templates)
10:55
Outlook - 1 Click Email Response (Templates)
3 месяца назад
VBA - Personal Macro Workbook (in Excel)
8:15
VBA - Personal Macro Workbook (in Excel)
3 месяца назад
Excel - New REGEX Functions are Amazing!
5:55
Excel - New REGEX Functions are Amazing!
3 месяца назад
Power Query - Alternate Group By Strategies
12:29
Power Query - Alternate Group By Strategies
3 месяца назад
Power Query - Import Fixed Width (Delimited) Files
4:17
Power Query - Import Fixed Width (Delimited) Files
3 месяца назад
Excel - GROUPBY Function Automatic Color Formatting
10:06
Excel - GROUPBY Function Automatic Color Formatting
4 месяца назад
Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)
10:20
Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)
4 месяца назад
Excel - Reverse Checkboxes (A different use for the upcoming Modern Checkbox feature)
4:28
Excel - Reverse Checkboxes (A different use for the upcoming Modern Checkbox feature)
4 месяца назад
Word - Revealing the Mystery of the "Hidden" Text Option
9:28
Word - Revealing the Mystery of the "Hidden" Text Option
4 месяца назад
Excel - Sort Sheets Alphabetically
7:26
Excel - Sort Sheets Alphabetically
4 месяца назад
DAX - Implicit vs Explicit Measures
11:49
DAX - Implicit vs Explicit Measures
5 месяцев назад
Excel - Image Function - Perform an Image Lookup
5:26
Excel - Image Function - Perform an Image Lookup
5 месяцев назад
Excel - Hide Formulas
3:13
Excel - Hide Formulas
5 месяцев назад
Excel Modes - Solve a MAJOR frustration when updating formulas
5:48
Excel Modes - Solve a MAJOR frustration when updating formulas
5 месяцев назад
Комментарии