Chester Tugwell
Welcome to Blue Pecan's video channel. Here you will find a collection of useful video tutorials covering Microsoft Office applications including Microsoft Excel. In the description of the videos you will find a link to a supporting page on our website where you will be able to download the files featured in our videos.
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at https://www.bluepecan.co.uk
We get many requests for help with Excel spreadsheets every week, but unfortunately we are not in the position to help out - sorry! Hopefully one of our videos will answer any questions you do have.
How to Group Ages in Excel & COUNTIF Age Range - 🚫Don't Use IF Formula for This
🪄 Excel Wildcard Tricks You NEED to Know!
Условное форматирование на основе формулы — (значение в другой ячейке) И, ЕСТЕКСТ, ЕСТФОРМУЛА, ЕС...
MS Excel - Automatically Format in Millions or Thousands Including in Charts 📊
How to Filter on Bold Text in Excel
Excel - How to Set a Character Limit In a Cell
SOLVED! 😡Two-Way XLOOKUP #VALUE! Error & 😡XLOOKUP Won't Spill in Two Dimensions
Paste Word Table Into Excel Without Splitting Cells
⚡БЫСТРО удаляйте пустые строки и столбцы с помощью функции УДАЛИТЬ в Excel.
🗺️Create an Interactive Map Chart in Excel with Country Drop-Down
💵Excel PV Function - Present Value in Excel for Loans, Service Agreement & Retirement Planning
💵Excel RATE Function - Interest Rate Formula
Excel Quartile Formula | .INC vs .EXC | & How to Make a Box and Whisker Chart
How to UNPIVOT In Excel - 3 Methods Including the UNPIVOT() Function
Better Than the Fill Handle? Use THIS Function to AutoFill Dates 🔥Skip Holidays & Weekends
Complex INDEX XMATCH Scenario that Requires MAP, LAMBDA & LET
Cumulative Total in Excel Using REDUCE & Running Balance Using SCAN
💰📈 Dynamic Compound Interest Schedule - Create Your Own LAMBDA Function - Watch Your Money Grow!
Tiered Calculation Formula - SEQUENCE vs LAMBDA Recursion (File Included)
=IF AND Excel Formula - IF With Multiple Conditions | 3 Different Methods (2 & 3 will SPILL)
📅Create a Dynamic Calendar in Excel With ONE Formula! - File Included
⭐Make these Improvements to Your Formulas with LET & LAMBDA
🧹How To Clean Up Weird Spaces in Excel Fast! 🏆Who is the Winner? TRIM vs CLEAN vs REGEXREPLACE
Dynamic Drop-down Based on a List on Another Sheet (new item get added automatically)
Как умножить время ⌚ на почасовую ставку 💵 в Excel
IF Function in Excel with Multiple Conditions - 2, 3 or More Conditions
How to Sum by Month in Excel | SUMIF by Month and Year
Multi-level Dependent Drop-Down Lists (Cascading) Based on Table with Dynamic Array Formulas
IF Formula: If Date Between Two Dates Then Return ... | IF Date is in Date Range
SCAN Function - Excel Inventory Formula | Stock In Stock Out Stock Level Tracker