Computergaga
Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work.
Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI.
If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody.
Who am I?
My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas".
I love working with data and helping people improve their Excel skills and save time.
I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.
Dot Operator will CHANGE how you Write Formulas in Excel | TRIMRANGE Function
![Excel Running Totals the RIGHT Way [Pro Tips for Better Results]](https://ricktube.ru/thumbnail/kd3qdL0BxSM/mqdefault.jpg)
Excel Running Totals the RIGHT Way [Pro Tips for Better Results]
Excel Users LOVE These Two Functions! (TAKE & DROP in Excel)
🔥 GROUPBY + PIVOTBY = Recreating PivotTable Drill Down with Excel’s New Functions!
7 Excel Slicer Tips You Wish You Knew Earlier!
Finally, an EASY Way to Calculate Percentages in Excel | PERCENTOF Function
Highlight Top 3 Values EACH Row in Excel (ONE Rule)
Stop Nesting IFs! Learn the SWITCH Function in Excel
The 5 BEST New Excel Features of 2024 (Too Good to Ignore!)
Excel Workout Tracker 2025 | Build a Workout Calendar in Excel
Why Excel Pros LOVE the AGGREGATE function in Excel!
TRIMMEAN Function (Average Excluding Outliers in Excel)
Совместное использование LAMBDA-функций в разных книгах (руководство по использованию LAMBDA-функ...
Get Excel to Write Formulas FOR YOU 🔥 (Formula by Example in Excel)
NEW Import Data from Web into Excel 🌐 (TWO Examples)
Change Number Format Button Styles in Excel 🔥 (DID You Know This?)
Create Charts with ChatGPT-4o from Excel Data 😮 (AMAZING!)
Copilot in Excel Tutorial - Create Formula Columns EASILY
REDUCE Function in Excel (Extract Uppercase Words ONLY 🚀)
Power Query UI Magic 🪄 (NO CODE Data Transformations)
XLOOKUP Case Sensitive in Excel | Match Text Exactly
LAMBDA Function in Excel (CUSTOM Excel Formulas 😮)
Visual Calculations in Power BI ⚡AMAZING (DAX is Easier than EVER)
Reference Sheets in Excel VBA by Name (the BEST WAY)
Sum Cells with Formula ONLY in Excel 🚀 (Excel Formula Trick)
Highlight Dates DUE Within 3 Months of Expiry Date 🕛 | Excel Tutorial
Clean Bad Data with ChatGPT for Excel 🤖 AMAZING!!
Frequency Function in Excel (Frequency Distribution Table Made Easy 🔥)
Извлечение из PDF в Excel с помощью Copilot 😲 (ТАК ЛЕГКО)
Динамическая формула СУММ с XLOOKUP (с функциями TAKE и DROP)