Microsoft Excel Module 1 : Create a spreadsheet using simple formula
Duration 2 Hours
Team Professional Development
In this course, you will learn how to create simple formulas (manually created) and functions (pre-defined formula that performs calculations using specific values in the correct order). You will understand how Excel treats text and numbers differently and how to manage this. You will also learn many useful shortcuts for inserting and extending content

Learning outcomes:
  • Make changes to data in a workbook
  • Label and format sheets
  • Understand Excel terminology
  • Convert numbers to text as appropriate
  • Use basic fill operations and the Clipboard
  • Work with ranges in a worksheet
  • Creating formula to add, subtract, divide and multiply

Pre-Requisites:

Delegates are required to have Microsoft Excel 2016 or above installed on their computer.  The features and techniques used in the course cannot be completed in the online Office365 version of Microsoft Excel.

Process:

This course will be delivered entirely online via Teams with course Leader input, demonstrations, and hands-on practical sessions.  If you don't already have Teams installed then please see https://teams.microsoft.com/uswe-01/downloads for more information.  

LocationStart DateAll DatesTimesPlaces AvailableBook