Auto Refresh Power Query on Workbook Open
Frédéric LE GUEN
No Posts Found
Categories
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (18)
- Tips and Tricks (21)
Frédéric LE GUEN
Power Query Function to Remove Accents in Excel
Use Excel Online for Free
Identifying Weekdays and Weekends with Excel
Excel Extract Worksheet Name by formula
How to Round Numbers to 0.99 in Excel
Group Data per 15 Minute Interval in Excel
Rounding Numbers in Excel: 8 Functions Explained
CHOOSECOLS function in Excel
Who Gets the Lowest and Highest Values with Excel
Searchable Dropdown List in Excel
GROUPBY vs SUMIF in Excel
Nested IF and IFS Functions in Excel
Calculate Week Number Excel: A Quick Guide
Week number in Excel: Avoid Mistakes
Remove Gridlines in Excel Easily
Excel LEN Function Explained
How to Copy a Worksheet to Another Workbook in Excel
Solve SUMIF Exercise: Answer Fun Questions
Step-by-step guide for SUMIF function
How to Use the SUMIF Function in Excel
Remove Duplicates in Excel: Tools and Formulas
GROUPBY function: The future of COUNTIF SUMIF
COUNTIF Function in Excel: A Must-Know Function
COUNTIFS Function: Mastering Multi-Criteria Counting
Master Conditional Formatting in Excel
Select the Top 5 Values with TAKE function
Change Excel Language Easily
Write Months in Any Language in Excel
Icons with Conditional Formatting in Excel
Change Formula Bar Font Size in Excel
Progress Bar in Excel with Conditional Formatting
Compare Two Columns in Excel Easily
Excel TEXTSPLIT Function: Easily Split Text into Parts
How to Use the VLOOKUP Function in Excel
Why VLOOKUP Returns #N/A Error
Why Excel Formulas Use Comma or Semi-Colon
Easily Create a Running Total in Excel (No formula)
VLOOKUP Left Lookup Using INDEX or XLOOKUP
Search in 2 Columns with VLOOKUP & XLOOKUP
Convert TRUE/FALSE to 1/0 in Excel
Return a Value Between Two Values in a Range
Master XLOOKUP function in Excel
Become an Office Insider 😃👍
Mixed References in Excel: Explanation
Excel Test for IF, IFS & IFERROR functions
Excel IF Function Explained with Examples
Historical Stock Quotes with the STOCKHISTORY Function 🏦
Calculate Percentage Change in Excel
How to Link Addresses in Excel to Google Maps 🌎
Mastering TEXTBEFORE and TEXTAFTER in Excel
Top 10 Excel Functions You Must Know
The SEARCH function in Excel: return character’s position
Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel
Excel Calendar with Automatic Monthly Data Saving 📅
Color Row Conditional Formatting in Excel 🎨
How to Create an Alphabet Series in Excel
Intelligent Filters with Excel
Adding Headers to Tables Built with Dynamic Arrays
Extract sample randomly in Excel
How to Hide Unused Slicer Items in Excel
Transform List to Matrix like Distance Table 🚗
Quickly Calculate Percentages in Excel Without Formulas
Unlocking the Secrets of Excel’s DATE Function
How to Add Flags pictures in Excel?
The IMAGE Function in Excel: A Quick Overview
Enable the Developer Tab in Excel
Discover Data Type in Excel
Connect slicer to multiple Pivot Tables
Connect slicer with Data Type
The TRANSLATE function of Excel
Learn how to use the Dollars in an Excel formula
Tutorial for the Excel Functions AVERAGE, MIN, and MAX
Learn how to use the SUM function in Excel
Live Quotes Stock in Excel
Bollinger Bands with Excel
TOSA Excel – Assessment of the Excel functions
TOSA Excel – Format, Alignment, Filter
Create a Dynamic VLOOKUP function
Excel on your mobile for free
Displaying Days in Letters in Excel
Return Arrays with Excel’s LAMBDA Function
Split Text on a Delimiter without Formula
Minutes to Hours converter with Excel
New Excel UI (User Interface)
Date Picker in Excel
How to do a Save As with Excel Online
The TIME function in Excel
Splitting a text based on a pattern in Excel
How to have 2 different highlight colors in Excel?
Convert Binary Number to Decimal in Excel
Excel Tutorial – Creating a dropdown menu
Manipulate Text in Excel without formula
How to Round a Number to the Nearest 10, 100 in Excel
Excel Tutorial – Filtering your data
Learn the secrets of Sorting Data with Excel
Tutorial – Number Format in Excel
Displaying Date and Time in the Same Cell
Tutorial – Excel Alignment text tips