This course will teach the basics of excel, including screen layout, changing the views, opening, closing and saving. It will also teach delegates about cell ranges, data entry, how to use auto-fill, formatting of numbers, dates, times and currency.
- Understanding cell ranges
- Data entry
- Opening, closing and saving
- Autofill and sequencing
- Data entry
- Sorting and filtering data
- Creating graphs and charts
- Conditional formatting
- Calculations and formula
- How to use popular functions for summative totals, records counting and calculating averages
- Creating an IF statement algorithm