PART 1: FAMILIARISATION AND FIRST EXCEL FORMULAE

In Excel Basics, we start from absolute beginner level, with no prior knowledge assumed.  

Part 1 is about building basic confidence in Excel, familiarizing yourself with the interface, interacting with cells, and undertaking some basic tasks.

Session Titles And Learning Outcomes

SESSION 1: Data Input And Arithmetic Formulae (PREVIEW BELOW)
  • Input numbers without using the mouse
  • Create basic arithmetic formulae: add, subtract, multiply, divide
  • Use the keyboard to build a formula
  • Use a keyboard shortcut
SESSION 2: Plan And Format A Spreadsheet
  • Plan a spreadsheet layout
  • Use basic formatting
  • Use paste special
SESSION 3: Summing Up, %S And Absolute References
  • Use the sum formula
  • Use absolute references ($$)
  • Create a % figure
SESSION 4: Charts And Conditional Formatting
  • Create a chart
  • Edit a chart
  • Use conditional formatting
SESSION 5: Effective Worksheet Layout And Presentation
  • Reformat a spreadsheet
  • Delete rows and columns
  • Create a simple dashboard look
7 Lessons