Section: Excel | OFFICE 365 FOR STUDENTS | West Lothian College Moodle

Home Staff Area

DIGITAL SKILLS

OFFICE 365 FOR STUDENTS

Topic outline

Main course page

Excel
- Get to know Excel for the web URL
  Starting a new document, or opening a document
  Using menus
  Sharing a spreadsheet
- Formulas
- Using formulas - Introduction URL
  Basic functions
  Repeating formulas
- Using formulas - SUM URL
  
  Use SUM when you want to find a total.
- Using formulas - IF URL
  
  IF allows you to make comparisons between a value and what you expect.
- More about Excel formulas URL
  
  For those who wish to find out more about using formulas in Excel.
- Tables
- Create & Format tables URL
- Save time filling in data URL
  
  Using Flash Fill
- Adding totals to an Excel table URL
- Sort & filter data in a table URL
  
  Sort your table by one or more columns, by ascending or descending order, or do a custom sort.
- Conditional formating URL
  
  Add visual cues, like different colours, that help you spot highs and lows or other trends.
- Charts
- Create a chart from start to finish URL
  Create a chart
  Add a trend line
- Add or remove titles in a chart URL
- Show or hide a chart legend URL
- Update the data in an existing chart URL
  
  If you need to change data in a chart, you can do it from its source.
- Sharing & authoring
- Share your Excel workbook with others URL
- Adding comments & notes URL
- Collaborate on Excel workbooks with colleagues URL
- Protect an Excel file URL
  
  Protect a workbook with a password.