(Para) Pathology Notes
  • Preface
  • Introduction
    • Introduction
    • GitBook Manual
    • Patoloji Notları
    • Patoloji Atlası
    • Edit Here
    • Pathology Pages
  • Medical School Lectures
    • Medical School Lectures
      • About Pathology Lectures
    • General Pathology
      • General Pathology Links
      • Introduction to Pathology
      • Cellular Pathology
      • Chronic Inflammation
      • Wound Healing
      • The Mechanisms of Cell Death, Apoptosis, and Autophagy
      • Intracellular Accumulations and Cellular Aging
      • Pathology of Infectious Diseases
      • Amyloidosis
    • Laboratory Lectures
      • Lab: Pathology of Heart and Vascular Diseases
      • Lab: Glomerular Diseases
      • Lab: Pathology of Breast
      • Lab: Pathology of Endocrine System-1
      • Lab: Pathology of Endocrine System-2
      • Lab: Pathology of Gastrointestinal Tract-2
      • Lab: Basic Tumor Pathology-1
      • Lab: Basic Tumor Pathology-2
      • Lab: Diseases and Tumors of Respiratory System-1
      • Lab: Gynecologic pathologies
      • Lab: Diseases and Tumors of Respiratory System-2
      • Lab: Infectious agents in tissues
      • Lab: Pathology of Gastrointestinal Tract-1
      • Lab Acute and Chronic Inflammation
      • Lab Cellular Injury
      • Lab Hemodynamic Disorders
      • Lab: Pathology of CNS
    • Public Health
    • Infectious Diseases
      • Vaccination
      • Fungal Diseases
      • Parasitic Diseases
  • Systemic Pathology
    • Systemic Pathology
    • Endocrine Pathology
    • Gastrointestinal Pathology
      • Esophagus Pathology
      • Stomach
      • Duodenal Biopsy
      • Polyps
      • Colon and Rectum
        • Colon Colorectal Carcinoma
        • Malignant Colorectal Polyps
    • Neuropathology
      • Injury in central nervous system and cerebrovascular diseases
      • Gliomlar
    • Bone and Soft Tissue
      • YumuÅŸak doku tümörleri
      • Approach to Soft Tissue Tumors
      • Bone Pathology
    • Liver Pathology
      • Approach to Liver Biopsies
      • Hepatitis C
    • Pancreas
    • Gallbladder
    • Lung
    • Medical Kidney
    • Unnecessary Thyroid FNAC
    • Salivary Gland
    • Head and Neck
    • Thymus
    • Breast Pathology
    • Transplantation Pathology
    • Immune System
    • Adrenal
    • Uropathology
      • Prostate Pathology
    • Bone
    • Soft Tissue
    • Gynecological Pathology
      • Approach to Endometrial Biopsies
      • Immunohistochemistry in Gynecological Pathology
    • Dermatopathology
    • Organ Independent Pathology
  • Pathology Residents & Pathologists
    • Pathologist
    • So Called Junk Materials & Pitfalls
    • It happens / I have seen that before / Olur öyle
    • Helpful Web Sites for Diagnostic Practice
    • Virtual Slides
    • General Resources For Residents
    • History of Pathology
    • Pathology Reports
    • Mitosis
    • The Future of Pathology
    • Resident Education
    • Rotations of Pathology Residents
    • Web sites of Pathologists
    • Unknowns
    • Photography
    • Pathology Associations
    • Pathology Webinars
    • Pathology as a Career
    • Diagnosis, accuracy, interobserver and intraobserver reliability
    • Pathology News
    • Academic Accounts
    • Academic Tools
    • Moleküler Patoloji'ye Dair
    • jargon
  • Pathology and Social Media
    • Pathology and Social Media
  • Pathology Tweets
    • Pathology Tweets
      • Pathology Tweets
  • Taxonomy and Classification of Diseases
    • Taxonomy and Classification of Diseases
    • Tumor Classification
    • Classification Theory
    • Chaos Theory and Uncertainity
  • Pathophysiology
    • Pathophysiology
  • Carcinogenesis, Hallmarks of Cancer
    • Carcinogenesis & Hallmarks of Cancer
      • Carcinogenesis
      • HPV
      • Tumor Immunology
      • Metastasis
  • Computational, Digital & Mathematical Pathology
    • Digital Pathology
    • Dijital Patoloji'ye Dair
    • About the Usage of Digital Pathology
    • Digital Pathology Software
    • Analysis
    • Telepathology
    • Cytomine
    • Openmicroscopy
    • Articles on computational, digital, and mathematical pathology
    • Mathematical Pathology
    • Image Analysis
  • Macroscopy
    • Macroscopy
    • Whipple Macroscopy
    • Macroscopic Photography
    • Macrocopy Videos
    • Macroscopy Articles & Guidelines
  • Autopsy
    • Autopsy
    • Autopsy Articles
  • Guidelines
    • Guidelines
    • AJCC, UICC, TNM
    • CAP
    • AAPA
  • Treatment and Pathology
    • Treatment
    • Therapy related changes
    • Immunotherapy
    • Prognostic, Predictive and Therapeutic Factors
  • Laboratory Management
    • Laboratory Management
    • Lean
    • Laboratory Information Systems
      • Patoloji Modülü Özellikleri
    • Routine Histology Laboratory
    • Liquid Based Cytology Preperations
    • Research Lab
    • Errors in Pathology
    • Microscopy
    • Health Risks
    • Critical Diagnoses
    • Staff
    • Quality And Standardisation
    • Resume
    • Acreditation
  • Stains
    • Stains
    • Hematoxylin and Eosin
    • Histochemistry
    • Immunohistochemistry
    • Immunohistochemistry Quantification
    • The use of immunohistochemistry for diagnosis
  • Databases and Pathology
    • Databases and Pathology
    • SEER
    • TCGA
    • Filemaker
    • Access
    • PubMed
    • MeSH
    • GLOBOCAN
    • National Cancer Database
  • Pathology and Other Departments
    • Pathology and Other Departments
    • Rotations of Residents to Pathology from Other Departments
    • Surgery and Pathology
    • Radiology and Pathology
    • Genetics and Pathology
    • Oncology and Pathology
    • Endoscopy and Pathology
    • Inadequate specimen? OR pathologist? OR laboratory?
    • Turnaround Time
    • Research Collaboration
    • Epidemiology and Pathology
    • Comperative Pathology
  • Patients and Pathology
    • Patients and Pathology
    • Informing Patients About Pathology
  • Statistics, Bioinformatics, and Pathology
    • Statistics, Bioinformatics, and Pathology
    • Histopatoloji çalışmalarında istatistik için nasıl veri hazırlanır?
    • Statistical Terms
    • Patologlarla istatistikçilerin potansiyel ortak çalışma alanları
  • Statistics and Bioinformatics
    • Statistics and Bioinformatics
    • Orange
    • R-project
      • Online R Books
      • R Education Videos
      • R-project veri yüklemek neden zor?
      • R packages
      • Using multiple R versions
    • SPSS
    • PSPP
    • Text Mining
      • Text Mining Videos
      • Text Mining Related Web Sites
      • Text Mining Journal Articles
      • Text Mining Courses
      • Text Mining Turkish
      • Text Mining Blog Posts Examples
      • Text Mining R
      • Text Mining Orange
      • Text Mining PubMed
      • Text Mining Twitter
      • Text Mining PubMed
    • Bioinformatics
    • Bioconductor
    • Tools for Data Analysis and Visualisation
    • googleVis
    • Data Visualization and R
    • P Value
    • MedCalc
    • Power Analysis
    • ROC analysis
    • Survival Analysis
    • Kaplan Meier
    • JASP
    • Jamovi
    • SAS
    • Statistics and Bioinformatics Education
    • Neural Network
    • Sensitivity, Specificity, Predictive Values & Decision Making
    • Alluvial Diagrams
    • Machine Learning
      • Linear Regression
      • Decision Tree
      • Random Forest
      • Logistic Regression
      • K - Nearest Neighbors
      • Support Vector Machine
      • Naïve Bayes Classifier
      • Cluster Analysis
      • Principal Component Analysis
      • Artificial Neural Networks
      • Apriori Algorithm
      • Association Rules
      • Linear Discriminant Analysis
      • Convolutional Neural Networks
      • Recurrent Neural Networks
    • Statistics General
    • Mathematic Tools
    • Kappa
    • Regression
    • Missing Values
    • Health Data
    • Python
    • Reproducible Reports
  • Writing Journal Articles
    • Writing Journal Articles
    • Finding Relevant Articles
    • Selecting A Journal
    • Rephrasing & Synonyms
    • Figures and Images
    • Plagiarism
    • Writing Journal Articles
    • IRB
    • Text Editing
    • Review
    • Reproducibility
    • Open Access
    • Platform / Oral Presentation
    • Authorship
    • Publishing General
    • Bibliography
      • EndNote
    • Research Planning
    • Citavi
    • Research Quality
    • Citation
    • Visual Abstracts
  • Bibliometrics
    • Bibliometrics
    • Bibliography, Impact Factor, and Citations
    • Research Articles
    • Data And Tools For Bibliographic Analysis
      • Data and Tools
      • VOSviewer
      • CitNetExplorer
      • Sci2Tool
      • CiteSpace
      • Reference Parsing
      • R for PubMed
    • Problems in Bibliometric Analysis
    • Freecite
  • Pathology Meetings
    • Pathology Meetings
    • Organization Of Meetings
  • Science
    • Science
    • Genetics
    • Physics
    • Mathematics & Geometry
    • Neuroscience
    • Academics
    • Cancer Research
    • Medicine
  • Computers
    • Computers
    • Computer Tips
    • Syntax Highlighting
    • Excel, Sheets
    • GitBook Plugins
    • Git GitHub
    • Lecture Preperation
    • Links
  • Games
    • Games
    • Eyewire
    • Go
    • Chess
      • Satranç
      • Videos
  • Appendix
    • Courses and MOOCs
    • Computer Programs and Applications
    • Books
    • Web Pages
    • Videos
    • GitHub Repositories
    • Yazmayıp da beslese miydik
    • Deutsche Artikel
    • Clippings
    • miscellaneous
  • Pathology and Social Media
    • Pathology and Social Media
  • Pathology Tweets
    • Pathology Tweets
      • Pathology Tweets
Powered by GitBook
On this page
  • Excel, Sheets
  • Excel, Sheets

Was this helpful?

  1. Computers

Excel, Sheets

PreviousSyntax HighlightingNextGitBook Plugins

Last updated 2 years ago

Was this helpful?

Excel, Sheets

RANK

LEFT, RIGHT

LEN, SEARCH

WEEKDAY

NOW

IF

IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))

OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)

RANK

LEFT, RIGHT

LEN, SEARCH

WEEKDAY

NOW

IF

IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))

OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)

Excel, Sheets

RANK

LEFT, RIGHT

LEN, SEARCH

WEEKDAY

NOW

IF

IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))

OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)

Compare two sheets

=IF(Sheet1!A1<> Sheet2!A1, Sheet1!A1&" | "&Sheet2!A1, "")

https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/
DATEDIF
COUNTIF(range, criterion)
SUMIF(range, criterion, sum_range)
AVERAGEIF(range, criterion, average_range)
VLOOKUP(search_key, range, index, is_sorted)
HLOOKUP(search_key, range, index, is_sorted)
SUMPRODUCT(array1, [array2, ...])
https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/
DATEDIF
COUNTIF(range, criterion)
SUMIF(range, criterion, sum_range)
AVERAGEIF(range, criterion, average_range)
VLOOKUP(search_key, range, index, is_sorted)
HLOOKUP(search_key, range, index, is_sorted)
SUMPRODUCT(array1, [array2, ...])
https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/
DATEDIF
COUNTIF(range, criterion)
SUMIF(range, criterion, sum_range)
AVERAGEIF(range, criterion, average_range)
VLOOKUP(search_key, range, index, is_sorted)
HLOOKUP(search_key, range, index, is_sorted)
SUMPRODUCT(array1, [array2, ...])