Search Blogs
Tag Search Results For 'formulas' (45)
Average Values, Exclude Extremes
VBA Code For Excel And Outlook | July 14th 2008 by Jimmy Pena
Sometimes I have a list of values and want to average them, while excluding zeros or negative numbers, so I use the following popular array formula. “MyRange” is a named range of cells on a worksheet. I discourage the use of magic numbers read more
Book review: Clinical Handbook of Internal Medicine (Vol 1)
Deepest Health | July 10th 2008 by Eric Grey
How to count words in a cell using excel functions
Pointy Haired Dilbert | July 8th 2008
I was doing some weird analysis on corporate mission statements and I had to count the number of words in each cell. That is when I realized there is no formula to calculate the number of words in a cell, I was too lazy to write an UDF for that, so I read more
5 Chinese Medicine texts you shouldn’t live without [Video]
Deepest Health | July 8th 2008 by Eric Grey
I’ve been figuring out how to take Deepest Health to the next level. It seems important to start diversifying media. Text is great, but the power of the Internet doesn’t stop there. I’m going to begin experimenting with audio read more
On Operations Research in comparison to the Jesuit Tradition
Over Coffee | July 7th 2008 by loi tolentino
Our professor had our class read an article by Salwa Ammar entitled O.R in the Jesuit Tradition. It is about the experiences of the author himself within Le Moyne College, which is a Jesuit institution. The article got my attention as the terms read more
Cost Variance and Project Management Terms
The Critical Path | June 20th 2008
If you’re looking to take the PMP exam, there are several definitions you need to know. You MUST know and understand the definitions listed in the table below. The exam won’t come right out and ask you “What does Actual Cost mea read more
Sum Simple Equations
The SolidWorks Geek | June 16th 2008 by Alex R. Ruiz
This is for all those who proclaimed in high school algebra, “I will never use this…” We use equations every day, even if you don’t know it. My paycheck is ‘X‘ and my bills are ‘Y‘ , money for fun stuff read more
How to do calculations with Live Data from the Web in Excel 2007?
jesse wright | June 12th 2008
Get live data from web, online in excel 2007 and create charts and do calculations with formula. Live data of stocks and portfolios from the business sector and do calculations in Excel to get quick result. Data are automatically updated from the int read more
PERT Formula
The Critical Path | May 29th 2008
PERT - Program Evaluation and Review Technique. If you’re going to take the PMP exam, you MUST remember this formula. I’ve used it countless times in the real world and it works with surprising accuracy. Formula: (P+4M+O)/6 Optimistic ti read more
Understanding Chinese herbs using Classical Chinese Medical think…
Deepest Health | May 28th 2008 by Eric Grey
Sometimes I learn small things that turn out to be very useful. I would like to start sharing these as bite sized treats interspersed in between the thicker cuts that many of you are accustomed to here on Deepest Health. Today, I would like to off read more
Electrical inventors
Electronics Design Infomation | May 15th 2008 by Good Matters
List below with attached picture with their Biodata. They are very popular electrical inventors even up to the present time, one of the remarkable was their family names use as units in the formulas of ohms law.Ohms Law formulaVoltage(v) = Current(i read more
Electrical and Electronic theory, laws, principles
Electronics Design Infomation | May 15th 2008 by Good Matters
Electrical circuit and theory - transformer, how to build transformer, the variable and inductor, magnetic fields, electric fields, induction motor, phase shift, wave forms analysis.Fundamental network theorems for dc and ac analysis - Ohms laws KCL read more
How to Convert Rows to Columns or Columns to Rows in Excel While…
jesse wright | May 6th 2008
Convert or copy rows to columns and columns to rows in Excel 2007 and Excel 2003 with formulas. copy vertical cell contents horizontally in Excel. How to Transpose data using paste special in Excel? How to paste only values in Excel? read more
How to Switch between A1 and R1C1 Reference Style in Excel?
jesse wright | April 30th 2008
how to change from R1C1 reference style to A1 reference style. change numeric reference of columns to alphabetic reference and vice versa. RC reference of excel from office 2007. read more
What are A1 and R1C1 Reference Style in Excel?
LyteByte | April 29th 2008
What are A1 and R1C1 reference style in Excel and how to use it? Absolute and relative reference using R1C1 reference style. Tutorial and examples of R1C1 reference style and A1 reference style. Using R1C1 reference style in Excel Macros and Formulas read more
How to do Quick Sum in Excel Using AutoSum and its Keyboard Short…
jesse wright | April 21st 2008
Using Autosum in Excel to do a quick sum in Excel Sheets. Tips on how to use AutoSum and Keyboard Shortcut for Autosum in Excel 2003 and Excel 2007. read more
How to View Formulas instead of Values in Excel Cells?
LyteByte | April 10th 2008
How to show or view formulas in all the cells in Excel instead of the actual values after evaluation. Keyboard Shortcut key to show and reveal all the formulas in the excel sheet. Ctrl + ` to show the formulas in excel from Office 2007 read more
Questions for the ancients
Deepest Health | February 23rd 2008 by Eric Grey
I’m part of the student government association at NCNM in Portland, OR and I am currently working on creating a scholarship for Classical Chinese Medicine students at our institution. The SGA funded the scholarship and now I’m just worki read more
Subscribe To