Introduction to Excel

Topics covered

• Overview of the Excel interface
• Workbooks, worksheets and the ribbon
• Navigating and selecting cells
• Entering and editing data

Topics covered

• Formatting cells and data types
• Copying, pasting and autofill
• Sorting and filtering data
• Basic spreadsheet organisation

Topics covered

• Relative cell references
• Absolute cell references using $
• Mixed references
• Named ranges

Topics covered

• Writing formulas with +, -, *, /
• Using SUM, AVERAGE, MIN, MAX
• Order of operations in Excel
• Referencing cells in formulas

Topics covered

• Mathematical functions: SQRT, POWER, ABS, ROUND
• Trigonometric functions: SIN, COS, TAN and their inverses
• Logarithmic functions: LOG, LOG10, LN, EXP
• Engineering applications of built-in functions

Topics covered

• Creating charts from data (line, bar, scatter)
• Formatting chart elements: titles, axis labels, legends
• Plotting multiple data series
• Engineering applications of Excel graphs