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.