Spreadsheets and Charts
Watch all the videos within the first few days to get the most value from FCS Express!
Spreadsheets (Short video)
IN THIS VIDEO:
Learn how Spreadsheets in FCS Express can be used to perform most of the operations that Microsoft Excel provides. In addition, values in Spreadsheet cells can be derived directly from statistics within the layout, keywords, or from data files in the Data List that automatically update. This video provides an introduction for the functionality of this tool in FCS Express.
LEARN HOW TO:
- Insert and Populate a Spreadsheet within a Layout
- Apply Formatting to a Spreadsheet
- Use Functions and Formulas for Advanced Analysis
 3 mins |
Download Video  |
Spreadsheets (Full video)
IN THIS VIDEO:
Learn how the Integrated Spreadsheet feature allows Microsoft Excel-like spreadsheet analysis with direct linking to data and statistics that updates as gates and data files change. Integrated Spreadsheets makes analysis of flow and image cytometry data even easier in FCS Express.
LEARN HOW TO:
- Create a New Spreadsheet
- Insert Specialty Plots to Display Spreadsheet Data
- Export Spreadsheets
 60 mins |
Download Video |
Adding Data to Integrated Spreadsheets
IN THIS VIDEO:
Leverage the use of the Spreadsheet feature to quickly analyze and compare statistics for many data files from the data list without opening additional plots or creating a batch process. Watch this short overview to learn about the details of this feature.
LEARN HOW TO:
- Incorporate an Integrated Spreadsheet into the Layout
- Add Statistic and/or Keyword Tokens
- Populate a Summary Spreadsheet from the Data List
| 3 mins |
Download Video |
Box and Whiskers Plots
IN THIS VIDEO:
Box and Whisker Plots allow you to visualize the distribution of your data according to quartiles, where the middle two quartiles are represented by a mean- or median-bisected box, and the outer two by whiskers. Individual data points within each set may be denoted by points, and the appearance of outliers can also be visually emphasized.
LEARN HOW TO:
- Interpret a Box and Whisker Plot
- Use the Box and Whisker Plot to Display Data
- Format a Box and Whisker Plot
| 4 mins |
Download Video |
Violin and Beeswarm Plots
IN THIS VIDEO:
Learn the advantages of using Summary charts, such as Beeswarm and Violin Plots, to graph summary statistics, such as the Mean or the Median, the distribution of the data, the Outliers, and Single Data Points. Watch this short video to understand the bullet points of this feature.
LEARN HOW TO:
- Arrange Data in a Spreadsheet
- Inserting a Beeswarm and Violin Plot
- Formatting Beeswarm and Violin Plots
| 4 mins |
** Direct Download Coming Soon ** Download Video |
Summary Charts (Full video)
IN THIS VIDEO:
Gain knowledge about using Integrated Spreadsheets and Charting tools, such as Box and Whisker, Violin, Bee Swarm, and Levey Jennings. Integrated Spreadsheets allow Microsoft Excel-like spreadsheet analysis with direct linking to data and statistics that updates as gates and data files change. These features make analysis of Flow and Image cytometry data sets that require side by side comparison and quick reporting even easier in FCS Express. View this webinar to learn how to get the most out of the new summary charts and Levey Jennings plots available in the new FCS Express release.
LEARN HOW TO:
- Incorporate Summary Charts into Analysis
- Select the Best Summary Chart to Represent Data
- Utilize and Format Summary Charts
 46 mins |
Download Video |
Regression Analysis and Curve Fitting
IN THIS VIDEO:
Learn how to incorporate an Integrated Spreadsheet and regression analysis features in FCS Express allow for Microsoft Excel-like spreadsheet style analysis with direct linking to data and statistics that updates as gates and data files change. These features make analysis of Flow and Image cytometry data sets that require graphing, curve fitting, and calculations based on curve fits, even easier with FCS Express. View this webinar to learn how to get the most out of regression analysis and spreadsheets
LEARN HOW TO:
- Build Regression Analysis
- Insert a Regression Plot Using Data Files or Custom Data
- Format Regression Plots
| 43 mins |
Download Video |
Levey-Jennings Charts
IN THIS VIDEO:
Explore how the Levey Jennings Plot allows you to visualize quality control data to ensure test metrics are stable over time and fall within control limits. The control limits allow the test metric to be assessed based on whether the values fall within the range or outside of the range. Values falling outside of the control limits are considered "out of control" and when occurring on consecutive measurements can indicate the accuracy of the test metric has shifted. Westgard Rules, which are used to interpret the control data, are directly integrated into this feature
LEARN HOW TO:
- Use an Internal Spreadsheet
- Insert, Duplicate, and Format Levey-Jennings Plots
- Add New Data to an Existing Levey-Jennings Plots
| 4 mins |
** Direct Download Coming Soon ** Download Video |
Bar and Pie Charts
IN THIS VIDEO:
Incorporate Integrated Spreadsheets and Charting tools, such as bar charts and pie charts, into your analysis. Use Microsoft Excel-like spreadsheet analysis with direct linking to data and statistics that updates as gates and data files change to take your analysis further. These features make analysis of Flow and Image cytometry data sets that require side by side comparison and quick reporting even easier in FCS Express. View this webinar to learn how to get the most out of bar charts, pie charts, and spreadsheets.
LEARN HOW TO:
- Work with Spreadsheets in FCS Express
- Insert Bar and Pie Charts
- Add Overlays and Format Charts
| 50 mins |
Download Video |
