Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

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. ...
2 comments:

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 ...
1 comment:

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...
17 comments:

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...
3 comments: