6 тысяч подписчиков
180 видео
Excel: How to Prevent Excel Replacing Last Numbers with Zeros
Excel: How to Filter a Pivot Table on Date Range (4 Methods)
How to Easily Replicate Power BI's Card Functionality in Excel
Excel: Get Data From a File Stored in a SharePoint Folder
Excel: How to Share and Backup Your Macros and VBA UserForms
Extract Text Between Characters in Excel (NO Formulas Needed!)
Excel: How To Quickly Convert Text Dates to Real Dates Without Using Formulas (Text-to-Columns)
Excel for Mac: How to Import Data From a Web Page
Excel: Create a Visual Interactive Map-Based Tracker for your Dashboards and Reports
Remove Duplicate Values From a List Using the UNIQUE Function in Excel
Excel: How to Calculate the Date of the Last Friday (Or Any Other Day) of Every Month
Excel: How to Calculate the First and Last Working Day of a Month
Excel: How to use Power Query to Combine Data from Multiple Excel Files with Different Sheet Names
Excel: What is a
Excel How to Create Clickable Hyperlinks in Power Query
Calculate Age From a Date of Birth in Excel (DATEDIF Function)
Excel for Beginners: Managing Sheets (Insert, Delete, Rename, Move, Duplicate, Hide/Unhide)
Excel - Quickly Find Highest/Lowest/Nth Highest/Nth Lowest Value in a List
Excel for iPad: Conditional Formatting: A First Look at a Brand New Feature
How to Count Unique Values (Distinct Count) in a Pivot Table in Excel Online and Excel for Mac
How to Add an Effective Title and Subtitle to an Excel Chart
Excel: How to Concatenate a Range (without using VBA)
Excel: Insert an Image into a Cell (the Non 365 Way)
Power Query Editor (Excel and Power BI): Choose Columns v Remove Columns. Which is Better?
Power Query and the Secrets of the LOAD To Option
Excel: Remove Unwanted Spaces with TRIM (the Cause of Many Common VLOOKUP/XLOOKUP/FILTER Problems)
Excel: 5 Essential Must-Know Slicer Tricks
Excel: How to Exclude Specific Columns From a Pivot Chart
Excel: Conditional Formatting Directional Icon Sets (Compare This Week’s Position to Last Week)
Excel: When Should You Use the Hash Sign (#) in a Formula?
Excel: VLOOKUP - How to Find the Next Largest Value
Excel: Create Calculated Fields in a Pivot Table
Excel for Mac: How to Combine Files Stored in SharePoint or Teams
Excel for Mac: Enhance Your Dashboards with Automatically Updating Symbols and Emojis
Excel Tricks: Creating Markdown Links from Multiple Columns Using Power Query on a Mac
How to Fix “Variable uses an Automation type not supported" Error in VBA Editor in Excel for Mac
How to Combine Text in Excel (4 Methods: CONCATENATE, CONCAT, TEXTJOIN and Ampersand)
Excel: Two Ways to Change the Case of Text: Functions and Power Query
Excel - Apply Conditional Formatting to a Text Box
Excel - How to Display Selected Slicer Value(s) in a Cell
Excel: How to Count the Number of Rows in a Table or Range using the ROWS Function
Exporting Part of a SharePoint List to Excel
Dependent Filters in an Excel Pivot Table: The Secret to Getting Them to Work
Excel: How to Count the Number of Items in a List
Excel for Mac: Colour Matching from an Image or Screen Element (Plus Bonus Tip)
Excel: How to Use the IF Function with Wildcards (so it Works!)
Excel: Use the VSTACK Function to Quickly, Easily and Dynamically Combine Lists (No Power Query)
Excel: Learn the Secrets of the Frequency Function: How to Easily Group Numerical Values
LAMBDA for Beginners in Excel
Build an Infographic Style Bar Chart in Excel