How to use Excel

Microsoft Excel is an electronic spreadsheet program that people use for storing, organising and manipulating data. The types of data that Excel can use include numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.

Because of its layout and widespread availability, it is often used as a tool to create and maintain a list of things. More seasoned users use it to store database records and to create charts or graphs. Many organisations use Excel to manage their budgets, business planning, customers’ records, market intelligence, analysis of sales data, customer data and more.

Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, use Excel headers and footers and to freeze panes so that you can always see column and row headings.

If you are already using Excel, we can bring you up to speed on some of the more advanced aspects - how formulas and cell referencing work and how to prepare attractive lists and spreadsheets.

For beginners, we can introduce you to spreadsheets, and take you to the stage where you will be able to:

  •   work within the basic Excel environment
  •   create a new spreadsheet
  •   open and navigate within workbooks and worksheets
  •   make changes to data
  •   understand various basic types of calculation
  •   understand and work with formulae and functions used in calculations
  •   understand and use formula cell referencing to create more complex formulae
  •   copy and paste data in Excel
  •   use font formatting options to enhance the appearance of a worksheet
  •   align the contents of cells in various ways
  •   format rows and columns in a worksheet
  •   understand and use the number formatting features in Excel
  •   print your workbook data
  •   create effective charts in Microsoft Excel

Learn more, or book a coaching session with Clearway Computing. Please explore the links in this website, and then get in touch with us to find out more.