Using Claude AI Inside Excel to Automate Those Soul-Crushing Repetitive Tasks
Claude in Excel: The Right Way to Do It in 2025/2026 This year, we've started using cluade inside Excel (ant later on inside Word and ...
Using the Switch Function to change values to text or the oposite
Easily add values of certain cells meeting certain cirteria.
How to Create a Gantt Chart with Progress Tracking using Excel Charts
Easily add values of certain cells meeting certain cirteria.
Using the SUMIF Excel Function to add desired values that match certain criteria.
Easily add values of certain cells meeting certain cirteria.
Excel: Delete unlocked / unprotected cells with a single keystroke
Use this method to delete all editable cells on a protected document.
CONCATENATE Excel Function to Create Titles from Cells
Use the CONCATENATE Function to create sentences from several Cells in Excel
[Guest Post] MS Excel: How to find the corresponding value for a given entry
Using the VLOOKUP function in Excel Català - Castellano - Deutsch Another Guest post by my brother about Excel. Imagine you have this list...
[Guest Post] Some useful shortcuts for Excel
Some useful shortcuts for Excel. A guest post by my brother Jordi. Català - Castellano - Deutsch This is a guest post by my brother Jordi. ...
Excel: Grouping Rows or Columns
When Excel Spreadsheets become big you might want to have your cells grouped so you can easily show and hide some of them as you please. Cat...
Excel: Creating a Drop Down List with Values on a Different Sheet
Simple step by step guide on how to set up a drop down list in excel Català - Castellano - Deutsch In many situations we might want to have ...
Excel: Turn numbers exported from ACAD into European Format
There is a quick way to turn numbers in Excel into European format and to remove apostrophes. Català - Castellano - Deutsch European Number...
AutoCAD: Extracting Data to Excel
Do you need to extract the object properties to an excel sheet? Easy, don't do it manually. Català - Castellano - Deutsch Sometimes we m...
AutoCAD: Using an Excel Sheet as if it was an XREF
You can insert an Excel sheet in AutoCAD and keep it linked so when the sheet is updated, it shows the updates in AutoCAD Català - Castella...