Quit wasting your time searching on Google for how to’s – we have the answers. This practical course introduces you to the basics of Microsoft Excel. Starting with creating a new spreadsheet to producing graphs and charts to clearly display data. All laptops are provided.
- Learn the basics of Excel, including the screen layout;
- Changing the views;
- Opening, closing and saving.
- Understand cell ranges;
- Data entry;
- Autofill.
- Learn how to format numbers, dates, times and currency;
- Sort records and filter these records.
- How to create and use a formula.
- How to use popular functions such as SUM, COUNT and AVERAGE.
- Create graphs and charts with the data entered earlier in the session.