Topic outline

• Excel for Beginners Course

  Collapse all Expand all

  Microsoft Excel is the industry-leading spreadsheet program used for data calculations, analysis, visualisation and much more; it also has many external programming features.  Excel is one of the best programs available for data modelling, statistics and financial calculations. Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs.

  This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles of Excel.

• Section 1: Excel Interface
  Not available unless: You are a(n) Student

• Section 2: Excel Options
  Not available unless: The activity 12. Zoom is marked complete

• Section 3: Mouse Pointer Shapes
  Not available unless: The activity 17. Zero Values is marked complete

• Section 4: Mouse Selection Techniques
  Not available unless: The activity 18. Mouse Pointer Shapes is marked complete

• Section 5: Entering and Editing Data
  Not available unless: The activity 20. Mouse Selection Technique 2 is marked complete

• Section 6: Working with Sheets
  Not available unless: The activity 26. Delete Note and Comment is marked complete

• Section 7: Working with Rows and Columns
  Not available unless: The activity 31. Copy a Sheet is marked complete

• Section 8: Copy Paste Move and Insert Text
  Not available unless: The activity 37. Row Height is marked complete

• Section 9: Autofill
  Not available unless: The activity 39. Copy and Paste is marked complete

• Section 10: Formatting Cells
  Not available unless: The activity 41. Custom List is marked complete

• Section 11: Basic Calculations
  Not available unless: The activity 53. Format Painter is marked complete

• Section 12: Working with Functions
  Not available unless: The activity 60. Subtraction is marked complete

• Section 13: Sorting
  Not available unless: The activity 63. Min is marked complete

• Section 14: Paste Special
  Not available unless: The activity 68. Sorting 5 is marked complete

• Section 15: Assessment
  Not available unless: The activity 73. Transpose is marked complete