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