Here are some useful Excel features and formula you can look at and practice:
- Pivot Tables
- Text To Columns
- V-look Up
- ISNA
- IF
- Match
- SumIF
- Macros
- Data ranges
- Conditional Formatting
Look here ---> bit.do/e8ZZU
Ensure to pace yourself so you don't get overwhelmed.
- Dashboards
- Invoices
- Attendance Sheets
- Analysed Data
- Charts
- Excel Projects
- Inventories
- Employee Admin
- Trackers
Then grab a template here:
- Microsoft Template tiny.cc/kf0kjz
- SpreadSheet Zone bit.do/frGK2
- SpreadSheet123 tiny.cc/2k0kjz
- CalculateHours bit.do/frGLN
- Vertex42 tiny.cc/ku0kjz
- TrumpExcel trumpexcel.com
Quite easy to forget formulars or tricks; but constantly playing around or cleaning & slicing data always helps.