Holarch
Course chapters

Training · Track 14

Spreadsheets

For engineers who keep budgets, trade studies and calculations next to the model. 5 chapters, 15 minutes in all, on one workbook: the mass budget of the CubeSat EO-1 demo. Watch them in order, or pick the chapter you need. The next chapter starts on its own when one ends.

Before you start

Take first
Chapter 1.1 The Holarch Workspace.
Plan
Free; chapter 14.5's AI formula help needs a plan with AI
Project
The CubeSat EO-1 demo: each chapter after the first has its starting file.

▶ Start with chapter 14.1 Exercise sheet

  1. 14.1Sheets, Data and Formulas 4:16Create a spreadsheet, name and color its sheets, enter data, and write formulas with the formula bar, the Name Box and autocomplete
  2. 14.2Formats and Layout 3:16Format numbers with format codes, highlight cells by value, merge a title and freeze the headings
  3. 14.3Tables, Find and Views 2:17Format a range as a table, find and replace text, and save named views without changing the cells
  4. 14.4Charts and Model Data 2:47Chart a range and format its axis, insert a live Model Table, and read model values with SUMIFS and HOLARCH.VALUE
  5. 14.5Excel Import and AI Formula Help 2:26Import an Excel workbook and read its Import Summary, then let AI explain a formula and write one