recentpopularlog in


« earlier   
R for Excel Users
Moving over to R (or any other programming language) from Excel can feel very daunting. One of the big stumbling blocks, in my view, is having a mental understanding of how we store data in structures in R. You can view your data structures in R, but unlike Excel where it’s in front of your face, it’s not always intuitive to the user just starting out.

There’s lots of great information on the hows, whys and wherefores: here’s a basic rundown of some of the common ways we structure our data in R and how that compares to what you’re already familiar with: Excel.
Excel  R_Studio 
20 hours ago by tlricherson
Conditional formatting with formulas (10 examples) | Exceljet
Formulas let you access the full power of Excel to apply conditional formatting with exactly the logic you need. This article shows how to highlight rows, column differences, missing values, and how to build Gantt charts and search boxes with CF formulas.
yesterday by enslrhs82
How to make Excel Data Validation Dependent Lists
How to limit choices in Excel drop down list, based on value in other cell. Step by step video, written instructions, download free workbook
yesterday by enslrhs82
Drop-down List in Excel - EASY Excel Tutorial
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.
yesterday by enslrhs82
Custom Formats (Removing the percentage symbol)
With a few percentages in eg A1:A10 (ie numeric values like 1.5, 0.5, 0.2 etc) go Format>Cells. On the Alignment Tab, check Wrap Text (this is important). Back on the Number tab go to Custom and type in: 0.00'Ctrl+j'% now, the 'Ctrl+j' bit means hit the j button whilst holding down Ctrl - this will insert a newline character (which will look like a little box). Click OK.
yesterday by diam0nd
What We Know About Spreadsheet Errors
research that shows as many as 88% of spreadsheets contain errors and that 1 in 5 large businesses have lost money because of it.
excel  spreadsheets  pmx  errors 
2 days ago by rnschmidt

Copy this bookmark:

to read